同事巡检查发现Oracle RAC DG备库的Oracle Home目录使用空间巨增，执行命令发现oracle目录占用了87G，这肯定不正常。
[root@dgdb1 app]# du -sh * 11G 11.2.0 8.0K asmpfile.ora 3.1G grid 87G oracle 4.0M oraInventory
进一步检查发现ORACLE_HOME目录下的dbs目录占用了61G。
[root@dgdb1 db_1]# du -sh * 177M apex 303M assistants 459M bin 58M ccr 8.0K cdata 2.9M cfgtoollogs 68K clone 4.0K config 5.9M crs 24K csmig 236K css 296M ctx 3.3M cv 61G dbs 12K dc_ocm 396K deinstall 1.1M demo 16K diagnostics 6.9M dv 40K emcli 8.0K EMStage 1.9M has 40K hs 11M ide 7.4M install 1.5M instantclient 215M inventory 60M j2ee 118M javavm 26M jdbc 520K jdev 186M jdk 43M jlib 2.7M ldap 768M lib 64K log 33M md 96K mesg 908K mgw 8.3M network 33M nls 326M oc4j 1.7M odbc 13M olap 5.5M OPatch 528K opmn 40M oracore 4.0K oraInst.loc 7.4M ord 29M oui 545M owb 1.7M owm 60M perl 1.6M plsql 5.1M precomp 316K racg 127M rdbms 124K relnotes 4.0K root.sh 12K scheduler 20K slax 82M sqldeveloper 4.8M sqlj 484K sqlplus 9.6M srvm 21M suptools 220M sysman 112K timingframework 512K ucp 3.7M uix 800K usm 8.0K utl 556K wwg 19M xdk
检查dbs目录发现多了很多broken*这样的文件,并且在是三月2号8:36分到9:49分之间生成的
[root@dgdb1 dbs]# ls -lrt total 63341528 -rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora -rw-rw---- 1 oracle asmadmin 1544 Nov 9 2016 hc_rlzy1.dat -rw-r----- 1 oracle oinstall 1536 Nov 11 2016 orapwRLZY1 -rw-r--r-- 1 oracle oinstall 60 Nov 20 2016 initRLZY1.ora -rw-r--r-- 1 oracle oinstall 60 Nov 24 2016 initRLZY1.ora.bk -rw-r--r-- 1 oracle oinstall 1922 Nov 24 2016 initCAIWU1.ora.bk -rw-r--r-- 1 oracle oinstall 60 Nov 24 2016 initCAIWU1.ora -rw-r----- 1 oracle oinstall 1536 Nov 24 2016 orapwCAIWU1 -rw-rw---- 1 oracle asmadmin 1544 Nov 24 2016 hc_chdyldg.dat -rw-r--r-- 1 oracle oinstall 1979 Nov 24 2016 initchdyl1.ora.bk -rw-r--r-- 1 oracle oinstall 61 Nov 24 2016 initchdyl1.ora -rw-r----- 1 oracle oinstall 1536 Nov 24 2016 orapwchdyl1 -rw-r--r-- 1 oracle oinstall 2019 Nov 28 2016 initsjjh1.ora.bk -rw-r--r-- 1 oracle oinstall 60 Nov 28 2016 initsjjh1.ora.bak.dgdb1 -rw-r----- 1 oracle oinstall 1536 Nov 28 2016 orapwsjjh1.bk -rw-r--r-- 1 oracle oinstall 83 Nov 29 2016 initsjjh1.ora -rw-rw---- 1 oracle asmadmin 1544 Apr 1 2017 hc_dbdb1.dat -rw-r--r-- 1 oracle oinstall 1783 Apr 1 2017 initdadb1.ora.bk -rw-r--r-- 1 oracle oinstall 53 Apr 1 2017 initdadb1.ora.bak.dgdb1 -rw-r----- 1 oracle oinstall 1536 Apr 1 2017 orapwdadb1 -rw-r--r-- 1 oracle oinstall 76 Apr 5 2017 initdadb1.ora -rw-rw---- 1 oracle asmadmin 1544 Apr 22 2019 hc_chdyl1.dat -rw-rw---- 1 oracle asmadmin 1544 Apr 22 2019 hc_dadb1.dat -rw-rw---- 1 oracle asmadmin 1544 Apr 22 2019 hc_CAIWU1.dat -rw-rw---- 1 oracle asmadmin 1544 Jul 29 2019 hc_RLZY1.dat -rw-r----- 1 oracle oinstall 1536 Aug 6 2019 orapwsjjh -rw-rw---- 1 oracle asmadmin 1544 Aug 6 2019 hc_sjjh.dat -rw-r----- 1 oracle asmadmin 10797056 Oct 14 2019 snapcf_sjjh1.f -rw-r----- 1 oracle oinstall 1536 Mar 1 18:31 orapwsjjh1 -rw-r----- 1 oracle asmadmin 1262486016 Mar 2 08:36 broken0 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:36 broken1 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:36 broken2 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:36 broken3 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:36 broken4 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:36 broken5 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:37 broken6 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:37 broken7 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:37 broken8 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:37 broken9 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:37 broken10 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:37 broken11 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:38 broken12 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:38 broken13 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:38 broken14 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:38 broken15 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:38 broken16 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:38 broken17 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:38 broken18 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:39 broken19 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:39 broken20 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:39 broken21 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:39 broken22 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:39 broken23 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:39 broken24 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:40 broken25 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:40 broken26 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:40 broken27 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:40 broken28 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:40 broken29 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:48 broken59 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:48 broken33 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:48 broken35 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:48 broken34 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:48 broken36 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:49 broken37 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:49 broken39 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:49 broken38 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:49 broken40 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:49 broken41 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:49 broken42 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:49 broken43 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:50 broken44 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:50 broken45 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:50 broken46 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:50 broken47 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:50 broken48 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:50 broken49 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:51 broken51 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:51 broken50 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:51 broken52 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:51 broken53 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:51 broken54 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:51 broken55 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:52 broken57 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:52 broken56 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 08:52 broken58 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 09:17 broken32 -rw-r----- 1 oracle asmadmin 1073742336 Mar 2 09:33 broken31 -rw-r----- 1 oracle asmadmin 1262486016 Mar 2 09:49 broken30 -rw-rw---- 1 oracle asmadmin 1544 Mar 2 10:02 hc_sjjh1.dat -rw-r----- 1 oracle asmadmin 48316416 Jul 21 03:00 snapcf_RLZY1.f
查看文件broken0发现是sjjh数据库与日志文件相关的错误
查看实例的alert.log文件的内容，果然是在写日志文件时出现了错误:
Successful mount of redo thread 1, with mount id 4246975374 Physical Standby Database mounted. Lost write protection disabled Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken0' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken0' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken1' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken1' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken2' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken2' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 4 of thread 1 ORA-00312: online log 4 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken3' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 4 of thread 1 ORA-00312: online log 4 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken3' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 5 of thread 1 ORA-00312: online log 5 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken4' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 5 of thread 1 ORA-00312: online log 5 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken4' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 6 of thread 1 ORA-00312: online log 6 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken5' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 6 of thread 1 ORA-00312: online log 6 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken5' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 7 of thread 1 ORA-00312: online log 7 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken6' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 7 of thread 1 ORA-00312: online log 7 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken6' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 8 of thread 1 ORA-00312: online log 8 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken7' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 8 of thread 1 ORA-00312: online log 8 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken7' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 9 of thread 1 ORA-00312: online log 9 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken8' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 9 of thread 1 ORA-00312: online log 9 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken8' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 10 of thread 1 ORA-00312: online log 10 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken9' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 10 of thread 1 ORA-00312: online log 10 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken9' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 11 of thread 1 ORA-00312: online log 11 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken10' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 11 of thread 1 ORA-00312: online log 11 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken10' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 12 of thread 1 ORA-00312: online log 12 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken11' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 12 of thread 1 ORA-00312: online log 12 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken11' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 13 of thread 1 ORA-00312: online log 13 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken12' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 13 of thread 1 ORA-00312: online log 13 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken12' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 14 of thread 1 ORA-00312: online log 14 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken13' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 14 of thread 1 ORA-00312: online log 14 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken13' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 15 of thread 1 ORA-00312: online log 15 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken14' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 15 of thread 1 ORA-00312: online log 15 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken14' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 16 of thread 1 ORA-00312: online log 16 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken15' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 16 of thread 1 ORA-00312: online log 16 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken15' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 17 of thread 1 ORA-00312: online log 17 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken16' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 17 of thread 1 ORA-00312: online log 17 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken16' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 18 of thread 1 ORA-00312: online log 18 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken17' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 18 of thread 1 ORA-00312: online log 18 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken17' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 19 of thread 1 ORA-00312: online log 19 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken18' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 19 of thread 1 ORA-00312: online log 19 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken18' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 20 of thread 1 ORA-00312: online log 20 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken19' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 20 of thread 1 ORA-00312: online log 20 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken19' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 21 of thread 1 ORA-00312: online log 21 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken20' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 21 of thread 1 ORA-00312: online log 21 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken20' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 22 of thread 1 ORA-00312: online log 22 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken21' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 22 of thread 1 ORA-00312: online log 22 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken21' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 23 of thread 1 ORA-00312: online log 23 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken22' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 23 of thread 1 ORA-00312: online log 23 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken22' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 24 of thread 1 ORA-00312: online log 24 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken23' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 24 of thread 1 ORA-00312: online log 24 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken23' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 25 of thread 1 ORA-00312: online log 25 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken24' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 25 of thread 1 ORA-00312: online log 25 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken24' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 26 of thread 1 ORA-00312: online log 26 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken25' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 26 of thread 1 ORA-00312: online log 26 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken25' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 27 of thread 1 ORA-00312: online log 27 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken26' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 27 of thread 1 ORA-00312: online log 27 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken26' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 28 of thread 1 ORA-00312: online log 28 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken27' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 28 of thread 1 ORA-00312: online log 28 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken27' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 29 of thread 1 ORA-00312: online log 29 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken28' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 29 of thread 1 ORA-00312: online log 29 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken28' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 30 of thread 1 ORA-00312: online log 30 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken29' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 30 of thread 1 ORA-00312: online log 30 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken29' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 31 of thread 1 ORA-00312: online log 31 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken30' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 31 of thread 1 ORA-00312: online log 31 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken30' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 32 of thread 1 ORA-00312: online log 32 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken31' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 32 of thread 1 ORA-00312: online log 32 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken31' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 33 of thread 1 ORA-00312: online log 33 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken32' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 33 of thread 1 ORA-00312: online log 33 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken32' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 34 of thread 1 ORA-00312: online log 34 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken33' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 34 of thread 1 ORA-00312: online log 34 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken33' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 35 of thread 1 ORA-00312: online log 35 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken34' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 35 of thread 1 ORA-00312: online log 35 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken34' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 36 of thread 1 ORA-00312: online log 36 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken35' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 36 of thread 1 ORA-00312: online log 36 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken35' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 37 of thread 1 ORA-00312: online log 37 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken36' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 37 of thread 1 ORA-00312: online log 37 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken36' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 38 of thread 1 ORA-00312: online log 38 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken37' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 38 of thread 1 ORA-00312: online log 38 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken37' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 39 of thread 1 ORA-00312: online log 39 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken38' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 39 of thread 1 ORA-00312: online log 39 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken38' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 40 of thread 1 ORA-00312: online log 40 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken39' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 40 of thread 1 ORA-00312: online log 40 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken39' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 41 of thread 1 ORA-00312: online log 41 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken40' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 41 of thread 1 ORA-00312: online log 41 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken40' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 42 of thread 1 ORA-00312: online log 42 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken41' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 42 of thread 1 ORA-00312: online log 42 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken41' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 43 of thread 1 ORA-00312: online log 43 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken42' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 43 of thread 1 ORA-00312: online log 43 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken42' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 44 of thread 1 ORA-00312: online log 44 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken43' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 44 of thread 1 ORA-00312: online log 44 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken43' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 45 of thread 1 ORA-00312: online log 45 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken44' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 45 of thread 1 ORA-00312: online log 45 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken44' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 46 of thread 1 ORA-00312: online log 46 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken45' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 46 of thread 1 ORA-00312: online log 46 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken45' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 47 of thread 1 ORA-00312: online log 47 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken46' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 47 of thread 1 ORA-00312: online log 47 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken46' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 48 of thread 1 ORA-00312: online log 48 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken47' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 48 of thread 1 ORA-00312: online log 48 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken47' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 49 of thread 1 ORA-00312: online log 49 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken48' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 49 of thread 1 ORA-00312: online log 49 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken48' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 50 of thread 1 ORA-00312: online log 50 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken49' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 50 of thread 1 ORA-00312: online log 50 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken49' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 51 of thread 1 ORA-00312: online log 51 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken50' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 51 of thread 1 ORA-00312: online log 51 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken50' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 52 of thread 1 ORA-00312: online log 52 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken51' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 52 of thread 1 ORA-00312: online log 52 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken51' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 53 of thread 1 ORA-00312: online log 53 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken52' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 53 of thread 1 ORA-00312: online log 53 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken52' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 54 of thread 1 ORA-00312: online log 54 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken53' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 54 of thread 1 ORA-00312: online log 54 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken53' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 55 of thread 1 ORA-00312: online log 55 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken54' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 55 of thread 1 ORA-00312: online log 55 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken54' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 56 of thread 1 ORA-00312: online log 56 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken55' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 56 of thread 1 ORA-00312: online log 56 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken55' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 57 of thread 1 ORA-00312: online log 57 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken56' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 57 of thread 1 ORA-00312: online log 57 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken56' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 58 of thread 1 ORA-00312: online log 58 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken57' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 58 of thread 1 ORA-00312: online log 58 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken57' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 59 of thread 1 ORA-00312: online log 59 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken58' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 59 of thread 1 ORA-00312: online log 59 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken58' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 60 of thread 1 ORA-00312: online log 60 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken59' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/sjjhdg/sjjh1/trace/sjjh1_lgwr_54343.trc: ORA-00313: open failed for members of log group 60 of thread 1 ORA-00312: online log 60 thread 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/broken59' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Completed: ALTER DATABASE MOUNT ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Mon Mar 02 08:35:50 2020 alter database open AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
查看主库的alert.log文件发现主库不能将日志同步到备库，原因是因为主备库之间网络故障
Mon Mar 02 01:17:22 2020 Thread 1 cannot allocate new log, sequence 3357 Private strand flush not complete Current log# 11 seq# 3356 mem# 0: /oradata/sjjh/redo11.log LGWR: Standby redo logfile selected for thread 1 sequence 3357 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3357 (LGWR switch) Current log# 12 seq# 3357 mem# 0: /oradata/sjjh/redo12.log Mon Mar 02 01:17:29 2020 Archived Log entry 6342 added for thread 1 sequence 3356 ID 0xfc687662 dest 1: Mon Mar 02 02:00:00 2020 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Mon Mar 02 02:33:30 2020 Thread 1 cannot allocate new log, sequence 3358 Private strand flush not complete Current log# 12 seq# 3357 mem# 0: /oradata/sjjh/redo12.log LGWR: Standby redo logfile selected for thread 1 sequence 3358 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3358 (LGWR switch) Current log# 13 seq# 3358 mem# 0: /oradata/sjjh/redo13.log Mon Mar 02 02:33:38 2020 Archived Log entry 6344 added for thread 1 sequence 3357 ID 0xfc687662 dest 1: Mon Mar 02 03:45:12 2020 Thread 1 cannot allocate new log, sequence 3359 Private strand flush not complete Current log# 13 seq# 3358 mem# 0: /oradata/sjjh/redo13.log LGWR: Standby redo logfile selected for thread 1 sequence 3359 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3359 (LGWR switch) Current log# 14 seq# 3359 mem# 0: /oradata/sjjh/redo14.log Mon Mar 02 03:45:19 2020 Archived Log entry 6346 added for thread 1 sequence 3358 ID 0xfc687662 dest 1: Mon Mar 02 08:24:54 2020 LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113) LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned Error 3113 for archive log file 14 to 'jhk_st' LGWR: Error 1041 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'jhk_st' Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED Thread 1 cannot allocate new log, sequence 3360 Private strand flush not complete Current log# 14 seq# 3359 mem# 0: /oradata/sjjh/redo14.log LGWR: Failed to archive log 14 thread 1 sequence 3359 (3113) Thread 1 advanced to log sequence 3360 (LGWR switch) Current log# 15 seq# 3360 mem# 0: /oradata/sjjh/redo15.log Mon Mar 02 08:25:01 2020 Archived Log entry 6347 added for thread 1 sequence 3359 ID 0xfc687662 dest 1: Mon Mar 02 08:30:31 2020 Thread 1 cannot allocate new log, sequence 3361 Private strand flush not complete Current log# 15 seq# 3360 mem# 0: /oradata/sjjh/redo15.log Mon Mar 02 08:30:52 2020 LGWR: Standby redo logfile selected for thread 1 sequence 3361 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3361 (LGWR switch) Current log# 16 seq# 3361 mem# 0: /oradata/sjjh/redo16.log Mon Mar 02 08:30:52 2020 Archived Log entry 6349 added for thread 1 sequence 3360 ID 0xfc687662 dest 1: Mon Mar 02 08:30:52 2020 ARC0: Standby redo logfile selected for thread 1 sequence 3360 for destination LOG_ARCHIVE_DEST_2 Mon Mar 02 08:54:23 2020 LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (272) LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned Error 272 for archive log file 16 to 'jhk_st' Mon Mar 02 08:55:04 2020 Thread 1 cannot allocate new log, sequence 3362 Private strand flush not complete Current log# 16 seq# 3361 mem# 0: /oradata/sjjh/redo16.log LGWR: Failed to archive log 16 thread 1 sequence 3361 (272) Thread 1 advanced to log sequence 3362 (LGWR switch) Current log# 17 seq# 3362 mem# 0: /oradata/sjjh/redo17.log Mon Mar 02 08:55:07 2020 Archived Log entry 6351 added for thread 1 sequence 3361 ID 0xfc687662 dest 1: Mon Mar 02 09:00:04 2020 ARC3: Standby redo logfile selected for thread 1 sequence 3361 for destination LOG_ARCHIVE_DEST_2 Mon Mar 02 09:00:04 2020 Thread 1 cannot allocate new log, sequence 3363 Private strand flush not complete Current log# 17 seq# 3362 mem# 0: /oradata/sjjh/redo17.log Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED LGWR: Standby redo logfile selected for thread 1 sequence 3363 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3363 (LGWR switch) Current log# 18 seq# 3363 mem# 0: /oradata/sjjh/redo18.log Mon Mar 02 09:00:08 2020 Archived Log entry 6353 added for thread 1 sequence 3362 ID 0xfc687662 dest 1: ARC3: Standby redo logfile selected for thread 1 sequence 3362 for destination LOG_ARCHIVE_DEST_2 Mon Mar 02 09:13:31 2020 LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113) LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned Error 3113 for archive log file 18 to 'jhk_st' LGWR: Error 1041 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'jhk_st' Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED Thread 1 cannot allocate new log, sequence 3364 Private strand flush not complete Current log# 18 seq# 3363 mem# 0: /oradata/sjjh/redo18.log LGWR: Failed to archive log 18 thread 1 sequence 3363 (3113) Thread 1 advanced to log sequence 3364 (LGWR switch) Current log# 19 seq# 3364 mem# 0: /oradata/sjjh/redo19.log Mon Mar 02 09:13:36 2020 Archived Log entry 6355 added for thread 1 sequence 3363 ID 0xfc687662 dest 1: Mon Mar 02 09:14:42 2020 ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*'; Mon Mar 02 09:14:43 2020 ARC3: Standby redo logfile selected for thread 1 sequence 3363 for destination LOG_ARCHIVE_DEST_2 Mon Mar 02 09:14:45 2020 Thread 1 cannot allocate new log, sequence 3365 Private strand flush not complete Current log# 19 seq# 3364 mem# 0: /oradata/sjjh/redo19.log Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED LGWR: Standby redo logfile selected for thread 1 sequence 3365 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3365 (LGWR switch) Current log# 20 seq# 3365 mem# 0: /oradata/sjjh/redo20.log Mon Mar 02 09:14:48 2020 Archived Log entry 6357 added for thread 1 sequence 3364 ID 0xfc687662 dest 1: Mon Mar 02 09:16:14 2020 LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (272) LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned Error 272 for archive log file 20 to 'jhk_st' Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED Thread 1 cannot allocate new log, sequence 3366 Private strand flush not complete Current log# 20 seq# 3365 mem# 0: /oradata/sjjh/redo20.log LGWR: Failed to archive log 20 thread 1 sequence 3365 (272) Thread 1 advanced to log sequence 3366 (LGWR switch) Current log# 21 seq# 3366 mem# 0: /oradata/sjjh/redo21.log Mon Mar 02 09:16:19 2020 Archived Log entry 6359 added for thread 1 sequence 3365 ID 0xfc687662 dest 1: Mon Mar 02 09:22:07 2020 Thread 1 cannot allocate new log, sequence 3367 Private strand flush not complete Current log# 21 seq# 3366 mem# 0: /oradata/sjjh/redo21.log Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED LGWR: Standby redo logfile selected for thread 1 sequence 3367 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3367 (LGWR switch) Current log# 22 seq# 3367 mem# 0: /oradata/sjjh/redo22.log Mon Mar 02 09:22:10 2020 Archived Log entry 6361 added for thread 1 sequence 3366 ID 0xfc687662 dest 1: Mon Mar 02 09:29:22 2020 LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113) LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned Error 3113 for archive log file 22 to 'jhk_st' LGWR: Error 1041 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'jhk_st' Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED Thread 1 cannot allocate new log, sequence 3368 Private strand flush not complete Current log# 22 seq# 3367 mem# 0: /oradata/sjjh/redo22.log LGWR: Failed to archive log 22 thread 1 sequence 3367 (3113) Thread 1 advanced to log sequence 3368 (LGWR switch) Current log# 23 seq# 3368 mem# 0: /oradata/sjjh/redo23.log Mon Mar 02 09:29:26 2020 Archived Log entry 6363 added for thread 1 sequence 3367 ID 0xfc687662 dest 1: Mon Mar 02 09:30:04 2020 ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*'; Mon Mar 02 09:30:05 2020 ARC3: Standby redo logfile selected for thread 1 sequence 3367 for destination LOG_ARCHIVE_DEST_2 Mon Mar 02 09:30:05 2020 Thread 1 cannot allocate new log, sequence 3369 Private strand flush not complete Current log# 23 seq# 3368 mem# 0: /oradata/sjjh/redo23.log Suppressing further error logging of LOG_ARCHIVE_DEST_2. FAL[server, ARC3]: FAL archive failed, see trace file. ARCH: FAL archive failed. Archiver continuing ORACLE Instance sjjh - Archival Error. Archiver continuing. Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED LGWR: Standby redo logfile selected for thread 1 sequence 3369 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3369 (LGWR switch) Current log# 24 seq# 3369 mem# 0: /oradata/sjjh/redo24.log Mon Mar 02 09:30:08 2020 Archived Log entry 6365 added for thread 1 sequence 3368 ID 0xfc687662 dest 1: ARC3: Standby redo logfile selected for thread 1 sequence 3368 for destination LOG_ARCHIVE_DEST_2 Mon Mar 02 09:31:27 2020 Suppressing further error logging of LOG_ARCHIVE_DEST_2. Suppressing further error logging of LOG_ARCHIVE_DEST_2. Suppressing further error logging of LOG_ARCHIVE_DEST_2. Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED Thread 1 cannot allocate new log, sequence 3370 Private strand flush not complete Current log# 24 seq# 3369 mem# 0: /oradata/sjjh/redo24.log LGWR: Failed to archive log 24 thread 1 sequence 3369 (272) Thread 1 advanced to log sequence 3370 (LGWR switch) Current log# 25 seq# 3370 mem# 0: /oradata/sjjh/redo25.log Mon Mar 02 09:31:33 2020 Archived Log entry 6367 added for thread 1 sequence 3369 ID 0xfc687662 dest 1: Mon Mar 02 09:37:09 2020 Thread 1 cannot allocate new log, sequence 3371 Private strand flush not complete Current log# 25 seq# 3370 mem# 0: /oradata/sjjh/redo25.log Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED LGWR: Standby redo logfile selected for thread 1 sequence 3371 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3371 (LGWR switch) Current log# 26 seq# 3371 mem# 0: /oradata/sjjh/redo26.log Mon Mar 02 09:37:12 2020 Archived Log entry 6369 added for thread 1 sequence 3370 ID 0xfc687662 dest 1: Mon Mar 02 09:37:12 2020 ARC3: Standby redo logfile selected for thread 1 sequence 3370 for destination LOG_ARCHIVE_DEST_2 Mon Mar 02 09:42:26 2020 Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED Thread 1 cannot allocate new log, sequence 3372 Private strand flush not complete Current log# 26 seq# 3371 mem# 0: /oradata/sjjh/redo26.log LGWR: Failed to archive log 26 thread 1 sequence 3371 (3113) Thread 1 advanced to log sequence 3372 (LGWR switch) Current log# 27 seq# 3372 mem# 0: /oradata/sjjh/redo27.log Mon Mar 02 09:42:31 2020 Archived Log entry 6371 added for thread 1 sequence 3371 ID 0xfc687662 dest 1: Mon Mar 02 09:44:23 2020 ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*'; Mon Mar 02 09:44:23 2020 ARC0: Standby redo logfile selected for thread 1 sequence 3371 for destination LOG_ARCHIVE_DEST_2 Mon Mar 02 09:44:25 2020 Thread 1 cannot allocate new log, sequence 3373 Private strand flush not complete Current log# 27 seq# 3372 mem# 0: /oradata/sjjh/redo27.log Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED LGWR: Standby redo logfile selected for thread 1 sequence 3373 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3373 (LGWR switch) Current log# 28 seq# 3373 mem# 0: /oradata/sjjh/redo28.log Mon Mar 02 09:44:28 2020 Archived Log entry 6373 added for thread 1 sequence 3372 ID 0xfc687662 dest 1: Mon Mar 02 09:44:28 2020 ARC3: Standby redo logfile selected for thread 1 sequence 3372 for destination LOG_ARCHIVE_DEST_2 Mon Mar 02 09:45:34 2020 Thread 1 cannot allocate new log, sequence 3374 Private strand flush not complete Current log# 28 seq# 3373 mem# 0: /oradata/sjjh/redo28.log LGWR: Standby redo logfile selected for thread 1 sequence 3374 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3374 (LGWR switch) Current log# 29 seq# 3374 mem# 0: /oradata/sjjh/redo29.log Mon Mar 02 09:45:35 2020 Archived Log entry 6376 added for thread 1 sequence 3373 ID 0xfc687662 dest 1: Mon Mar 02 13:45:51 2020 LGWR: Standby redo logfile selected for thread 1 sequence 3375 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3375 (LGWR switch) Current log# 30 seq# 3375 mem# 0: /oradata/sjjh/redo30.log Mon Mar 02 13:45:55 2020 Archived Log entry 6378 added for thread 1 sequence 3374 ID 0xfc687662 dest 1: Mon Mar 02 13:47:12 2020 Thread 1 cannot allocate new log, sequence 3376 Private strand flush not complete Current log# 30 seq# 3375 mem# 0: /oradata/sjjh/redo30.log Destination LOG_ARCHIVE_DEST_2 no longer supports SYNCHRONIZATION Thread 1 advanced to log sequence 3376 (LGWR switch) Current log# 1 seq# 3376 mem# 0: /oradata/sjjh/redo01.log Mon Mar 02 13:47:19 2020 Archived Log entry 6380 added for thread 1 sequence 3375 ID 0xfc687662 dest 1: Mon Mar 02 22:00:00 2020 Setting Resource Manager plan SCHEDULER[0x32D9]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Mon Mar 02 22:00:00 2020 Starting background process VKRM Mon Mar 02 22:00:00 2020 VKRM started with pid=47, OS id=81983 Mon Mar 02 22:00:02 2020 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Mon Mar 02 22:01:00 2020 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Mar 03 00:38:04 2020 Thread 1 cannot allocate new log, sequence 3377 Private strand flush not complete Current log# 1 seq# 3376 mem# 0: /oradata/sjjh/redo01.log Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED LGWR: Standby redo logfile selected for thread 1 sequence 3377 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3377 (LGWR switch) Current log# 2 seq# 3377 mem# 0: /oradata/sjjh/redo02.log Tue Mar 03 00:38:12 2020 Archived Log entry 6382 added for thread 1 sequence 3376 ID 0xfc687662 dest 1: Tue Mar 03 00:40:10 2020 LGWR: Standby redo logfile selected for thread 1 sequence 3378 for destination LOG_ARCHIVE_DEST_2 Thread 1 advanced to log sequence 3378 (LGWR switch) Current log# 3 seq# 3378 mem# 0: /oradata/sjjh/redo03.log
明白原因之后现在可以删除dbs目录中的broker*文件来释放空间