11.2 dg部署测试 - 墨天轮文档

11.2 dg部署测试

一叶知秋

1071

19页

33次

2020-02-27

免费下载

cat /etc/hosts

192.168.8.50 nodea

10.10.10.50 nodea-priv

192.168.8.51 nodea-vip

192.168.8.60 nodeb

10.10.10.60 nodeb-priv

192.168.8.61 nodeb-vip

192.168.8.52 rac-scan

备库 ip

192.168.8.90

rac centos 7.2

dg redhat 6.5

oracle 11.2.0.4

primary database

1、主库需要是归档数据库

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP MOUNT;

SQL> ALTER DATABASE ARCHIVELOG;

SQL> ALTER DATABASE OPEN;

2、查询数据库是否 force logging

SQL> select name,force_logging from v$database;

NAME FOR

--------- ---

WANG YES

如 no，执行如下命令

alter database force logging;

3、把主库的 password file 复制到备库，作为备库的 password file，注意名称

scp orapwwang2 192.168.8.90:/u01/app/oracle/product/11.2.0/db_1/dbs/orapwzhang

4、配置主库接收日志，以备主备库切换时，无法接收日志

oracle rac 如果主库有 5 个日志组，添加 standby redo logfile 时，应该按 thread 进行添加，

thread 1 添加 6 个 standby redo logfile 日志组，thread 2 也添加 6 个。

添加 standby log

col member for a50

set linesize 200

select l.group#,l.bytes/1024/1024 MB,f.type,f.member from v$log l,v$logfile f

where l.group#=f.group# order by group#;

alter database add standby logfile group 6 ('+DATA','+FRA') size 50M;

alter database add standby logfile group 7 ('+DATA','+FRA') size 50M;

alter database add standby logfile group 8 ('+DATA','+FRA') size 50M;

alter database add standby logfile group 9 ('+DATA','+FRA') size 50M;

alter database add standby logfile group 10 ('+DATA','+FRA') size 50M;

alter database add standby logfile group 11 ('+DATA','+FRA') size 50M;

select group#,member ,type from v$logfile;

alter database drop logfile group 6;

********************************************************************************

***************************************************************

If the redo source database is an Oracle Real Applications Cluster (Oracle RAC)

or Oracle One Node database, query the V$LOG view at the redo source database to

determine how many redo threads exist and specify the corresponding thread

numbers when adding redo log groups to the standby redo log.

For example, the following SQL statements might be used to create a standby redo

log at a database that is to receive redo from a redo source database that has

two redo threads:

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 SIZE 500M;

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 SIZE 500M;

********************************************************************************

*****************************************************************

5、设置主库参数

官方文档举例

DB_NAME=wang

DB_UNIQUE_NAME=wang

LOG_ARCHIVE_CONFIG='DG_CONFIG=(wang,zhang)'

CONTROL_FILES='+DATA/wang/controlfile/current.260.991155623',

'+FRA/wang/controlfile/current.256.991155625'

LOG_ARCHIVE_DEST_1=

'LOCATION=/arch1/chicago/

VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

DB_UNIQUE_NAME=chicago'

LOG_ARCHIVE_DEST_2=

'SERVICE=boston ASYNC

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

DB_UNIQUE_NAME=boston'

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

#standby role

FAL_SERVER=boston

DB_FILE_NAME_CONVERT='boston','chicago'

LOG_FILE_NAME_CONVERT=

'/arch1/boston/','/arch1/chicago/','/arch2/boston/','/arch2/chicago/'

STANDBY_FILE_MANAGEMENT=AUTO

of 19

免费下载

关注

评论