ORA-00322 ORA-00312 ORA-17502 ORA-15041 Standby database archivelog error

收到客戶的錯誤訊息，一般來說遇到ORA-00322、ORA-00312沒有其他錯誤，可以呼略，但這次多帶了ORA-17502、ORA-15041的錯誤

ORA-00322: log 42 of thread 2 is not current copy
ORA-00312: online log 42 thread 2: '+FRADG/ESBDBSTBY/ONLINELOG/group_42.264.1043845525'
ORA-00322: log 42 of thread 2 is not current copy
ORA-00312: online log 42 thread 2: '+DATADG/ESBDBSTBY/ONLINELOG/group_42.402.1043845523'
ORA-17502: ksfdcre:4 Failed to create file +FRADG/arch/esbdb/react_test_c8b8be34.arc
ORA-15041: diskgroup "FRADG" space exhausted

客戶的ASM +FRADG空間原只有1顆200G，後來有再發生此問題的前一天，擴充1顆200G

查看support文件 Doc ID 2372651.1，找到有此類似的狀況，雖不是online log相關，而是發生在create tablespace，這兩種過程與結果都是要「create file」，而發生空間不足的現象

SQL> CREATE BIGFILE TEMPORARY TABLESPACE TEMP_APP TEMPFILE '+DATA' SIZE 10g autoextend on next 1g maxsize 50g;
CREATE BIGFILE TEMPORARY TABLESPACE TEMP_APP TEMPFILE '+DATA' SIZE 10g autoextend on next 1g maxsize 50g
*
ERROR at line 1:
ORA-01119: error in creating database file '+DATA'
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15041: diskgroup "DATA" space exhausted

依照文件的內容步驟，對diskgroup做repair以及rebalance disk的動作

SQL> alter diskgroup FRADG check all repair;
SQL> alter diskgroup FRADG rebalance power 8;

檢查目前diskgroup rebalance的狀況

SQL> select * from gv$asm_operation;

後續就是再觀察還會不會發生...

參考來源：

Create TableSpace Fails with ORA-01119 ORA-17502 ORA-15041: Diskgroup Space Exhausted Despite Plenitude of Free Space is Present (Doc ID 2372651.1)

ORA-00322: log 41 of thread 2 is not current copy