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

From: <>
Date: Tue, 6 May 2008 01:43:16 -0700 (PDT)
Message-ID: <>

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: I was surprised that "RECOVER DATABASE USING" is NOT a valid construct although the metalink document states the document apply to DB versions to

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

Original text of this message