data guard 操作指南

1、data guard 操作指南 oracle 11gr2 windows server 2003平台下的dataguard的部署 一、环境： 主库服务器地址: 11.0.1.1 sid=whgjj 备库服务器地址: 11.0.1.2 二、主库设置： 1.设置主数据库为force logging模式 sqlsqlplus sys/yixinyu sqlalter database force logging; 2.设置主数据库为归档模式 sql shutdown immediate ; sql startup mount ; sql alter database archivelog; 3.添加

2、备用联机日志文件 先查看日志文件位置： sqlselect * from v$logfile; 再添加： sql alter database add standby logfile group 4 (g:appadministratororadatawhgjjredo04.log) size 50m; sql alter database add standby logfile group 5 (g:appadministratororadatawhgjjredo05.log) size 50m; sql alter database add standby logfile group 6

3、(g:appadministratororadatawhgjjredo06.log) size 50m; sql alter database add standby logfile group 7 (g:appadministratororadatawhgjjredo07.log) size 50m; 4.创建主库的初始化参数给备库用 sqlcreate pfile from spfile; 产生的文件名为initwhgjj.ora存放目录默认放在$oracle_home/database下 5. 在主库创建监听和配置tnsnams.ora listener.ora配置如下: sid_lis

4、t_listener = (sid_list = (sid_desc = (global_dbname = whgjj) (oracle_home =g:appadministratorproduct11.2.0dbhome_1) (sid_name = whgjj) ) (sid_desc = (sid_name = clrextproc) (oracle_home = g:appadministratorproduct11.2.0dbhome_1) (program = extproc) (envs =clr11.dll ) ) listener = (description_list =

5、 (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 = (desc

6、ription = (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_na