OGG-01172 Discard file (dirrpt/REPTMP.dsc) exceeded max bytes (20000000).

OGG-01172  Discard file (dirrpt/REPTMP.dsc) exceeded max bytes (20000000).

One of my replicate got abended due to discard file reach max bytes value.

There is two option to resolve this issue.

Option : 1

Take backup of current discard file and purge it.

oracle@test dirrpt]$ du -sh REPTMP.dsc
2G REPTMP.dsc
[oracle@test dirrpt]$ ls -ltr REPTMP.dsc
-rw-r—–. 1 oracle oracle 2000930198 Apr 27 12:42 REPTMP.dsc
[oracle@test dirrpt]$ cp REPTMP.dsc REPTMP_BKP.dsc
[oracle@test dirrpt]$ >REPTMP.dsc
[oracle@test dirrpt]$ cat REPTMP.dsc

Option : 2

To increase size of the discardfile to a higher value.

Edit replicat parameter file and change DISCARDFILE parameter as below:

DISCARDFILE dirrpt/REPTMP.dsc, APPEND, MEGABYTES 4000

Save the replicat parameter file and quit from editor.
Start the replicat.

  • April 27, 2019 | 27 views
  • Comments