Subject:  RMAN-6026 RMAN-6023 Restoring Database 
Type:  PROBLEM 
Status:  PUBLISHED 
 Content Type:  TEXT/PLAIN 
Creation Date:  14-FEB-2001 
Last Revision Date:  25-MAR-2002 
 

Problem Description -------------------  You have added a new tablespace since your last backup was taken on the 02/13/01. You do not need this tablespace anymore so you run an rman job to restore the  controlfile and the database from the latest backup.  Recovery Manager: Release 8.1.7.0.0 - Production  RMAN-06006: connected to target database: testrman (not mounted) RMAN-06008: connected to recovery catalog database  RMAN>  RMAN> run { 2> allocate channel d1 type disk; 3> restore controlfile; 4> alter database mount; 5> restore database; 6> release channel d1; 7> } RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=13 devtype=DISK  RMAN-03022: compiling command: restore  RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel d1: starting datafile backupset restore RMAN-08502: set_count=3 set_stamp=421584951 creation_time=13-FEB-01 RMAN-08021: channel d1: restoring controlfile RMAN-08505: output filename=/srvr1/u01/oradata/testrman/control01.ctl RMAN-08023: channel d1: restored backup piece 1 RMAN-08511: piece handle=/export/home/gxanders/rman/03ci1o1n_1_1 tag=null params=NULL RMAN-08024: channel d1: restore complete RMAN-08058: replicating controlfile RMAN-08506: input filename=/srvr1/u01/oradata/testrman/control01.ctl RMAN-08505: output filename=/srvr1/u01/oradata/testrman/control02.ctl RMAN-08505: output filename=/srvr1/u01/oradata/testrman/control03.ctl  RMAN-03022: compiling command: alter db RMAN-06199: database mounted  RMAN-03022: compiling command: restore RMAN-03025: performing implicit partial resync of recovery catalog RMAN-03023: executing command: partial resync RMAN-08003: starting partial resync of recovery catalog RMAN-08005: partial resync complete  RMAN-03022: compiling command: IRESTORE RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: d1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure during compilation of command RMAN-03013: command type: restore RMAN-03002: failure during compilation of command RMAN-03013: command type: IRESTORE RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 2 found to restore  The restore job fails because it is looking for a backup of the datafile that belongs to the the new tablespace that has been added since the last backup was taken.  Solution Description --------------------  You need to specify the "SET UNTIL" time clause in the restore job to a time  before the new tablespace was added.   Recovery Manager: Release 8.1.7.0.0 - Production  RMAN-06006: connected to target database: testrman (not mounted) RMAN-06008: connected to recovery catalog database  RMAN>  RMAN> run { 2> allocate channel d1 type disk; 3> set until time '13-FEB-01 10:45:00'; 4> restore controlfile; 5> alter database mount; 6> restore database; 7> release channel d1; 8> } RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=13 devtype=DISK  RMAN-03022: compiling command: set  RMAN-03022: compiling command: restore  RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel d1: starting datafile backupset restore RMAN-08502: set_count=3 set_stamp=421584951 creation_time=13-FEB-01 10:55:51 RMAN-08021: channel d1: restoring controlfile RMAN-08505: output filename=/srvr1/u01/oradata/testrman/control01.ctl RMAN-08023: channel d1: restored backup piece 1 RMAN-08511: piece handle=/export/home/gxanders/rman/03ci1o1n_1_1 tag=null params=NULL RMAN-08024: channel d1: restore complete RMAN-08058: replicating controlfile RMAN-08506: input filename=/srvr1/u01/oradata/testrman/control01.ctl RMAN-08505: output filename=/srvr1/u01/oradata/testrman/control02.ctl RMAN-08505: output filename=/srvr1/u01/oradata/testrman/control03.ctl  RMAN-03022: compiling command: alter db RMAN-06199: database mounted  RMAN-03022: compiling command: restore RMAN-03025: performing implicit partial resync of recovery catalog RMAN-03023: executing command: partial resync RMAN-08003: starting partial resync of recovery catalog RMAN-08005: partial resync complete  RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel d1: starting datafile backupset restore RMAN-08502: set_count=3 set_stamp=421584951 creation_time=13-FEB-01 10:55:51 RMAN-08089: channel d1: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 00001 to /srvr1/u01/oradata/testrman/system01.dbf RMAN-08023: channel d1: restored backup piece 1 RMAN-08511: piece handle=/export/home/gxanders/rman/03ci1o1n_1_1 tag=null params=NULL RMAN-08024: channel d1: restore complete RMAN-03023: executing command: partial resync RMAN-08003: starting partial resync of recovery catalog RMAN-08005: partial resync complete  RMAN-03022: compiling command: release RMAN-03023: executing command: release RMAN-08031: released channel: d1      Explanation -----------  When a restore command is run from RMAN and if NO "SET UNTIL" clause is defined, RMAN will try and restore backups for all the datafiles in the database at the present time. If a "SET UNTIL" clause is defined, then RMAN will restore   only the datafiles that exist in the database that match the specified point  of time in the "SET UNTIL" time clause.