Re: Noarchivelog 11.2.0.1 Restart

  • From: Ed Long <rdhm99a@xxxxxxxxxxx>
  • To: De DBA <dedba@xxxxxxxxxx>
  • Date: Wed, 26 Jan 2011 10:30:15 -0800 (PST)

Hi everyone.
Here is today's update.
Oracle seconded "De DBA"''s suggestion to recreate the controlfile referring to 
document 735106.1 for specifics.
Step 1 is alter database backup controlfile to trace.
Step 1 fails with ORA-16433 database m/b in r/w mode.
I now believe this bug is Windows 7 related as that is what is different. 
Any experience with 11.2.0.2?

Edward Long

--- On Wed, 1/26/11, De DBA <dedba@xxxxxxxxxx> wrote:


From: De DBA <dedba@xxxxxxxxxx>
Subject: Re: Noarchivelog 11.2.0.1 Restart
To: "Ed Long" <rdhm99a@xxxxxxxxxxx>
Cc: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
Date: Wednesday, January 26, 2011, 5:01 AM


That could be your problem then: RMAN's "restore database" command does not 
restore the control file or the SP-file. It's got to be done explicitly. 

The existing control file after the RAT "knows" that the database has had 
activity after your level 0 backup and RMAN wants to bring the restored 
database up to speed. Hence the message that file 1 needs media recovery. 

Cheers,
Tony


Ed Long wrote: 




Thanks for thinking about the problem.
No, I literally just did restore database.
Ticket open with Oracle, more updates tomorrow (Tuesday).

Edward Long

--- On Mon, 1/24/11, De DBA <dedba@xxxxxxxxxx> wrote:


From: De DBA <dedba@xxxxxxxxxx>
Subject: Re: Noarchivelog 11.2.0.1 Restart
To: "'rdhm99a@xxxxxxxxxxx'" <rdhm99a@xxxxxxxxxxx>
Cc: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
Date: Monday, January 24, 2011, 7:57 PM


Hi Ed,

Perhaps a silly question, but did you restore the control files after 
completing the RAT? If not, the post-RAT control file will have a higher 
SCN than the restored database and insist that the datafiles need media 
recovery. There should be an automatic controlfile backup in your level 
0 backup, since it contains the system datafile.

Cheers,
Tony

Other related posts: