逐步创建Data Guard - 数据库编程

E = primary )
（SERVER = DEDICATED）
)
)
standby =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby-ip )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = standby)
（SERVER = DEDICATED）
)
)
==================================================================
6、至此主库已经设置完成，需要重新启动才能使参数文件生效，并将产生的备份文件、standby控制文件、密码文件拷贝到备机相应目录下
============================================================================================
备库部分的设置

1、配置监听（配置完成后需要重启监听才能生效）
======================================================================================
# listener.ora Network Configuration File: /oracle/oracle/product/10.2.1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/oracle/product/10.2.1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = primary)
(ORACLE_HOME = /oracle/oracle/product/10.2.1)
(SID_NAME = primary)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))
)
)
=========================================================================================
2、tnsnames.ora配置（需要注意服务名，涉及到日志传输）
primary =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = primary-ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = primary )
（SERVER = DEDICATED）
)
)
standby =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby-ip )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = standby)
（SERVER = DEDICATED）
)
)
=============================================================================================
3、创建日志输出文件的相关目录(注意登录的用户，和文件权限)
/oradata/dg/mkdir standy
/oradata/dg/cd standy
/oradata/dg/mkdir adump bdump cdump ddump
=====================================================================
4、增加standby redologs
在备机创建，注意组号不要与主机online redologs重复，大小要与主库的online redologs一致

首先查询当前主库的online redologs大小等信息
select group#,type,member from v$logfile; 查询online redologs路径
select thread#,group#,bytes/1024/1024 from v$log; 查询online redologs大小，及组号

ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ('/oradata/dg/redost4_1') size 10M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 ('/oradata/dg/redost5_1') size 10M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 ('/oradata/dg/redost6_1') size 10M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 ('/oradata/dg/redost7_1') size 10M;
================================================================
检查日志文件
select member from v$logfile;
select * from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/oratest/app/oracle/oradata/allinpay/redo03.log
/oratest/app/oracle/oradata/allinpay/redo02.log
/oratest/app/oracle/oradata/allinpay/redo01.log
/oradata/dg/redost4_1
/oradata/dg/redost5_1
/oradata/dg/redost6_1
/oradata/dg/redost7_1

5、env | grep ORACLE_SID -----查看并确认当前备机的实例名
export ORACLE_SID=standby

6、测试两台服务器网络
TNSPING primdb
TNSPING standby

7、配置备机初始化参数文件（在从primary复制过来的pfile文件上更改）
======================================================

逐步创建Data Guard(二)