Re: [SPAM] Re: Noarchivelog 11.2.0.1 Restart
Date: Mon, 24 Jan 2011 14:12:12 +1100
Message-ID: <AANLkTimo4U43NcSy2-iSJ3Qfty_bF-Lyn-ToQ-0g=AFn_at_mail.gmail.com>
Have you tried
dont't bother putting in a scn (I assume that level 0 backup is the latest
backup)
restore database;
don't even bother with the recover database; (there is nothing to recover)
and just open it.
other option to try is "RECOVER DATABASE NOREDO; # specify NOREDO because online redo logs are lost"
Jack van Zanen
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
On Mon, Jan 24, 2011 at 6:24 AM, Ed Long <rdhm99a_at_prodigy.net> wrote:
> I cannot explain this feature and is part of why I reached out to this
> group.
> As noted previously, the restore works just fine including the table space
> that won't come online which suggests that the error is software not
> hardware.
> I spent a couple of hours on Friday reading the fine manual and it states
> pretty clearly that one has to be able to do a recover after a noarchivelog
> level 0 restore even if there are no logs required. To me, this is
> nonsensical as a clean level 0 backup should be good enough as one
> respondent noted.
> I will have to chat up Oracle support to get any further.
> Packers and Jets!
> Thank you all for the assist.
> Edward Long
>
> --- On *Sat, 1/22/11, Hemant K Chitale <hemantkchitale_at_gmail.com>* wrote:
>
>
> From: Hemant K Chitale <hemantkchitale_at_gmail.com>
>
> Subject: Re: Noarchivelog 11.2.0.1 Restart
> To: rdhm99a_at_prodigy.net
> Cc: oracle-l_at_freelists.org
> Date: Saturday, January 22, 2011, 12:09 PM
>
>
>
> Can you explain why you get the error
> "ORA-16433 the database must be opened in r/w mode" ?
> Apparently, the database is in read-only mode.
>
> Hemant
>
> On Sat, Jan 22, 2011 at 4:47 AM, Ed Long <rdhm99a_at_prodigy.net<http://mc/compose?to=rdhm99a_at_prodigy.net>
> > wrote:
>
> All I want to do is restore the database and restart. I don't want to
> apply any logs at all. Even in noarchivelog I should be able to do this.
>
> Anyway, recover database; returns the following:
> 1: RMAN-03002 failure of recover command
> 2: ORA-00283 recovery session cancelled due to errors.
> 3: RMAN-11003 failure during parse/execution of SQL statement: alter
> database recover if needed start until cancel
> 4: ORA-00283 recovery session canceled due to errors.
> 5: ORA-16433 the database must be opened in r/w mode.
>
>
>
> Edward Long
>
>
>
>
> --
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jan 23 2011 - 21:12:12 CST