当前位置： 首页 > news >正文

oracle 11.2.0.1 rman异机恢复 11.2.0.3(windows X64)

news 来源：原创 2024/5/2 4:42:14

问题原因： 误操作，需要时间点恢复。

备份情况：rman 备份，每天一次全备份，并且附带备份当天所有产生的archivelog，无expdp备份

恢复目标： 恢复到9号晚上21点数据

源系统：WINDOWS2008R2，数据库版本如下：

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

 

目标系统： WINDOWS2012 R2 数据库版本如下：

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

 

恢复步骤：

1：目标系统安装oracle软件，不进行建库操作，略过

2：复制源系统pfile 到 目标系统，路径重新自定义。略过

3：以spfile启动目标数据库到nomount状态。略过

4：目标系统恢复控制文件：

    4.1：目标系统恢复控制文件：

   

RMAN> restore controlfile from 'c:\db\FULL_COMPRESSD_G8TKC9OO_1_1.BAK';

Starting restore at 14-DEC-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=127 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=C:\APP\ADMINISTRATOR\ADMIN\ORCL\CONTROL.CTL
Finished restore at 14-DEC-18

 

     4.2：目标系统 rman 注册备份集路径：

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> catalog start with 'c:\db';

searching for all files that match the pattern c:\db

List of Files Unknown to the Database
=====================================
File Name: C:\db\ARCH_GATKC9TQ_1_1.BAK
File Name: C:\db\ARCH_GBTKC9TR_1_1.BAK
File Name: C:\db\ARCH_GGTKEU9G_1_1.BAK
File Name: C:\db\ARCH_GHTKEU9H_1_1.BAK
File Name: C:\db\FULL_COMPRESSD_G6TKC9ML_1_1.BAK
File Name: C:\db\FULL_COMPRESSD_G7TKC9ML_1_1.BAK
File Name: C:\db\FULL_COMPRESSD_G8TKC9OO_1_1.BAK

Do you really want to catalog the above files (enter YES or NO)? y
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: C:\db\ARCH_GATKC9TQ_1_1.BAK
File Name: C:\db\ARCH_GBTKC9TR_1_1.BAK
File Name: C:\db\ARCH_GGTKEU9G_1_1.BAK
File Name: C:\db\ARCH_GHTKEU9H_1_1.BAK
File Name: C:\db\FULL_COMPRESSD_G6TKC9ML_1_1.BAK
File Name: C:\db\FULL_COMPRESSD_G7TKC9ML_1_1.BAK
File Name: C:\db\FULL_COMPRESSD_G8TKC9OO_1_1.BAK

 

 5：目标系统进行数据文件还原：

RMAN> run{
2> set newname for datafile 1 to "C:\app\Administrator\admin\orcl\oradata\system01.dbf";
3> set newname for datafile 2 to "C:\app\Administrator\admin\orcl\oradata\sysaux01.dbf";
4> set newname for datafile 3 to "C:\app\Administrator\admin\orcl\oradata\undotbs01.dbf";
5> set newname for datafile 4 to "C:\app\Administrator\admin\orcl\oradata\users01.dbf";
6> set newname for datafile 5 to "C:\app\Administrator\admin\orcl\oradata\example01.dbf";
7> set newname for datafile 6 to "C:\app\Administrator\admin\orcl\oradata\FLIGHTRADAR.DBF.dbf";
8> restore database;
9> switch datafile all;
10> }

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 14-DEC-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=65 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to C:\app\Administrator\admin\orcl\oradata\system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to C:\app\Administrator\admin\orcl\oradata\sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to C:\app\Administrator\admin\orcl\oradata\undotbs01.dbf
channel ORA_DISK_1: reading from backup piece D:\DBBACKUP\RMAN\FULL_COMPRESSD_G7TKC9ML_1_1.BAK
channel ORA_DISK_1: errors found reading piece handle=D:\DBBACKUP\RMAN\FULL_COMPRESSD_G7TKC9ML_1_1.BAK
channel ORA_DISK_1: failover to piece handle=C:\DB\FULL_COMPRESSD_G7TKC9ML_1_1.BAK tag=TAG20181209T210004
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:25
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to C:\app\Administrator\admin\orcl\oradata\users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to C:\app\Administrator\admin\orcl\oradata\example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to C:\app\Administrator\admin\orcl\oradata\FLIGHTRADAR.DBF.dbf
channel ORA_DISK_1: reading from backup piece C:\DB\FULL_COMPRESSD_G6TKC9ML_1_1.BAK
channel ORA_DISK_1: piece handle=C:\DB\FULL_COMPRESSD_G6TKC9ML_1_1.BAK tag=TAG20181209T210004
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:26
Finished restore at 14-DEC-18

