linux下oracle重建spfileorcl.ora

数据库默认用spfile启动，可以指定用pfile启动，再创建spfile，不启动也可以用pfile创建spfile

pfile在/u01/app/oracle/admin/orcl/pfile/init.ora.115201373031，你也有，结尾数据会不同，

创建好的spfile在/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora (spfile+SID)

参考：http://happyqing.iteye.com/admin/blogs/1801069

[[email protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Feb 17 00:56:46 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup pfile='/u01/app/oracle/admin/orcl/pfile/init.ora.115201373031

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size                  2235208 bytes

Variable Size             616563896 bytes

Database Buffers          444596224 bytes

Redo Buffers                5541888 bytes

Database mounted.

Database opened.

SQL> create spfile from pfile='/u01/app/oracle/admin/orcl/pfile/init.ora.115201373031';   

File created.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size                  2235208 bytes

Variable Size             616563896 bytes

Database Buffers          444596224 bytes

Redo Buffers                5541888 bytes

Database mounted.

Database opened.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[[email protected] ~]$