Re: benefits of multiple switch logfile calls?

On Fri, 05 Dec 2003 07:58:07 +1100, Howard J. Rogers wrote:
> It makes no difference. The controlfile trace script cheats. It re-creates
> the controlfile empty; it then populates the controlfile with pointers to
> where all the data files and online redo logs are. It then hares off down
> those pointers to read the SCN in the header of each datafile. It takes the
> highest SCN it finds, and writes that into the SCN of the new controlfile.
> It then uses that as the basis for performing recovery. Therefore, it is
> irrelevant when you take the tracefile backup, because the new controlfile
> starts virgin and uses the existing state of the surviving components of the
> database as a way of reconstructing itself.

Well my latest attempt failed as well. This past attempt I rebuilt the control file from trace. Still ran into it wanting an archive log file that I didn't have and so my datafiles need more recovery. Looks like I get more Oracle 7 migration practice.

I just now noticed Burt Peltier's suggestion that I should be doing an ALTER SYSTEM CHECKPOINT before the ALTER SYSTEM ARCHIVE LOG CURRENT. I haven't been doing this, do you believe it will make a critical difference? Received on Fri Feb 27 2004 - 09:54:01 CST