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

Thread: oracle 7.3.3.5, can we set log_Archive_dest dynamically??

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456

    oracle 7.3.3.5, can we set log_Archive_dest dynamically??

    HI,

    I am running Oracle 7.3.3.5 , is there a way for me to change the Log_Archive_dest dynamically w/o shutting DB server down?? i tried to but it failed...

    thanks,

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    If you are performing a recovery on an offline tablespace this is possible by using LOGSOURCE parameter of SET command in Server Manager. Now you use ALTER DATABASE RECOVER ... FROM...

    HTH.
    Last edited by ggnanaraj; 03-05-2003 at 03:06 AM.

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Code:
    ALTER SYSTEM ARCHIVE LOG START TO 'D:\ARCHIVE';
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  4. #4
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    hi Sanjay,

    it works ! thanks!

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