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,

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.

Code:

---

ALTER SYSTEM ARCHIVE LOG START TO 'D:\ARCHIVE';

---

hi Sanjay,

it works ! thanks! :)