hi,
i am using oracle 11.2.0.1.0. We have configured rman using repository catalog configure in another database. We have perform incomplete recovery to restore database to previous scn, but the database fail to open shown error message, how to open the database?
RMAN-00571, RMAN-00569,RMAN-03002,
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
[code]
sql ) startup mount;
RMAN> run {
set until scn 1812690;
restore database;
recover database;
}
SQL>
recover database until cancel;
alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF'
[code]