Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Santosh.Vukkalkar on Sep 1 at 7:40 AM Hi,
To set the archiving destination using LOG_ARCHIVE_DEST_*n*:
1. Edit the LOG_ARCHIVE_DEST_*n* parameter to specify from one to five
archiving locations. For example, enter:
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arc/'LOG_ARCHIVE_DEST_2 =
'LOCATION=/disk2/arc/'LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arc/'
Thanks.
Regards,
Santosh.
| | | ---------------Original Message---------------
From: pranavdesai123
Sent: Tuesday, September 01, 2015 7:28 AM
Subject: Oracle Archive Log In Different Location
Hi kindly check
the Unix move command is "mv".
So you can login to your Unix box as orasid (replace sid with your SID in lowercase).
Find a dir that has free space (depend on which flavor of Unix you have you can either do "df" or "bdf" to see which file system has enough free space).
Let's assume /oracle/stage has 10GB free space, type in this:
mkdir /oracle/stage/oraarch
mv /oracle/SID/oraarch/*.dbf /oracle/stage/oraarch/
HOWEVER, make sure that you will backup this separate directory in some way. The ordinary brarchive or RMAN backup won't backup archive logs in other dir. So if you Manually moved these archive logs but do not Manually back them up, you won't be able to recover with these files in case you need to.
Regards,
Pranav |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
