日期:2014-05-16  浏览次数:20886 次

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

?

[oracle@dev ~]$ 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
[oracle@dev ~]$