Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: [q] How to pick up archived logs

Re: [q] How to pick up archived logs

From: LEV <lev_at_hq.icb.chel.su>
Date: 1997/02/21
Message-ID: <01bc1fbe$65206380$0acd3ac2@lev.hq.icb.chel.su>#1/1

Vasily R. Kraskovsky <vasily_at_kvr.spb.ru> wrote in article <ABD0zpsGbH_at_kvr.spb.ru>...
> Hi!
>
> I have Oracle 7.3.2 under Solaris 2.5 on my place, and I need to switch
> database backup mode from full-offline backup to online backup, trying to
> attain 24-hour database accsessibility. So I want to pick up archive logs
> when they are already finished archiving, move them to another server,
 and
> there add/compress them to solid archive.
>
> Question: How can I detect from unix (ksh script starting by cron) that
> Oracle have completed another log to archiving, and it can be moved to
> another place? Help, please.
>

       First execution of ksh script

  1. Get a log-file date/time
  2. Copy it to destination

       Next execution
   3. Compare log-file date/time with previous    5. If equal or older then remove it

       If newer, then copy it again. Received on Fri Feb 21 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US