loading
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) ) )
十二、 目标库：配置监听