DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Failure of backup

  1. #1
    Join Date
    Mar 2014
    Posts
    1

    Question Failure of backup

    Hello,

    i have a question regarding the ARCHIVE LOGS.

    After starting the backup with HP Data Protector we get this Message.
    The File ARC19788.001 is not present in the system anymore, i think somebody has deleted the file.
    The oldest ARCHIVE Log is "ARC22170.001"

    Is ist possible to reset the counter?

    Code:
    RMAN-03090: Starting backup at 11-MAR-14
    RMAN-03033: current log archived
    RMAN-08031: released channel: dev_0
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of backup command at 03/11/2014 20:16:36
    RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
    ORA-19625: error identifying file F:\DBMS_LOG\IASP\ARCHIVE\ARC19788.001
    If you need more Information please be so kind ans tell me the commands which i should type in.

    Thanks a lot

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You can use the following commands to remove the archive log from the control file.
    If you are using 11g you can set the archive log deletion policy to control how long
    archive logs are needed on disk. You may also want to change the archive log format.
    You will need to restart the database for it to take effect. I use the following:

    alter system set log_archive_format='mydb_%t_%s_%r.arc' scope=spfile;

    Code:
    CHANGE ARCHIVELOG ALL CROSSCHECK;
    CHANGE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3' UNAVAILABLE;
    SHOW ALL;
    CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;
    Last edited by gandolf989; 03-12-2014 at 12:14 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width