Sai,
We do not delete the files right away. The 'delete' scripts verifies that the file is present
(with correct file size) at the destination before deleting it. We have not had any problems with
this method for over 5 years now.
I never used 8.1.7.2 much, so I can't say how the ARCH process behaved in that version.
- Kirti
- Sai Selvaganesan <ssaisundar_at_sbcglobal.net> wrote:
> 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 <kirtikumar_deshpande_at_yahoo.com> 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 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
> >
>
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: kirtikumar_deshpande_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Wed Oct 15 2003 - 14:14:25 CDT
