LoveUnix » ORACLE等数据库 » 对10g DG几个参数不清楚的地方?
让LU留住您的每

一天 让LU博客留住您的每一天
2007-4-22 21:48 tom0732
对10g DG几个参数不清楚的地方?

*.log_archive_dest_1='location=D:\oracle\product\10.2.0\oradata\orcl\archive
[color=red]VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl' [/color]
*.log_archive_dest_2='service=AUX [color=red]VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=auxdb' [/color]

ONLINE_LOGFILES,ALL_ROLES,ALL_ROLESPRIMARY_ROLE,这些参数是什么意思.还有其它参数么.
还有后面跟着的DB_UNIQUE_NAME=auxdb,在归档路径后面代表什么意思.
fal_service='aux'
fal_client='orcl'
*.log_archive_config='dg_config=(orck,auxdb)'

听说10g dg可以做到自动切换??怎么设置

2007-4-22 22:56 oraix
VALID_FOR就是告诉数据库根据自己的角色来选择处理归档文件的方式

10g DG已经可以实现自动切换. 建议看一眼官方文档, 不难. 在这里写就费劲了.

可以琢磨下 一个例子:
[font=Courier New]
Chicago Database (Primary Role)           |  Boston Database (Physical Standby Database Role)
DB_UNIQUE_NAME=chicago            |   DB_UNIQUE_NAME=boston
LOG_ARCHIVE_CONFIG=             |   LOG_ARCHIVE_CONFIG=
 'DG_CONFIG=(chicago,boston)'        |    'DG_CONFIG=(chicago,boston)'
LOG_ARCHIVE_DEST_1=              |   LOG_ARCHIVE_DEST_1=
 'LOCATION=/arch1/chicago/         |    'LOCATION=/arch1/boston/
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)    |     VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=boston'          |     DB_UNIQUE_NAME=boston'
LOG_ARCHIVE_DEST_2=             |   LOG_ARCHIVE_DEST_2=
 'SERVICE=boston              |    'SERVICE=chicago
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) |     VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
  DB_UNIQUE_NAME=boston'          |     DB_UNIQUE_NAME=chicago'
LOG_ARCHIVE_DEST_STATE_1=ENABLE       |   LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE       |   LOG_ARCHIVE_DEST_STATE_2=ENABLE
STANDBY_ARCHIVE_DEST=/arch1/chicago/     |   STANDBY_ARCHIVE_DEST=/arch1/boston/
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE     |   REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE



Chicago Database (Primary Role)                                              
LOG_ARCHIVE_DEST_1          Directs archiving of redo data to the local archived redo log files in /arch1/chicago/.
LOG_ARCHIVE_DEST_2          Directs transmission of the redo data to the remote physical standby database boston.
STANDBY_ARCHIVE_DEST        Is ignored; valid only when chicago is running in the standby role.                

Boston Database (Physical Standby Role)
LOG_ARCHIVE_DEST_1          Directs archiving of redo data to the local archived redo log files in /arch1/boston/.
LOG_ARCHIVE_DEST_2          Is ignored; valid only when boston is running in the primary role.
STANDBY_ARCHIVE_DEST        Directs archival of redo data to the archived redo log files in the local directory /arch1/boston/.
[/font]

[[i] 本帖最后由 oraix 于 2007-4-22 23:06 编辑 [/i]]

2007-4-22 23:27 rwq_
好好看一下官司方的DATAGUARD文档资料

2007-4-23 18:38 tom0732
谢版主,可以稍微详细的解释一下
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=auxdb'
:lu11:
本地归档用=(ALL_LOGFILES,ALL_ROLES)  DB_UNIQUE_NAME=orcl'
远程归档用=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=auxdb'

页: [1]


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.