OCP 052 005

 QUESTION NO: 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

Answer: C  

现象重现：

1、查看此数据库是否为归档模式

sys@TEST0910> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     28

Current log sequence           30

2、关闭数据库，再启动到mount状态

sys@TEST0910> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

sys@TEST0910> startup mount;

ORACLE instance started.

Total System Global Area 2505338880 bytes

Fixed Size                  2230952 bytes

Variable Size             587203928 bytes

Database Buffers         1895825408 bytes

Redo Buffers               20078592 bytes

Database mounted.

3、改为归档模式

sys@TEST0910> alter database archivelog;

Database altered.

4、打开数据库

sys@TEST0910> alter database open;

Database altered.

5、查询现在是否为归档模式

sys@TEST0910> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     28

Next log sequence to archive   30

Current log sequence           30