rac oracle 11g spfile参数文件损坏,导致数据库节点10.8.25.240起不来,且无法关闭与连接
原因是:恢复db_recovery_file_dest_size默认值0 操作导致,参数文件内容如下
*.SPFILE='+DATA/zdzrac/spfilezdzrac.ora'
解决办法:
在节点10.8.25.239,create pfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0711.ora' from spfile='+DATA/zdzrac/spfilezdzrac.ora';
vi /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0711.ora 复制所有内容
在节点10.8.25.240,vi init0711.ora 粘贴刚刚复制的内容
SQL> startup pfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0711.ora';
SQL>shutdown immediate
SQL>startup
SQL>create spfile from pfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0711.ora';
SQL>shutdown immediate
SQL>startup
注释:如果将节点10.8.25.239与10.8.25.240的db_recovery_file_dest_size值都由4g改为0,发现节点10.8.25.240数据库起不来,报错如下
Total System Global Area 3524177920 bytes
Fixed Size 2258280 bytes
Variable Size 1275071128 bytes
Database Buffers 2231369728 bytes
Redo Buffers 15478784 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch
处理办法是:将参数文件pfile 中的*.db_recovery_file_dest_size=4注释掉,如#*.db_recovery_file_dest_size=4
原因是:恢复db_recovery_file_dest_size默认值0 操作导致,参数文件内容如下
*.SPFILE='+DATA/zdzrac/spfilezdzrac.ora'
解决办法:
在节点10.8.25.239,create pfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0711.ora' from spfile='+DATA/zdzrac/spfilezdzrac.ora';
vi /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0711.ora 复制所有内容
在节点10.8.25.240,vi init0711.ora 粘贴刚刚复制的内容
SQL> startup pfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0711.ora';
SQL>shutdown immediate
SQL>startup
SQL>create spfile from pfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0711.ora';
SQL>shutdown immediate
SQL>startup
注释:如果将节点10.8.25.239与10.8.25.240的db_recovery_file_dest_size值都由4g改为0,发现节点10.8.25.240数据库起不来,报错如下
Total System Global Area 3524177920 bytes
Fixed Size 2258280 bytes
Variable Size 1275071128 bytes
Database Buffers 2231369728 bytes
Redo Buffers 15478784 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch
处理办法是:将参数文件pfile 中的*.db_recovery_file_dest_size=4注释掉,如#*.db_recovery_file_dest_size=4