MyException - 我的异常网
当前位置:我的异常网» Linux/Unix » linux上oracle重建spfileorcl.ora

linux上oracle重建spfileorcl.ora

www.MyException.Cn  网友分享于:2013-02-21  浏览:135次
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 ~]$

文章评论

软件开发程序错误异常ExceptionCopyright © 2009-2015 MyException 版权所有