Hi there
I am facing a peculiar problem when restoring the database in prior point in time. Situations are as under :
1. I took zero level backup on 13/11/2015
2. I add a data file in the USERS tablespace on 16/11/2015
3. Next time I took incremental differential backup on 12/01/2016 ( as my tape based backup system was out of order)
I need to restore data of 31/12/2016
Data restoration I did as under :
--------------------
a. First I restore controlfile of 12/01/2016
b.
run{ set until time "to_date('2015-12-31:22:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
restore database; recover database;
alter database open resetlogs; }
When I am executing the above script I am getting the following errors :
executing command: SET until clause
Starting restore at 05-OCT-16
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=451 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 6.3.0.0
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=466 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/05/2016 01:22:15
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 20 found to restore
Note : data file 20 is that file which were added after zero level backup.
Please guide me to overcome from the errors.
Regards
Iqbal