Can anyone please clarify what 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?
John
-Original Message-
From: Ganesh Raja [SMTP:[EMAIL PROTECTED]]
Sent: 29 May 2002 10:48
To: Multiple recipients of list ORACLE-L
Subject: RE: online backup and alter system switch logfile
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:[EMAIL PROTECTED]]
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, [EMAIL PROTECTED] 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 [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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