altarchivelogdest
Oracle日志的读取 – 归档日志
- 缺省查询数据库中归档日志位置和格式并到指定位置查找对应归档日志文件
- 可通过参数指定归档日志
–TRANLOGOPTIONS {
[ALTARCHIVEDLOGFORMAT <string>] [INSTANCE <instance_name>] [THREADID <id>]
- 指定日志文件名的格式
[ALTARCHIVELOGDEST [PRIMARY] [INSTANCE <instance_name>] <path name>]
- 指定归档日志目录。如果是RAC，需要访问到所有节点归档日志，可使用共享文件系统或者使用nfs等将其它节点归档共享到运行节点
- 如果为所有节点指定了归档日志目录，则可以使用PRIMARY参数告诉GoldenGate无需再去查询log_archive_dest_N
–可以通过降低进程对控制文件访问次数
- 注意：OGG无法读取经压缩过的归档日志文件
TRANLOGOPTIONS ARCHIVEDLOGONLY
TRANLOGOPTIONS ALTARCHIVELOGDEST primary INSTANCE abv61 /ora_arch1,ALTARCHIVELOGDEST INSTANCE abv62 /ora_arch2
FETCHOPTIONS NOUSESNAPSHOT, NOUSELATESTVERSION, MISSINGROW REPORT
TRANLOGOPTIONS ALTARCHIVELOGDEST [PRIMARY] [INSTANCE
instance_name] <path name>
Valid for Oracle (single instance and RAC). Points Extract to the archived logs when they reside somewhere other than the default location. Extract first checks the default location, then the location specified with this parameter. <path name> specifies the fully qualified path to the archived logs. This directory must be NFS mounted to the node where GoldenGate is running.
Use that mount point for ALTARCHIVELOGDEST. INSTANCE <instance_name> applies the specified ALTARCHIVELOGDEST behavior to a specific Oracle instance. On RAC, if this option is used, you must specify the ALTARCHIVELOGDEST parameter on each node.
Comment