My GG version: 11.2.1.0.x
OS version: RHEL 5.x
Oracle version: 11.2.0.2
Extract ABENDS
with below error
ERROR OGG-00730 No
minimum supplemental logging is enabled. This may cause extract process to
handle key update incorrectly if key column is not in first row piece.
This error occurs when we haven't yet enabled supplemental logging on the database
level but when I check my database it has
supplemental logging enabled
SQL> SELECT force_logging,
supplemental_log_data_min FROM v$database;
FOR SUPPLEME
--- --------
YES
YES
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 5
Next log sequence to archive 6
Current log sequence 6
Solution: This is a BUG, [1571665.1]
Added undocumented
parameter “TRANLOGOPTIONS
DISABLESUPPLOGCHECK” parameter to extract and once started then removed it from
paramfile and everything worked fine
0 comments:
Post a Comment