could anyone tell me how to switch the location of archive log file without shutdown db?
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
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/';
ORA-02095: specified initialization parameter cannot be modified
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?
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:
Hope this would help you.
ALTER SYSTEM SET LOG_ARCHIVE_DUPLEX_DEST= '...';
ARCHIVE LOG START filespec;
filespec: Your new archive destination;
thanks, it works, problem solved.