OCP 053 31.Which two statements are correct about database transportation? (Choose two.)
来源:互联网 发布:苹果双系统切换回mac 编辑:程序博客网 时间:2024/04/28 22:52
A. The source and target platforms must be the same
B. Redo logs, control files and temp files are also transported
C. The transported database must have the same database identifier (DBID) as the source database and
cannot be changed
D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in
readonly mode before being transported
E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target
platform is different and has different endian format
Answer: DE
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmxplat.htm#BRADV476
Checking the Database Before Cross-Platform Database Conversion
When you transport entire databases, note that certain files require RMAN conversion to ensure compatibility with the destination platform. Even though the endian formats for the source and destination platform are the same, these files cannot be simply copied from the source to the destination system. The following kinds of files require RMAN conversion:
Any file containing undo segments
Any file containing automatic segment space management (ASSM) segment headers that is being transported to or from the HP Tru64 platform
The CONVERT DATABASE
command, by default, processes all data files in the database using RMAN conversion. The RMAN conversion copies the files from one location to another, even when it does not make any changes to the file. If you have other preferred means to copy those files that do not require RMAN conversion, you can use the SKIP UNNECESSARY DATAFILES
option of the CONVERT DATABASE
command. If you select this option, then the CONVERT DATABASE
command only processes the kinds of files previously mentioned. All other files must be copied by the user from the source to the destination database.
The files should be copied while the source database is open in read-only mode. Similarly, if the conversion is performed at the destination, all data files should be copied to the destination when the source database is open in read-only mode.
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmxplat.htm#BRADV89979
Basic Concepts of Cross-Platform Data Transportation
You must use the RMAN CONVERT
command in a transportable tablespace operation when the source platform is different from the destination platformand the endian formats are different. If you are converting part of the database between platforms that have the same endian format, you can use operating system methods to copy the files from the source to the destination. If you are converting an entire, same endian database, any data files with undo information must be converted. You cannot copy the data files directly from the source to the destination platform.
http://docs.oracle.com/cd/E11882_01/server.112/e17766/e38001.htm#ORA-38952
- OCP 053 31.Which two statements are correct about database transportation? (Choose two.)
- 45.Which two statements are true about sequences created in a single instance database? (Choose two.
- 19.Which two statements about the background process of the database writer are true? (Choose two.)
- 39.Which two statements are true about standard database auditing? (Choose two.)
- 46.Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two
- 50.Which two statements are true about alerts? (Choose two.)
- 65.Which two statements are true about checkpointing? (Choose two.)
- 053-4 Which two statements about the SQL Management Base (SMB) are true? (Choose two.)
- 108 Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.) A.
- 142 Which two statements are true about encrypting RMAN backup? (Choose two.) A. The transparent enc
- 15.Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)
- 27.Which two statements are true regarding transactions in an Oracle database? (Choose two.)
- 35.Which two statements are true regarding constraints? (Choose two.)
- 38.Which two statements are true regarding views? (Choose two.)
- 41.Which two statements are true regarding views? (Choose two.)
- 48.Which two statements are true regarding indexes? (Choose two.)
- 133.Which two statements are true regarding subqueries? (Choose two.)
- 175.Which two statements are true regarding savepoints? (Choose two.)
- SDUACM16级寒假热身1
- go-workerpool 支持每分钟百万并发的抽象原型
- ActiveMQ简单封装
- Android App瘦身详解
- 解决web项目中发送文字乱码以及Tomcat 7控制台打印乱码问题
- OCP 053 31.Which two statements are correct about database transportation? (Choose two.)
- Mysql 分页语句Limit用法
- Excel数据分析与业务建模_第一章_名称(Range names)
- 【LeetCode】75. Sort Colors
- Codeforces_611D:New_Year_and_Ancient_Prophecy(DP+树状数组)
- javascript 两种方式实现动态雪碧图
- 重拾java基础(九):抽象类、接口总结
- Golang Cron 定时任务分析
- Python中assert函数的用法小结