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-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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'
As this was an online backup, you should have issued a RECOVER DATABASE between the RESTORE DATABASE and OPEN RESETLOGS. I don't see a RECOVER DATABASE
(probably issued with a SET UNTIL clause as well ?)
The simplest way to check log sequence numbers is to look at the alert.log file which shows the log sequence numbers when you did the backup . A RECOVER would be rolling forward from the backup until the lastest archivelog (or online redo log if available).
hi guys, i have a similar problem, in my own case, the archivelogs are missing, as in they are lost, so i cannot apply them, is there some sort of solution or the database is not recoverable...?thanks in advance for your help.