近期公司资金服务器数据库要求使用11g配置data guard使用物理备用库做容灾,现对配置过程进行整理.测试在linux环境下完成,正式库放在windows 2008上面,具体操作步骤类似,以下主要介绍windows环境下的配置管理过程.
一.服务器环境:
两台DELL R710服务器,操作系统为WINDOWS SERVER 2008 ENTERPRISE EDTION 64X, 数据库为ORACLE 11G R1.
二.配置前准备:
两台DELL R710服务器,操作系统为WINDOWS SERVER 2008 ENTERPRISE EDTION 64X, 数据库为ORACLE 11G R1.
二.配置前准备:
1.将服务器硬盘配置RAID5与热备后,分为四个区,分别为system、data、log、backup四个区,system存放系统数据,data存放数据库文件,log存放数据库日志和归档文件,backup用于备份.
2.安装操作系统,安装数据库软件,主库ip配置为90.137,从库配置为90.138,在安装oracle时,主库安装数据库,从库只安装软件。
三.正式配置过程:
1.在主库上启动数据库到mount模式,开启归档模式与force logggin.
2.查看当前日志文件组
select group#,member from v$logfile order by group#;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------- ---
1 ONLINE E:\LOG\REDO01.LOG NO
2 ONLINE E:\LOG\REDO02.LOG NO
3 ONLINE E:\LOG\REDO03.LOG NO
---------- ------- ------- -------------------- ---
1 ONLINE E:\LOG\REDO01.LOG NO
2 ONLINE E:\LOG\REDO02.LOG NO
3 ONLINE E:\LOG\REDO03.LOG NO
3.为备用库创建三组日志文件:
alter database add standby logfile group 4 (E:\LOG\STAN04.LOG’) size 50m;
alter database add standby logfile group 5 (E:\LOG\STAN05.LOG’) size 50m;
alter database add standby logfile group 6 (E:\LOG\STAN06.LOG’) size 50m;
4.创建standby控制文件:
alter database create standby controlfile as ‘d:\standby.ctl’;
5.创建参数文件:
create pfile='d:\initora.ora' from spfile;
5.编辑参数文件,框内是要添加的内容:
6.使用修改过的参数文件启动主库:
startup pfile=’d:\initora.ora’ nomount;
create spfile from pfile=’’d:\initora.ora’ ;
shutdown immediate;
startup;
7.创建密码文件:
密码文件存放于C:\app\Administrator\product\11.1.0\db_1\database目录,文件名为PWDcenter.ora(center为实例名),如果目录下找不到,则手动创建,创建命令为:
orapwd file=C:\app\Administrator\product\11.1.0\db_1\database\PWDcenter.ora password=oracle entries=10
8.配置主库静态网络监听(备用库同理)
修改listener.ora文件,内容如下:
# listener.ora Network Configuration File: c:\app\Administrator\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.90.137)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\app\Administrator\product\11.1.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = center)
(ORACLE_HOME = c:\app\Administrator\product\11.1.0\db_1)
(SID_NAME = center)
)
)
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.90.137)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\app\Administrator\product\11.1.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = center)
(ORACLE_HOME = c:\app\Administrator\product\11.1.0\db_1)
(SID_NAME = center)
)
)
修改tnsnames.ora文件,内容如下:
primary =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.90.137)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = center)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.90.137)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = center)
)
)
standby =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.90.138)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = center)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.90.138)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = center)
)
)
9.启用主数据库,开启监听,用网络名连接测试监听是否正常。
alter database open;
lsnrctl start;
sqlplus username/pwd@primary as sysdba
10. 建立备用库.
a.将C:\app\Administrator目录下admin、cfgtollogs和diag目录拷至备用库
b.将d:\oradata目录拷至90.138的d盘下
c.将e:\log目录拷至90.138的e盘下
d.将standby.ctl拷至90.138的d:\oradata\center\目录下,并分别复制为control01.ctl,control02.ctl,control03.ctl.
11.在138上修改网络监听,内容与137类似,注册修改服务器
ip即可.
在windows上注意注册oracle实例到服务中,具体命令如下:
oradim -new -sid center(实例名)
oradim -new -sid center(实例名)
12.修改备用库参数文件:
将
initora.ora复制到90.138的d盘,修改参数文件,修改内容如下
13.启动备用节点:
startup nomount pfile=’d:\initora.ora’;
create spfile from pfile=’d:\initora.ora’;
shutdown immediate;
startup nomount;
14.加截数据库为备用库模式.
alter database mount standby database;
15.开启备用库应用重做
alter database recover managed standby database disconnect from session;
关闭应用重做
关闭应用重做
alter database recover managed standby database cancel;
配置实时应用重做
alter database recover managed standby database using current logfile;
16.查看配置是否成功:
a.查看切换状态:
a.查看切换状态:
select switchover_status from v$database;
b.手动切换归档,查看归档文件是否自动同步到备用库.
切换归档:alter system switch logfile;
在90.137和138上查看归档日志是否同步:SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
如果查看从库可以看到归档日志,表示归档日志同步成功,如果APPLIED列的值为yes,表示重做应用成功.
主库
从库:
配置完成.
本文转自ttzztt 51CTO博客,原文链接:http://blog.51cto.com/tianzt/251239
,如需转载请自行联系原作者