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] ~]$