Recover from Level 0 backup
My data base is running on ARCHIVE log mode and my RMAN level 0 backup completed at 13-mar-2011 12:59. I have deleted all of the archive logs generated since last rman backup ( 12 march ) due to space constraint before RMAN Level 0 backup starts on 13 march. and there are few ARchive log files were exists during backup which are generated after ARchive deletion and included in backup data sets.
I tried Point in time recovery with util time as 13-mar-2011 12:30. But it failed becauze it required more archive logs to apply for consistency which i dont have .
Is it possible to try cancel based recovery so that i can cancel if archive logs are not there using RMAN. or how do i see the valid log seqence no so that i can mention until log sequence. Please help me.
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/prd_db/psftp/gbl/PSFTPRD5/u02/system01.dbf'
syntax i used.
connect catalog rman/rman@PSECGRCT
set dbid 4151495469;
connect target /;
startup nomount;
run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
restore controlfile from '/stage2/prd_backup/PS_stm6teh4_1_1';
alter database mount;
SET UNTIL TIME '13-MAR-2011 12:30:00';
catalog start with '/stage2/prd_backup' NOPROMPT;
restore database;
switch datafile all;
recover database;
alter database open resetlogs;
}
Can someone pleas help me.
Edited by: lm**** on Mar 13, 2011 3:28 PM