Second RAC instance fails to start with error ORA-1102
背景:
使用备份软件进行的Oracle 恢复, instance_name,db_unique_name,service_names 可以与源库一致, db_name 保持一致即可。
在使用svrctl start database -d db_unique_name 时报ora-1102错。
按照RAC: Second Instance Fails to Start With Error ORA-1102 (Doc ID 1579765.1) 解决报错。
- srvctl start output
srvctl start database -d <DB_NAME> -o mount
PRCR-1079 : Failed to start resource ora.<DB_NAME>.db
CRS-5017: The resource action "ora.<DB_NAME>.db start" encountered the following error:
ORA-01102: cannot mount database in EXCLUSIVE mode
. For details refer to "(:CLSN00107:)" in "<GRID_HOME>/log/<HOSTNAME>/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.<DB_NAME>.db' on '<HOSTNAME>' failed
- sqlplus startup output
Connected to an idle instance.
SQL> startup mount
ORA-01102: cannot mount database in EXCLUSIVE mode
解决方案:
Connect to a running instance and issue the following commands:
SQL> alter system set cluster_database=TRUE scope=spfile sid='*';
SQL> alter system set cluster_database_instances=<n> scope=spfile sid='*';
where '<n>' is the actual number of instances.




