Dataguard 物理安装

最新推荐文章于 2024-09-19 16:47:21 发布

crfb86846

最新推荐文章于 2024-09-19 16:47:21 发布

阅读量94

点赞数

文章标签：数据库操作系统网络

一 : 环境配置
1.查看linux版本号
[oracle@fastrise02 /]$ lsb_release -a
LSB Version: :core-3.0-ia32:core-3.0-noarch:graphics-3.0-ia32:graphics-3.0-noarch
Distributor ID: CentOS
Description: CentOS release 4.7 (Final)
Release: 4.7
Codename: Final

2.查看oracle版本号
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

3.配置oracle帐户的环境变量
编辑 vi .bash_profile

ORACLE_BASE=/u01
ORACLE_HOME=/u01/oracle
ORACLE_SID=snowdb
PATH=$ORACLE_HOME/bin:$PATH
NLS_LANG=american_america.ZHS16GBK;
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH NLS_LANG

4.配置hosts、IP、listener.ora、tnsname.ora.

vi /etc/hosts
172.16.99.195 fastrise01
172.16.99.196 fastrise02

vi /etc/sysconfig/network-scripts/ifcfg-eth0
ONBOOT=yes
USERCTL=no
IPV6INIT=no
PEERDNS=yes
GATEWAY=172.16.99.254
TYPE=Ethernet
DEVICE=eth0
HWADDR=00:0c:29:31:2d:fe
BOOTPROTO=none
NETMASK=255.255.255.0
IPADDR=172.16.99.196

vi /u01/oracle/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fastrise02)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

vi /u01/oracle/network/admin/tnsnames.ora
FASTRISE02 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.99.196)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = snowdb)
)
)
FASTRISE01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.99.195)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = snowdb)
)
)
5.创建主数据库(dbca)
ORA_SID =snowdb

二：创建并配置主、备库库
配置步骤首先，装好主库fastrise01和备库fastrise02上的oracle，建sid同为snowdb的库，所有设置完全相同。然后停止shutdown两台上的oracle，将主库fastrise01上的所有数据文件、控制文件、初始化init***.ora文件、redo文件和password文件都copy到备库fastrise02机器的相应位置（还可以利用热备，rman等来建立初始备库），这样，我们就拥有了两台完全一样的ORACLE SERVER 。
1.在primary database上设置force logging
SQL>create pfile from spfile;
SQL>alter database force logging;
2.修改primary database初始化参数
SERVICE_NAMES=SNOWDB
DB_UNIQUE_NAME='UQN_NODE1'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(UQN_NODE2,UQN_NODE1)'
LOG_ARCHIVE_DEST_2=
'SERVICE=FASTRISE02 ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=UQN_NODE2'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_MAX_PROCESSES=30
FAL_SERVER=FASTRISE02
FAL_CLIENT=FASTRISE01
STANDBY_FILE_MANAGEMENT=AUTO
通过 VALID_FOR 属性指定传输及接收对象
valid_for 配合其 redo_log_type,database_role 属性，其理解为：为指定角色设置日志文件的归档路径，主要目的是为了辅助一旦发生角色切换操作后数据库的正常运转。
redo_log_type 可设置为： online_logfile ，standby_logfile ，all_logfiles
database_role 可设置为： primary_role ，standby_role ， all_roles
online_logfile: 表示归档联机重做日志
standby_logfile:表示归档备用数据库的重做日志/接受的重做日志
all_logfiles: online_logfile && standby_logfile
primary_role: 仅当数据库角色为主库时候归档生效
standby_role: 仅当数据库角色为备库时候归档生效
all_role: 任意角色归档均生效
3. 设置primary database为archivelog模式
SQL>shutdown immediate;
SQL>startup mount;
SQL>alter database archivelog;
SQL>alter database open:
4.在primary database上创建standby database的控制文件
SQL> shutdown immediate;
SQL> startup mount pfile='/u01/oracle/dbs/initsnowdb.ora';
SQL> alter database create standby controlfile as '/u01/testst.ctl';
SQL>alter database open;
然后将该controlfile复制到standby server的对应位置
5.修改standby databse的初始化参数
SERVICE_NAMES=SNOWDB
DB_UNIQUE_NAME='UQN_NODE2'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(UQN_NODE1,UQN_NODE2)'
LOG_ARCHIVE_DEST_2=
'SERVICE=FASTRISE01 ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=UQN_NODE1'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_MAX_PROCESSES=30
FAL_SERVER=FASTRISE01
FAL_CLIENT=FASTRISE02
STANDBY_FILE_MANAGEMENT=AUTO
6.启动primary database
SQL>startup pfile='/u01/oracle/dbs/initsnowdb.ora';
7.启动standby database
SQL>startup nomount pfile='/u01/oracle/dbs/initsnowdb.ora'
SQL>alter database mount standby database;
8.启动standby database到recover manage模式
SQL>alter database recover managed standby database disconnect from session;
三：测试主备库方案
1.查看归档情况及其传输方法
⑴查看全部归档数：
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oradata/arch1
Oldest online log sequence 48
Next log sequence to archive 50
Current log sequence 50
⑵查看正在应用归档：
SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
8 NO
8 YES
⑶查看日志无法传送
SQL>select dest_name,status,error from v$archive_dest;
查看相应的归档路径的状态是否valid，否则根据error信息进行处理
⑷查看归档是否有错误同步
SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ# FROM V$ARCHIVE_DEST_STATUS WHERE STATUS <> 'DEFERRED' AND STATUS <> 'INACTIVE';
DESTINATION
--------------------------------------------------------------------------------
STATUS ARCHIVED_THREAD# ARCHIVED_SEQ#
--------- ---------------- -------------
/u01/oradata/arch1
VALID 1 49