oracle rac 增加实例,ORACLE 11GRAC配置单实例ADG

环境：

主库和备库：

操作系统：Liunx6.5

数据库版本： 11.2.0.4

创建步骤：

一.主库配置

1.

设置为 force logging 模式

SQL> alter database force logging;

验证

SQL> select force_logging fromv$database;

FOR

---

YES

2.

主库添加standby redo日志文件

selectgroup#,thread#,members,status,bytes/1024/1024 m from v$log;

select group#,type,member from v$logfile order by 2;

添加原则：大小和 online redo 相同，比 online redo group 多一组。

alter database add standbylogfile thread 1 group 7 ('+DATA') size 521M;

alter database add standby logfile thread 1 group 8 ('+DATA') size 521M;

alter database add standby logfile thread 1 group 9 ('+DATA') size 521M;

alter database add standby logfile thread 1 group 10 ('+DATA') size 521M;

alter database add standby logfile thread 2 group 31('+DATA') size 521M;

alter database add standby logfile thread 2 group 32('+DATA') size 521M;

alter database add standby logfile thread 2 group 11 ('+DATA') size 521M;

alter database add standby logfile thread 2 group 12 ('+DATA') size 521M;

alter database add standby logfile thread 2 group 13 ('+DATA') size 521M;

alter database add standby logfile thread 2 group 14 ('+DATA') size 521M;

3.

添加监听及网络别名

在rac 中listener.ora 没有做配置。

只对tnsname.ora 做了配置，并且使用的是scanip

RACDB=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST =

192.168.2.79)(PORT = 1521)) ---s

canip

地址

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = racdb)

)

)

RACDB1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.77)(PORT= 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = racdb)

)

)

RACDB2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.78)(PORT= 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = racdb)

)

)

racdg =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.90)(PORT= 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = racdg)

)

)

4.

参数修改

alter system set log_archive_config='dg_config=(racdb,racdg)';

alter system setlog_archive_dest_1='location=+data/arch valid_for=(all_logfiles,all_roles)db_unique_name=racdb' scope=both sid='*' ; ;

alter system setlog_archive_dest_2='service=racdg sync valid_for=(online_logfiles,primary_role)db_unique_name=racdg'  scope=bothsid='*'  ;

alter system setlog_archive_dest_state_1=enable;

alter system setlog_archive_dest_state_2=enable;

alter system setFAL_SERVER='racdg';

alter system setfal_client='racdb';

alter system setstandby_file_management=auto;

二：配置standby库

1.

添加监听及网络别名

Lister.ora

SID_LIST_listener=

(SID_LIST=

(SID_DESC=

(SID_NAME=ptsdg)

(ORACLE_HOME=/u01/oracle/product/11.0.2.4)))

Tnsname.ora

同上

2.

修改参数

把节点一的参数文件scp到stadby库

把带有RACDB1 RACDB2 参书删除.

把节点一的参数文件scp到stadby库

db_unique_name=racdg

log_archive_format=%t_%s_%r.arc

log_archive_config='dg_config=(racdb,racdg)'

log_archive_dest_1='location=/data/archvalid_for=(all_logfiles,all_roles) db_unique_name=racdg'

log_archive_dest_2='service=racdb sync valid_for=(online_logfiles,primary_role)db_unique_name=racdb'

log_archive_dest_state_1=enable

log_archive_dest_state_2=enable

#remote_login_passwordfile=exclusive

fal_server=racdb

fal_client=racdg

standby_file_management=auto

db_file_name_convert='+DATA/racdb/datafile','/data/racdg/','+DATA/racdb/TEMPFILE/','/data/racdg'

log_file_name_convert='+DATA/racdb/onlinelog/','/data/racdg','

+data/arch

/','data/arch/'

3.

重建密码文件：(非常重要)(一般scp某个节点的密码文件，但是一般有问题)

orapwd file=orawpracdgpassword=sys ignorecase=y force=y

如果不这样做的话会导致alter报ORA-16191 and ORA-1017/ORA-1031

4.

创建目录

mkdir -p /u01/app/oracle/diag/rdbms/racdg/racdg /trace

mkdir -p /u01/app/oracle/diag/rdbms/ racdg/ racdg /cdump

mkdir -p /u01/app/oracle/admin/ racdg/adump

5.

启动数据库到nomount

Export ORACLE_SID=racdg

Sql>startup  nomount pfile=’/home/oracle/pfile.ora’

6.

创建standby

rman target sys/oracle@

RACDB1 auxiliarysys/oracle@

RACDG

duplicate target database for standby fromactive database;

7.

应用日志及验证

alter database open;

recover managed standbydatabase using current logfile disconnect from session;

主库

create table T  ( ID int);

insert into ID values(1);

commit;

standby:

SQL> select * from T;

设置主库参数

配置归档删除策略

CONFIGURE ARCHIVELOG DELETION POLICY toapplied on all standby;---

至此adg 配置完成。