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

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
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值