This discussion is archived
9 Replies Latest reply: May 12, 2011 2:40 PM by 835273 RSS

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

656500 Newbie
Currently Being Moderated
hi
i want to make a copy from a databse to new host by rman (hot backup).
first i do a backup from primary db (with controlfile autobackup ) :

printing stored script: full_db
{
allocate channel c1 type disk format '/home/oracle/backup/%s%d.bck';
backup archivelog all delete input filesperset=10 ;
backup full database filesperset =4 ;
}

then i copy this files to secondary host and then :

1- $./rman
2- RMAN>connect target /
3- RMAN>startup nomount ;
4- RMAN>restore spfile from '/.......' ;
5- RMAN>startup force nomount ;
6- RMAN>restore controlfile from '/.......' ;
7- RMAN>shutdown ;
8- RMAN>exit ;
9- $./rman target /
10- RMAN>startup mount ;
11- RMAN>restore databse ;


and here , when i issue this command : "alter databse open resetlogs;" rman display this error :

RMAN> alter database open resetlogs ;

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 08/24/2008 17:40:48
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'


what's means this error ?

thx in adv.