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

On May 6, 10:43 am, "gba..._at_ravenpack.com" <gba..._at_ravenpack.com> wrote:
> Hi, many thanks for your responses.
>
> I have continued my tests using your info, specially the Metalink
> documents.
>
> 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;" Received on Tue May 06 2008 - 04:14:36 CDT