Database Backup and Recovery (MOSC)

MOSC Banner

Cannot start 10g database on SUN after point in time recovery using RMAN.

edited Aug 25, 2009 8:31AM in Database Backup and Recovery (MOSC) 1 commentAnswered
 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 ;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center