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"
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 do***ent states the do***ent 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? ....
|
