OCP 053 31.Which two statements are correct about database transportation? (Choose two.)

来源:互联网 发布:苹果双系统切换回mac 编辑:程序博客网 时间:2024/04/28 22:52
31.Which two statements are correct about database transportation? (Choose two.) 
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 

1.当source和target的platform和endian格式相同:
仅传输表空间,可以直接copy;
但是传输整个DB,undo information就必须convert。
2.传输表空间时,必须10.0.0.0版本及以上,传输前,必须先设置为read-only模式。


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
ORA-38952: Source database not 10.0.0.0 compatible
Cause: Cross platform transport is not supported unless database compatibility is advanced to 10.0.0.0 or higher
Action: Use the compatible parameter to advance source database compatibility and redo the transport
0 0
原创粉丝点击