参考文档Oracle 11g初始化参数文件修复
本篇文章来源于 Linux公社网站(www.linuxidc.com) 原文链接:http://www.linuxidc.com/Linux/2012-12/77134.htm
log_archive_dest 归档路径修后,
SQL> startup mount;
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
问题解决过程
由于我的数据库是安装在ASM磁盘组上
需要执行create pfile='/tmp/init.ora' from spfile='+DATA/gfovdb/spfilegfovdb.ora'
意思就是说,将spfile文件导出到/tmp/init.ora文件中,
vi /tmp/init.ora
*.audit_file_dest='/home/u01/app/oracle/admin/gfovdb/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='+DATA/gfovdb/controlfile/current.261.812733855','+DATA/gfovdb/controlfile/current.260.812733855'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='gfovdb'
*.db_recovery_file_dest='+DATA'
*.db_recovery_file_dest_size=4070572032
*.diagnostic_dest='/home/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=gfovdbXDB)'
gfovdb.log_archive_dest_1='LOCATION=+arch/arch001' 修改这行,可通过ASMCMD> pwd ,+ data/gfovdb/spfilegfovdb.ora'查归档路径
#gfovdb.log_archive_dest='+data' 注释掉这行
*.memory_target=6665797632
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
[root@dbserver1 tmp]#
接下来还原spfile文件,执行
create spfile=+DATA/gfovdb/spfilegfovdb.ora' from pfile='/tmp/init.ora' 注意这句跟上面的区别,
然后重新启动数据库。
SQL> startup
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2213896 bytes
Variable Size 1006635000 bytes
Database Buffers 637534208 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.