系统环境: Oracle 11G R2 RAC
RAC事件:修改Oracle RAC 归档日志路径参数,导致数据库实例无法正常启动
错误提示:ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
处理方法:
1、复制数据库初始化文件参数文件init.ora.8172011185713至其他目录
2、重命名init.ora.8172011185713 为init.ora,并修改该文件操作系统下的所属组及权限
3、以spfile方式加载init.ora启动数据库
SQL>startup mount pfile='/oraclefs/app/oracle/admin/future/pfile/init.ora';
4、打开数据库
SQL>alter database open;
5、创建数据库实例的spfile文件
SQL>create spfile from pfile='/oraclefs/app/oracle/admin/future/pfile/init.ora';
6、重启数据库实例,问题解决.
操作日志记录如下:
[root@node2 oraclefs]# cd /oraclefs/app/oracle/admin/future/pfile/
[root@node2 pfile]# ls
init.ora.8172011185713
[root@node2 pfile]# cp init.ora.8172011185713 /oraclefs/
[root@node2 pfile]# cd /oraclefs/
[root@node2 oraclefs]# ls
app init.ora.8172011185713
[root@node2 oraclefs]# mv init.ora.8172011185713 init.ora
[root@node2 oraclefs]# ls
app init.ora
[root@node2 oraclefs]# ll
total 8
drwxr-xr-x 6 root oinstall 4096 Sep 17 14:14 app
-rw-r----- 1 root root 2476 Nov 8 19:51 init.ora
[root@node2 oraclefs]# chown oracle:oinstall init.ora
[root@node2 oraclefs]# ll
total 8
drwxr-xr-x 6 root oinstall 4096 Sep 17 14:14 app
-rw-r----- 1 oracle oinstall 2476 Nov 8 19:51 init.ora
[oracle@node2 oraclefs]$ cp init.ora /oraclefs/app/oracle/admin/future/pfile/
[oracle@node2 pfile]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Tue Nov 8 19:52:43 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount pfile='/oraclefs/app/oracle/admin/future/pfile/init.ora';
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2213776 bytes
Variable Size 469764208 bytes
Database Buffers 1124073472 bytes
Redo Buffers 7360512 bytes
Database mounted.
SQL> alter database open;
Database altered.
SQL> create spfile from pfile='/oraclefs/app/oracle/admin/future/pfile/init.ora';
File created.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2213776 bytes
Variable Size 469764208 bytes
Database Buffers 1124073472 bytes
Redo Buffers 7360512 bytes
Database mounted.
Database opened.