datafile 1 switched to datafile copy
input datafile copy RECID=8 STAMP=994847838 file name=C:\APP\ADMINISTRATOR\ADMIN\ORCL\ORADATA\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=9 STAMP=994847838 file name=C:\APP\ADMINISTRATOR\ADMIN\ORCL\ORADATA\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=10 STAMP=994847838 file name=C:\APP\ADMINISTRATOR\ADMIN\ORCL\ORADATA\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=11 STAMP=994847839 file name=C:\APP\ADMINISTRATOR\ADMIN\ORCL\ORADATA\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=12 STAMP=994847839 file name=C:\APP\ADMINISTRATOR\ADMIN\ORCL\ORADATA\EXAMPLE01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=13 STAMP=994847840 file name=C:\APP\ADMINISTRATOR\ADMIN\ORCL\ORADATA\FLIGHTRADAR.DBF.DBF

6：还原一个归档日志：

RMAN> run{
2> set until sequence 14040 thread 1;
3> recover database;
4> }

executing command: SET until clause

Starting recover at 14-DEC-18
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=14039
channel ORA_DISK_1: reading from backup piece C:\DB\ARCH_GHTKEU9H_1_1.BAK
channel ORA_DISK_1: piece handle=C:\DB\ARCH_GHTKEU9H_1_1.BAK tag=TAG20181210T210341
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:26
archived log file name=C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000014039_0897388701.0001 thread=1 sequence=14039
media recovery complete, elapsed time: 00:00:03
Finished recover at 14-DEC-18

7：resetlogs打开目标数据库,由于目标数据库版本过高，提示：ORA-00704: 引导程序进程失败
ORA-39700: 必须用 UPGRADE 选项打开数据库

alter database open resetlogs
.........
ORA-39700: 必须用 UPGRADE 选项打开数据库

 

8:重新连接数据库执行升级：

SQL>startup upgrade;
SQL>@C:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\ADMIN\catupgrd.sql   --重建数据字典视图脚本
执行完毕后数据库自动关闭，再次启动数据库
SQL>startup
SQL>@C:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\ADMIN\utlrp.sql     --编译无效对象

 

 

 

              

 

转载于:https://www.cnblogs.com/monkeybron/p/10119318.html

相关文章：

  • Linux查询网址
  • GCP为Kubernetes引擎提供支持原生容器的负载均衡器
  • input文本框实现宽度自适应代码实例
  • 牛课练习赛34 Flittle w and Discretization 主席树维护Mex
  • 阿里云购买磁盘后挂载
  • Struts2原理
  • 雷军带领小米老员工公园步行 称这些人是小米最宝贵财富
  • 建密钥免密码登录openwrt路由器
  • Python线程学习
  • linux用户态定时器的使用---19
  • Eclipse 创建第一个 springboot 应用
  • java 同一个类中 多个synchronized 方法会造成死锁
  • 职业生涯 一个六年开发经验的女程序员的心声。
  • CSS样式定义的优先级顺序总结
  • 二次冲刺站立会议十
  • JS中 map, filter, some, every, forEach, for in, for of 用法总结
  • 【5+】跨webview多页面 触发事件（二）
  • Cookie 在前端中的实践
  • electron原来这么简单----打包你的react、VUE桌面应用程序
  • es6--symbol
  • EventListener原理
  • leetcode46 Permutation 排列组合
  • overflow: hidden IE7无效
  • PHP CLI应用的调试原理
  • SpingCloudBus整合RabbitMQ
  • Vim Clutch | 面向脚踏板编程……
  • 基于Volley网络库实现加载多种网络图片（包括GIF动态图片、圆形图片、普通图片）...
  • 在weex里面使用chart图表
  • Spark2.4.0源码分析之WorldCount 默认shuffling并行度为200(九) ...
  • （1）STL算法之遍历容器
  • （2）(2.4) TerraRanger Tower/Tower EVO(360度)
  • （2021|NIPS，扩散，无条件分数估计，条件分数估计）无分类器引导扩散
  • (iPhone/iPad开发)在UIWebView中自定义菜单栏
  • (poj1.3.2)1791(构造法模拟)
  • (pojstep1.1.2)2654(直叙式模拟)
  • (zz)子曾经曰过：先有司，赦小过，举贤才
  • （二）fiber的基本认识
  • （附源码）springboot高校宿舍交电费系统 毕业设计031552
  • (附源码)ssm教师工作量核算统计系统 毕业设计 162307
  • （黑马C++）L06 重载与继承
  • （亲测成功）在centos7.5上安装kvm,通过VNC远程连接并创建多台ubuntu虚拟机（ubuntu server版本）...
  • (未解决)jmeter报错之“请在微信客户端打开链接”
  • （最简单，详细，直接上手）uniapp/vue中英文多语言切换
  • .NET C#版本和.NET版本以及VS版本的对应关系
  • .NET MVC 验证码
  • .net 获取url的方法
  • .NET 同步与异步 之 原子操作和自旋锁（Interlocked、SpinLock）（九）
  • .NET 中 GetHashCode 的哈希值有多大概率会相同（哈希碰撞）
  • .NET/C# 避免调试器不小心提前计算本应延迟计算的值
  • .Net多线程总结
  • .net中生成excel后调整宽度
  • .net专家（高海东的专栏）
  • .php结尾的域名,【php】php正则截取url中域名后的内容
  • .py文件应该怎样打开？
  • @require_PUTNameError: name ‘require_PUT‘ is not defined 解决方法