$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
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
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
Hi All,
You do not need to archive the log files.
Alter system switch logfile does not return until
the logfile is written to disk. For recovery purposes
the location of the logfile does not matter as long
as it has been written.
On Wed, 29 May 2002, Dave Morgan wrote:
You do not need to archive the log files.
Alter system switch logfile does not return until
the logfile is written to disk.
This is demonstrably untrue, and incredibly easy to disprove. Try it
yourself!
SQL select group#,
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
You Should Be Using
Alter System Archive Log Current / ALL
This will wait till the archive Process has written out the archivelog
unlike the Alter System Switch Log file.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
controlfile.David A. BarbourOracle DBA, OCPAISD512-414-1002John Dunn [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]05/28/2002 03:08 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Subject: online backup and alter system switch logfile I have a online
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