oracle恢复异常处理

news/2024/5/14 9:10:43

问题现象:

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 
using target database control file instead of recovery catalog
allocated channel: ch01
channel ch01: SID=1513 device type=SBT_TAPE
channel ch01: NMDA Oracle v19.8.0.1

allocated channel: ch02
channel ch02: SID=1549 device type=SBT_TAPE
channel ch02: NMDA Oracle v19.8.0.1

allocated channel: ch03
channel ch03: SID=1585 device type=SBT_TAPE
channel ch03: NMDA Oracle v19.8.0.1

allocated channel: ch04
channel ch04: SID=1621 device type=SBT_TAPE
channel ch04: NMDA Oracle v19.8.0.1

allocated channel: ch05
channel ch05: SID=1657 device type=SBT_TAPE
channel ch05: NMDA Oracle v19.8.0.1

allocated channel: ch06
channel ch06: SID=1693 device type=SBT_TAPE
channel ch06: NMDA Oracle v19.8.0.1

allocated channel: ch07
channel ch07: SID=1729 device type=SBT_TAPE
channel ch07: NMDA Oracle v19.8.0.1

allocated channel: ch08
channel ch08: SID=1765 device type=SBT_TAPE
channel ch08: NMDA Oracle v19.8.0.1

sql statement: alter session set nls_date_format="yyyy-mm-dd hh24:mi:ss"

released channel: ch01
released channel: ch02
released channel: ch03
released channel: ch04
released channel: ch05
released channel: ch06
released channel: ch07
released channel: ch08
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of send command at 04/09/2024 08:50:44
ORA-19559: error sending device command: NB_ORA_CLIENT=ebsdevtest
ORA-19557: device error, device type: SBT_TAPE, device name: 
ORA-27194: skgfdvcmd: sbtcommand returned error
ORA-19511: Error received from media manager layer, error text:
   sbtcommand: Unable to obtain the server parameter. (100:111:2)
 

解决排查步骤:

1.  检查netbackup状态是否正常

root      6992 65497  0 09:13 pts/1    00:00:00 grep --color=auto netbackup
root     11755     1  0 Apr07 ?        00:00:01 /usr/openv/netbackup/bin/vnetd -proxy inbound_proxy -number 0
root     11756     1  0 Apr07 ?        00:00:02 /usr/openv/netbackup/bin/vnetd -proxy outbound_proxy -number 0
root     11814     1  0 Apr07 ?        00:00:09 /usr/openv/netbackup/bin/vnetd -standalone
root     11819     1  0 Apr07 ?        00:00:02 /usr/openv/netbackup/bin/bpcd -standalone
root     11907     1  0 Apr07 ?        00:00:11 /usr/openv/netbackup/bin/nbdisco

2. 由于之前安装过Dell Networker客户端,检查是否存在,如果存在卸载

rpm -qa | grep lgto
lgtonmda-19.8.0.1-1.x86_64
lgtoclnt-19.8.0.1-1.x86_64

卸载后依然存在问题

3. 可能是NBU跟oracle lib库关联异常(该环境oracle是拷贝过来)

[oraprod@testdb bin]$ pwd

/usr/openv/netbackup/bin

[oraprod@testdb bin]$ ls oracle_link

oracle_link

[oracle@testdb bin]$ ./oracle_link

All Oracle instances should be shutdown before running this script.

Please log into the Unix system as the Oracle owner for running this script

Do you want to continue? (y/n) [n] y

LIBOBK path: /usr/openv/netbackup/bin

ORACLE_HOME: /u01/app/oracle/product/11.2.0/db_1

Oracle version: 11.2.0.4.0

Platform type: x86_64

Linking LIBOBK:

ln -s /usr/openv/netbackup/bin/libobk.so64 /u01/app/oracle/product/11.2.0/db_1/lib/libobk.so

Done

重新执行恢复,成功恢复

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:http://www.tangninghui.cn.cn/item-12912.htm

如若内容造成侵权/违法违规/事实不符,请联系我们进行投诉反馈,一经查实,立即删除!

相关文章

IntelliJ IDEA 2024 激活版 集成开发环境(IDE)mac/win

IntelliJ IDEA 2024是一款由JetBrains公司开发的集成开发环境(IDE),专为Java等编程语言量身打造,同时支持多种其他语言。该软件凭借其出色的智能化和高效性,赢得了广大开发者的喜爱。 mac软件下载:IntelliJ…

微服务项目sc2024通用Base工程

1. cloud-provider-payment8001 2.pom文件 <?xml version"1.0" encoding"UTF-8"?> <project xmlns"http://maven.apache.org/POM/4.0.0"xmlns:xsi"http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation"ht…

Python第四次作业

周六&#xff1a; 1. 找出10000以内能被5或6整除&#xff0c;但不能被两者同时整除的数&#xff08;函数&#xff09; def find_number():for number in range(0,10000):if number % 5 0 or number % 6 0:if number % 5 ! number % 6:ls.append(number)print(ls)ls [] fin…

spring aop

约定编程&#xff1a;我们只需要实现约定的流程部分&#xff0c;而具体实现通过框架实现 “约定编程”&#xff08;Convention Over Configuration&#xff09;是一种软件开发的理念&#xff0c;旨在减少开发者在项目配置上的决策&#xff0c;并通过约定促进开发者之间的协作和…

Python | 超前滞后分析

Nino SST Indices (Nino 12, 3, 3.4, 4; ONI and TNI) 有几个指标用于监测热带太平洋&#xff0c;所有这些指标都是基于海表温度(SST)异常在一个给定的区域的平均值。通常&#xff0c;异常是相对于30年的周期来计算的。厄尔尼诺3.4指数(Nio 3.4 index)和海洋厄尔尼诺指数(Ocea…

酷开科技 |酷开系统全视频化升级,让电视回归视频属性

随着消费升级浪潮的兴起&#xff0c;家庭互联网这一概念也在资本的注入下&#xff0c;成为了新风口。酷开系统全视频化升级&#xff0c;让电视回归视频属性&#xff0c;酷开系统在之前瀑布流板块设计的基础上&#xff0c;增加了视频流图文融合的并行界面&#xff0c;同时酷开系…