Re: continuously copy archive redo logfiles to tape

From: Sai Selvaganesan <ssaisundar_at_sbcglobal.net>
Date: Wed, 15 Oct 2003 09:39:29 -0800
Message-ID: <F001.005D33FD.20031015093929@fatcity.com>

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
    >
    > --
    > Please see the official ORACLE-L FAQ: http://www.orafaq.net
    > --
    > Author: Roger Xu
    > INET: roger_xu_at_dp7uptx.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).
    

    ---

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sai Selvaganesan
  INET: ssaisundar_at_sbcglobal.net

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 - 12:39:29 CDT