手机版
你好,游客 登录 注册 搜索
背景:
阅读新闻

RAC环境启动数据库时报错:ORA-01105,ORA-19808 解决方法

[日期:2020-04-21] 来源:blog.51cto.com  作者:20130529 [字体: ]

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 redhat3920
CRS-5017: The resource action "ora.ylao.db start" encountered the following error:
ORA-01105: mount is incompatible with mounts by other instances
ORA-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 string
db_recovery_file_dest_size big integer 4000G
db_unrecoverable_scn_tracking boolean TRUE
recovery_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 string
db_recovery_file_dest_size big integer 200G
db_unrecoverable_scn_tracking boolean TRUE
recovery_parallelism integer 0

[oracle@redhat3919 ~]$ oerr ora 19808
19808, 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 01105
01105, 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.linuxidc.com/topicnews.aspx?tid=12

Linux公社的RSS地址https://www.linuxidc.com/rssFeed.aspx

本文永久更新链接地址https://www.linuxidc.com/Linux/2020-04/162975.htm

linux
相关资讯       ORA-01105  ORA-19808 
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款