RMAN恢复案例之--不完全恢复错误案例

RMAN恢复案例之--不完全恢复错误案例RMAN恢复案例：不完全恢复，由于在先前的数据文件备份有误，导致恢复失败。[oracle@rh6~]$rmantarget/RecoveryManager:Relea

RMAN恢复案例之--不完全恢复错误案例

RMAN恢复案例：

不完全恢复，由于在先前的数据文件备份有误，导致恢复失败。

[oracle@rh6 ~]$ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Sat Sep 20 15:54:25 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: TEST1 (DBID=1195893416) RMAN> run { 2> shutdown immediate; 3> startup mount; 4> set until time '2014-09-20 15:49:36'; 5> restore database; 6> recover database ; 7> alter database open resetlogs; 8> sql'alter system switch logfile'; 9> } using target database control file instead of recovery catalog database closed database dismounted Oracle instance shut down connected to target database (not started) Oracle instance started database mounted Total System Global Area 175767552 bytes Fixed Size 1335276 bytes Variable Size 142606356 bytes Database Buffers 29360128 bytes Redo Buffers 2465792 bytes executing command: SET until clause Starting restore at 20-SEP-14 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=18 device type=DISK flashing back control file to SCN 9601534 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/test1/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/test1/users01.dbf channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/test1/perfs.dbf channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/test1/undotbs2.dbf channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/test1/index01.dbf channel ORA_DISK_1: reading from backup piece /dsk1/backup/test1/TEST1_240.bak channel ORA_DISK_1: piece handle=/dsk1/backup/test1/TEST1_240.bak tag=TAG20140920T152720 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:35 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00013 to /u01/app/oracle/oradata/test1/tbs_16.dbf channel ORA_DISK_1: reading from backup piece /dsk1/backup/test1/TEST1_241.bak channel ORA_DISK_1: piece handle=/dsk1/backup/test1/TEST1_241.bak tag=TAG20140920T152720 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/test1/system01.dbf channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/test1/test1.dbf channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/test1/dict1.dbf channel ORA_DISK_1: reading from backup piece /dsk1/backup/test1/TEST1_239.bak channel ORA_DISK_1: piece handle=/dsk1/backup/test1/TEST1_239.bak tag=TAG20140920T152720 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:45 Finished restore at 20-SEP-14 Starting recover at 20-SEP-14 using channel ORA_DISK_1 starting media recovery

recover 失败......

media recovery failed

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

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

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

RMAN-03002: failure of recover command at 09/20/2014 15:59:01

RMAN-20505: create datafile during recovery

RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed

start until time 'SEP 20 2014 15:49:36'

ORA-00283: recovery session canceled due to errors

ORA-01244: unnamed datafile(s) added to control file by media recovery

ORA-01110: data file 8: '/u01/app/oracle/oradata/test1/tbs2.dbf'

查看备份信息：