1，pfile配置文件

initagridb.ora 
agridb.audit_file_dest='/oradata/agridb/adump'
agridb.audit_trail='db'
agridb.compatible='11.2.0.4.0'
agridb.control_files='/oradata/agridb/control01.ctl'
agridb.db_block_size=8192
agridb.db_create_file_dest='/oradata/agridb/datafile'
agridb.db_create_online_log_dest_1='/oradata/agridb/onlinelog'
agridb.db_domain=''
agridb.db_files=1024
agridb.db_name='agridb'
agridb.db_unique_name='agridb'
agridb.dispatchers='(PROTOCOL=TCP) (SERVICE=agridbXDB)'
agridb.enable_goldengate_replication=TRUE
agridb.fal_server='agridbdg'
agridb.log_archive_config='dg_config=(agridb,agridbdg)'
agridb.log_archive_dest_1='LOCATION=/oradata/agridb/arch'
agridb.log_archive_dest_2='SERVICE=agridbdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=agridbdg'
agridb.log_archive_dest_state_1='ENABLE'
agridb.log_archive_dest_state_2='ENABLE'
agridb.log_archive_max_processes=30
agridb.open_cursors=300
agridb.parallel_force_local=TRUE
agridb.parallel_max_servers=16
agridb.processes=1500
agridb.remote_login_passwordfile='EXCLUSIVE'
agridb.sec_case_sensitive_logon=FALSE
agridb.service_names='agridb'
agridb.standby_file_management='auto'
agridb.undo_tablespace='UNDOTS1'
agridb.sga_target=20G
agridb.PGA_AGGREGATE_TARGET=30G


复制

使用omf自动文件管理功能，就可以快速转换文件位置。

2 开启数据库克隆

rman target sys/xxxxx@agridbdg auxiliary sys/xxx@agridb <<!
run{
allocate channel ch001 type disk;
allocate channel ch002 type disk;
allocate channel ch003 type disk;
allocate channel ch004 type disk;
allocate channel ch005 type disk;
allocate channel ch006 type disk;
allocate channel ch007 type disk;
allocate channel ch008 type disk;
allocate channel ch009 type disk;
allocate channel ch0010 type disk;
allocate auxiliary channel ch0011 type disk;
allocate auxiliary channel ch0012 type disk;
allocate auxiliary channel ch0013 type disk;
allocate auxiliary channel ch0014 type disk;
allocate auxiliary channel ch0015 type disk;
allocate auxiliary channel ch0016 type disk;
allocate auxiliary channel ch0017 type disk;
allocate auxiliary channel ch0018 type disk;
allocate auxiliary channel ch0019 type disk;
allocate auxiliary channel ch0020 type disk;
duplicate target database for standby from active database;
release channel ch001;
release channel ch002;
release channel ch003;
release channel ch004;
release channel ch005;
release channel ch006;
release channel ch007;
release channel ch008;
release channel ch009;
release channel ch0010;
release channel ch0011;
release channel ch0012;
release channel ch0013;
release channel ch0014;
release channel ch0015;
release channel ch0016;
release channel ch0017;
release channel ch0018;
release channel ch0019;
release channel ch0020;
}
!

复制

nohup 放入后台既可以，完成dataguard搭建。