ORACLE pfile spfile位置
从spfile获取pfile Create pfile='d:pfileSID.ora' from spfile;Create pfile='d:pfileSID.ora' from spfile='spfile_location';
从pfile获取spfile
Create spfile from pfile='Your_pfile_location'
Create spfile='spfile_location' from pfile='Your_pfile_location'
动态修改参数
> Startup nomount的时候需要读去spfile或pfile,两者共存，spfile优先
强制用pfile启动
SQL>startup pfile='Your_Pfile.ora'
startup spfile='/data/oracle/product/10.2.0/db_1/dbs/dbs/spfile_mqq.ora' force
页:
[1]