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

Thread: How to physically remove and archive log

  1. #1
    Join Date
    Feb 2003
    Posts
    2

    Unhappy How to physically remove and archive log

    Hello all, I am trying to do an update backup using the EM console and apparently a particular log file was corrupted during the process. Therefore, each time I run a backup using EM I get this error stating below:

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of backup command at 02/07/2003 12:46:36
    RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
    ORA-19625: error identifying file D:\ORACLE\ORA90\RDBMS\ARC00003.001
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.

    Is there some way resetting this procedure

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

    Re: How to physically remove and archive log

    Run first

    change archivelog all validate;
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    You have to resync catalog. Checkout this link

    http://otn.oracle.com/docs/products/...cat.htm#434027
    Agasimani
    OCP(10g/9i/8i/8)

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