Oracle 10G恢復實戰1

RMAN> restore database;

Starting restore at 13-JUN-11

Starting implicit crosscheck backup at 13-JUN-11

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK

Crosschecked 16 objects

Finished implicit crosscheck backup at 13-JUN-11

Starting implicit crosscheck copy at 13-JUN-11

using channel ORA_DISK_1

Finished implicit crosscheck copy at 13-JUN-11

searching for all files in the recovery area

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: autobackup/2011_06_13/o1_mf_s_753718540_6zcbrfm3_.bkp

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00002 to undotbs01.dbf

restoring datafile 00003 to sysaux01.dbf

restoring datafile 00008 to fda_idx_01.dbf

restoring datafile 00009 to fda_idx_02.dbf

channel ORA_DISK_1: reading from backup piece s3_1.dbf

channel ORA_DISK_1: restored backup piece 1

piece handle=s3_1.dbf tag=TAG20110613T121011

channel ORA_DISK_1: restore complete, elapsed time: 00:00:56

channel ORA_DISK_1: starting datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to system01.dbf

restoring datafile 00004 to users_01.dbf

restoring datafile 00005 to fda_data_01.dbf

restoring datafile 00006 to oratext01.dbf

restoring datafile 00007 to fda_data_02.dbf

channel ORA_DISK_1: reading from backup piece s4_1.dbf

channel ORA_DISK_1: restored backup piece 1

piece handle=s4_1.dbf tag=TAG20110613T121011

channel ORA_DISK_1: restore complete, elapsed time: 00:00:55

Finished restore at 13-JUN-11

RMAN> recover database;

Starting recover at 13-JUN-11

using channel ORA_DISK_1

channel ORA_DISK_1: starting incremental datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00002: undotbs01.dbf

destination for restore of datafile 00003: sysaux01.dbf

destination for restore of datafile 00008: fda_idx_01.dbf

destination for restore of datafile 00009: fda_idx_02.dbf

channel ORA_DISK_1: reading from backup piece s9_1.dbf

channel ORA_DISK_1: restored backup piece 1

piece handle=s9_1.dbf tag=TAG20110613T121220

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting incremental datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00001: system01.dbf

destination for restore of datafile 00004: users_01.dbf

destination for restore of datafile 00005: fda_data_01.dbf

destination for restore of datafile 00006: oratext01.dbf

destination for restore of datafile 00007: fda_data_02.dbf

channel ORA_DISK_1: reading from backup piece s10_1.dbf

channel ORA_DISK_1: restored backup piece 1

piece handle=s10_1.dbf tag=TAG20110613T121220

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

starting media recovery

channel ORA_DISK_1: starting archive log restore to default destination

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=175

channel ORA_DISK_1: reading from backup piece s14_1.arc

channel ORA_DISK_1: restored backup piece 1

piece handle=s14_1.arc tag=TAG20110613T121303

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting archive log restore to default destination

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=174

channel ORA_DISK_1: reading from backup piece s13_1.arc

channel ORA_DISK_1: restored backup piece 1

piece handle=s13_1.arc tag=TAG20110613T121303

channel ORA_DISK_1: restore complete, elapsed time: 00:00:02

archive log filename=arch_1_174.1942.dbf thread=1 sequence=174

archive log filename=arch_1_175.1942.dbf thread=1 sequence=175

channel ORA_DISK_1: starting archive log restore to default destination

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=177

channel ORA_DISK_1: reading from backup piece s16_1.arc

channel ORA_DISK_1: restored backup piece 1

piece handle=s16_1.arc tag=TAG20110613T141537

channel ORA_DISK_1: restore complete, elapsed time: 00:00:02

channel ORA_DISK_1: starting archive log restore to default destination

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=176

channel ORA_DISK_1: reading from backup piece s15_1.arc

channel ORA_DISK_1: restored backup piece 1

piece handle=s15_1.arc tag=TAG20110613T141537

channel ORA_DISK_1: restore complete, elapsed time: 00:00:02

archive log filename=arch_1_176.1942.dbf thread=1 sequence=176

archive log filename=arch_1_177.1942.dbf thread=1 sequence=177

unable to find archive log

archive log thread=1 sequence=178

RMAN-00571: =================================================

RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: =================================================

RMAN-03002: failure of recover command at 06/13/2011 15:04:54

RMAN-06054: media recovery requesting unknown log: thread 1 seq 178 lowscn 5270477

RMAN> alter database open resetlogs;

database opened

RMAN>