archive log dest

could anyone tell me how to switch the location of archive log file without shutdown db?

init.ora

log_archive_dest = /ora/arch1/@/arch.log
log_archive_duplex_dest = /ora/arch2/@/arch.log

I know I can issue:

alter system archive log stop;
alter system archive log start to 'new location';

but it only change the first one, how about the duplex dest?

thnaks in advance

ALTER SYSTEM SET LOG_ARCHIVE_DEST = filespec

Sam

if init.ora is not changed when rebooted it shall the old destination ..hence also edit init.ora while issuing alter system command to change the arch destination

I understand it can be changed from init.ora then bounce db.
I need is "do not shutdown and restart instance".

I tried from sqlplus and svrmgrl:
ALTER SYSTEM SET LOG_ARCHIVE_DEST = '/ora2/arch1/DBU5/';
get
ORA-02095: specified initialization parameter cannot be modified

any sgguestion?

I need to change both destination not only one.
alter system archive log start to 'new location'
on can change one, not 2nd one

What is your Oracle version?

Sam

8.0.6 on Unix

The command is : (through svrmgrl)
ARCHIVE LOG START TO 'your_new_destination';

Of course, init.ora change has to be done for this new destination to be effective even after a shutdown.

O.K now it all makes sense.

From your server manager try:

Code:

---


 ALTER SYSTEM SET LOG_ARCHIVE_DUPLEX_DEST= '...';

 ARCHIVE LOG START filespec;

  filespec: Your new archive destination;

---

Hope this would help you.

Sam

thanks, it works, problem solved.