Oracle error
ORA-16014
ORA-16014: log %s sequence# %s not archived, no available destinations
What usually causes it
The archiver has no valid destination to write to, because they're full or in error.
What to check first
Fix the destination: free space in the FRA or clear the error on the destination.
Scripts that help
- Redo destinations and transport errorsEvery active archive destination with its status, gap state and last error. Any text in the ERROR column means redo isn't reaching that standby.
- Fast Recovery Area usageFRA size, used and reclaimable space, then what's using it by file type. Real used % is the number that matters: at 100% the database stops archiving…