11GR2做物理DG.docVIP

------------------------------主库--------------------------------------------- 1.设置主库为force logging模式 SQL alter database force logging; Database altered. 2.编辑初始化参数 SQL create pfile=/u01/export/home/oracle/pfile.txt from spfile; File created. Vi pfile.txt 添加红色部分的内容 [oracle@primary ~]$ more pfile.txt oracl.__db_cache_size=272629760 oracl.__java_pool_size=4194304 oracl.__large_pool_size=4194304 oracl.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment oracl.__pga_aggregate_target=276824064 oracl.__sga_target=415236096 oracl.__shared_io_pool_size=0 oracl.__shared_pool_size=125829120 oracl.__streams_pool_size=0 *.audit_file_dest=/u01/app/oracle/admin/oracl/adump *.audit_trail=db *.compatible=.0 *.control_files=/u01/app/oracle/oradata/oracl/control01.ctl,/u02/app/oracle/oradata/oracl/control02.ctl *.db_block_size=8192 *.db_domain= *.db_name=oracl *.diagnostic_dest=/u01/app/oracle *.dispatchers=(PROTOCOL=TCP) (SERVICE=oraclXDB) *.memory_target=692060160 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile=EXCLUSIVE *.undo_tablespace=UNDOTBS1 *.db_unique_name=oracl *.log_archive_config=dg_config=(oracl,oraclbak) *.log_archive_dest_1= location=/u02/archive_log/ valid_for=(all_logfiles,all_roles) db_unique_name=oracl *.log_archive_dest_2= service=dup_oracl async valid_for=(online_logfiles,primary_role) db_unique_name=oraclbak *.log_archive_dest_state_1=enable *.log_archive_dest_state_2=enable *.standby_file_management=auto *.fal_server=dup_oracl *.fal_client=tar_oracl *.db_file_name_convert=/u01/app/oracle/oradata/oracl/,/u01/app/oracle/oradata/oracl/ *.log_file_name_convert=/u01/app/oracle/oradata/oracl/,/u01/app/oracle/oradata/oracl/,/u02/app/oracle/oradata/oracl/,/u02/app/oracle/oradata/oracl/ 3.使用步骤2修改的参数启动主库 SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL create spfile from pfile=/u01/export/home/oracle/pfile.txt; File created. SQL startup ORACLE instance started. Total System Global Area 6905036