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