?

List of Files Which Where Not Cataloged

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

File Name:/data/impdp/2015-08-20/rman_backup.log

RMAN-07517: Reason: The file header is corrupted

?

RMAN>

?

2.5，开始恢复整个库

因为前面恢复了整个spfile已经controlfile，所以接下来恢复所有库的话，就不用带参数，直接恢复restore database就可以 ;

RMAN> restore database;

RMAN> restore database;

?

Starting restore at 20-AUG-15

using channel ORA_DISK_1

?

channel ORA_DISK_1: starting datafilebackup set restore

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

channel ORA_DISK_1: restoring datafile00001 to /home/oradata/powerdes/system01.dbf

channel ORA_DISK_1: restoring datafile00002 to /home/oradata/powerdes/sysaux01.dbf

channel ORA_DISK_1: restoring datafile00003 to /home/oradata/powerdes/undotbs01.dbf

channel ORA_DISK_1: restoring datafile00004 to /home/oradata/powerdes/users01.dbf

channel ORA_DISK_1: restoring datafile00005 to /home/oradata/powerdes/powerdesk01.dbf

channel ORA_DISK_1: restoring datafile00006 to /home/oradata/powerdes/plas01.dbf

channel ORA_DISK_1: restoring datafile00007 to /home/oradata/powerdes/pl01.dbf

channel ORA_DISK_1: restoring datafile00008 to /home/oradata/powerdes/help01.dbf

channel ORA_DISK_1: restoring datafile00009 to /home/oradata/powerdes/adobelc01.dbf

channel ORA_DISK_1: restoring datafile00010 to /home/oradata/powerdes/sms01.dbf

channel ORA_DISK_1: restoring datafile00011 to /home/oradata/powerdes/plcrm01.dbf

channel ORA_DISK_1: restoring datafile00012 to /home/oradata/powerdes/powerdesk02.dbf

channel ORA_DISK_1: reading from backuppiece /data/impdp/2015-08-20/full_POWERDES_20150820_4419.bak

channel ORA_DISK_1: piecehandle=/data/impdp/2015-08-20/full_POWERDES_20150820_4419.baktag=TAG20150820T030008

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete,elapsed time: 00:17:35

Finished restore at 20-AUG-15

?

RMAN>

?

2.6 然后recover修复数据库

RMAN> recover database;

?

Starting recover at 20-AUG-15

using channel ORA_DISK_1

?

starting media recovery

?

channel ORA_DISK_1: starting archived logrestore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=36277

channel ORA_DISK_1: reading from backuppiece /data/impdp/2015-08-20/arch_POWERDES_20150820_4420.bak

channel ORA_DISK_1: piecehandle=/data/impdp/2015-08-20/arch_POWERDES_20150820_4420.baktag=TAG20150820T032015

channel ORA_DISK_1: restored backup piece 1

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

archived log filename=/oracle/app/oracle/flash_recovery_area/POWERDES/archivelog/2015_08_20/o1_mf_1_36277_bxcjyzbg_.arcthread=1 sequence=36277

channel default: deleting archivedlog(s)

archived log file name=/oracle/app/oracle/flash_recovery_area/POWERDES/archivelog/2015_08_20/o1_mf_1_36277_bxcjyzbg_.arcRECID=71395 STAMP=888264671

unable to find archived log

archived log thread=1 sequence=36278

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

RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============

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

RMAN-03002: failure of recover command at08/20/2015 20:11:13