Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01152: file 1 was not restored from a sufficiently old backup

891490Sep 5 2012 — edited Sep 6 2012
hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 4 2012
Added on Sep 5 2012
11 comments
14,564 views