ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle 10G恢复实战1

Oracle 10G恢复实战1

原创 Linux操作系统 作者:cow977 时间:2011-06-14 09:30:46 0 删除 编辑

Oracle 10G恢复实战:http://space.itpub.net/81227/viewspace-697846

 

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>

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/81227/viewspace-697847/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Oracle 10G恢复实战
下一篇: Oracle 9I恢复实战
请登录后发表评论 登录
全部评论

注册时间:2011-03-02

  • 博文量
    698
  • 访问量
    786655