oracle 126.96.36.199, can we set log_Archive_dest dynamically??
I am running Oracle 188.8.131.52 , 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...
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...
Last edited by ggnanaraj; 03-05-2003 at 02:06 AM.
ALTER SYSTEM ARCHIVE LOG START TO 'D:\ARCHIVE';
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
it works ! thanks!
Click Here to Expand Forum to Full Width