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
No comments:
Post a Comment