昨天 JCDMS 数据库结点1 报 ora-600 错误
今天对 jcdms1 进行启库的时候报了
ORA-01678: parameter log_file_name_convert must be pairs of pattern and replacement strings
无论是 sqlplus 还是 srvctl start instance -d JCDMS -i jcdms1 均报相同错误
进行尝试:
在其它结点 alter system set log_file_name_convert='' scope=both sid='*';
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2.6724E+10 bytes
Fixed Size 2241016 bytes
Variable Size 5502930440 bytes
Database Buffers 2.1072E+10 bytes
Redo Buffers 146341888 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 91356
Session ID: 1514 Serial number: 9
再次启动报上面错误
使用 create pfile='/u01/app/oracle/jcdms0419.ora' from spfile='+DATA_DM02/jcdms/spfilejcdms.ora';
并修改参数 将 log_file_name_convert 参数置空,在故障结点启动
错误依旧
尝试2:
在其它结点执行
alter system reset LOG_ARCHIVE_CONFIG scope=both sid='*';
后故障依旧
尝试3:
alter system set LOG_ARCHIVE_CONFIG=NODG_CONFIG scope=both sid='*';
在故障结点启动,故障恢复
今天对 jcdms1 进行启库的时候报了
ORA-01678: parameter log_file_name_convert must be pairs of pattern and replacement strings
无论是 sqlplus 还是 srvctl start instance -d JCDMS -i jcdms1 均报相同错误
进行尝试:
在其它结点 alter system set log_file_name_convert='' scope=both sid='*';
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2.6724E+10 bytes
Fixed Size 2241016 bytes
Variable Size 5502930440 bytes
Database Buffers 2.1072E+10 bytes
Redo Buffers 146341888 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 91356
Session ID: 1514 Serial number: 9
再次启动报上面错误
使用 create pfile='/u01/app/oracle/jcdms0419.ora' from spfile='+DATA_DM02/jcdms/spfilejcdms.ora';
并修改参数 将 log_file_name_convert 参数置空,在故障结点启动
错误依旧
尝试2:
在其它结点执行
alter system reset LOG_ARCHIVE_CONFIG scope=both sid='*';
后故障依旧
尝试3:
alter system set LOG_ARCHIVE_CONFIG=NODG_CONFIG scope=both sid='*';
在故障结点启动,故障恢复
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7569309/viewspace-2137588/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7569309/viewspace-2137588/