RMAN备份之丢失数据文件及控制文件的恢复
About Recovery with a Backup Control File
If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file. You must then run the RECOVER command, even if no data files have been restored, and open the database with the RESETLOGS option. If some copies of the current control file are usable, however, then you can follow the procedure in "Responding to the Loss of a Subset of the Current Control Files" and avoid the recovery and RESETLOGS operation. When RMAN is connected to a recovery catalog, the recovery procedure with a backup control file is identical to recovery with a current control file. The RMAN metadata missing from the backup control file is available from the recovery catalog. The only exception is if the database name is not unique in the catalog, in which case you must use SET DBID command before restoring the control file.
1. Start RMAN and connect to a target database.
2. Start the target instance without mounting the database. RMAN>STARTUP NOMOUNT; --控制文件丢失或损坏,只能将启动到nomount
3. Restore the control file
RMAN> SET DBID 320066378; # (Optional) If the database name is not unique, you need to specify the DBID
RMAN> RUN
{
SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'autobackup_format';
RESTORE CONTROLFILE FROM AUTOBACKUP; --从自动备份中恢复控制文件
}
4. Start the target instance with mounting the database. RMAN>STARTUP MOUNT; --控制文件已恢复,可mount数据文件
5. Restore the data files; RMAN>RESTORE DATABASE; --restore/recover损坏的数据文件
6. Recover the database; RMAN>RECOVER DATABASE;
7. Open the database with RESETLOGS option; RMAN> ALTER DATABASE OPEN RESETLOGS; --以resetlog方式打开数据库
最新文章
- 【BZOJ】3526: [Poi2014]Card
- 初窥Linux 之 我最常用的20条命令
- 推荐几款制作网页滚动动画的 JavaScript 库
- swift学习笔记之-协议
- left join 条件区别
- linux下使用localhost和127.0.0.1都不能连接的解决思路
- JS中标准对象
- iOS程序中调用系统自带应用(短信,邮件,浏览器,地图,appstore,拨打电话,iTunes,iBooks )
- Android——GridView(显示文字)
- TP复习6
- sql中常见日期获取
- IT外包一定要按着程序流程做
- SpringBoot使用Maven插件打包部署
- CentOS6.5 下在Nginx中添加SSL证书
- 斜率优化dp 的简单入门
- newinstance和new的区别
- Linux替换文件内容sed命令
- Go中的Init函数
- Mybatis关联一对多映射不能查询出所有的数据的问题
- PAT 1026 程序运行时间