Re: benefits of multiple switch logfile calls?

From: Don Seiler <don_at_seiler.us>
Date: Tue, 06 Jan 2004 16:01:44 GMT
Message-ID: <pan.2004.01.06.16.03.18.335821@seiler.us>

On Thu, 11 Dec 2003 05:45:52 -0800, lsattle wrote:

> drak0nian_at_yahoo.com (Paul Drake) wrote in message news:<1ac7c7b3.0312081614.7d4515d9_at_posting.google.com>...
>> lsattle_at_yahoo.com (lsattle) wrote in message news:<95898986.0312040755.16c6f7ac_at_posting.google.com>...

>> > Note I now believe these last steps are out of order.  I think we
>> > should get the controlfile backup first, and then get the log switch. 
>> > Note we do restore the backup of the control file before the recovery
>> > because again who knows where in the backup process the controlfile
>> > was backed up.
>> 
>> just snipping at one point:
>> you will be better off, if you backup controlfile to <dest> 
>> and then archive the current logfile afterwards.
>> 
>> if you use the binary version of the backup controlfile, it will be
>> asking for the logfile to be applied that has not yet been archived,
>> in other words, file#1 needs more recovery.

> Yes I understand what you are saying. I think I brought this same
> issue up in some of my dialogue with HJR. I will explain why we don't
> get burned (Howard answered it in other posts to this thread). When
> we do the recovery, with the parm "using backup controlfile until
> cancel" the recovery goes until it runs out of archive redo logs.
> Howard's argument to rebuild the controlfile during the recovery with
> the bu to trace file will produce the same results. If we happen to
> have 2 more hours of redo (or even a couple of days worth) we can keep
> the recovery going till oracle can't the next numbered one.

Well our current script (the one for Oracle 7 that was written long ago, does the 3 log switch calls, then backs up the tablespaces, then backs up the controlfile to dest.

So I should be backing up the controlfile before archiving the logs? And should one ALTER SYSTEM ARCHIVE LOG CURRENT be sufficient?

If anyone has a backup script that they use for 9i (not using RMAN) I'd love to see it. Received on Tue Jan 06 2004 - 10:01:44 CST