RMAN recovery case -- Incomplete recovery error case

RMAN recovery case-Incomplete recovery error case RMAN recovery case: Incomplete recovery, recovery failed due to a backup error in the previous data file. [Oracle @ rh6 ~] $ RmantargetRecoveryManager: Relea

RMAN recovery case-Incomplete recovery error case RMAN recovery case: Incomplete recovery, recovery failed due to a backup error in the previous data file. [Oracle @ rh6 ~] $ Rmantarget/RecoveryManager: Relea

RMAN recovery case -- Incomplete recovery error case

RMAN recovery case:

Incomplete recovery: The Restoration fails due to an error in the backup of the previous data file.

[Oracle @ rh6 ~] $ Rman target/Recovery Manager: Release 11.2.0.1.0-Production on Sat Sep 20 15:54:25 2014 Copyright (c) 1982,200 9, 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 '2017-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 partition command: SET until clauseStarting restore at partition channel: ORA_DISK_1channel ORA_DISK_1: SID = 18 device type = DISKflashing back control file to SCN 9601534 channel 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/kerberora_disk_1: restoring datafile 00010 to/u01/app/oracle/oradata/test1/index01.dbfchannel ORA_DISK_1: reading from backup piece/dsk1/backup/test1/export ORA_DISK_1: piece handle =/dsk1/backup/test1/TEST1_240.bak tag = export 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 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 = stored 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 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/export ORA_DISK_1: piece handle =/dsk1/backup/test1/TEST1_239.bak tag = export ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00: 00: 45 Finished restore at 20-SEP-14Starting recover at 20-SEP-14using channel ORA_DISK_1starting media recovery

Recover failed ......

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'

View the backup information: