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

Thread: archive log dest

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    245

    could anyone tell me how to switch the location of archive log file without shutdown db?

    init.ora

    log_archive_dest = /ora/arch1/@/arch.log
    log_archive_duplex_dest = /ora/arch2/@/arch.log

    I know I can issue:

    alter system archive log stop;
    alter system archive log start to 'new location';

    but it only change the first one, how about the duplex dest?

    thnaks in advance

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    ALTER SYSTEM SET LOG_ARCHIVE_DEST = filespec

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    if init.ora is not changed when rebooted it shall the old destination ..hence also edit init.ora while issuing alter system command to change the arch destination
    sonofsita
    http://www.ordba.net

  4. #4
    Join Date
    Nov 2000
    Posts
    245
    I understand it can be changed from init.ora then bounce db.
    I need is "do not shutdown and restart instance".

    I tried from sqlplus and svrmgrl:
    ALTER SYSTEM SET LOG_ARCHIVE_DEST = '/ora2/arch1/DBU5/';
    get
    ORA-02095: specified initialization parameter cannot be modified

    any sgguestion?

    I need to change both destination not only one.
    alter system archive log start to 'new location'
    on can change one, not 2nd one


  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is your Oracle version?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Nov 2000
    Posts
    245

    8.0.6 on Unix

  7. #7
    Join Date
    Jul 2000
    Posts
    521
    The command is : (through svrmgrl)
    ARCHIVE LOG START TO 'your_new_destination';

    Of course, init.ora change has to be done for this new destination to be effective even after a shutdown.
    svk

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    O.K now it all makes sense.

    From your server manager try:
    Code:
     ALTER SYSTEM SET LOG_ARCHIVE_DUPLEX_DEST= '...';
    
     ARCHIVE LOG START filespec; 
    
      filespec: Your new archive destination;
    Hope this would help you.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  9. #9
    Join Date
    Nov 2000
    Posts
    245

    thanks, it works, problem solved.


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