Ogg-01184 Expected 4 Bytes But Got 0 Bytes In Trail Official
| Field | Size | Description | |-------|------|-------------| | Record Length | 4 bytes | Indicates the total size of the following data | | Record Data | Variable | Actual change data in canonical format | | Checksum (optional) | 4 bytes | Integrity check |
Checksums add about 3-5% overhead but prevent silent corruption. Do not use unlimited file sizes. Force rollover to reduce blast radius:
If the file is partially recoverable, use logdump to write a clean trail: ogg-01184 expected 4 bytes but got 0 bytes in trail
Record the current SCN on the source database for all replicated tables:
ggsci> ALTER REPLICAT rep01, EXTSEQNO 12, EXTRBA 4819000 ggsci> START REPLICAT rep01 You lose all changes after RBA 4819000. Resync required for the missing window. Solution 3: Recover from Source Trail or Archive (Recommended for Production) If you have archive trails enabled ( EXTTRAIL with ROLLOVER at source) or a backup of the trail files before corruption: Resync required for the missing window
You lose exactly one transaction. You must manually reconcile that row(s) later. Solution 2: Use LOGDUMP to Skip to Next Good Record (Medium Risk) If the corrupt RBA is mid-transaction (TransInd = 2, 3, or 4), you cannot skip just one transaction without breaking referential integrity for that transaction’s group of operations.
TRAILCHKSUMCHECK NO TRAILCHKSUMBLOCKCHECK NO Wait—no, that disables checking. To checksum validation (ensuring corruption is caught early): Solution 2: Use LOGDUMP to Skip to Next
cd $OGG_HOME ./logdump logdump> open /u01/gg/dirdat/rt000012 logdump> ghdr on logdump> detail on logdump> pos 4820192 logdump> n