数据库|mysql教程
RMAN备份恢复,Oracle 11g没备份文件参数文件在
数据库-mysql教程
asp拉圈圈网站源码,vscode numpy,ubuntu 打包命令,tomcat 位置,sqlite的用途,iis 服务器重启,fckeditor 视频插件,来访登记前端框架,网络爬虫技术 java,php抛异常,seo深度优化平台,网络游戏运营数据分析网站模板,网页下载的css代码乱,404模板免费下载,给html页面添加随机数,开源内容管理系统 java,主题程序大全lzw
同事误删除线上数据,所以需要从备份中找回数据恢复。真实屋漏偏逢连夜雨、船迟又遇打头风,前两天备份的磁盘坏块,现在只有rman
手机扫描二维码源码,开发微信小程序vscode,ubuntu 设置777,sts调出tomcat网址,快递网站爬虫,php 解析验证码,百度推广seo公司价格,用做企业网站lzw
tom猫安卓市场整站源码,vscode如何让代码换行,ubuntu 命令文件,tomcat 默认字符,公司爬虫构架,php执行js函数,抖音seo软件工具郑州,php音乐采集网站,discuz触屏版模板lzw
背景:
同事误删除线上数据,所以需要从备份中找回数据恢复。真实屋漏偏逢连夜雨、船迟又遇打头风,前两天备份的磁盘坏块,现在只有rman全备的.bak文件,没有控制文件和参数文件,所以现在需要考虑的是如何根据bak文件在备份数据库上恢复数据,从中找出被误删的数据。
1 通过catalog start with’’的方式来恢复
1.1手动创建控制文件
CREATE CONTROLFILE REUSE set DATABASE”powerdes” RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 454
DATAFILE
‘/home/oradata/powerdes/system01.dbf’,
‘/home/oradata/powerdes/sysaux01.dbf’,
‘/home/oradata/powerdes/undotbs01.dbf’,
‘/home/oradata/powerdes/users01.dbf’,
‘/home/oradata/powerdes/powerdesk01.dbf’,
‘/home/oradata/powerdes/plas01.dbf’,
‘/home/oradata/powerdes/pl01.dbf’,
‘/home/oradata/powerdes/help01.dbf’,
‘/home/oradata/powerdes/adobelc01.dbf’,
‘/home/oradata/powerdes/sms01.dbf’,
‘/home/oradata/powerdes/plcrm01.dbf’
LOGFILE
GROUP 1(‘/home/oradata/powerdes/redo03.log’) SIZE 10M,
GROUP 2(‘/home/oradata/powerdes/redo02.log’) SIZE 10M,
GROUP 3(‘/home/oradata/powerdes/redo01.log’) SIZE10M,
GROUP 4(‘/home/oradata/powerdes/redo_dg_01.log’) SIZE 10M,
GROUP 5(‘/home/oradata/powerdes/redo_dg_02.log’) SIZE 10M,
GROUP 6(‘/home/oradata/powerdes/redo_dg_03.log’) SIZE 10M
CHARACTER SET ZHS16GBK;
1.2,设置catalog start with 路径
searching for all files that match the pattern/tmp/-03-30/
List of Files Unknown to the Database
=====================================
File Name:/tmp/-03-30/full_POWERDES_0330_3395.bak
File Name: /tmp/-03-30/rman_backup.log
File Name:/tmp/-03-30/arch_POWERDES_0330_3396.bak
File Name:/tmp/-03-30/arch_POWERDES_0330_3394.bak
Do you really want to catalog the abovefiles (enter YES or NO)? yes
cataloging files…
cataloging done
List of Cataloged Files
=======================
File Name:/tmp/-03-30/full_POWERDES_0330_3395.bak
File Name:/tmp/-03-30/arch_POWERDES_0330_3396.bak
File Name:/tmp/-03-30/arch_POWERDES_0330_3394.bak
List of Files Which Where Not Cataloged
=======================================
File Name: /tmp/-03-30/rman_backup.log
RMAN-07517: Reason: The file header is corrupted
1.3 开始restore database恢复数据库
RMAN> restore database;
Starting restore at 01-APR-15
using channel ORA_DISK_1
RMAN-00571:===========================================================
RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-03002: failure of restore command at04/01/ 03:39:01
RMAN-06026: some targets not found -aborting restore
RMAN-06023: no backup or copy of datafile12 found to restore
RMAN-06023: no backup or copy of datafile11 found to restore
RMAN-06023: no backup or copy of datafile10 found to restore
RMAN-06023: no backup or copy of datafile 9found to restore
RMAN-06023: no backup or copy of datafile 8found to restore
RMAN-06023: no backup or copy of datafile 7found to restore
RMAN-06023: no backup or copy of datafile 5found to restore
RMAN-06023: no backup or copy of datafile 4found to restore
RMAN-06023: no backup or copy of datafile 3found to restore
RMAN-06023: no backup or copy of datafile 2found to restore
RMAN-06023: no backup or copy of datafile 1found to restore
RMAN>
PS:遗憾的是恢复失败,google了很久,,发现只能通过sys.dbms_backup_restore.restoreDatafileTo的方式来做不完全一致恢复。
更多详情见请继续阅读下一页的精彩内容:
————————————–推荐阅读 ————————————–
RMAN 配置归档日志删除策略
Oracle基础教学之通过RMAN复制数据库
RMAN备份策略制定参考内容
RMAN备份学习笔记
Oracle数据库备份加密 RMAN加密
————————————–分割线 ————————————–