Oracle OCP Certification Exam Bank Analysis 052-5

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.