Re: Noarchivelog 11.2.0.1 Restart
Date: Wed, 26 Jan 2011 10:30:15 -0800 (PST)
Message-ID: <113437.83794.qm_at_web80207.mail.mud.yahoo.com>
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_at_tpg.com.au> wrote:
From: De DBA <dedba_at_tpg.com.au>
Subject: Re: Noarchivelog 11.2.0.1 Restart
To: "Ed Long" <rdhm99a_at_prodigy.net>
Cc: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
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_at_tpg.com.au> wrote:
From: De DBA <dedba_at_tpg.com.au>
Subject: Re: Noarchivelog 11.2.0.1 Restart
To: "'rdhm99a_at_prodigy.net'" <rdhm99a_at_prodigy.net>
Cc: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 26 2011 - 12:30:15 CST