Wednesday 14 August 2013

Archive log not found during oracle DB backup


I notice an issue with TDP for Oracle where the COLD DB backup + Archive failed with below error.


Starting backup at Aug 13 2013 02:47:08
ORACLE error from target database:
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log

allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=130 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protection for Oracle: version<version detais>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 08/13/2013 02:47:09
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /Path/to/oracle/archlog/<log_file_name.arc
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3




===================================

The above error means there is a problem with Archive log file.

First we should check the log file under given location /Path/to/oracle/archlog

--------------------------------------
//Path/to/oracle/archlog # ls -ltr Log name_96_1_822820066.arc
Log name_96_1_822820066.arc  not found
-------------------------------------

This means that during backup RMAN is looking for a log which does not exist. It may be possible the this log might have been deleted accidently by DBA, but since log file not found backup can not be completed. Here are some possible solutions:


1- Ask your DBA to do a crosscheck of backup ( using RMAN command) which will check the status of log and mark it expire or tell the catalog to NOT ask for this log during recovery time.

command >
RMAN> crosscheck backup;

specification does not match any backup in the repository


2- Check the size of FS which may lead to this issue.

run  df -g ( in AIX) to check the size of FS used. If FS is 100 %, make sure you have enough space in FS to have a backup.



1 comment:

  1. If you are considering having a data center in London, then it's very important for you to be aware of the various types of servers and other technology that are available in London Datacentre.

    ReplyDelete