Duplication with Oracle Managed Files
If the source database files are in the Oracle Managed Files (OMF) format, then you cannot use the DB_FILE_NAME_CONVERT andLOG_FILE_NAME_CONVERT initialization parameters or the fileNameConversionSpec clause to generate new OMF file names for the duplicate database. If you do not follow this rule, the new OMF files generated from these three methods can cause problems. For more information on OMF names, see the "Considerations When Renaming OMF Auxiliary Set Files in TSPITR" in the Oracle Database Backup and Recovery User's Guide
//如果源库使用OMF,那么duplicate过程中不能使用db_file_name_convert和log_file_name_convert
The only exception to this rule is when changing only an ASM disk group name. Assume that source data files and online redo log files are stored in ASM disk group +SOURCEDSK. You want to store the duplicate database files in ASM disk group +DUPDSK. In this case, you can set the initialization parameters as follows:
DB_FILE_NAME_CONVERT = ("+SOURCEDSK","+DUPDSK")
LOG_FILE_NAME_CONVERT = ("+SOURCEDSK","+DUPDSK")
RMAN uses DB_FILE_NAME_CONVERT or LOG_FILE_NAME_CONVERT to convert the disk group name, and then generates a new, valid file name based on the converted disk group name.
You have the following other supported options for naming data files when the source files are in the Oracle Managed Files format:
-
Use
SETNEWNAMEto specify names for individual data files.
//使用SET NAME -
Set
DB_FILE_CREATE_DESTto make all data files of the new database Oracle-managed files, except the files for whichSET NEWNAMEis used. You should not setDB_FILE_NAME_CONVERTif you setDB_FILE_CREATE_DEST.
//使用DB_FILE_CREATE_DEST
Supported options for naming online redo logs duplicated from Oracle-managed files are DB_CREATE_FILE_DEST, DB_RECOVERY_FILE_DEST, orDB_CREATE_ONLINE_LOG_DEST_n.
//DB_CREATE_ONLINE_LOG_DEST_n (where n = 1, 2, 3, ... 5) specifies the default location for Oracle-managed control files and online redo logs.

本文探讨了在源数据库采用Oracle Managed Files (OMF)格式时进行数据库复制时的注意事项,包括不能使用DB_FILE_NAME_CONVERT及LOG_FILE_NAME_CONVERT参数转换文件名的情况,以及在更改ASM磁盘组名称时的例外情况。同时介绍了使用SET NEWNAME和DB_FILE_CREATE_DEST参数来指定新数据文件名称的方法。

2612

被折叠的 条评论
为什么被折叠?



