GoldenGate

Hi,

Note: Please apologize me for posting every thing in plain text. I could not find how to tag the text in this page.

I am new to OGG and trying to get my hands dirty. Please help me to understand how to specify the ALTARCHIVEDLOGFORMAT when database is using FRA.

Oracle 11.2.0.1 OGG 11.1

My database is using FRA so oracle is not using the format specified in log_archive_format parameter. Where as, when i explicitly set TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT ARC%S_%R.%T (same as log_archive_format value) extract is abended with the below error message

2011-08-19 15:02:40 ERROR OGG-00446 Could not find archived log for sequence 28 thread 1 under alternative destinations. SQL <SELECT MAX(sequence#) FROM v$log WHERE thread# = :ora_thread AND status in ('INVALIDATED', 'CURRENT', 'ACTIVE')>. Last alternative log tried F:\app\VT0046014\flash_recovery_area\ora11g\ARCHIVELOG\ARC00028_0755020128.001, error retrieving redo file name for sequence 28, archived = 1, use_alternate = 0Not able to establish initial position for sequence 28, rba 11790864.

sample archivelog files ...

O1_MF_1_29_74VZSXOH_.ARC
O1_MF_1_30_74VZY20Z_.ARC
O1_MF_1_31_74W801CQ_.ARC

Please see my extract param file ...

EXTRACT extsrc
--CHECKPARAMS
SETENV (ORACLE_HOME = "F:\app\VT0046014\product\11.2.0\dbhome_1")
SETENV (ORACLE_SID = "ora11g")
USERID gguser@ora11g, PASSWORD gguser
EXTTRAIL F:\GoldenGate\GGS11\dirdat\lt
TRANLOGOPTIONS ALTARCHIVELOGDEST PRIMARY F:\app\VT0046014\flash_recovery_area\ora11g\ARCHIVELOG
TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT ARC%S_%R.%T
TABLE scott.allobjects;
TABLE Scott.allobjects1;


Please see the output of showch command ...

GGSCI (STLAP05376) 67> info extsrc showch

EXTRACT EXTSRC Last Started 2011-08-19 14:59 Status ABENDED
Checkpoint Lag 47:32:00 (updated 00:16:10 ago)
Log Read Checkpoint Oracle Redo Logs
2011-08-17 15:27:27 Seqno 28, RBA 11793336


Current Checkpoint Detail:

Read Checkpoint #1

Oracle Redo Log

Startup Checkpoint (starting position in the data source):
Sequence #: 28
RBA: 11790864
Timestamp: 2011-08-17 15:27:27.000000
Redo File: F:\APP\VT0046014\ORADATA\ORA11G\REDO01.LOG

Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Sequence #: 28
RBA: 11790864
Timestamp: 2011-08-17 15:27:27.000000
Redo File: F:\APP\VT0046014\FLASH_RECOVERY_AREA\ORA11G\ARCHIVELOG\2011_08_19\O1_MF_1_28_74VRNO00_.ARC

Current Checkpoint (position of last record read in the data source):
Sequence #: 28
RBA: 11793336
Timestamp: 2011-08-17 15:27:27.000000
Redo File: F:\APP\VT0046014\ORADATA\ORA11G\REDO01.LOG

Write Checkpoint #1

GGS Log Trail

Current Checkpoint (current write position):
Sequence #: 36
RBA: 1051
Timestamp: 2011-08-19 14:59:27.718000
Extract Trail: F:\GoldenGate\GGS11\dirdat\lt

Header:
Version = 2
Record Source = A
Type = 4
# Input Checkpoints = 1
# Output Checkpoints = 1

File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0

Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0

Status:
Start Time = 2011-08-19 14:59:27
Last Update Time = 2011-08-19 14:59:27
Stop Status = A
Last Result = 0

Please let me know if any one need any more information to look in.

Regards,
-Vijay