Oracle OCP Certification Exam Bank Analysis 052-5

QUESTION 5

You want to enable archiving on your database. Presently, the database is running in Noarchivelog mode.

Given below is the steps to accomplish the task in random order:

1. Shut down the instance.

2. Execute the ALTER DATABASE ARCHIVELOG command.

3. Start up the instance and mount the database.

4. Set The Db_recovery_file_dest initialization parameter to $ORACLE _home/dest_1.

5. Open the database.

Which is the correct sequence of steps for accomplishing the task?

A. 4, 1, 3, 2, 5

B. 1, 3, 4, 5, 2

C. 1, 3, 2, 5; 4 Not required

D. 4, 1, 5, 2; 3 not required

E. 1, 3, 4, 5; 2 not required

Correct Answer:c

Explanation/reference: To see if the database is in archive mode : [Email protected]> archive Log list Database log mode No Archive mode Automatic Archival Disabled Archive Destination Use_db_recovery_file_dest oldest online log sequence 1 Current Log sequence 2 To close the database : [Email protected]> shutdown Immediate Database closed. Database dismounted. ORACLE instance shut down. Database boot to mount: [Email protected]> startup Mount ORACLE instance started. Total System Global area 421724160 bytes Fixed Size 2253864 bytes Variable Size 322964440 bytes Database buffers 88080384 bytes Redo buffers 8425472 bytes Database mounted. Modify the database to archive mode : [Email protected]> ALTER DATABASE archivelog; Database altered. Open the database : [Email protected]> ALTER DATABASE open; Database altered. Review the archive mode again : [Email protected]> archive Log list Database Log Mode Archive mode Automatic Archival Enabled Archive Destination Use_db_recovery_file_dest oldest online log sequence 1 Next log sequence to archive 2 Current log sequence 2

Oracle OCP Certification Exam Bank Analysis 052-5