solution:
the first step: look at the journal CD $ORACLE_BASE/diag/RDBMS/zdzrac/zdzrac1/trace; Tail – 200 alert_zdzrac1. The log
note: 200 represents the display of 200 lines
CTL ‘,’/ disk2/ control01.ctl’, ‘/disk3/control03.ctl’,’/disk3/control03.ctl’ scope=spfile; Causes the control file path to change
step 3: find the path of the original control file on another normal node
SQL> select status,name from v$controlfile;
the STATUS of the NAME
——————————————————————————–
+ DATA/zdzrac controlfile/current. 256.947408805
step 4: modify the control file path in the spfilec parameter file to solve the problem
oracle# create pfile = ‘/ u01/app/oracle/product/11.2.0.4/dbhome_1/DBS/init0714 ora’ from spfile = ‘/ u01/app/oracle/product/11.2.0.4/dbhome_1/DBS/spfilezdzrac1 ora’;
oracle# vi/u01/app/oracle/product/11.2.0.4/dbhome_1/DBS/init0714 ora
zdzrac2.__db_cache_size=2801795072
zdzrac1.__db_cache_size=2801795072
zdzrac2.__java_pool_size=16777216
zdzrac1.__java_pool_size=16777216
zdzrac2.__large_pool_size=33554432
zdzrac1.__large_pool_size=33554432
zdzrac1.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from environment
zdzrac2.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from environment
zdzrac2.__pga_aggregate_target=838860800
zdzrac1.__pga_aggregate_target=838860800
zdzrac2.__sga_target=3539992576
zdzrac1.__sga_target=3539992576
zdzrac2.__shared_io_pool_size=0
zdzrac1.__shared_io_pool_size=0
zdzrac2.__shared_pool_size=654311424
zdzrac1.__shared_pool_size=654311424
zdzrac2.__streams_pool_size=0
zdzrac1.__streams_pool_size=0
*.audit_file_dest=’/u01/app/oracle/admin/zdzrac/adump’
*.audit_trail=’db’
*.cluster_database=true
*. Compatible = ‘11.2.0.4.0’
*. Control_files = ‘+ DATA/zdzrac controlfile/current 256.947408805’// change control file path
*.db_block_size=8192
*.db_create_file_dest=’+DATA’
*.db_domain=”
“/ u01/app/oracle/product/11.2.0.4/dbhome_1/DBS/init0714 ora” 44 l, 1489 c
step 5: restart the database using the pfile file
startup pfile = ‘/ u01/app/oracle/product/11.2.0.4/dbhome_1/DBS/init0711 ora’;
step 6: create the spfile file with the modified pfile
SQL> The create spfile from pfile = ‘/ u01/app/oracle/product/11.2.0.4/dbhome_1/DBS/init0714 ora’ ‘;
step 7: close the database and start the database
SQL> shutdown immediate
SQL> startup