NUB备份介质恢复问题记录

最新推荐文章于 2023-03-18 23:47:40 发布
最新推荐文章于 2023-03-18 23:47:40 发布
阅读量1.9k 收藏
点赞数 1
分类专栏： NBU
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/huangliang0703/article/details/49739177
版权

库A 用NBU做了一个全备，现在要搭一个备库，刚好用NBU的备份做一个恢复，下面是在备库运行的恢复脚本

将数据库启动到mount 状态


#!/bin/bash
source /home/oracle/.bash_profile
$ORACLE_HOME/bin/rman << eof > /home/oracle/scripts/restore.log
connect target sys/oracle@kdedi （<span style="color:#ff0000;">主库的服务名</span>）
connect auxiliary /
RUN {
allocate auxiliary channel ch00 TYPE 'SBT_TAPE';
allocate auxiliary channel ch01 TYPE 'SBT_TAPE';
allocate auxiliary channel ch02 TYPE 'SBT_TAPE';
allocate auxiliary channel ch03 TYPE 'SBT_TAPE';
allocate auxiliary channel ch04 TYPE 'SBT_TAPE';
allocate auxiliary channel ch05 TYPE 'SBT_TAPE';
allocate auxiliary channel ch06 TYPE 'SBT_TAPE';
allocate auxiliary channel ch07 TYPE 'SBT_TAPE';
send 'NB_ORA_CLIENT=xxx.xxx.com'; (<span style="color:#ff0000;">主库的域名</span>)
send 'NB_ORA_SERV=nbuserver.xxx.com';
duplicate target database for standby nofilenamecheck;
release channel ch00;
release channel ch01;
release channel ch02;
release channel ch03;
release channel ch04;
release channel ch05;
release channel ch06;
release channel ch07;
}
eof
exit;

运行后报下面的错误： 

Recovery Manager: Release 11.2.0.4.0 - Production on Mon Nov 9 15:30:14 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> 
connected to target database: KDEDI (DBID=1364717330)

RMAN> 
connected to auxiliary database (not started)

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 11/09/2015 15:30:15
RMAN-06403: could not obtain a fully authorized session
RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

RMAN>

报出来的错误不好定位，我们分解执行


[oracle@qs-fbfjdbadg1 ~]$ rman target sys/oracle@kdedi （<span style="color:#ff0000;">连到主库</span>）

Recovery Manager: Release 11.2.0.4.0 - Production on Mon Nov 9 15:24:48 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: KDEDI (DBID=1364717330)

RMAN> connect auxiliary / （<span style="color:#ff0000;">备库本身</span>）

connected to auxiliary database: KDEDI (DBID=1364717330, not open)

RMAN> RUN {
2> allocate auxiliary channel ch00 TYPE 'SBT_TAPE';
3> allocate auxiliary channel ch01 TYPE 'SBT_TAPE';
4> allocate auxiliary channel ch02 TYPE 'SBT_TAPE';
5> allocate auxiliary channel ch03 TYPE 'SBT_TAPE';
6> allocate auxiliary channel ch04 TYPE 'SBT_TAPE';
7> allocate auxiliary channel ch05 TYPE 'SBT_TAPE';
8> allocate auxiliary channel ch06 TYPE 'SBT_TAPE';
9> allocate auxiliary channel ch07 TYPE 'SBT_TAPE';
10> send 'NB_ORA_CLIENT=xxx.xxx.com';
11> send 'NB_ORA_SERV=nbuserver.xxx.com';
12> duplicate target database for standby nofilenamecheck;
13> release channel ch00;
14> release channel ch01;
15> release channel ch02;
16> release channel ch03;
17> release channel ch04;
18> release channel ch05;
19> release channel ch06;
20> release channel ch07;
21> }

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ch00 channel at 11/09/2015 15:26:32
ORA-19554: error allocating device, device type: SBT_TAPE, device name: 
ORA-27211: Failed to load Media Management Library
Additional information: 2

RMAN> exit

错误指出不能加载介质管理库，原来是没有装NBU客户端，需要执行一个oralink‘ 文件(/usr/openv/netbackup/bin 目录下)


再次执行，出现下面的错误，

RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/09/2015 15:46:47
RMAN-05501: aborting duplication of target database
RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE command


duplicate 是一种数据复制方式，要求数据库出在 nomount ，我们更改下脚本：

