We have received an alert in the morning that the Primary Database is out of Sync. Primary and Standby are with difference of 9 archives.
I have logged on to the primary and identified the below error.
ORA-19502: write error on file "", block number (block size=)
I have logged on to the primary and identified the below error.
ORA-19502: write error on file "", block number (block size=)
SQL> set line 200 col DEST_NAME for a50 col BINDING for a10 select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE' / DEST_ID DEST_NAME STATUS BINDING ERROR ---------- -------------------------------------------------- --------- ---------- ----------------------------------------------------------------- 1 LOG_ARCHIVE_DEST_1 VALID OPTIONAL 2 LOG_ARCHIVE_DEST_2 ERROR OPTIONAL ORA-19502: write error on file "", block number (block size=)In the above output the STATUS column is showing ERROR.
I have logged on to the Standby database and found the archive mount point is full. I removed the applied archives and freed up some space. How to check Sync Status on Standby
Defer'd and Enable'd the shipping on Primary Database.
SQL> alter system set log_archive_dest_state_2=defer; System Altered. SQL> alter system set log_archive_dest_state_2=enable; System Altered. SQL> set line 200 SQL> col DEST_NAME for a50 SQL> col BINDING for a10 SQL> select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE' / DEST_ID DEST_NAME STATUS BINDING ERROR ---------- -------------------------------------------------- --------- ---------- ----------------------------------------------------------------- 1 LOG_ARCHIVE_DEST_1 VALID OPTIONAL 2 LOG_ARCHIVE_DEST_2 VALID OPTIONAL
Now the STATUS column is showing Valid and the ERROR column is null.
Archive started shipping to Standby Database and got applied.
How to check Sync Status on Standby
Archive started shipping to Standby Database and got applied.
How to check Sync Status on Standby