The ORA-16664 occur4es in Data Guard log files as following:
... .. . Site StandbyDb returned ORA-16664. ... .. .
Solution
a) Check both alert and data guard logs of primary database
b) Check both alert and data guard logs of standby database with following errors:
ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 28: No space left on device Additional information: 9925 ... .. . OS Audit file could not be created; failing after 6 retries ...
After cleaned the old audit files, then everything is fine.
DGMGRL> show database verbose "STANDBYDB"; ... .. . Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed 0 seconds ago) Apply Lag: 0 seconds (computed 1 second ago) Average Apply Rate: 4.38 MByte/s Active Apply Rate: 1.11 MByte/s Maximum Apply Rate: 46.39 MByte/s .. .. . Database Status: SUCCESS DGMGRL>