Database Backup and Recovery (MOSC)

MOSC Banner

RMAN recovery failure

edited Aug 29, 2013 7:23AM in Database Backup and Recovery (MOSC) 11 commentsAnswered
Hello Everyone,
- Database: 11.2.0.2, 2 Node RAC Standard Edition
- OS: Oracle Linux 5 x86_64
- I'm not usung rman catalog

RMAN is looking for an archivelog that is required to recover a datafile which is already very old and already offline and dropped:

 RMAN-03002: failure of recover command at 08/26/2013 10:42:03
 RMAN-06053: unable to perform media recovery because of missing log
 ........................................................................................................................................................
 RMAN-06025: no backup of archived log for thread 2 with sequence 28370 and starting SCN of 33205631064 found to restore
 RMAN-00567: Recovery Manager could not print some error messages

Manual recovery from a sqlplus session fails with:

 SQL> recover database using backup controlfile;
 ORA-00279: change 32419144707 generated at 07/11/2013 02:32:05 needed for

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