On Fri, 05 Dec 2003 07:58:07 +1100, Howard J. Rogers wrote:
>> Also, Howard, you think that just the ALTER SYSTEM ARCHIVE LOG CURRENT;
>> statement is enough? Does it matter if we do it before or after backing
>> up the control file to trace?
>
> 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.
Looking that tracefile, it has two sets of instructions, one for
NORESETLOGS and one for RESETLOGS, the difference is that I use the
RESETLOGS process if the online logs are damaged. Should I assume that I
want to use NORESETLOGS in this case?
Received on Tue Jan 06 2004 - 10:38:56 CST