RUN {
allocate  channel ch00 TYPE 'SBT_TAPE';
allocate  channel ch01 TYPE 'SBT_TAPE';
allocate  channel ch02 TYPE 'SBT_TAPE';
allocate  channel ch03 TYPE 'SBT_TAPE';
allocate  channel ch04 TYPE 'SBT_TAPE';
allocate  channel ch05 TYPE 'SBT_TAPE';
allocate  channel ch06 TYPE 'SBT_TAPE';
allocate  channel ch07 TYPE 'SBT_TAPE';
send 'NB_ORA_CLIENT=qs-xx.xxx.com';
send 'NB_ORA_SERV=nbuserver.xxx.com';
restore database;
release channel ch00;
release channel ch01;
release channel ch02;
release channel ch03;
release channel ch04;
release channel ch05;
release channel ch06;
release channel ch07;
}

这次报数据文件不能创建的错误，请NBU的工程师检查，发现时备库与nbu master 是通的，但是与nbu 介质服务器不同，

将备库与nbu 介质服务器打通，能正常进行恢复。

huangliang0703
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
NUB恢复ORACLE数据库.pdf
10-09
NUB恢复ORACLE数据库.pdf
使用RMAN工具复制数据库
热爱生活，努力工作
10-15 1646
复制数据库即使用RMAN工具的
RMAN-05001，RMAN-05500 问题解决
cuixie2370的博客
01-04 1615
On the primary node, perform. an RMAN backup of the primary database that places the backup pieces into the stagin...
RMAN-05501: aborting duplication of target database
congwei2855的博客
07-15 1682
1. 问题： 在搭建DG的时候，d...
使用NBU备份数据文件和Oracle
文档搬运工
06-10 3770
基本配置信息 基本配置信息 主机名 IP 备注说明 WIN-TT550NADE2Q 192.168.2.10 NBU Server （Master ） WIN-V3L71BODI0T 192.168.2.11 DB Server1 （备份的库） WIN-48UTQP5TASO 192.
oracle RAC数据库建立STANDBY（五）
weixin_33739541的博客
05-09 115
这篇文章描述为RAC环境创建STANDBY数据库。由于篇幅限制，加上碰到了很多的bug，只能将文章拆分成多篇。由于错误太多，导致一篇文章无法完全记录下来，创建STANDBY数据库问题汇总的第三部分。刚刚在进行RAC环境的DUPLICATE DATABASE的时候，就碰到了很多问题，由于二者命令比较相似，本来认为这次不会碰到太多的问题，没有想到的是，这次碰到的问题居然比DUPL...
RMAN-05501 AND RMAN-05001
技术专栏
08-16 1283
在通过 rman active duplicate 创建 standby数据库时，报下面的错误： contents of Memory Script: {    sql clone 'alter database mount standby database'; } executing Memory Script sql statement: alter databas
auxiliary恢复备库详细记录
weixin_34162629的博客
02-09 574
   -bash-3.2$ rman target / auxiliary sys/password@standby     Recovery Manager: Release 10.2.0.4.0 - Production on Wed Feb 8 22:01:47 2012     Copyright (c) 1982, 200...
