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 2014copyright (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 catalogdatabase closeddatabase dismountedoracle instance shut downconnected to target database (not started)oracle instance starteddatabase mountedtotal system global area 175767552 bytesfixed size 1335276 bytesvariable size 142606356 bytesdatabase buffers 29360128 bytesredo buffers 2465792 bytesexecuting command: set until clausestarting restore at 20-sep-14allocated channel: ora_disk_1channel ora_disk_1: sid=18 device type=diskflashing back control file to scn 9601534channel ora_disk_1: starting datafile backup set restorechannel ora_disk_1: specifying datafile(s) to restore from backup setchannel ora_disk_1: restoring datafile 00002 to /u01/app/oracle/oradata/test1/sysaux01.dbfchannel ora_disk_1: restoring datafile 00004 to /u01/app/oracle/oradata/test1/users01.dbfchannel ora_disk_1: restoring datafile 00005 to /u01/app/oracle/oradata/test1/perfs.dbfchannel ora_disk_1: restoring datafile 00007 to /u01/app/oracle/oradata/test1/undotbs2.dbfchannel ora_disk_1: restoring datafile 00010 to /u01/app/oracle/oradata/test1/index01.dbfchannel ora_disk_1: reading from backup piece /dsk1/backup/test1/test1_240.bakchannel ora_disk_1: piece handle=/dsk1/backup/test1/test1_240.bak tag=tag20140920t152720channel ora_disk_1: restored backup piece 1channel ora_disk_1: restore complete, elapsed time: 00:00:35channel ora_disk_1: starting datafile backup set restorechannel ora_disk_1: specifying datafile(s) to restore from backup setchannel ora_disk_1: restoring datafile 00013 to /u01/app/oracle/oradata/test1/tbs_16.dbfchannel ora_disk_1: reading from backup piece /dsk1/backup/test1/test1_241.bakchannel ora_disk_1: piece handle=/dsk1/backup/test1/test1_241.bak tag=tag20140920t152720channel ora_disk_1: restored backup piece 1channel ora_disk_1: restore complete, elapsed time: 00:00:01channel ora_disk_1: starting datafile backup set restorechannel ora_disk_1: specifying datafile(s) to restore from backup setchannel ora_disk_1: restoring datafile 00001 to /u01/app/oracle/oradata/test1/system01.dbfchannel ora_disk_1: restoring datafile 00003 to /u01/app/oracle/oradata/test1/test1.dbfchannel ora_disk_1: restoring datafile 00006 to /u01/app/oracle/oradata/test1/dict1.dbfchannel ora_disk_1: reading from backup piece /dsk1/backup/test1/test1_239.bakchannel ora_disk_1: piece handle=/dsk1/backup/test1/test1_239.bak tag=tag20140920t152720channel ora_disk_1: restored backup piece 1channel ora_disk_1: restore complete, elapsed time: 00:00:45finished restore at 20-sep-14starting recover at 20-sep-14using channel ora_disk_1starting media recoveryrecover 失败......
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'
查看备份信息：