BABU123
asked on
ORA-01152: file 1 was not restored from a sufficiently old backup
I am getting the following error
RMAN> alter database open resetlogs;
RMAN-00571: ========================== ========== ========== ========== ===
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ========================== ========== ========== ========== ===
RMAN-03002: failure of alter db command at 04/02/2010 10:28:11
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oracle/oradata/xxx/syste m01.dbf'
RMAN> alter database open resetlogs;
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-03002: failure of alter db command at 04/02/2010 10:28:11
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oracle/oradata/xxx/syste
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We are testing restore and recovery using RMAN
1.I FTPed all the backup files from production to development box.
2. Issue restore controlfile from this backup copy from production..WORED FINE
3. Issued RESTORE database= Worked fine
RMAN> recover database;
Starting recover at 02-APR-10
using channel ORA_DISK_1
starting media recovery
unable to find archive log
archive log thread=1 sequence=33391
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 3 was not restored from a sufficiently old backup
ORA-01110: data file 3: '/oracle/oradata/XXC/cwmli
If I am doing wrong...please provide the steps I should do
giving err
2