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

Thread: Backup failed - due to missing archived log file

  1. #1
    Join Date
    Jul 2000
    Posts
    31
    Hi:

    I am having a problem with RMAN backups:

    I issued the following command to backup all the archived logs:

    backup
    (archivelog all
    delete input)

    It fails with the following error:

    RMAN-06089 archived log 'log file name' not found or out of sync with catalog.

    The reason it fails is because I accidentally deleted the files from the Unix file system - but I guess there are still references to it within the database.

    My question is - Is there a way for me to delete these references from the database. I don't really care about those archived log files anyway, but starting now I do want to backup all future archived log files.

    Thanks,

    Una.

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Can you post your entire RMAN script?

    Thanks.
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Jul 2000
    Posts
    31
    The script is as follows:

    create script online_database_bkup {
    # Hot database level 0 whole backup
    allocate channel t1 type DISK;
    backup
    incremental level 0
    skip inaccessible
    tag hot_db_bk
    # recommended format
    format 'bk_%s_%p_%t'
    (database);
    sql 'alter system archive log current';
    # backup all archive logs
    backup
    filesperset 20
    format 'al_%s_%p_%t'
    (archivelog all
    delete input);
    }


    I run it using the following command:

    run { execute script online_database_bkup; }

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    replace script online_database_bkup {
    # Hot database level 0 whole backup
    allocate channel t1 type DISK;
    backup
    incremental level 0
    skip inaccessible
    tag hot_db_bk
    # recommended format
    format 'bk_%s_%p_%t'
    (database include current controlfile);
    release channel t1;
    sql 'alter system archive log current';
    allocate channel t1 type DISK;
    # backup all archive logs
    backup
    filesperset 20
    format 'al_%s_%p_%t'
    (archivelog all
    delete input);
    release channel t1;
    }

    This would fix you the problem

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Jul 2000
    Posts
    31
    I tried the script with the modifications you suggested and it still fails...

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is your oracle and OS version, could you also give me all the errors you get?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    If the backup of archive logs done by rman fails for the reason some or one archive log file to be backed up is not available.. you may validate the archive logs by issuing change validate archive log all command from rman prompt and then back up the archive logs.
    sonofsita
    http://www.ordba.net

  8. #8
    Join Date
    Feb 2001
    Posts
    129
    for the missing archive logs... u can do the following

    connect target /
    connect catalog rman/pwd@rmancatalog
    run {
    change archivelog from logseq = xxx until logseq =
    yyy unavailable;
    }

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

  9. #9
    Join Date
    Jul 2000
    Posts
    50
    Hi!

    Complete resync your database with catalog:

    rman>resync database

    Then try your script. This should take care your problem

    regards,

    abhijit

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