本文介绍如何将Oracle数据库从NOARCHIVELOG模式更改为ARCHIVELOG模式，包括正确的步骤顺序和解释为什么不需要设置DB_RECOVERY_FILE_DEST参数。
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数据库
就修改完成了
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
