Re: Problems applying archived redologs

Piotr Kolodziej (pkol_at_otago.gda.pl) wrote:
: Stephen Harris wrote in message <7abj24$evc$2_at_nebula.mpn.com>...

: >The best way is to "alter database backup controlfile to trace;"

: But, I think, not as main procedure of backing up control file during
: hot backup. Recreating control file drops information about log history
: for example.

Doesn't matter too much.... If the machine has died so badly that your hot control files are dead (all three or more of them) then recreate it using the backup control file, and then something like...   "recover automatic database using backup control file until cancel" (syntax not checked :-))

Of course, you will have to open with "resetlogs" afterwards, but this _is_ a disaster case we're talking about, and you would have to do that if you can't perform complete recovery (eg if current online redo logs were lost) anyway.

: I'd suggest backing up via "alter database backup controlfile to <file>" also

Same thing really. "to trace" just copies it to udump/PID.trc rather than to a specified file.

: If I understood your strategy, you restore datafiles, recreate controlfiles
: (is that?) and recover ? If so, you may not be able to apply archived logs.

Yeah, that's what the "backup control file" bit is for. Tells the recovery process to ignore the SCN in the control file (from my hazy memory of the course I did a year ago...)

--

rgds
Stephen Received on Tue Feb 16 1999 - 08:42:25 CST