Hi,
I am implementing Oracle GoldenGate 11g on 2 server's . The details are as follows :-
MACHINE 1 :- SOURCE Machine :- ASM DB.
MACHINE 2 :- TARGET Machine :- Non - ASM.
I want to replicate from ASM db to NON-ASM db. I have created the EXTRACT and REPLICAT process. They both are running fine. No error in their report file. But I can see that EXTRACT is still trying to access REDO log of an ASM format.
The scenario is that we had taken a full backup using RMAN of ASM database and then restored it to other server which is NON-ASM. While restoring we faced some error for redo log files but then the DB was in mount mode as TARGET machine so we renamed the REDO log files and successfully opened the DB for use.
Now when i am trying to run a EXTRACT it shows me that its searching for REDO log files in ASM path .... how to change this ??
info NGPSMOKE,showch
EXTRACT NGPSMOKE Last Started 2011-09-30 15:01 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:11 ago)
Log Read Checkpoint Oracle Redo Logs
2011-09-30 15:01:36 Seqno 891, RBA 21788672
Current Checkpoint Detail:
Read Checkpoint #1
Oracle Redo Log
Startup Checkpoint (starting position in the data source):
Sequence #: 891
RBA: 19905040
Timestamp: 2011-09-30 14:57:48.000000
*Redo File: +ORADATA/ngpsmoke/onlinelog/group_1.472.749143799*
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Sequence #: 891
RBA: 21788176
Timestamp: 2011-09-30 15:01:36.000000
*Redo File: +ORADATA/ngpsmoke/onlinelog/group_1.472.749143799*
Current Checkpoint (position of last record read in the data source):
Sequence #: 891
RBA: 21788672
Timestamp: 2011-09-30 15:01:36.000000
Redo File: +ORADATA/ngpsmoke/onlinelog/group_1.472.749143799
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 0
RBA: 0
Timestamp: 2011-09-30 11:46:35.639498
Extract Trail: /u02/GoldenGate/dirdat/NGPSMOKE/rt
Write Checkpoint #2
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 1
RBA: 1094
Timestamp: 2011-09-30 15:01:54.679287
Extract Trail: /home/oracle/GoldenGate/dirdat/NGPSMOKE/rt
Header:
Version = 2
Record Source = A
Type = 4
# Input Checkpoints = 1
# Output Checkpoints = 2
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-09-30 15:01:13
Last Update Time = 2011-09-30 15:01:54
Stop Status = A
Last Result = 400
I have used the DBLOGREADER option in my params of EXTRACT which is as below :-
EXTRACT NGPSMOKE
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/db_1")
SETENV (ORACLE_SID = "NGPSMOKE2")
TRANLOGOPTIONS DBLOGREADER
USERID ggs_owner,PASSWORD ggs_owner
RMTHOST OFSMUW-OVM-51.i-flex.com,MGRPORT 7810
RMTTRAIL /home/oracle/GoldenGate/dirdat/NGPSMOKE/rt
FETCHOPTIONS FETCHPKUPDATECOLS
TABLE NGPSMOKE.*;
but this option it should read the redo log files directly from the user and not from ASM .... where am i doing it wrong ?
Please guide me as per.
Thanks in Advance.