Forum Discussion

nanoboy23's avatar
nanoboy23
Level 3
16 years ago

Oracle Failed Backup

Im currently experiencing errors on my online oracle database backup. It seems that the backup is finding a missing archive log.

But as I look on my archivelog directory the missing archive log is really missing.

Please refer below:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 07/29/2009 21:28:21
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /ed07/archivelog/PROD/PROD_1_37116_675116688.arc
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory

How will I eliminate this error?

Any help?
7.1.x and Earlier
Backup and Recovery
NetBackup
  • gilbert08's avatar
    gilbert08
    16 years ago
    The archived log was not found. The repository thinks it does exist. If the archived log has in fact been lost and there is no backup, then the database is no longer recoverable across the point in time covered by the archived log. This may occur because the archived log was removed by an outside utility without updating the repository.

    Action: If the archived log has been removed with an outside utility and the archivelog has already been backed up, then you can synchronize the repository by running CROSSCHECK ARCHIVELOG ALL.


    If the archivelog has not been previously backed up, then you should take a full backup of the database and archivelogs to preserve recoverability.

    Previous backups are not fully recoverable.

    RMAN> Change Archivelog All Crosscheck;
    Oracle 9i:
    RMAN> crosscheck archivelog all ;


    Hope this answers your question.

    Thanks,
  • gilbert08's avatar
    gilbert08
    Level 5
    16 years ago
    The archived log was not found. The repository thinks it does exist. If the archived log has in fact been lost and there is no backup, then the database is no longer recoverable across the point in time covered by the archived log. This may occur because the archived log was removed by an outside utility without updating the repository.

    Action: If the archived log has been removed with an outside utility and the archivelog has already been backed up, then you can synchronize the repository by running CROSSCHECK ARCHIVELOG ALL.


    If the archivelog has not been previously backed up, then you should take a full backup of the database and archivelogs to preserve recoverability.

    Previous backups are not fully recoverable.

    RMAN> Change Archivelog All Crosscheck;
    Oracle 9i:
    RMAN> crosscheck archivelog all ;


    Hope this answers your question.

    Thanks,
  • Venkatesh_K's avatar
    Venkatesh_K
    Level 5
    16 years ago
    gilbert08,

    i have been facing simalar issues so need your help.

    when u say outside utility might have backedup the archive, wt are these outside utility exactly ?
    are these other backup tools used if yes which tool are these in particular


    Hi nanoboy23,

    when tyhe RMAn is showing error from its logs what does netbackup say ? i mean what error code does it give



    thanks,
    Venkat
  • gilbert08's avatar
    gilbert08
    Level 5
    16 years ago

    The outside utility Iam saying is when you the archive log backup was manually remove and store to other path/location or even other storage.Archive log should be sync on your rman so when the backup scrpt run it will automatically find the archive and backup it up. Archive log is required to backup.
    The error I got from master server end is failed to backup the requested file (5).Where only parent job was failed while child job are all successful.

    I think nanoboy have the same error as well.