使用ACTIVATE 命令想强制拉成主库,很遗憾如下图报错 ORA-00349。alert 日志中发现有很多清理 redo log 的报错,“ORA-00313: open failed…”无法打开日志组 5、6、23,于是查看日志组成员确实发现 redolog 创建的有问题,member 成员显示的为不存在的磁盘组 “+JIEKE_DATA” 而不是具体路径,真是存在的磁盘组“+...
ORA-00313openfailedformembersorloggroup1ofthread1 ORA-00312online log1thread1:+DATA DG/FTPDMX01/ONLINELOG/group_1.577.1050100085 ORA-17503:ksfdopn:2Failedtoopenfile+DATA DG/MX01/ONLINELOG/group_1.577.1050100085 ORA-15012:ASM file +DATA DG/MX01/ONLINELOG/group1.577.1050100085' does not exist ...
OPEN ORA-600 6711 open ora-8103 OpenSSH ora redo异常 ORA-00081 ORA-00206 ORA-00202 ORA-15081 ORA-00227 ORA-00227 ORA-00202 ORA-00257 ORA-00279 ORA-00289 ORA-00280 ORA-00283 ORA-00742 ORA-00283 ORA-01122 ORA-00283 ORA-16433 ORA-00313 ORA-00312 ...
sql statement: alter system set db_file_name_convert = ''/oradata/fpyj/datafile'', ''/u01/oradata/fpyjbak/datafile/'' comment= ''' scope=spfile sql statement: alter system set LOG_FILE_NAME_CONVERT = ''/oradata/fpyj/logfile'', ''/u01/oradata/fpyjbak/logfile'' comment= ''' sco...
5713 oracle 18 0 150g 20m 17m S 5.3 0.0 410:01.33 ora_asmb_q9db1 5821 oracle 15 0 150g 23m 17m S 5.3 0.0 4883:29 ora_lck0_q9db1 7596 oracle 15 0 150g 69m 37m S 5.3 0.0 5368:28 ora_pr00_q9db1 [oracle@q9adg02 ~]$ top -c ...