ITPub博客

首页 > 数据库 > Oracle > spfile 丢失重建

spfile 丢失重建

原创 Oracle 作者:diyindo 时间:2016-01-20 19:43:45 0 删除 编辑
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/app1/oracle/product/11.2.0.1.0/db_1/dbs/initorcl.ora'
SQL> startup pfile='/app1/oracle/admin/orcl/pfile/init.ora.9172012113220';
SQL> startup
ORACLE instance started.
Total System Global Area 3423965184 bytes
Fixed Size    2218152 bytes
Variable Size 1862272856 bytes
Database Buffers 1543503872 bytes
Redo Buffers   15970304 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile='/app1/oracle/admin/orcl/pfile/init.ora.9172012113220';
File created.
停库
SQL> startup
ORACLE instance started.
Total System Global Area 3423965184 bytes
Fixed Size    2218152 bytes
Variable Size 1862272856 bytes
Database Buffers 1543503872 bytes
Redo Buffers   15970304 bytes
Database mounted.
Database opened.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24974673/viewspace-1979785/,如需转载,请注明出处,否则将追究法律责任。

下一篇: rman恢复控制文件
请登录后发表评论 登录
全部评论

注册时间:2011-11-17

  • 博文量
    6
  • 访问量
    8912