本文主要是介绍OCP-1Z0-053-V12.02-584题,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
584.How is block-change tracking enabled?
A. With alter database enable block change tracking
B. With alter system enable block change tracking
C. With an init.ora parameter change
D. With an spfile parameter change
Answer: A
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12321679
You can enable block change tracking when the database is either open or mounted.
To enable block change tracking:
-
Start SQL*Plus and connect to a target database with administrator privileges.
-
Ensure that the
DB_CREATE_FILE_DEST
initialization parameter is set.SHOW PARAMETER DB_CREATE_FILE_DESTIf the parameter is not set, and if the database is open, then you can set the parameter with the following form of the ALTER SYSTEM statement:
ALTER SYSTEM SETDB_CREATE_FILE_DEST = '/disk1/bct/'SCOPE=BOTH SID='*'; -
Enable block change tracking.
Execute the following
ALTER DATABASE
statement:ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;You can also create the change tracking file in a location that you choose yourself by using the following form of SQL statement:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGUSING FILE '/mydir/rman_change_track.f' REUSE;The
REUSE
option tells Oracle Database to overwrite any existing block change tracking file with the specified name.
官方参考:http://docs.oracle.com/cd/E16655_01/backup.121/e17630/rcmbckba.htm#BRADV8125
这篇关于OCP-1Z0-053-V12.02-584题的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!