oracle_golden_gate_extract_redo_log

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		 Previous revision
oracle_golden_gate_extract_redo_log [2019/10/18 11:04] – external edit 127.0.0.1oracle_golden_gate_extract_redo_log [2019/11/19 23:15] (current) – external edit 127.0.0.1
Line 126: Line 126:
 SET ECHO OFF  SET ECHO OFF 
 </sxh> </sxh>
 +
 +
 +You can also use the following select to see the exact archivelog when the change happened. Remember that the archivelogs are keeping data for ALREADY Done changes, therefore, if the redo logs was created at 16:30, then this redo log holds the changes prior 16:30
 +
 +<sxh bash>
 +alter session SET NLS_DATE_FORMAT = 'YYYY/MM/DD HH24:MI:SS';
 +set linesize 400
 +set pagesize 100
 +col name format a100
 +col SEQ format 999,999,999
 +select NAME
 +,SEQUENCE# SEQ
 +,to_date(COMPLETION_TIME, 'YYYY-MM-DD HH24:MI:SS') Applied_date
 +,APPLIED
 +from v$archived_log
 +</sxh>
 +
 +
 +
 +The output will be something similar:
 +
 +
 +<sxh bash>
 +NAME                                                                                                          SEQ APPLIED_DATE        APPLIED
 +---------------------------------------------------------------------------------------------------- ------------ ------------------- ---------
 +/db/salesprd/arch/SALESPRD_1_442177_881750047.arc                                                         442,177 2019/11/19 15:10:48 NO
 +/db/salesprd/arch/SALESPRD_1_442178_881750047.arc                                                         442,178 2019/11/19 15:14:28 NO
 +/db/salesprd/arch/SALESPRD_1_442179_881750047.arc                                                         442,179 2019/11/19 15:17:40 NO
 +/db/salesprd/arch/SALESPRD_1_442180_881750047.arc                                                         442,180 2019/11/19 15:18:57 NO
 +/db/salesprd/arch/SALESPRD_1_442181_881750047.arc                                                         442,181 2019/11/19 15:23:02 NO
 +/db/salesprd/arch/SALESPRD_1_442182_881750047.arc                                                         442,182 2019/11/19 15:25:10 NO
 +/db/salesprd/arch/SALESPRD_1_442183_881750047.arc                                                         442,183 2019/11/19 15:27:13 NO
 +/db/salesprd/arch/SALESPRD_1_442184_881750047.arc                                                         442,184 2019/11/19 15:28:23 NO
 +/db/salesprd/arch/SALESPRD_1_442185_881750047.arc                                                         442,185 2019/11/19 15:30:02 NO
 +
 +</sxh>
 +
  
  • oracle_golden_gate_extract_redo_log.1571396697.txt.gz
  • Last modified: 2019/10/18 20:04
  • (external edit)