Re: Do you need to start manually the recover on a datafile?

  • From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
  • To: juancarlosreyesp@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 20 Jan 2006 06:01:50 -0800 (PST)

Have you tried
  recover datafile '<full_path_of_datafile>';
  alter database datafile <full_path_datafile_name> online; 
  Joseph Amalraj

Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx> wrote:
  Hi, please,
The database was started up, when a datafiles was locked by a os
program, and there was a pending to recover transaction, on that
So the database started but that datafiles moves offline, with a
pending recovery transaction.

I set online the datafile and restarted the database and the problem
was still there, and because it was urgent, and I didn't have time to
ask, I solved the problem in other way.

But checking in oradebug wakeup command, I'm asking If I had to wake
up the recovery process to get the recovery to start immediately,
wihch was the correct step?.

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i


Other related posts: