oracle11gRMAN：ActiveDatabaseDuplicationforstandbydatabase创建dg命令解读 - 数据库编程

基于生产的duplicate 复制，如果事先没有手动配置pfile（设定内存，进程，dg相关配置参数，数据库相关路径参数）则会出现各种参数无法转换的问题；
因为duplicate 会从生产自动拷贝pfile，控制文件，密码文件过来，如果主库和备库环境不一样（数据库软件路径，数据文件存储路径）
如果没在duplicate的命令中完整指定新环境备库的各种参数涉及路径，及转换参数，就会默认使用从主库拷贝过来的spfile中的参数设置（会忽略oracle 自定义的的缺省配置：比如adr 缺省会放在ORACLE_BASE下，所有参数配置一切以主库拷贝过来的spfile 为准）；

鉴于那些对原来主库环境，和oracle数据库参数不是特别了解的同学，就不建议使用这种配置了，折腾！

-------注意如果=备库和主库的$ORACLE_BASE/$ORACLE_HOME/数据存放路径任意一个不同，则必须配置一下的参数

run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;

duplicate target database for standby from active database
dorecover
spfile
parameter_value_convert 'ora11g','lixora'
set db_unique_name='orcl'
set standby_file_management='AUTO'
SET FAL_SERVER="ora11g"
SET LOG_ARCHIVE_DEST_1='LOCATION=/oracle/app/oracle/oradata/arch VALID_FOR=(ALL_LOGFILE,ALL_ROLE) DB_UNIQUE_NAME=lixora'
set log_archive_dest_2='service=ora11g ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ora11g'
SET CONTROL_FILES '/oracle/app/oracle/oradata/control01.ctl'
set diagnostic_dest='/oracle/app/oracle'
set audit_file_dest='/oracle/app/oracle'
set DB_FILE_NAME_CONVERT='/u01/app/ora11/oradata/ORA11G/datafile/','/oracle/app/oracle/oradata/'
SET LOG_FILE_NAME_CONVERT '/u01/app/ora11/oradata/ORA11G/onlinelog/', '/oracle/app/oracle/oradata/'
set db_create_file_dest='/oracle/app/oracle/oradata/'
set db_recovery_file_dest='/oracle/app/oracle/oradata/'
#SET SGA_MAX_SIZE 200M
#SET SGA_TARGET 185M
NOFILENAMECHECK;
}

这些个存放目录：闪回区目录，adr目录，审计日志目录， Oracle-managed 数据文件目录等等，一定要注意啊

------------这里解释使用类上述命令执行后的日子输出，来理解使用上述命令初始化备库的原理：

$rman target sys/sys@chicago auxiliary sys/sys@boston
connected to target database: CHICAGO (DBID=761464750)
connected to auxiliary database: CHICAGO (not mounted)
RMAN> run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'chicago','boston'
set db_unique_name='boston'
set db_file_name_convert='/chicago/','/boston/'
set log_file_name_convert='/chicago/','/boston/'
set control_files='/u01/app/oracle/oradata/control01.ctl'
set log_archive_max_processes='5'
set fal_client='boston'
set fal_server='chicago'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(chicago,boston)'
set log_archive_dest_2='service=chicago ASYNCvalid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=chicago'
;
}


using target database control file instead of recovery catalog
allocated channel: prmy1 ---------这个就不多说了：分配通道
channel prmy1: SID=147 device type=DISK
allocated channel: prmy2
channel prmy2: SID=130 device type=DISK
allocated channel: prmy3
channel prmy3: SID=137 device type=DISK
allocated channel: prmy4
channel prmy4: SID=170 device type=DISK
allocated channel: stby
channel stby: SID=98 device type=DISK


Starting Duplicate Db at 19-MAY-08
contents of Memory Script:
{
backup as copy reuse -------------拷贝

oracle11gRMAN：ActiveDatabaseDuplicationforstandbydatabase创建dg命令解读(一)