Recovery File Structures   «Prev 

Oracle Database Installation - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. In an authorized SQL*Plus session, which command displays the SPFILE path used by the running instance, if an SPFILE is in use?
Please select the best answer.
  A. SHOW PARAMETER control_files
  B. SHOW PARAMETER db_create_file_dest
  C. SHOW PARAMETER spfile
  D. SHOW PARAMETER db_recovery_file_dest

2. For a conventional physical backup strategy for an ARCHIVELOG CDB, with no deliberate tablespace exclusions, which items belong in the backup plan?
Please select all the correct answers.
  A. The SPFILE, or a maintained copy of the PFILE if that is the initialization source
  B. The control file
  C. Permanent datafiles, including those containing indexes
  D. Archived redo logs required by the recovery and retention objectives
  E. Only the Oracle software home, because it contains everything needed for database recovery

3. An ARCHIVELOG CDB suffers media loss two days after a database backup. For restore-based point-in-time recovery to a chosen target before the failure, which set of resources is required?
Please select the best answer.
  A. The archived redo logs alone, without any usable datafile backup
  B. Usable datafile backups from before the target, all required redo through the target, usable control-file information, and the required startup configuration and decryption keys
  C. Copies of the current control file and parameter file, without datafile backups or redo
  D. The old database backup alone, regardless of the requested recovery target

4. LGWR cannot write to one member of the current multiplexed redo log group, but can still write successfully to another member in that group. What normally happens?
Please select the best answer.
  A. The instance must terminate even though another member remains writable.
  B. LGWR continues writing to the available member or members and reports the inaccessible member.
  C. LGWR automatically creates a replacement member at a new storage location.
  D. LGWR automatically drops the entire group and discards its redo.

5. All current control-file copies are unusable, and no usable binary control-file backup exists. A previously generated reconstruction trace and a verified file inventory are available. Which approach can recreate the control file?
Please select the best answer.
  A. Issue ALTER DATABASE RESTORE BACKUP CONTROLFILE; and open immediately.
  B. Copy the trace text directly over the binary control-file paths.
  C. Start with STARTUP NOCONTROLFILE and let Oracle discover every file automatically.
  D. With appropriate administrative privileges and no instance mounting the database, use NOMOUNT, execute a reviewed database-specific CREATE CONTROLFILE statement, then complete the required recovery and open procedure.

6. Which kinds of information are recorded in an Oracle database control file?
Please select all the correct answers.
  A. Names and locations of associated datafiles and online redo log files
  B. Log sequence information
  C. Checkpoint information
  D. Archived redo log metadata
  E. A complete copy of every archived redo log and every user table