Re: a practice question of backup & recovery

How about your control file was corrupted? Or you need to do physical cloning?

Cheers,

Reid Lai

Dino Hsu wrote:

> Dear all,
>
> A practice question:
> If the DBA must re-create the control file as part of database
> recovery, in which of the following ways should it be done?
> A. After backup datafile restoration
> B. Between restoring backups and applying redo logs
> C. Before closing the database to user access
> D. Using the script containing the create controlfile command in the
> trace directory
>
> The answer is C,
> Explanation: This question is tricky, and requires careful reading of
> the question as well as thorough knowldege of the Oracle database
> recovery process. Creation of a control file for the database recovery
> process should be accomplished first. The other choices are all
> incorrect becasue they place the creation of control files later in
> the recovery process.
>
> I cannot remember any scenario that requires creating a copy of
> controlfile first although there are some which do recovery when
> controlfiles are missing or damaged. Your comments are highly
> appreciated.
>
> Dino
Received on Wed Sep 05 2001 - 12:14:57 CDT