hi kirti
i was using the below method to copy archives to drsites and running this cron very frequently. the job used to ship and delete them immediately after successful copy and i used to have fuser check. but soon we started hitting this issue when we used to ship archives even when they are being used by the archiver.
i think you are using fuser to find whether the file is open and then you ship it. when i implemented this i thought archiver process open the archive file once and then starts copying the redo..which seems logical..but it so happens archiver closed the files (ran truss os ARCH process) frequently when writing to the same file and my fusuer check used to fail occasionally. This was in 8.1.7.2.
but these things may have changed now. just fyi.
thanks
sai
Kirtikumar Deshpande <[EMAIL PROTECTED]> wrote:
We use cron facility to run a script that copies archived log files, not in use by archiver
process, (fuser command) to a different location. We also use 'Autosys' software to run such
scripts on remote servers. Another script, that runs after the 'copying' script, confirms that the
'copying' was successful and removes 'copied' archived log from archived log destination....
When hired junior DBAs in the distant past, we 'oriented' them by asking them to manually do such
copying and removing of archived logs :)
- Kirti
--- Roger Xu <[EMAIL PROTECTED]>wrote:
>
> Hello,
>
> How do I continuously copy archive redo logfiles to tape ?
>
> Roger Xu
> Database Administrator
> Dr Pepper Bottling Company of Texas
> (972)721-8337
>
> --
> Please see the official ORACLE-L F! AQ: http://www.orafaq.net
> --
> Author: Roger Xu
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
