SQL> show parameter backup
NAME TYPE VALUE
------------------------------------ ----------- ---------------------
backup_tape_io_slaves boolean TRUE
pfile中加
*.spfile='E:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE\SPFILEORCL.ORA' 也可以启动其它spfile名字
SQL> startup pfile='E:\oracle\product\10.1.0\Db_1\database\INITorcl.ora';
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 788068 bytes
Variable Size 145488284 bytes
Database Buffers 41943040 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string E:\ORACLE\PRODUCT\10.1.0\DB_1\
DATABASE\SPFILEORCL.ORA
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/12020513/viewspace-611521/ ,如需转载,请注明出处,否则将追究法律责任。