Oracle 11g没有备份文件参数文件在异机通过RMAN备份恢复找回被误删的数据

背景：同事误删除线上数据，所以需要从备份中找回数据恢复。真实屋漏偏逢连夜雨、船迟又遇打头风，前两天备份的磁盘坏块，现在只有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 454DATAFILE"/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"LOGFILEGROUP 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 10MCHARACTER SET ZHS16GBK; 1.2，设置catalog start with 路径searching for all files that match the pattern/tmp/2015-03-30/ List of Files Unknown to the Database=====================================File Name:/tmp/2015-03-30/full_POWERDES_20150330_3395.bakFile Name: /tmp/2015-03-30/rman_backup.logFile Name:/tmp/2015-03-30/arch_POWERDES_20150330_3396.bakFile Name:/tmp/2015-03-30/arch_POWERDES_20150330_3394.bak Do you really want to catalog the abovefiles （enter YES or NO）？ yescataloging files...cataloging done List of Cataloged Files=======================File Name:/tmp/2015-03-30/full_POWERDES_20150330_3395.bakFile Name:/tmp/2015-03-30/arch_POWERDES_20150330_3396.bakFile Name:/tmp/2015-03-30/arch_POWERDES_20150330_3394.bakList of Files Which Where Not Cataloged=======================================File Name: /tmp/2015-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-15using channel ORA_DISK_1 RMAN-00571:===========================================================RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============RMAN-00571:===========================================================RMAN-03002: failure of restore command at04/01/2015 03:39:01RMAN-06026: some targets not found -aborting restoreRMAN-06023: no backup or copy of datafile12 found to restoreRMAN-06023: no backup or copy of datafile11 found to restoreRMAN-06023: no backup or copy of datafile10 found to restoreRMAN-06023: no backup or copy of datafile 9found to restoreRMAN-06023: no backup or copy of datafile 8found to restoreRMAN-06023: no backup or copy of datafile 7found to restoreRMAN-06023: no backup or copy of datafile 5found to restoreRMAN-06023: no backup or copy of datafile 4found to restoreRMAN-06023: no backup or copy of datafile 3found to restoreRMAN-06023: no backup or copy of datafile 2found to restoreRMAN-06023: no backup or copy of datafile 1found to restoreRMAN>PS：遗憾的是恢复失败，google了很久，发现只能通过sys.dbms_backup_restore.restoreDatafileTo的方式来做不完全一致恢复。更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2015-04/115774p2.htm--------------------------------------推荐阅读 --------------------------------------RMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm--------------------------------------分割线 --------------------------------------

利用RMAN在文件系统与ASM之间迁移数据库关于Oracle权限管理的实用脚本相关资讯 rman备份 RMAN备份恢复

RMAN备份报 RMAN-06059 错误（05月13日）
RMAN备份文件远大于数据库大小的原（01月09日）
Oracle RMAN备份之控制文件备份（12/20/2015 20:07:06）

RMAN备份策略修正案例实录（02月29日）
Oracle 11g R2 RAC RMAN备份脚本示（12/27/2015 11:33:20）
RMAN备份时遇到ORA-19588 （07/23/2015 15:01:01）

本文评论查看全部评论（0）