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
|
原文：http://enmoedu.blog.51cto.com/7203658/1606149