RE: online backup and alter system switch logfile

it looks like alter system archive log current; is the way to go.

Can anyone please clarify waht archived logs should be backed up when doing a online backup?

I have seen various online backup scripts that seem to take different approaches.

I have also seem the comment

"a backup script should never just back up "all the archived redologs." If a script does not restrict itself only to those logs that it knows to be archived, it may improperly try to back up an archived redolog that is not yet completely archived. To determine which logs are archived, a backup script should query the v$archived_log view to obtain a file list for copying."

What apporoach do you guys take?

> -----Original Message-----
> From: Jeremiah Wilton [SMTP:jwilton_at_speakeasy.net]
> Sent: 28 May 2002 16:18
> To: Multiple recipients of list ORACLE-L
> Subject: Re: online backup and alter system switch logfile
>
> On Tue, 28 May 2002, DBarbour_at_austin.isd.tenet.edu wrote:
>
> > Add a 'sleep' command to your UNIX-side shell script before you copy
> > the logs to ensure the log has finished writing. You need to have
> > that last archivelog - it contains the data regarding datafile
> > header record changes you'll need to apply in the event you have to
> > restore to sync up your controlfile.
>
> Sleep doesn't seem like a very reliable approach here. As has already
> been mentioned, Oracle provides a command that does not return until
> the current log is archived.
>
> alter system archive log current;
>
> In fact, this is one of the Oracle misconceptions I wrote about:
>
> http://www.speakeasy.org/~jwilton/oracle/switch-logfile-backups.html
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> > John Dunn <john.dunn_at_sefas.co.uk>
> >
> > I have a online backup script which issues the command
> >
> > ALTER SYSTEM SWITCH LOGFILE;
> >
> > immediately before copying the archived redo logs.
> >
> > Does this make sense? I am finding that the ARC process has not finished
> > archiving the log before I copy the archive logs
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeremiah Wilton
> INET: jwilton_at_speakeasy.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
-- 
Author: John Dunn
  INET: john.dunn_at_sefas.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).