Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Wednesday, 29 August 2012

RMAN-06059: expected archived log not found

Starting backup
current log archived
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 14:24:55
RMAN-06059: expected archived log not found, lost of archived log
compromises recoverability
ORA-19625: error identifying file /u02/oradata/scr9/archive/1_1160.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

I am writing this post in response of Mr. Nitin Geetam who is asking to share the answer for an interview question “While taking Rman backup, one archivelog missing .. how you will proceed?

This can happen for a variety of reasons; the file has been manually moved or deleted, the archive log destination has recently been changed, the file has been compressed, etc.
Your options are either to restore the missing file(s), or to perform a crosscheck. To perform a crosscheck, run the following command from within RMAN: 
RMAN> change archivelog all crosscheck;

It is advisable to perform a full backup of the database at this point. When an archive log crosscheck is performed, RMAN checks each archive log in turn to make sure that it exists on disk (or tape). Those that are missing are marked as unavailable. If you have got missing logs, this won't bring them back. It will allow you to get past this error and back-up the database though.

The other alternative way is that you can skip the particular range of missing archivelog while taking the backup.

Rman target sys/oracle@orcl3 catalog rman/rman@shaan
change archivelog from logseq = xxx until logseq =
yyy unavailable;

Note: xxx and yyy are the logseg numbers, the one's you are missing.


Post a Comment