-
my instance has 2 archive log dest:
log_archive_dest =/ora1/arch/arch.log
log_archive_duplex_dest=/ora2/arch/arch.log
now I need to move them to different location without shutdown the instance
move /ora1/arch/arch.log to /ora1/arch/DBA1/arch.log
move /ora2/arch/arch.log to /ora2/arch/DBA1/arch.log
could someone tell me the syntax
thanks in advance
-
How about:
ALTER SYSTEM SET log_archive_dest='/ora1/arch/DBA1/arch.log'
and,
ALTER SYSTEM SET
log_archive_duplex_dest='/ora2/arch/DBA1/arch.log'
Both LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST are dynamic parameters - you don't need to shut down the instance to modify there values.
-amar
-
Will the init***.ora file be updated automatically or will he have to change that as well?
MH
-
The init.ora file will most definitely NOT be updated. When the instance is bounced it would revert back to the old values (different in 9i BTW)
Jeff Hunter
-
do I have to issue
alter system archive log current
before switch to the new location?
-
Hi
As Jeff surely it will not update the init.ora file you will have to change the init.ora file setting and bounce the database to make those changes permanent.
Yes do a alter system archive log current before you switch
Regards
Santosh
-
thanks I tried it works but I read from some place, I can use
alter system archive log stop;
alter system archive log start to 'new locatin';
does this work? if yes, how I switch the 2nd archive log location?
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
|