ORA-01152: file 1 was not restored from a sufficiently old backup
891490Sep 5 2012 — edited Sep 6 2012hi All,
i have took a level0 backup on 30/08/2012 using:
RUN{
ALLOCATE CHANNEL H1 DEVICE tYPE DISK MAXPIECESIZE 5G;
ALLOCATE CHANNEL H2 DEVICE TYPE DISK MAXPIECESIZE 5G;
ALLOCATE CHANNEL H3 DEVICE TYPE DISK MAXPIECESIZE 5G;
Backup INCREMENTAL level=0 as COMPRESSED
backupset database TAG
incremental_Leve0_bck_weekly
archivelog ALL DELETE ALL INPUT;
}
my script for restoring the backup is:
run{
allocate channel ch1 device type disk;
SET NEWNAME FOR DATAFILE 1 TO '/raid1/System/system01.dbf';
SET NEWNAME FOR DATAFILE 2 TO '/raid1/Sysaux/sysaux01.dbf';
---
----there are 44 files
restore database;
switch datafile all;
recover database;
release channel ch1;
}
when i restored this backup on different server with the same name we got the error message:
starting media recovery
media recovery failed
---
---
workarround:i fired the command
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
then it gave me this error:
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/raid1/System/system01.dbf'
ORA-01112: media recovery not started
now what are the posible solutions for that?
1:*apply archived log files*(but we don't have because every day level1 backup is scheduled and after that it deletes previous archived log files)
2: Apply incremental backup of 31/08/2012:(but i dont know how to apply that because control file is of 30/08/2012)
please help me ...
thanke you in advance.