原帖由 ward 于 2008-1-4 14:18 发表
再问一下,spfile是在nomount状态就应用了吗?
是的 ,你可以测试下
在nomount 下
[php]
C:\Documents and Settings\Paul Yi>sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 4 14:22:46 2008
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 97590928 bytes
Fixed Size
454288 bytes
Variable Size
75497472 bytes
Database Buffers 20971520 bytes
Redo Buffers
667648 bytes
SQL> show parameter log;
NAME
TYPE
------------------------------------ ----------------------
VALUE
------------------------------
db_create_online_log_dest_1
string
[/php]