RMAN高级应用之Duplicate复制数据库(2)辅助实例
cqbh2011的博客
12-04 252
使用rman的duplicate命令复制数据库系列，本系列可以视为一步一步学RMAN的姊妹篇~~~~ RMAN高级应用之Duplicate复制数据库(1)概述　　辅助实例是创建副本数据库的重要一步，一般而言会有下列几个步骤，有些...
NBU7.5 BRM备份还原Aix
06-16
NBU7.5 BRM备份还原Aix，新资料欢迎下载。
音创音响 nub X6 数字前置效果器调音软件
01-05
音创音响 nub X6 数字前置效果器调音软件 附带效果文件
NUB-开源
05-01
NUB是一组高级C ++代码，为可变长度密钥，压缩资源文件提供索引，并为内存块提供istream接口。 现在支持Unicode密钥和多达17万亿千兆字节的文件大小。 见www.cnub.org/NUB.ashx
AppleACPIPS2Nub
11-08
AppleACPIPS2Nub.kext说明： 苹果系统驱动文件
【11.2拾遗】rman复制数据库 Duplicating a Database
viviliving的专栏
04-16 608
本章描述如何使用DUPLICATE命令创建独立运行的数据库副本。 This chapter contains the following topics: Overview of RMAN Database Duplication Preparing to Duplicate a Database Placing the Source Database in the Pr...
【RMAN】RMAN-05001: auxiliary filename conflicts with the target database
weixin_33737774的博客
06-28 447
oracle 11.2.0.4 运行以下脚本，使用活动数据库复制技术创建dataguard备库报错rman-005001： run{ duplicate target database for standby from active database spfile     set db_unique_name='dbkingstd'     set log_file_name_c...
RMAN-05501 RMAN-05001
冰刀(skate)
10-28 8485
author：skate time：2011/10/28   错误信息： RMAN-05501: aborting duplication of target database RMAN-05001: auxiliary file name /oracle/oradata/skatedb/tbs_statspack01.dbf conflicts with a file used by
RMAN duplicate搭建辅助数据库
mengxiangfeiyang的专栏
03-18 764
使用RMAN DUPLICATE命令可以在保留目标数据库的基础上依靠目标数据库(TargetDatabase)的备份创建一个副本数据库(DuplicateDatabase)，目标数据库和辅助数据库可以在同一台机器上，辅助数据库是目标数据库的一个拷贝。
ora-19554 ora-27211 failed to load media management library
j_ychen的博客
04-26 1175
su - oracle cd /usr/openv/netbackup/bin ./oracle_link
package demo; import java.util.HashMap; import java.util.Scanner; public class exercise333 { private static Scanner scanner; /** * 学生信息集合 */ private static HashMap<String,Student> map; public static void main(String[] args) { // TODO Auto-generated method stub select(); } private static void select() { System.out.println("请输入学号："); Scanner sc = new Scanner(System.in); String nub = sc.nextLine(); Student student = map.get(nub); if(student == null) System.out.println("没有查询到该学生！"); else System.out.println(student.toString()); } } class Student{ private String sno; /** * 学号 */ private String name; /** * 姓名 */ private String major; /** * 专业 */ private String score; /** * 成绩 */ public String toString() { return "学生信息{"+ "学号='" + sno + '\'' + "姓名='" + name + '\'' + "专业='" + major + '\'' + "成绩='" + score + '\'' + '}'; } public String getSno() { return sno; } public void setSno(String sno) { this.sno = sno; } public String getName() { return name ; } public void setName(String name) { this.name = name; } public String getMajor() { return major; } public void setMajor(String major) { this.major = major; } public String getScore() { return score; } public void setScore(String score) { this.score =score; } public Student(String sno,String name,String major,String score) { this.sno = sno; this.name = name; this.major = major; this.score = score; } }
最新发布
03-25
There are a few issues with the provided code: 1. The `map` object is not initialized, which will cause a `NullPointerException` when using the `get` method. To fix this, initialize the map object before using it: ``` private static HashMap<String,Student> map = new HashMap<String,Student>(); ``` 2. The `toString` method in the `Student` class is missing some plus signs to concatenate the strings. Fix it by adding the plus signs: ``` public String toString() { return "学生信息{" + "学号='" + sno + '\'' + ", 姓名='" + name + '\'' + ", 专业='" + major + '\'' + ", 成绩='" + score + '\'' + '}'; } ``` 3. The `score` field is declared as `String`, which is not a suitable type for storing scores. Change it to a numeric type, such as `int` or `double`. 4. The `setScore` method has a typo and should be `this.score = score;` 5. It's a good practice to use `try-catch` blocks when reading from input, as the input could be incorrect and cause exceptions. For example, using `Integer.parseInt()` to get an integer from input could throw a `NumberFormatException`, and using `scanner.nextLine()` could throw a `NoSuchElementException` if there is no more input available. Here is the fixed code with these issues addressed: ``` package demo; import java.util.HashMap; import java.util.Scanner; public class Exercise333 { private static Scanner scanner; /** 学生信息集合 */ private static HashMap<String, Student> map = new HashMap<String, Student>(); public static void main(String[] args) { // TODO Auto-generated method stub select(); } private static void select() { System.out.println("请输入学号："); Scanner sc = new Scanner(System.in); String nub = sc.nextLine(); try { Student student = map.get(nub); if (student == null) System.out.println("没有查询到该学生！"); else System.out.println(student.toString()); } catch (Exception e) { System.out.println("输入有误！"); } finally { sc.close(); } } } class Student { private String sno; /** 学号 */ private String name; /** 姓名 */ private String major; /** 专业 */ private int score; /** 成绩 */ public String toString() { return "学生信息{" + "学号='" + sno + '\'' + ", 姓名='" + name + '\'' + ", 专业='" + major + '\'' + ", 成绩='" + score + '\'' + '}'; } public String getSno() { return sno; } public void setSno(String sno) { this.sno = sno; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getMajor() { return major; } public void setMajor(String major) { this.major = major; } public int getScore() { return score; } public void setScore(int score) { this.score = score; } public Student(String sno, String name, String major, int score) { this.sno = sno; this.name = name; this.major = major; this.score = score; } } ```

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

huangliang0703

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值