-
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
Thanx
Sam
Life is a journey, not a destination!
-
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
sonofsita
http://www.ordba.net
-
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
Thanx
Sam
Life is a journey, not a destination!
-
-
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.
svk
-
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
Thanx
Sam
Life is a journey, not a destination!
-
thanks, it works, problem solved.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|