changing archivelog destination

[tamilselvan]

It is nothing wrong to change the destination.
In fact, you should be familarize this quite often. This will help you whenever arch dest is full, you must be in a position to change the location.
See below:

SQL>
SQL> alter system set log_archive_dest_1='location=/tmp' ;

System altered.

SQL> alter system switch logfile;

System altered.


[ /tmp ]
UAT:SID=SBLTEST=>ls -al *.arc
-rw-r-----   1 oracle   dba            1024 Oct 26 08:24 sbltest_log_0000000033.arc


SQL> alter system set log_archive_dest_1='location=/opt/sblppr2/arch1/SBLTEST/arch' ;

System altered.

SQL>
SQL> alter system switch logfile;

System altered.


-rw-r-----   1 oracle   dba         2796032 Oct 23 20:22 sbltest_log_0000000031.arc
-rw-r-----   1 oracle   dba         7543808 Oct 26 08:21 sbltest_log_0000000032.arc
-rw-r-----   1 oracle   dba            6144 Oct 26 08:26 sbltest_log_0000000034.arc
drwxr-sr-x   2 oracle   dba            1024 Oct 26 08:26 ./

[ /opt/sblppr2/arch1/SBLTEST/arch ]
UAT:SID=SBLTEST=> 

sql>Alter system archive log stop
sql>alter system archive log start
Those 2 statements are not needed in 9i. W/o stop you change the destination.


Tamil