oracle 10g rac 配置物理dataguard系列4,Oracle10g RAC环境下 DataGuard备库搭建实例-4-自己补...

补充说明：==oracle官方配置===lvlisong==

(2006年

发布的，应该是9版本的===)

1.

tnsname.ora配置

CHICAGO1_SERV = (DESCRIPTION

= (ADDRESS

=

(PROTOCOL = TCP)

(HOST =chicago_host1vip)

(PORT = 1521))

(CONNECT_DATA

=

(SERVER =DEDICATED)

(SERVICE_NAME

=

CHICAGO)

(INSTANCE_NAME =CHICAGO1)

)

)

CHICAGO2_SERV

=

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = TCP)

(HOST = chicago_host2vip)

(PORT = 1521))

(CONNECT_DATA

=

(SERVER = DEDICATED)

(SERVICE_NAME

= CHICAGO)

(INSTANCE_NAME = CHICAGO2)

)

BOSTON

=

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = TCP)

(HOST =boston_host1)

(PORT = 1521))

(CONNECT_DATA

=

(SERVER = DEDICATED)

来源：(http://blog.sina.com.cn/s/blog_5ded2e5b0100f44h.html)

- Oracle10g RAC环境下DataGuard备库搭建实例-4-自己补_伊帆_新浪博客

(SERVICE_NAME

= BOSTON)

)

)

Primary

Database======配置==

*.db_unique_name=CHICAGO

*.service_names=CHICAGO

*.log_archive_config='dg_config=(CHICAGO,BOSTON)'

*.log_archive_dest_2='service=BOSTONvalid_for=(online_logfiles,primary_role)

db_unique_name=BOSTON'

*.db_file_name_convert='+DATA/BOSTON/',’+DATA/CHICAGO/',

’+RECOVERY/BOSTON’,’+RECOVERY/CHICAGO’

*.log_file_name_convert='+DATA/BOSTON/',’+DATA/CHICAGO/',

’+RECOVERY/BOSTON’,’+RECOVERY/CHICAGO’

=说明=下面参数是switch

over用的,切换成standy时，fal_server='bosten'=

*.standby_file_management=auto

*.fal_server='BOSTON'

CHICAGO1.fal_client='CHICAGO1_SERV'

CHICAGO2.fal_client='CHICAGO2_SERV'

Standby

database==================配置============

*.service_names='BOSTON'

*.db_unique_name='BOSTON'

*.log_archive_config='dg_config=(CHICAGO,BOSTON)'

*.log_archive_dest_2='service=CHICAGO1_SERV

valid_for=(online_logfiles,primary_role)

db_unique_name=CHICAGO'*.db_file_name_convert='+DATA/CHICAGO/','+DATA/BOSTON/','+RECOVERY/CHICAGO',

'+RECOVERY/BOSTON'

*.log_file_name_convert='+DATA/CHICAGO/','+DATA/BOSTON/','+RECOVERY/CHICAGO',

'+RECOVERY/BOSTON'

*.standby_file_management=auto

*.fal_server='CHICAGO1_SERV','CHICAGO2_SERV'

*.fal_client='BOSTON'

primary database create standby redo

log========

2.

Create standby redo logs on the primary database

to support the standby role. The standby

redo logs are the same size as the primary database online

logs. The recommended number of standby redo logs

is one more than the number of online redo

logs for each thread. Because this example has two online

redo logs for each thread, three standby redo logs are required for

each thread.

SQL> ALTER DATABASE ADD STANDBY

LOGFILE THREAD 1

GROUP 5 SIZE 10M,

GROUP 6 SIZE 10M,

GROUP 7 SIZE 10M;

SQL> ALTER DATABASE ADD STANDBY

LOGFILE THREAD 2

GROUP 8 SIZE 10M,

GROUP 9 SIZE 10M,

GROUP 10 SIZE 10M;

physical standby

database-------------------------------

(maximum # of logfiles +1) * maximum # of

threads

This example uses two online log files for

each thread.

Thus, the number of standby redo logs should be (2 + 1) * 2 = 6.

That is, one more standby redo log file for each thread.

Thread 1,

group 1 2

Thread

2,group 3, 4

SQL> ALTER DATABASE

ADD STANDBY LOGFILE THREAD 1

GROUP 5 SIZE 10M,

GROUP 6 SIZE 10M,

GROUP 7 SIZE 10M;SQL> ALTER DATABASE ADD STANDBY

LOGFILETHREAD 2

GROUP 8 SIZE 10M,

GROUP 9 SIZE 10M,

GROUP 10 SIZE 10M;

查询：

SQL> SELECT * FROM V$LOG;

SQL>

SELECT * FROM

V$STANDBY_LOG;

SQL> SELECT * FROM V$LOGFILE;