2009年5月17日星期日

oracle 11g 中 可以使用 create spfile from memory

fail-tolerant of Oracle 11g

實驗如下:
[oracle@croracle01 ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.1.0.6.0 - Production on Mon May 18 18:09:12 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL>
SQL>
SQL> create spfile='/tmp/spfile.ora' from memory;

File created.

SQL> create pfile='/tmp/initcroracle.ora' from memory;

File created.

SQL>!

[oracle@croracle01 tmp]$ ll *.ora
-rw-r--r-- 1 oracle oinstall 5996 May 18 18:09 initcroracle.ora
-rw-r----- 1 oracle oinstall 13824 May 18 18:09 spfile.ora

參考文檔:http://www.eygle.com/archives/2007/08/11gspfile_fault_tolerant.html

没有评论:

发表评论