| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: online backup and alter system switch logfile
John,
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.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
John Dunn <john.dunn@sefas.co.uk>
Sent by: root@fatcity.com
05/28/2002 03:08 AM PST
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
cc:
bcc:
Subject: online backup and alter system switch logfile
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
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: john.dunn@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@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).
 |
 |