QUESTION 5

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

Given below are 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:

檢視資料庫是否為歸檔模式:

SYS@ENMOEDU> 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

關閉資料庫:

SYS@ENMOEDU> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

資料庫啟動到mount:

SYS@ENMOEDU> 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.

修改資料庫為歸檔模式:

SYS@ENMOEDU> alter database archivelog;

Database altered.

開啟資料庫:

SYS@ENMOEDU> alter database open;

Database altered.

再次檢視歸檔模式:

SYS@ENMOEDU> 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

11g OCP題庫，考試必備

恩墨學院開通【免費課程複習資料申請】，幫助同學們在課程結束後，有效果的進行溫習。

申請步驟：

1、將[連結]複製-黏貼到網頁中

申請連結：

2、開啟連結後，填寫申請並提交即可

提交後，會在3個工作日內將【複習資料】傳送至您的郵箱。

更多精彩認證系列課程，期待您的關注！
http://ke.qq.com/cgi-bin/courseDetail?course_id=36323#rd

【每日一練】Oracle OCP認證考試題庫解析052-5

相關文章