About Rman Duplicate some of the more important points of knowledge--series three

FYI:

http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF126

Rman Duplicate database must be the same platform, but supports 32bit\64bit replication, which needs to be run after replication is complete ￥oracle_home/rdbms/admin/utlirp.sql
Scripts convert PL/SQL code


The DUPLICATE command requires one or more auxiliary channels. These channels perform the work of the duplication on the auxiliary database instance.
Rman Duplicate command requires at least one secondary channel (auxiliary channels) to be allocated on the standby


If The source database files is in the Oracle Managed files (OMF) format, then you cannot use the Db_file_name_convert an D
Log_file_name_convert initialization parameters or the FILENAMECONVERSIONSPEC clause to generate new OMF FILE names for th E
Duplicate database. If You don't follow this rule, the new OMF files generated from these three methods can cause problems
when using duplicate, it is important to note that if the source Library uses OMF, then we cannot use Db_file_name_convert and Log_file_name_convert and other files to
For example, the data file names in the repository's control file are converted according to Db_file_name_convert and Log_file_name_convert, but the actual

If the data file is not in the corresponding path, the actual file will be managed by OMF, which needs to be used:

1 "RMAN catalog and switch database to copy

2 "ALTER DATABASE rename file to and

3 "switch datafile file# to copy to modify the control file information;

Of course there are exceptions, if you just change the ASM disk group name, the other path name is not changed, you can use Db_file_name_convert
The only exception to this rule was when changing only a ASM disk group name. Assume that source data files and online redo
Log files is 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 fi Le
Name based on the converted disk group name.


-If the source library uses OMF, the following parameter configuration is recommended:
You had the following other supported options for naming data files when the source files is in the Oracle Managed files Format

1.Use SET NEWNAME To specify names for individual data files.
2.Set db_file_create_dest to make all data files of the new database oracle-managed files, except the files for which Set


NEWNAME is used. You should not set Db_file_name_convert if you set db_file_create_dest.
Db_create_file_dest
Db_recovery_file_dest

For Redolog if Db_recovery_file_dest is not set, or Db_create_online_log_dest_n. The directory specified by the Db_create_file_dest parameter is used to store

Sql> Show Parameter Db_create_online_log_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Db_create_online_log_dest_1 string
Db_create_online_log_dest_2 string
Db_create_online_log_dest_3 string
Db_create_online_log_dest_4 string
Db_create_online_log_dest_5 string

If the db_create_online_log_dest_* parameter is specified separately, the Redolog member will be redundantly placed in these individually specified directories

Supported options for naming online redo logs duplicated from oracle-managed files is db_create_file_dest,

Db_recovery_file_dest, or Db_create_online_log_dest_n.

----db_create_online_log_dest_n parameter interpretation, specify a storage directory for Redolog,control file, specify multiple multiplexed
Db_create_online_log_dest_n (where n = 1, 2, 3, ...) 5) Specifies the default location for oracle-managedcontrol files and online redo logs. If more than one db_create_online_log_dest_n parameter is specified and then the control file or ONLINE redo LOG is multiplex Ed across the locations of the other db_create_online_log_dest_n parameters. One member of each online redo log are created in each location, and one control file are created in each location.


Specifying at least-parameters provides greater fault tolerance for the control files and online redo logs if one of T He locations should fail.

If a file system directory is specified as the default location and then the directory must already exist; Oracle does not create it. The directory must has appropriate permissions, which allow Oracle to create files in it. Oracle generates unique names for the files, and a file thus created are an Oracle Managed file.

For file systems, the specified directory must have permissions that are accurate and already present, and if not, Oracle does not automatically create

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

About Rman Duplicate some of the more important points of knowledge--series three