« 关注一下Oracle的CPU (Critical Patch Updates) | Blog首页 | opatch的补丁号、下载及备忘 »
DataGuard的STANDBY_ARCHIVE_DEST参数
作者:eygle | 【转载请注出处】|【云和恩墨 领先的zData数据库一体机 | zCloud PaaS云管平台 | SQM SQL审核平台 | ZDBM 数据库备份一体机】
链接:https://www.eygle.com/archives/2009/06/dataguard_standby_archive_dest.html
从Oracle 10gR2开始,Oracle DataGuard技术做出了很多改进,这些改进通过极其简单的参数设置就可以实现DataGuard的环境部署。链接:https://www.eygle.com/archives/2009/06/dataguard_standby_archive_dest.html
不过在这些简化之后,是大量参数属性的引入,这甚至会使人觉得不是简化而是复杂化吧。比如对于
LOG_ARCHIVE_DEST_
n
参数,有以下一系列属性信息,我引用一些文档连接在这里备忘:AFFIRM and NOAFFIRM ALTERNATE COMPRESSION DB_UNIQUE_NAME
DELAY LOCATION and SERVICE MANDATORY MAX_CONNECTIONS
MAX_FAILURE NET_TIMEOUT NOREGISTER REOPEN
SYNC and ASYNC VALID_FOR
对于STANDBY_ARCHIVE_DEST参数,实际上从10gr2开始就感觉是可有可无了,在11g中,被标记为废弃,不再被支持。
这实际上是一次简化。
对于
LOG_ARCHIVE_DEST_
n参数,如果设置了VALID_FOR=(ALL_LOGFILES,ALL_ROLES),那么在不定义
STANDBY_ARCHIVE_DEST参数时,Oracle就会选择LOG_ARCHIVE_DEST_
n参数作为归档目标。
当然也可以设置独立的LOG_ARCHIVE_DEST_n参数,设置VALID_FOR=(STANDBY_LOGFILE,*) 属性,则可以使用该路径作为备用归档路径。当然,即使所有设置都不满足备用归档使用,Oracle会使用一个缺省路径:
SQL> show parameter standby
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string ?/dbs/arch
standby_file_management string MANUAL
$ORACLE_HOME/dbs/arch里是个万能的归所。
以下日志来自一个测试环境:
Sun Jun 21 02:03:12 2009在Oracle 11g的文档中,已经标记出来该参数仅为向后兼容的目的保留了:
Using STANDBY_ARCHIVE_DEST parameter default value as /opt/oracle/archivelog
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 31987
RFS[1]: Identified database type as 'physical standby'
Sun Jun 21 02:03:12 2009
RFS LogMiner: Client disabled from further notification
RFS[1]: Successfully opened standby log 5: '/opt/oracle/oradata/eygle/stdrd2.log'
Sun Jun 21 02:03:12 2009
Fetching gap sequence in thread 1, gap sequence 37-38
Sun Jun 21 02:03:12 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[2]: Assigned to RFS process 31989
RFS[2]: Identified database type as 'physical standby'
Sun Jun 21 02:03:16 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[3]: Assigned to RFS process 31991
RFS[3]: Identified database type as 'physical standby'
Primary database is in MAXIMUM AVAILABILITY mode
Changing standby controlfile to RESYNCHRONIZATION level
Primary database is in MAXIMUM AVAILABILITY mode
Standby controlfile consistent with primary
RFS[3]: Successfully opened standby log 4: '/opt/oracle/oradata/eygle/stdrd1.log'
Sun Jun 21 02:03:16 2009
RFS[2]: Archived Log: '/opt/oracle/archivelog/1_37_689973859.dbf'
Sun Jun 21 02:03:17 2009
RFS[1]: Successfully opened standby log 5: '/opt/oracle/oradata/eygle/stdrd2.log'
Sun Jun 21 02:03:17 2009
RFS[2]: Archived Log: '/opt/oracle/archivelog/1_38_689973859.dbf'
Sun Jun 21 02:03:38 2009
Primary database is in MAXIMUM AVAILABILITY mode
Changing standby controlfile to MAXIMUM AVAILABILITY level
RFS[3]: Successfully opened standby log 4: '/opt/oracle/oradata/eygle/stdrd1.log'
Sun Jun 21 02:03:42 2009
Media Recovery Log /opt/oracle/archivelog/1_37_689973859.dbf
Media Recovery Log /opt/oracle/archivelog/1_38_689973859.dbf
Media Recovery Log /opt/oracle/archivelog/1_39_689973859.dbf
Media Recovery Log /opt/oracle/archivelog/1_40_689973859.dbf
Media Recovery Log /opt/oracle/archivelog/1_41_689973859.dbf
Media Recovery Waiting for thread 1 sequence 42 (in transit)
STANDBY_ARCHIVE_DEST
Property Description Parameter type String Syntax STANDBY_ARCHIVE_DEST =
filespec
Default value Operating system-specific Modifiable ALTER SYSTEM
Range of values A valid path or device name other than RAW
Note:
TheSTANDBY_ARCHIVE_DEST
parameter is deprecated. It is retained for backward compatibility only.
STANDBY_ARCHIVE_DEST
is relevant only for a standby database in managed recovery mode. It specifies the location of archive logs arriving from a primary database. Oracle usesSTANDBY_ARCHIVE_DEST
andLOG_ARCHIVE_FORMAT
to fabricate the fully qualified standby log filenames and stores the filenames in the standby control file.
这个参数的历史是这样的:
Version Parameter Type Modifiable 11.1.0.7 standby_archive_dest DEPRECATED STRING ALTER SYSTEM (IMMEDIATE) 11.1.0.6 standby_archive_dest DEPRECATED STRING ALTER SYSTEM (IMMEDIATE) 10.2.0.4 standby_archive_dest STRING ALTER SYSTEM (IMMEDIATE) 10.2.0.3 standby_archive_dest STRING ALTER SYSTEM (IMMEDIATE) 10.1.0.5 standby_archive_dest STRING ALTER SYSTEM (IMMEDIATE) 10.1.0.4 standby_archive_dest STRING ALTER SYSTEM (IMMEDIATE) 9.2.0.8 standby_archive_dest STRING ALTER SYSTEM (IMMEDIATE) 9.0.1.4 standby_archive_dest STRING ALTER SYSTEM (IMMEDIATE) 8.1.7.4 standby_archive_dest STRING ALTER SYSTEM (IMMEDIATE)
-The End-
历史上的今天...
>> 2010-06-22文章:
>> 2006-06-22文章:
>> 2005-06-22文章:
>> 2004-06-22文章:
By eygle on 2009-06-22 14:16 | Comments (1) | Advanced | 2314 |
10gR1 中standby 的改动真是深得人心啊,现在switch over 不用改任何配置,相当方便