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

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"

I went to the backup and recovery reference guide and check the syntax for RECOVER command on 10gR2 library:
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta044.htm I was surprised that "RECOVER DATABASE USING" is NOT a valid construct although the metalink document states the document apply to DB versions 9.0.1.4 to 10.2.0.3.

Reading down I get to RESTORE EXAMPLES, specifically the one titled: Performing DBPITR with a Backup Control File and Recovery Catalog: Example
The example restores the control file in NOMOUNT state before mounting the database and start restore and recovery. I changed the RUN block to specify the SCN number instead of the log sequence in the SET UNTIL clause. Also removed Tablespace Skip clauses:

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? .... Received on Tue May 06 2008 - 03:43:16 CDT