Scenario 1
ERROR OGG-00446 Missing filename opening checkpoint file.
ERROR OGG-01668 PROCESS ABENDING.
___
Checking the replicat status
GGSCI (node4.example.com as ogguser@euro) 45> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT STOPPED REP1 00:00:00 00:00:06
Below is the error :-
2015-09-26 17:26:03 ERROR OGG-00446 Missing filename opening checkpoint file.
2015-09-26 17:26:03 ERROR OGG-01668 PROCESS ABENDING.
## this means that in replicat file keyword REPLICAT rep_group name is not written, lets fix this :-
edit params rep1
GGSCI (node4.example.com as ogguser@euro) 49> view params rep1
REPLICAT REP1
ASSUMETARGETDEFS
USERID ogguser, PASSWORD o
MAP scott.emp4, TARGET scott.emp4;
# Now we have updated REPLICAT REP1
GGSCI (node4.example.com as ogguser@euro) 52> start replicat rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (node4.example.com as ogguser@euro) 53> info replicat rep1
REPLICAT REP1 Last Started 2015-09-26 17:28 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Process ID 9086
Log Read Checkpoint File /u01/app/oracle/product/ogg_trg/dirdat/rt000000
2015-09-26 16:49:45.000288 RBA 1964
ERROR OGG-00446 Missing filename opening checkpoint file.
ERROR OGG-01668 PROCESS ABENDING.
___
Checking the replicat status
GGSCI (node4.example.com as ogguser@euro) 45> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT STOPPED REP1 00:00:00 00:00:06
Below is the error :-
2015-09-26 17:26:03 ERROR OGG-00446 Missing filename opening checkpoint file.
2015-09-26 17:26:03 ERROR OGG-01668 PROCESS ABENDING.
## this means that in replicat file keyword REPLICAT rep_group name is not written, lets fix this :-
edit params rep1
GGSCI (node4.example.com as ogguser@euro) 49> view params rep1
REPLICAT REP1
ASSUMETARGETDEFS
USERID ogguser, PASSWORD o
MAP scott.emp4, TARGET scott.emp4;
# Now we have updated REPLICAT REP1
GGSCI (node4.example.com as ogguser@euro) 52> start replicat rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (node4.example.com as ogguser@euro) 53> info replicat rep1
REPLICAT REP1 Last Started 2015-09-26 17:28 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Process ID 9086
Log Read Checkpoint File /u01/app/oracle/product/ogg_trg/dirdat/rt000000
2015-09-26 16:49:45.000288 RBA 1964
No comments:
Post a Comment