Oracle Database:以指定的SPFILE启动实例
说明:
文件 –
pfile:pfile_ecard.ora
spfile:ecard_1.ora
只需要如下设置即可:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
[oracle@oracle10g ~]$ pwd /home/oracle [oracle@oracle10g ~]$ [oracle@oracle10g ~]$ ls -ltr *.ora -rw-r--r-- 1 oracle oinstall 34 Apr 13 16:57 pfile_ecard.ora -rw-r----- 1 oracle oinstall 2560 Apr 13 17:22 ecard_1.ora [oracle@oracle10g ~]$ [oracle@oracle10g ~]$ file ecard_1.ora ecard_1.ora: data [oracle@oracle10g ~]$ [oracle@oracle10g ~]$ cat pfile_ecard.ora spfile='/home/oracle/ecard_1.ora' [oracle@oracle10g ~]$ [oracle@oracle10g ~]$ |
SQL*Plus:
1 2 3 4 5 6 7 8 9 10 11 12 |
SQL> startup pfile='/home/oracle/pfile_ecard.ora'; ORACLE instance started. Total System Global Area 171966464 bytes Fixed Size 2094736 bytes Variable Size 150997360 bytes Database Buffers 16777216 bytes Redo Buffers 2097152 bytes Database mounted. Database opened. SQL> |
——————————————————
Done。