Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > Re: DBPITR and ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 13 of 14 Topic 16497 of 17418
Post > Topic >>

Re: DBPITR and ORA-16005 Error: database requires recovery.

by vitalisman@[EMAIL PROTECTED] May 6, 2008 at 02:14 AM

On May 6, 10:43 am, "gba...@[EMAIL PROTECTED]
" <gba...@[EMAIL PROTECTED]
>
wrote:
> Hi, many thanks for your responses.
>
> I have continued my tests using your info, specially the Metalink
> do***ents.
>
> When I tried the statement:
>
> RMAN> recover database using backup controlfile until cancel;
> ......
> RMAN-01009: syntax error: found "using": expecting one of:
> "archivelog, auxiliary, allow, check, delete, from, high, noredo,
> noparallel, parallel, ;, skip, tablespace, test, until, undo"

That is an SQL*Plus command, not RMAN.

> RMAN> run {
>  set until SCN [scn1];
>  restore controlfile;
>  alter database mount;
>   restore database;
>  recover database;
>  }
>
> When executed I got this error:
> RMAN-03002: failure of set command at 05/06/2008 10:21:22
> ORA-01507: database not mounted
>
> Probably this is because the example assumes the target DB is using a
> recovery catalog? ....

Yes. Add "... from autobackup;" at the end of "restore controlfile".
If you still have problems getting RMAN read the right autobackup, try
"... from /path/to/the/proper/autobackup;"
 




 14 Posts in Topic:
DBPITR and ORA-16005 Error: database requires recovery.
"gbahut@[EMAIL PROTE  2008-05-02 10:04:37 
Re: DBPITR and ORA-16005 Error: database requires recovery.
"fitzjarrell@[EMAIL   2008-05-02 10:26:27 
Re: DBPITR and ORA-16005 Error: database requires recovery.
"gbahut@[EMAIL PROTE  2008-05-02 12:53:43 
Re: DBPITR and ORA-16005 Error: database requires recovery.
"fitzjarrell@[EMAIL   2008-05-02 13:57:38 
Re: DBPITR and ORA-16005 Error: database requires recovery.
vitalisman@[EMAIL PROTECT  2008-05-05 00:52:25 
Re: DBPITR and ORA-16005 Error: database requires recovery.
"gbahut@[EMAIL PROTE  2008-05-05 01:00:48 
Re: DBPITR and ORA-16005 Error: database requires recovery.
vitalisman@[EMAIL PROTECT  2008-05-05 01:29:38 
Re: DBPITR and ORA-16005 Error: database requires recovery.
tim2boles@[EMAIL PROTECTE  2008-05-05 07:25:03 
Re: DBPITR and ORA-16005 Error: database requires recovery.
joel garry <joel-garry  2008-05-05 10:05:17 
Re: DBPITR and ORA-16005 Error: database requires recovery.
tim2boles@[EMAIL PROTECTE  2008-05-05 13:05:11 
Re: DBPITR and ORA-16005 Error: database requires recovery.
joel garry <joel-garry  2008-05-05 14:49:46 
Re: DBPITR and ORA-16005 Error: database requires recovery.
"gbahut@[EMAIL PROTE  2008-05-06 01:43:16 
Re: DBPITR and ORA-16005 Error: database requires recovery.
vitalisman@[EMAIL PROTECT  2008-05-06 02:14:36 
Re: DBPITR and ORA-16005 Error: database requires recovery.
"gbahut@[EMAIL PROTE  2008-05-06 05:07:48 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 15:35:23 CST 2008.