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.