a practice question of backup & recovery

From: Dino Hsu <dino1.nospam_at_ms1.hinet.net>
Date: Wed, 05 Sep 2001 22:04:00 +0800
Message-ID: <vmbcpt86cufh5uree7o0sdose2h7t3i5mc@4ax.com>

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 - 09:04:00 CDT