changing archivelog destination

[k007]

Hello all,

Is it possible to change the archivelogs destination on a live database. I have oracle 10g on linux. We are not using the DB_RECOVERY_FILE_DEST , instead are using ARCHIVELOG_DEST. Can someone let me know the steps to change this parameter. Will doing the following work

cp

alter system set ARCHIVELOG_DEST ''

Will this affect the current archived logs


Thanks for your help
--K

[k007]

Hello,

A correction in my original post

What I meant to say was

Will the following work

# cp old_archive_logs new_location/old_archive_logs

sql> alter system set ARCHIVE_LOG_DEST 'new location'

Thanks
--K

[akhadar]

certainly u can change the archive log destination dynamically by using the command what u mentioned.Then check the database archive process that it shouldn't stuck and here should be normal database activity.suppose the archive process is stuck then use
sql>Alter system archive log stop
sql>alter system archive log start

[marist89]

Originally posted by k007

# cp old_archive_logs new_location/old_archive_logs

sql> alter system set ARCHIVE_LOG_DEST 'new location'

I wouldn't do that. The database keeps track of where it archived the redo to. By moving it by hand your backup program could lose it depending on how smart it is.

Just:
ALTER SYSTEM LOG ARCHIVE START TO 'new_location';

If you want to change it permanently, change your init.ora file or set your parameter with scope=pfile.

[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

[k007]

Hello all,

Thanks for the reponses.

When I had first configured archivelogs, I set the parameter
ARCHIVE_LOG_DEST = /x/y/z

I am using oracle 10g

Will it be possible for me to use
ARCHIVE_LOG_DEST_1="location=/a/b/c"
now ?

or it would not allow to use ARCHIVE_LOG_DEST_n parameter since ARCHIVE_LOG_DEST is already set ?

Thanks
--K