ORA-10458,ORA-01196,ORA-01110处理

最新推荐文章于 2022-01-24 14:15:49 发布

转载

最新推荐文章于 2022-01-24 14:15:49 发布 · 990 阅读

文章标签：

#运维 #数据库

本文介绍了如何处理Oracle数据库中出现的三个常见错误：ORA-10458, ORA-01196和ORA-01110。内容来源于ITPUB博客，详细分析了这些错误的原因和解决方案。" 51620514,5658210,嵌入式操作系统资源管理：临界区、调度器锁定与信号量,"['嵌入式', '操作系统', '内核', 'os', 'uCOSIII']

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

事情起因:是因为主备dg机器要换新位置,运维直接关机搬服务器修改ip地址,系统起来后,备库启动报错.
ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '/u01/app/oracle/oradata/rong/system01.dbf'

原因:日志的scn跟控制文件不一致导致

处理步骤:
1:分别修改tns里对应主备的ip地址为新地址
2:主库可以正常启动,备库启动到mount状态,启动监听,tnsping测试互通
3:备库启用日志应用
alter database recover managed standby database disconnect from session;

alert日志有如下应用日志的提示
Attempt to start background Managed Standby Recovery process (rong)
Tue Mar 01 15:14:56 2016
MRP0 started with pid=26, OS id=3933
MRP0: Background Managed Standby Recovery process started (rong)
started logmerger process
Tue Mar 01 15:15:01 2016
Managed Standby Recovery not using Real Time Apply
Parallel Media Recovery started with 24 slaves
Waiting for all non-current

最低0.47元/天解锁文章

200万优质内容无限畅学

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

cuixiaohui5019

关注关注

1
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

ORA-10458 ORA-01196 ORA-01110

weixin_34319111的博客

06-15

762

2019独角兽企业重金招聘Python工程师标准>>> ...

ORA-10458、ORA-01196和ORA-01110错误解决办法

weixin_34038293的博客

02-25

2176

oracle DG 备库启动报错如下SQL> startupORACLE instance started. Total System Global Area 1.0689E+11 bytesFixed Size 2265864 bytesVariable Size 1.2885E+10 bytesDatabase Buffers 9.3952E+10...

参与评论您还未登录，请先登录后发表或查看评论

ORA-10458 ORA-01196 ORA-01110 处理

kadwf123的专栏

05-23

2898

今天有个dataguard库，启动备库的时候报错： ERROR at line 1: ORA-10458: standby database requires recovery ORA-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: data file 1: '/oradata/prov/system01.dbf' 原因:日志的scn跟控制文件不一致导致 1、主库可以正常起来，并正常启动主库

ora-10458，ora-01196，ora-01110

袁子建

06-22

776

SQL> startup ORACLE instance started. Total System Global Area 1644167168 bytes Fixed Size 2925024 bytes Variable Size 1073745440 bytes Database Buffers 553648128 bytes Redo Buffers 13848576 bytes Database mounted. ORA-10458: standby data.

重庆思庄IT技术分享-ORA-10458、ORA-01196、ORA-01110异常处理

duanweifang的博客

01-24

730

主备数据库版本：oracle 11.2.0.4 问题描述：主备库都开启的状态单独重启备库出现以下异常 SQL> startup ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size 2257520 bytes Variable Size 1811942800 bytes Database Buffers 1375731712 bytes

数据库报：ORA-01196(ORA-10458/ORA-01110)错误的解决方法

09-09

主要给大家介绍了关于数据库报：ORA-01196(ORA-10458/ORA-01110)错误的解决方法，文中通过示例代码介绍的非常详细，对大家学习或者使用数据库具有一定的参考学习价值，需要的朋友们下面来一起学习学习吧

ORA-10458 ORA-01196故障处理

glogin

07-02

5802

ORA-10458 ORA-01196 机房搬迁，测试环境直接关机，再次开机导致standby库报错如下：操作系统均为centos6.5，是基于11.2.0.4的RAC TO DG 官方文档给出的解释: ORA-10458: standby database requires recovery Cause: A standby database was in a state requirin...

oracle ora 01152,standby database ope时，提示ORA-10458: ORA-01152: ORA-01110:

weixin_32656511的博客

04-10

1631

在配置完standby database，完成数据库同步时，将standby database切换到open状态时，提示下面的的错误SQL> select open_mode from v$database;OPEN_MODE--------------------MOUNTEDSQL> alter database open;alter database open*ERROR at ...

oracle ora1019,ORACLE 11G 配置DG 报ORA-10458、ORA-01152、ORA-01110

weixin_36282765的博客

04-05

1033

操作系统:Oracle Linux Server release 5.7数据库版本：Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 -64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE11.2.0.3.0ProductionTNS for Linux: Vers...

dataguard-(ORA-16004/ORA-01196/ORA-01110)

冰刀(skate)

08-01

8266

author：skatetime： 2009/08/01 1. 故障现象：一次突然断电导致我的standby，open时报如下的错误： ORA-16004: 备份数据库需要恢复ORA-01196: 文件 1 由于介质恢复会话失败而不一致ORA-01110: 数据文件 1: D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCLDG/SYSTEM01.

数据库ORA-01196故障-归档日志丢失恢复详解

12-16

问题：由于机房停电，其中一DG备库无法open，启动时报错启动数据库时报下面的错误 SQL> alter database open; alter database open * 第 1 行出现错误: ORA-10458: standby database requiresrecovery ORA-01196: 文件 1 由于介质恢复会话失败而不一致 ORA-01110: 数据文件 1:’+DATA/htdb7/datafile/system.313.884996245′ 查看归档日志应用情况，发现一部分日志没应用 SQL> Select Name,Sequence#,applie

ORA-10458 ORA-01196 ORA-01110报错解决

copd94993的博客

06-03

396

今天接到上家公司一个运维的电话，说dg库启动不了，发给我一个报错 ORA-10458:standbydatabaserequiresrecovery ORA-01196:file1isinconsistent...

ORA-10458: standby database requires recovery&ORA-01196&ORA-01110

hbhe0316的专栏

10-23

1696

ORA-10458: standby database requires recovery&ORA-01196&ORA-011101.报错信息：https://www.cndba.cn/hbhe0316/article/4975https://www.cndba.cn/hbhe0316/article/4975 * ERROR at line 1: ORA-1...

DG问题：ORA-10458: standby database requires recovery&ORA-01196&ORA-01110

07-23

5009

ORA-10458: standby database requires recovery&ORA-01196&ORA-01110 1.报错信息： ORA-10458: standby database requires recovery ORA-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: data file 1: '/u01/app/oracle/oradata/proe/s

oracle revovery ora-01110,Oracle Adg 备库 ORA-10458 ORA-01196 ORA-01110: ORA-10458 故障处理

weixin_28778547的博客

04-07

707

一环境：主库：Oracle 双节点RAC 19.6C(Linux)备库：Oracle 双节点RAC 19.6C(Linux)二详细报错：Errors with log +ORA19CB_ARCH/ORA19CB/ARCHIVELOG/2021_02_07/thread_1_seq_809.315.10639078052021-02-16T11:07:34.513934+08:00Standby...

数据库ORA-01196(ORA-10458/ORA-01110)错误解决方法