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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: online backup and alter system switch logfile

RE: online backup and alter system switch logfile

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Wed, 29 May 2002 01:48:21 -0800
Message-ID: <F001.0046DAD2.20020529014821@fatcity.com>


Yes Alter System Achive Log Current is the way to go.

Now regarding what are the archive logs hat I will backup. My Script at the End of Each Backup routine will Backup all the archive Logs and then delete the same from the Log Dest in this way I only backup all the Logs that have been generated since the last backup and also by doing this I free a lot of space in my Archive Location.

HTH Best Regards,
Ganesh R

Tel  : +971 (4)  397 3337  Ext 420
Fax  : +971 (4)  397 6262
HP   : +971 (50) 745 6019
============================================
Live to learn... forget... and learn again.

-----Original Message-----
Sent: Wednesday, May 29, 2002 1:03 PM
To: Multiple recipients of list ORACLE-L

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ganesh Raja
  INET: ganesh_at_gtfs-gulf.com

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).
Received on Wed May 29 2002 - 04:48:21 CDT

Original text of this message

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