RAC环境启动数据库时报错：ORA-01105，ORA-19808 解决方法 [Oracle@RedHat3919 dbs]$ srvctl start instance -d ylao -i ylao2 PRCR-1013 : Failed to start resource ora.ylao.db PRCR-1064 : Failed to start resource ora.ylao.db on node
RAC环境启动数据库时报错：ORA-01105，ORA-19808 解决方法
[Oracle@RedHat3919 dbs]$ srvctl start instance -d ylao -i ylao2PRCR-1013 : Failed to start resource ora.ylao.dbPRCR-1064 : Failed to start resource ora.ylao.db on node redhat3920CRS-5017: The resource action "ora.ylao.db start" encountered the following error: ORA-01105: mount is incompatible with mounts by other instancesORA-19808: recovery destination parameter mismatch. For details refer to "(:CLSN00107:)" in "/oracle/app/grid/grid_home/log/redhat3920/agent/crsd/oraagent_oracle//oraagent_oracle.log".
CRS-2674: Start of 'ora.ylao.db' on 'redhat3920' failed
SQL> show parameter recover
NAME TYPE VALUE
db_recovery_file_dest stringdb_recovery_file_dest_size big integer 4000Gdb_unrecoverable_scn_tracking boolean TRUErecovery_parallelism integer 0
SQL> create pfile='/home/oracle/initylao0720.ora' from spfile;
File created.
SQL> alter system set db_recovery_file_dest_size=200G scope=both;
System altered.
[oracle@redhat3919 ~]$ srvctl start instance -d ylao -i ylao2
SQL> show parameter recover
NAME TYPE VALUE
db_recovery_file_dest stringdb_recovery_file_dest_size big integer 200Gdb_unrecoverable_scn_tracking boolean TRUErecovery_parallelism integer 0
[oracle@redhat3919 ~]$ oerr ora 1980819808, 00000, "recovery destination parameter mismatch"// Cause: The value of parameters DB_RECOVERY_FILE_DEST and// DB_RECOVERY_FILE_DEST_SIZE must be same in all instances.// instance. All databases must have same recovery destination// parameters.// Action: Check DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE// values in all instances.[oracle@redhat3919 ~]$ oerr ora 0110501105, 00000, "mount is incompatible with mounts by other instances"// Cause: An attempt to mount the database discovered that another instance// mounted a database by the same name, but the mount is not// compatible. Additional errors are reported explaining why.// Action: See accompanying errors.[oracle@redhat3919 ~]$
更多Oracle相关信息见Oracle 专题页面 https://www.558idc.com/topicnews.aspx?tid=12
