Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Bhagawati on Sep 1 at 7:22 AM Hi Pranav,
It seems you did not get my question.
I want to maintain archive log in 2nd location in addition of it default location.
Basically system will write same log in two different location.
Regards,
Bhagawati Pandey
| | | ---------------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. __.____._ |   _.____.__ |
