)
)
启动时要带上监听名：
[grid@srvrac2 admin]$ lsnrctl start LISTENER2
2. 添加tnsnames.ora
从库节点1：
TEST1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.205.0.35)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test1)
)
)
TEST21 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.205.0.30)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test1)
)
)
从库节点2：
TEST1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.205.0.35)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test1)
)
)
TEST21 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.205.0.31)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test1)
)
)
主库：
test1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.205.0.35)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test1)
)
)
test21 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.205.0.30)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST =10.205.0.31)(PORT = 1522))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = test1)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = basic)
(RETRIES = 200)
(DELAY = 5)
)
)
)
红色的网络服务名对应配置log_archive_dest_2中的service
测试方法：
sqlplus sys/oracle@test21 as sysdba
3.
备库环境准备
1. 建好了主库的 pfile 后，将其复制到备库服务器的相同位置，使用备库的 SID 修改其名字。需要对 pfile 做如下修改：
根据你备库的配置和文件位置，你可能需要修改AUDIT_FILE_DEST，CONTROL_FILES 和 DISPATCHERS 参数（也许还有其他需要修改的参数）。
LOG_ARCHIVE_DEST_1参数中的 db_unique_name 修改为备库的相应唯一名（这里是 JED2）。
LOG_ARCHIVE_DEST_2参数，修改为主库对应的服务名和数据库唯一名（这里是 JED）。
FAL_SERVER参数修改指向主库的服务名。
增加如下参数：
db_unique_name=JED2
altersystem set standby_file_management = 'AUTO';
db_file_name_convert和 log_file_name_convert。如果主备库的数据文件、日志文件位置不同，需要设置这两个参数。
然后在备库服务器上创建所需目录结构和修改相关文件
2. 如：
[oracle@srvrac1dbs]$ cat test2_pfile.ora
test1.__db_cache_size=883027968
test1.__java_pool_size=23554432
test1.__large_pool_size=30331648
test1.__pga_aggregate_target=673741824
test1.__sga_target=922122547
test1.__shared_io_pool_size=0
test1.__shared_pool_size=203979776
test1.__streams_pool_size=11777216
*.audit_file_dest='/bee/app/oracle/admin/test2/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='+DATA/test2/controlfile/control01.ctl','+DATA/test2/controlfile/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/bee/app/oracle/oradata/test1/','+DATA/test2/datafile/'
*.log_file_name_convert='/bee/app/oracle/oradata/test1/','+DATA/test2/datafile/'
*.db_name='test1'
*.db_unique_name='test2'
*.diagnostic_dest='/bee/app/oracle'
*.dispatchers='(PROTOCOL=TCP)(SERVICE=test2XDB)'
*.fal_server='test1'
*.log_archive_config='dg_config=(test1,test2)'
*.log_archive_dest_1='location=+DATA/test2/archivelogvalid_for=(all_logfiles, all_roles) db_unique_name=test2'
*.log_archive_dest_2='service=test1async valid_for=(online_logfile,primary_role) db_unique_name=test1'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=1072693248
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=3218079744
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
3. 启动备库export ORACLE_SID=test11
startup nomount pfile='/bee/app/oracle/prod