Wednesday, December 12, 2012

OGG-00446 Oracle GoldenGate Capture for Oracle Could not find archived log




OGG-00446  Oracle GoldenGate Capture for Oracle, ext1.prm:  Could not find archived log for sequence 204 thread 3 under default destinations

==============================================
find the archivelog creation date from DB
===============================================

SQL> select thread#,sequence#,completion_time from v$archived_log where sequence#=204;
THREAD#  SEQUENCE# COMPLETIO
---------- ---------- ---------
         3        204 07-DEC-12

==================================
restore archivelogs from backup
====================================

RMAN> LIST BACKUP SUMMARY;

run {
allocate channel t1 DEVICE type DISK;
restore archivelog from logseq = 204 until logseq = 260 thread 3;
release channel t1;
}

====================================
Restart goldengate extract process
=====================================
GGSCI (subhen-db01.***.***.***.***.au) 4> start EXTRACT EXT1

Sending START request to MANAGER ...
EXTRACT EXT1 starting

GGSCI (subhen-db01.***.***.***.***.au) 6> send extract ext1 status

Sending STATUS request to EXTRACT EXT1 ...


EXTRACT EXT1 (PID 31388)
  Current status: Recovery complete: Processing data

  Current read positions:
  Redo thread #: 1
  Sequence #: 250
  RBA: 192748
  Timestamp: 2012-12-11 10:51:34.000000
  SCN: 0.20959342

  Redo thread #: 2
  Sequence #: 242
  RBA: 44560
  Timestamp: 2012-12-11 10:57:18.000000
  SCN: 0.20965318

  Redo thread #: 3
  Sequence #: 250
  RBA: 431396
  Timestamp: 2012-12-11 10:40:40.000000
  SCN: 0.20939902

  Current write position:
  Sequence #: 18
  RBA: 1095
  Timestamp: 2012-12-13 15:29:31.918258
  Extract Trail: ./dirdat/x1

No comments:

Post a Comment