Oracle 11GR2 Windows server 2003平台下的DataGuard的部署
一、环境：
主库服务器地址: 11.0.1.1 SID=whgjj 备库服务器地址: 11.0.1.2
二、主库设置：
1.设置主数据库为force logging模式 SQL>sqlplus sys/yixinyu
SQL>alter database force logging;
2.设置主数据库为归档模式 SQL> shutdown immediate ; SQL> startup mount ;
SQL> alter database archivelog;
3.添加\备用联机日志文件\ 先查看日志文件位置：
SQL>select * from v$logfile; 再添加：
SQL> alter database add standby logfile group 4
('G:\\app\\Administrator\\oradata\\whgjj\\redo04.log') size 50m; SQL> alter database add standby logfile group 5
('G:\\app\\Administrator\\oradata\\whgjj\\redo05.log') size 50m; SQL> alter database add standby logfile group 6
(G:\\app\\Administrator\\oradata\\whgjj\\redo06.log') size 50m; SQL> alter database add standby logfile group 7
('G:\\app\\Administrator\\oradata\\whgjj\\redo07.log') size 50m; 4.创建主库的初始化参数给备库用 SQL>create pfile from spfile;
产生的文件名为initwhgjj.ora存放目录默认放在$ORACLE_HOME/database下 5. 在主库创建监听和配置tnsnams.ora listener.ora配置如下: SID_LIST_LISTENER = (SID_LIST = (SID_DESC =
(GLOBAL_DBNAME = whgjj)
(ORACLE_HOME =G:\\app\\Administrator\\product\\11.2.0\\dbhome_1) (SID_NAME = whgjj) )
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = G:\\app\\Administrator\\product\\11.2.0\\dbhome_1) (PROGRAM = extproc) (ENVS
=\clr11.dll\ ) )
LISTENER =
(DESCRIPTION_LIST = (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 11.0.1.1)(PORT = 1521)) )
)
tnsnames.ora配置如下: WHGJJ =
(DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 11.0.1.1)(PORT = 1521)) )
(CONNECT_DATA = (SERVICE_NAME = whgjj) ) )
STANDBY = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 11.0.1.2)(PORT = 1521)) )
(CONNECT_DATA =
(SERVICE_NAME = whgjj) ) )
ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) )
(CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )
7.在initorcl.ora添加以下内容： *.db_unique_name='whgjj'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=whgjjXDB)' *.fal_client='whgjj' *.fal_server='standby'