Cannot start 10g database on SUN after point in time recovery using RMAN.
I cannot start my 10g database on SUN after point in time recovery using RMAN.
In alert log can see for each datafile errors like :
Errors in file /u01/oracle/admin/ORCL/udump/orcl1_ora_28201.trc:
ORA-01177: data file does not match dictionary - probably old incarnation
ORA-01110: data file 6: '+DGDB/blue_auto_indx01.dbf'
Error 1177 happened during db open, shutting down database
USER: terminating instance due to error 1177
I used next RMAN commands and there was no error during restore:
RMAN> run
2> {
3> set until time ="to_date('08/18/2009 15:00:00','mm/dd/yyyy hh24:mi:ss')";
4> RESTORE DATABASE ;
5> RECOVER DATABASE ;
Errors in file /u01/oracle/admin/ORCL/udump/orcl1_ora_28201.trc:
ORA-01177: data file does not match dictionary - probably old incarnation
ORA-01110: data file 6: '+DGDB/blue_auto_indx01.dbf'
Error 1177 happened during db open, shutting down database
USER: terminating instance due to error 1177
I used next RMAN commands and there was no error during restore:
RMAN> run
2> {
3> set until time ="to_date('08/18/2009 15:00:00','mm/dd/yyyy hh24:mi:ss')";
4> RESTORE DATABASE ;
5> RECOVER DATABASE ;
0