RMAN 基于时间点恢复

《RMAN 基于时间点恢复》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、RMAN基于时间点的恢复（实验）1、做次全备份run{backuptag'full'format'd:rmanbkfull_%d_s%s_p%p_%t'databaseplusarchivelogdeleteallinput;}SQL>select*fromtest;IDSYS_DATE-----------------------------12008-06-1210:55:1922008-06-1210:55:2332008-06-1210:56:2042008-06-1210:56:2652008-06-1211:

2、02:3562008-06-1211:02:3972008-06-1211:02:4482008-06-1211:03:522、删除5、6SQL>deletetestwhereid='5'orid='6';已删除2行。SQL>commit;提交完成。SQL>select*fromtest;IDSYS_DATE-----------------------------12008-06-1210:55:1922008-06-1210:55:2332008-06-1210:56:2042008-06-1210:56:2672008

3、-06-1211:02:4482008-06-1211:03:52已选择6行。插入9、10SQL>insertintotestselect9,sysdatefromdual;已创建1行。SQL>insertintotestselect10,sysdatefromdual;已创建1行。SQL>commit;提交完成。3、SQL>select*fromtest;IDSYS_DATE-----------------------------12008-06-1210:55:1922008-06-1210:55:2332008-06

4、-1210:56:2042008-06-1210:56:2672008-06-1211:02:4482008-06-1211:03:5292008-06-1211:28:59102008-06-1211:29:03已选择8行。归档备份RMAN>backuparchivelogalldeleteinputtag'arc'format'd:rmanbkarc_%t';4、SQL>insertintotestselect11,sysdatefromdual;已创建1行。SQL>insertintotestselect12,sy

5、sdatefromdual;已创建1行。SQL>select*fromtest;IDSYS_DATE-----------------------------12008-06-1210:55:1922008-06-1210:55:2332008-06-1210:56:2042008-06-1210:56:26122008-06-1211:31:0472008-06-1211:02:4482008-06-1211:03:5292008-06-1211:28:59102008-06-1211:29:03112008-06-121

6、1:31:01已选择10行。归档备份RMAN>backuparchivelogalldeleteinputtag'arc'format'd:rmanbkarc_%t';5、数据库到mount状态startupforcemount6、恢复RMAN>run{2>allocatechannelch1typedisk;3>setuntiltime"to_date('2008-06-1211:28:59','YYYY-MM-DDhh24:mi:ss')";4>restoredatabase;5>recoverdatabase;6>

7、releasechannelch1;7>}恢复后应该显示绿色显示部分SQL>altersessionsetnls_date_format='yyyy-mm-ddhh24:mi:ss';会话已更改。SQL>select*fromtest;IDSYS_DATE-----------------------------12008-06-1210:55:1922008-06-1210:55:2332008-06-1210:56:2042008-06-1210:56:2672008-06-1211:02:4482008-06-1211

8、:03:52总结：恢复的时间点必须是最后一次备份（全备、归档等）前的时间