Windows环境下配置Oracle 11gR2 Data Guard手记(二)
)
(ENVS = "EXTPROC_DLLS=ONLY:d:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = tt)
(ORACLE_HOME = d:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = tt)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.166)(PORT = 1521))
)
)
修改 tnsnames.ora 文件,内容如下:
# tnsnames.ora Network Configuration File: d:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
PRIMARY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.166)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tt)
)
)
STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.121)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tt)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
TT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.166)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tt)
)
)
3.12 备库新建实例
实例名称必须和主库的一致
oradim -new -sid tt
3.14 备库参数文件
在备库中需要新加
系统变量，变量名：oracle_sid 变量值:tt
注：tt为实例名
原文没有做这一步，导致启动出错。
3.15.3 复制数据库
RMAN> connect auxiliary sys/sys@standby
此次的意思是连接备库，如果出现问题打开命令窗口输入tnsping 192.168.1.121
IP地址为备库IP。
如果无法连接通，重启备库电脑上服务里的OracleOraDb11g_homeTNSListener.