OCP-1Z0-053-V12.02-184题
来源:互联网 发布:怎样让淘宝搜索靠前 编辑:程序博客网 时间:2024/05/16 19:03
184.Which RMAN backup command is used to create the block-change tracking file?
A. alter database create block change tracking file
B. alter database enable block change file
C. alter database enable block change tracking using file ,,/ora01/opt/ block_change_tracking.fil
D. alter system enable block change tracking using file '/ora01/opt/block_ change_tracking.fil'
E. alter system block change tracking on
Answer: C
答案解析:
参考: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-184题
- OCP-1Z0-053-V12.02-679题
- OCP-1Z0-053-V12.02-591题
- OCP-1Z0-053-V12.02-590题
- OCP-1Z0-053-V12.02-552题
- OCP-1Z0-053-V12.02-551题
- OCP-1Z0-053-V12.02-549题
- OCP-1Z0-053-V12.02-548题
- OCP-1Z0-053-V12.02-234题
- OCP-1Z0-053-V12.02-584题
- OCP-1Z0-053-V12.02-595题
- OCP-1Z0-053-V12.02-59题
- OCP-1Z0-053-V12.02-676题
- OCP-1Z0-053-V12.02-667题
- OCP-1Z0-053-V12.02-660题
- OCP-1Z0-053-V12.02-580题
- OCP-1Z0-053-V12.02-323题
- OCP-1Z0-053-V12.02-320题
- OCP-1Z0-053-V12.02-595题
- Java多线程 1 Thread类
- Java多线程 2 Runnable类
- mysql 设置远程连接
- Java多线程 3 同步代码块
- OCP-1Z0-053-V12.02-184题
- Flatten Binary Tree to Linked List (二叉树转前序链表)【leetcode】
- HDOJ,杭电, 2500 做一个正气的杭电人。。超级超级大水题。。。
- Hibernate 注解
- Java多线程 4 同步方法
- 好资源推荐-经典技术文章集锦!!!
- 华为HCNE(H3CNE) / HCSE(H3CSE)认证必看书籍
- Java多线程 5 同步方法的锁
- 求给定字符串中最长重复子串