OGG-01411 – Cannot convert input file ./dirdat/xx with format RELEASE 9.0/9.5 to output file ./dirdat/zz

Hi.

If you search solutions to this Error, you will perceived only one documented root cause:

Error:

OGG-01411  Cannot convert input file ./dirdat/xx000549 with format RELEASE 9.0/9.5 to output file ./dirdat/zz000034 with format RELEASE 12.1.

Cause:

“The output trail of the data pump has a different format (version) than the input trail of the data pump”

If you are using GG 12.1 version, and all trails (rmttrail and exttrail) are correctly set with “format release”, you fell into a bug.

Oracle recommend to do upgrade to GG 12.2.

To work around this issue and start process, you need write a new trail, perform etrollover and reposition pump process.

On the Target System, process works fine, but not receive new trails, because pump process are abended.

GGSCI (lab2.grepora.net) 001> info rep01

REPLICAT rep01 Last Started 2017-03-20 12:08 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Process ID 13563
Log Read Checkpoint File ./dirdat/zz000034
2017-03-22 09:53:31.004144 RBA 30683971

Go to the source system.

GGSCI (lab1.grepora.net) 010> info pump01 
 
EXTRACT pump01                               Status ABENDED
Checkpoint Lag 06:10:32 (updated 00:00:01 ago) 
Process ID 13213 
Log Read Checkpoint File ./dirdat/xx000549 
2017-03-22 03:12:02.000012 RBA 267098 

Copy the red line above, to reposition extract process avoiding data loss.

GGSCI (lab1.grepora.net) 4> STOP ext01
GGSCI (lab1.grepora.net) 4> ALTER ext01 ETROLLOVER
GGSCI (lab1.grepora.net) 5> ALTER ext01 BEGIN 2017-03-22 02:12:02.000012 (red line copied)
GGSCI (lab1.grepora.net) 6> START ext01
GGSCI (lab1.grepora.net) 010> info pump01
EXTRACT pump01                               Status ABENDED
Checkpoint Lag 06:10:50 (updated 00:00:02 ago) 
Process ID 13213 
Log Read Checkpoint File ./dirdat/xx000549 
2017-03-22 03:12:02.000012 RBA 267098

Copy the red line above, to find new trail generated by etrollover.

GGSCI (lab1.grepora.net) 010> sh ls -lart ./dirdat/xx* (use second red line copied)
-rw-r----- 1 oracle oinstall 83729605 Mar 22 00:12 ./dirdat/xx000546
-rw-r----- 1 oracle oinstall 83821063 Mar 22 00:35 ./dirdat/xx000547
-rw-r----- 1 oracle oinstall 99998927 Mar 22 01:52 ./dirdat/xx000548
-rw-r----- 1 oracle oinstall   563291 Mar 22 02:30 ./dirdat/xx000549
-rw-r----- 1 oracle oinstall     3291 Mar 22 06:52 ./dirdat/xx000550 (this is the new trail, genereted by etrollover)

GGSCI (lab1.grepora.net) 014> STOP pump01
GGSCI (lab1.grepora.net) 015> ALTER pump01 extseqno 550 extrba 0
GGSCI (lab1.grepora.net) 016> START pump01

After you perform this procedure, check Pump and replicat process until they are online. If you have time, upgrade to 12.2 and show result to us. o/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s