Get Familiar With Oracle Database 11g: Administration II

  By Certification Magazine —

Oracle Database Backup and Recovery User's Guide 11g Release 1 (11.1), Part Number B28270-02, Performing User-Managed Database Flashback and Recovery - Performing Incomplete Database Recovery

Oracle Database Backup and Recovery Reference 11g Release 1 (11.1), Part Number B28273-02, RESTORE

SQL*Plus User's Guide and Reference Release 11.1, Part Number B31189-01, RECOVER

Objective: Additional flashback operations.
Sub-objective: Configure, monitor flashback database and perform Flashback Database operations.

Single answer, multiple-choice

You are maintaining a database that is in ARCHIVELOG mode. You have configured a flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode, and you want to configure the Flashback Database feature.

Which two actions are NOT required to configure the Flashback Database feature? (Choose two.)

A.    Opening the database in read-only mode.
B.    Setting the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
C.    Enabling the block change tracking feature.
D.    Executing the ALTER DATABASE FLASHBACK ON; statement.

Answer:
A. Opening the database in read-only mode.
C. Enabling the block change tracking feature.

Tutorial:
To configure the Flashback Database feature in a database, you are not required to open the database in read-only mode. The database should be in MOUNT EXCLUSIVE mode. Also, you are not required to enable the block change tracking feature in your database to configure the Flashback Database feature. The block change tracking feature is used to increase the performance of the backup process during incremental backups.

The option stating you are not required to set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter to configure the Flashback Database feature in a database is incorrect. You should issue the following statement to set the value of the DB_FLASHBACK_RETENTION_TARGET parameter:

ALTER DB_FLASHBACK_RETENTION_TARGET=<value>;

The DB_FLASHBACK_RETENTION_TARGET parameter determines the point-in-time in the past to which you can flash back the database. The value of the DB_FLASHBACK_RETENTION_TARGET parameter is specified in minutes.

The option stating that you are not required to execute the ALTER DATABASE FLASHBACK ON; statement to configure the Flashback Database in a database is incorrect. After executing the ALTER DB_FLASHBACK_RETENTION_TARGET=<value>; statement, you must execute the ALTER DATABASE FLASHBACK ON; statement to enable the Flashback Database feature.

References:
Oracle University - Oracle Database 11g: Administration Workshop II - Chapter 12: Additional Flashback Operations - Configuring Flashback Database
D50079GC10
Edition 1.0
November 2007
D53298

Oracle Database Concepts 11g Release 1 (11.1), Part Number B28318-03, Backup and Recovery - Data Repair - Oracle Flashback Technology - Oracle Flashback Database

Oracle Database SQL Language Reference 11g Release 1 (11.1), Part Number B28286-03, FLASHBACK DATABASE

Oracle Database Backup and Recovery User's Guide 11g Release 1 (11.1), Part Number B28270-02, Configuring the RMAN Environment - Configuring Oracle Flashback Database and Restore Points - Prerequisites for Flashback Database and Guaranteed Restore Points - Enabling Flashback Database

Objective: Manage database performance.
Sub-objective: Understand database replay.

Single answer, multiple-choice

You plan to upgrade your operating system and want to use database replay to analyze the impact of the upgrade. Which statement is true?

A.    When replaying workload, you must specify a single replay client that can access the capture directory.
B.    When you preprocess the captured workload, all connections are automatically remapped.
C.    To successfully replay captured workload, the replay database should be identical to what the capture database was when workload capture began.
D.    You can replay the captured workload multiple times, but each time the workload must be preprocessed.

Answer:
C. To successfully replay captured workload, the replay database should be identical to what the capture database was when workload capture began.

Tutorial:
To successfully replay captured workload, the replay database should be identical to what the capture database was when workload capture began so the database can be restored and the workload replayed against it. You also should note that if your workload is time-sensitive, you should reset the system clock on the replay system to the time you started the capture.

The option that states when replaying workload, you must specify a single replay client that can access the capture directory is incorrect. You can specify one or more replay clients. Each replay client can control one or more workload sessions.

The option that states when you preprocess the captured workload, all connections are automatically remapped is incorrect. Preprocessing simply converts the captured data into files that can be replayed, creating the needed metadata. External connections are remapped during preprocessing, but not all connections.

The option that states you can replay the captured workload multiple times, but the workload must be preprocessed each time is incorrect. The captured workload only has to be preprocessed once and then can be replayed multiple times.

References:
Oracle University - Oracle Database 11g: Administration Workshop II - Chapter 15: Managing Database Performance - Database Replay
D50079GC10
Edition 1.0
November 2007
D53298

Oracle University - Oracle Database 11g: Administration Workshop II - Chapter 15: Managing Database Performance - System Architecture: Capture
D50079GC10
Edition 1.0
November 2007
D53298

Oracle University - Oracle Database 11g: Administration Workshop II - Chapter 15: Managing Database Performance - System Architecture: Processing the Workload
D50079GC10
Edition 1.0
November 2007
D53298

Oracle University - Oracle Database 11g: Administration Workshop II - Chapter 15: Managing Database Performance - System Architecture: Replay
D50079GC10
Edition 1.0
November 2007
D53298

Oracle Database Performance Tuning Guide 11g Release 1 (11.1), Part Number B28274-01 Database Replay