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