spfile 丢失重建

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24974673/viewspace-1979785/