如何让数据库使用spfile启动

2024-07-21 02:39:33

字体：大中小

来源：转载

供稿：网友

从pfile创建spfile的方法SQL> show parameter spfile NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               stringSQL> create spfile from pfile='?/dbs/initsid.ora'   SQL> shutdown
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup
ORACLE instance started.Total System Global Area 236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
SQL> show parameter spfileNAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      ?/dbs/spfile@.ora

上一篇：unix----hp-ux ,trusted system 察看及convert

下一篇：怎么样快速复制表或者是插入数据