ORACLE LINUX 11G RAC 单实例DATAGUARD - 图文

create pfile='/tmp/standby_pfile.ora' from spfile;

九、 源库：修改生成的pfile，作为DATAGUARD的目标库的pfile：

修改pfile，传递到DG节点/app/standby_pfile.ora：

*.audit_file_dest='/app/oracle/admin/oem_dg/adump' *.audit_trail='db' *.cluster_database=false *.compatible='11.2.0.0.0'

*.control_files='/oradata/oem_dg/controlfile/control01.ctl','/oradata/oem_dg/controlfile/control02.ctl' *.db_block_size=8192

*.db_create_file_dest='/oradata' *.db_domain=''

*.db_file_name_convert='+DATA/oem/datafile/','/oradata/oem_dg/datafile/' *.db_name='oem'

*.db_unique_name='oem_dg' *.diagnostic_dest='/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=oemXDB)' *.fal_server='OEM'

*.job_queue_processes=100

*.log_archive_config='DG_CONFIG=(oem,oem_dg)' *.log_archive_dest_1='LOCATION=/backup/oem

VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oem_dg' *.log_archive_dest_2='SERVICE=oem LGWR AFFIRM

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oem' *.log_archive_format='%t_%s_%r.arc' *.log_archive_max_processes=4 *.log_buffer=10485760

*.log_file_name_convert='+DATA/oem/','/oradata/oem_dg/' *.memory_target=2147483648 *.open_cursors=300 *.processes=1500

*.remote_login_passwordfile='exclusive' *.session_cached_cursors=300 *.sessions=800

*.standby_file_management='AUTO' *.undo_tablespace='UNDOTBS1'

十、 修改oracle的sys密码，保持所有源库和目标库一致：

源库节点一：

orapwd file=/u01/app/oracle/11.2.0/db_1/dbs/orapwoem1 password=Oracle11 force=y 传递到节点二： scp /u01/app/oracle/11.2.0/db_1/dbs/orapwoem1 11grac2:/u01 /app/oracle/11.2.0/db_1/dbs/

mv /u01/app/oracle/11.2.0/db_1/dbs/orapwoem1 /u01/app/oracle/11.2.0/db_1/dbs/orapwoem2

传递到目标库：

scp /u01/app/oracle/11.2.0/db_1/dbs/orapwoem1 DGTEST: /app/oracle/11.2.0/db_1/dbs/ mv /app/oracle/11.2.0/db_1/dbs/ orapwoem1 /app/oracle/11.2.0/db_1/dbs/ orapwoem 十一、 源库：修改的tnsnames.ora文件，添加源库和目标库的配置：

修改所有节点的：tnsnames.ora文件，添加如下内容：

OEM =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = scan11g.fawcar.com.cn)(PORT = 1521)) (CONNECT_DATA =

(SERVER = DEDICATED) (SERVICE_NAME = oem) ) )

OEM_DG =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST=10.135.161.241)(PORT = 1521)) (CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = oem_dg) (SID=oem) (UR=A) ) )

OEM1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST=10.135.33.170)(PORT = 1521)) (CONNECT_DATA =

(SERVER = DEDICATED) (SERVICE_NAME = oem) (SID=oem1) ) )

OEM2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST=10.135.33.171)(PORT = 1521)) (CONNECT_DATA =

(SERVER = DEDICATED) (SERVICE_NAME = oem) (SID=oem2) ) )

十二、 目标库：配置监听