1.备库编辑实例参数文件
vi init$SID.ora
DB_NAME=ORCL
2.启动备库到nomout
startup nomount;
3.复制备库
rman>
connect target sys/oracle@primary
rman>connect auxiliary sys/oracle@standby
run{
allocate channel primy1 type disk;
allocate channel primy2 type disk;
allocate channel primy3 type disk;
allocate channel primy4 type disk;
allocate auxiliary channel sty1 type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'orcl','orcldg'
set 'db_unique_name=orcldg'
set controlfile='+data/orcldg/control01.ctl'
set db_create_file_dest='+DATA'
set db_create_online_log_dest_1='+FLASH'
set db_create_online_log_dest_2='+DATA'
set db_recovery_file_dest_+='+FLASH'
set db_recovery_file_dest_size='10G'
nofilenamecheck;
}
4.修改备库参数
备库执行:
alter system set fal_server=orcl;
alter system set fal_client=orcldg;
alter system set log_archive_config='DG_CONFIG=(orcl,orclDG)';
alter system set standby_file_management=AUTO;
alter system set log_archive_dest_2='service=orcl ASYNC DB_UNIQUE_NAME=orcl VALID_FOR=(primary_role,online_logfile)';
alter database recover mananged standby database using current logfile disconnect;
5.修改主库参数
主库:
alter system set fal_server=orcldg;
alter system set fal_client=orcl ;
alter system set log_archive_config='DG_CONFIG=(orcl,orclDG)';
alter system set standby_file_management=AUTO;
alter system set log_archive_dest_2='service=orcldg ASYNC DB_UNIQUE_NAME=orcldg VALID_FOR=(primary_role,online_logfile)';
alter system switch logfile;