验证11gR2 RAC中ocr中的spfile信息置空之后的初始化参数读取位置

来源：互联网发布：华纳网络商店编辑：程序博客网时间：2024/04/26 10:18

环境：GI 11.2.0.3; DB 11.2.0.3

ocr中的spfile信息置空：

[oracle@ectonb dbs]$ srvctl modify database -d ecton -p ''[oracle@ectonb dbs]$ srvctl config database -d ectonDatabase unique name: ectonDatabase name: ectonOracle home: /u02/app/oracle/product/11.2.0/dbhome_1Oracle user: oracleSpfile: Domain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: ectonDatabase instances: ecton1,ecton2Disk Groups: DATAFILE,FRAMount point paths: Services: abcd,ectonxaType: RACDatabase is administrator managed[oracle@ectonb dbs]$

重启主机：init6

检查数据库实例的alert日志：

SYS auditing is disabledStarting up:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing options.ORACLE_HOME = /u02/app/oracle/product/11.2.0/dbhome_1System name:    LinuxNode name:      ectonbRelease:        2.6.32-431.el6.x86_64Version:        #1 SMP Sun Nov 10 22:19:54 EST 2013Machine:        x86_64Using parameter settings in server-side pfile /u02/app/oracle/product/11.2.0/dbhome_1/dbs/initecton2.ora --->>>注意此处.System parameters with non-default values:  processes                = 300  sessions                 = 472  spfile                   = "+DATAFILE/ecton/spfileecton.ora"  sga_target               = 864M  control_files            = "+DATAFILE/ecton/controlfile/current.260.894471947"  control_files            = "+FRA/ecton/controlfile/current.256.894471947"下略

/u02/app/oracle/product/11.2.0/dbhome_1/dbs/initecton2.ora 的内容：

[grid@ectonb ~]$ cat /u02/app/oracle/product/11.2.0/dbhome_1/dbs/initecton2.ora SPFILE='+DATAFILE/ecton/spfileecton.ora'[grid@ectonb ~]$

0 0