Log actively being archived by another process
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Log actively being archived by another process

  1. #1
    Join Date
    Sep 2004
    Posts
    54

    Question Log actively being archived by another process

    Dear All,

    I am having following problem in one Oracle 10g database.

    ARC0: Unable to archive log 2 thread 1 sequence 40985
    Log actively being archived by another process


    I suspect that on a shell scripts being run arround the sale time.

    The code looks like this
    =======================
    sqlplus "/ as sysdba" < alter system switch logfile;
    alter system switch logfile;
    alter system switch logfile;
    archive log all;
    EOF


    # Use rman to create backup pieces for the archived logs and a controlfile backu
    p
    rman target=/ nocatalog < backup archivelog from time 'SYSDATE-$3' tag = 'archivelogs backup' format '/u4
    /backup/TASKPAK_$1_t%t_s%s_p%p.arc';
    backup current controlfile tag = 'cf separate backup' format='/u4/backup/TASKPA
    K_$1_t%t_s%s_p%p.controlfile';
    EOF

    =====================

    Could someone advise what causing this problems ?

    Please advise.

    Thanks

    V.

  2. #2
    Join Date
    Sep 2004
    Posts
    54
    Do we get the above error if a redo file is empty and we try to archive it ?

  3. #3
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    thats not a major issue..

    Check below...

    http://forums.oracle.com/forums/thre...sageID=2228643
    Rgds
    Parag

  4. #4
    Join Date
    Sep 2004
    Posts
    54
    Quote Originally Posted by paragp1981
    thats not a major issue..

    Check below...

    http://forums.oracle.com/forums/thre...sageID=2228643
    Thanks

    Vineet

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