rman
I had tried to restore the database by using following script:
rman nocatalog target
run {
startup mount;
allocate channel t1 type disk;
restore database;
recover database noredo;
alter database open resetlogs;
}
However I am not able to restore it. The following is the RMAN log during the recovery. By the way, is there a way to extra archive log files from backup piece?
Thank you
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN-06193: connected to target database (not started)
RMAN> run {2> startup mount;3> allocate channel t1 type disk;4> restore database;5> recover database noredo;6> alter database o
pen resetlogs;7> }
RMAN-03022: compiling command: startup
RMAN-06196: Oracle instance started
RMAN-06199: database mounted
Total System Global Area 631021728 bytes
Fixed Size 73888 bytes
Variable Size 166273024 bytes
Database Buffers 464494592 bytes
Redo Buffers 180224 bytes
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=10 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel t1: starting datafile backupset restore
RMAN-08502: set_count=217 set_stamp=451261377 creation_time=15-JAN-02
RMAN-08089: channel t1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to /u01/oradata/prod/data/system01.dbf
RMAN-08523: restoring datafile 00002 to /u01/oradata/prod/data/tools01.dbf
RMAN-08523: restoring datafile 00003 to /u01/oradata/prod/data/rbs01.dbf
RMAN-08523: restoring datafile 00004 to /u01/oradata/prod/data/temp01.dbf
RMAN-08523: restoring datafile 00005 to /u01/oradata/prod/data/users01.dbf
RMAN-08523: restoring datafile 00006 to /u01/oradata/prod/data/indx01.dbf
RMAN-08023: channel t1: restored backup piece 1
RMAN-08511: piece handle=/u01/oradata/oratmp/df_t451261377_s217_p1 tag=SUNDAY_LEVEL_0 params=NULL
RMAN-08024: channel t1: restore complete
RMAN-03022: compiling command: recover
RMAN-03022: compiling command: recover(1)
RMAN-03022: compiling command: recover(2)
RMAN-03022: compiling command: alter db
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: alter db
RMAN-06003: ORACLE error from target database: ORA-01152: file was not restored from a sufficiently old backup
RMAN-06097: text of failing SQL statement: alter database open resetlogs
RMAN-06099: error occurred in source file: krmk.pc, line: 22062
RMAN>
Recovery Manager complete.