Archive Log Missing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Archive Log Missing

  1. #1
    Join Date
    Jan 2003
    Location
    Caçador (SC) - Brazil
    Posts
    56

    Archive Log Missing

    Hi all!

    There is my problem:

    My Oracle 8.1.7 in on archivelomg mode. When I do a Hot Backup it fails saing that "archived log E:\ORACLE\ORADATA\CENTRAL\ARCHIVE\CENTRALT001S00521.ARC not found or out of sync with catalog
    This file really doesn´t exists. It was deleted on my server.
    Ok. My first archivelogfile is CENTRALT001S00825. My question is: How can I say to Oracle that it is my first file, and that it has to start backup from this, and not from CENTRALT001S00521?

    I really thanks by your help!!
    Adilsom José Musskopf
    Live like each of your days was the last.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Archive Log Missing

    Run:

    rman target / catalog rman/rman@catalog

    CHANGE ARCHIVELOG ALL VALIADATE;
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    change archivelog all crosscheck;

    Since you are missing an archived redo log, you should take a full backup IMMEDIATELY. Otherwise you might not be able to recover up to current.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jan 2003
    Location
    Caçador (SC) - Brazil
    Posts
    56
    Thanks for all answers!!

    Will it be a good Idea to put my Db on "NOARCHIVELOG" mode, close and start it and, next, put it again on "ARCHIVELOG" mode, and close and start it again? If I do that, will not it to start a new sequence of ARL??

    May this cause any trouble on my db?
    Adilsom José Musskopf
    Live like each of your days was the last.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    You can put your DB in noarchivelog mode for as long as you want. However, realize your backup is in jeapordy while the database is in noarchivelog mode. If you must be in noarchivelog mode, when you switch back, immediately take a full backup.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Jan 2003
    Location
    Caçador (SC) - Brazil
    Posts
    56
    OK

    My sincere thanks by your help!!
    Adilsom José Musskopf
    Live like each of your days was the last.

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