72.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
答案:C
解析:DB_RECOVERY_FILE_DEST在启动的时候已经设置好了,默认为$ORACLE_BASE/fast_recovery_area,默认大小为2G
因此4不是必须的,那么就可以选C了
修改归档必须在mount阶段,因此应该首先
1.关闭数据库
2.启动到mount阶段
3.然后打开归档
4.最后open数据库
就修改完成了
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
答案:C
解析:DB_RECOVERY_FILE_DEST在启动的时候已经设置好了,默认为$ORACLE_BASE/fast_recovery_area,默认大小为2G
因此4不是必须的,那么就可以选C了
修改归档必须在mount阶段,因此应该首先
1.关闭数据库
2.启动到mount阶段
3.然后打开归档
4.最后open数据库
就修改完成了