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

Thread: archival fails

  1. 03-07-2003, 06:59 AM #1
    feng11
    feng11 is offline Junior Member
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    49

    archival fails

    Hi,

    Has anyone of you hit the problem wherby your archival fails to write the online redo logs to the archive logs? I'm running 8.1.6.0 on solaris 2.6ARC0: Beginning to archive log# 5 seq# 53978
    ARC0: Archiving not possible: No primary destinations
    ARC0: Failed to archive log# 5 seq# 53978
    Wed Mar 5 13:35:51 2003
    Thread 1 advanced to log sequence 53982
    Current log# 4 seq# 53982 mem# 0: /opt/oracle/oradata/prodb/redo4.log
    Current log# 4 seq# 53982 mem# 1: /opt/oracle/oradata/prodb/redo4a.log
    Wed Mar 5 13:35:51 2003
    ARC0: Beginning to archive log# 5 seq# 53978
    ARC0: Archiving not possible: No primary destinations
    ARC0: Archiving not possible: No primary destinations
    ARC0: Failed to archive log# 5 seq# 53978
    ARC0: Beginning to archive log# 5 seq# 53978
    ARC0: Archiving not possible: No primary destinations
    ARC0: Failed to archive log# 5 seq# 53978
    ARC0: Beginning to archive log# 5 seq# 53978
    ARC0: Archiving not possible: No primary destinations
    ARC0: Failed to archive log# 5 seq# 53978
    ARC0: Beginning to archive log# 5 seq# 53978
    ARC0: Archiving not possible: No primary destinations
    ARC0: Failed to archive log# 5 seq# 53978
    Regards
    CF
    Reply With Quote Reply With Quote
  2. 03-07-2003, 07:12 AM #2
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Can u show your 'archive' parameters ?

    This problem has been reported when using log_archive_dest_n. After switching to log_archive_dest it has been solved.

    Check these links...

    http://metalink.oracle.com/metalink/..._id=112482.996

    http://metalink.oracle.com/metalink/...id=1012967.102

    HTH.
    Last edited by ggnanaraj; 03-07-2003 at 07:15 AM.
    Reply With Quote Reply With Quote
  3. 03-07-2003, 07:14 AM #3
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Has it worked before and just now started to fail? Or is this the first time you have tried?

    Do you have "log_archive_dest = " in your init.ora?
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
  4. 03-07-2003, 07:16 AM #4
    feng11
    feng11 is offline Junior Member
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    49
    I only have one archive destination:


    # Uncommenting the lines below will cause automatic archiving if chiving has
    # been enabled using ALTER DATABASE ARCHIVELOG.
    log_archive_start = true
    log_archive_dest_1 = "location=/opt/oracle/admin/mrprodb/arch"
    log_archive_format = arch_%t_%s.arc
    Regards
    CF
    Reply With Quote Reply With Quote
  5. 03-07-2003, 07:26 AM #5
    feng11
    feng11 is offline Junior Member
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    49
    My production database has been running for 2 years and this is the first time such error messages happens.
    Regards
    CF
    Reply With Quote Reply With Quote
  6. 03-07-2003, 07:26 AM #6
    samx18's Avatar
    samx18
    samx18 is offline Junior Member
    Join Date
    May 2002
    Posts
    36
    log_archive_dest_1 = "location=/opt/oracle/admin/mrprodb/arch"
    Try using the parameter log_archive_dest instead.
    Reply With Quote Reply With Quote
  7. 03-07-2003, 11:41 AM #7
    feng11
    feng11 is offline Junior Member
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    49

    Thumbs up

    Thank you , samx18, DaPi, ggnanaraj. Really appreciate the help.

    Cheers!
    Regards
    CF
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width