Welcome 微信登录

首页 / 数据库 / MySQL / 探索Oracle不完全恢复之--基于检查点恢复 第二篇

基于SCN的恢复，第二篇 1、察看当前的SCN，以便于后期数据丢失用来恢复：SQL> select current_scn from v$database; CURRENT_SCN-----------    1511297 SQL> select file#,checkpoint_change#from v$datafile;     FILE# CHECKPOINT_CHANGE#---------- ------------------        1            1510535        2            1510535        3            1510535        4            1510535        5            1510535         6            1510535        7            1510535 7 rows selected. SQL> col name format a45SQL> set line 300SQL> select name,checkpoint_change# fromv$datafile_header; NAME                                         CHECKPOINT_CHANGE#---------------------------------------------------------------/DBBak2/oradata/WWL/system01.dbf                         1510535/DBBak2/oradata/WWL/undotbs01.dbf                        1510535/DBBak2/oradata/WWL/sysaux01.dbf                         1510535/DBBak2/oradata/WWL/users01.dbf                          1510535/DBBak2/oradata/WWL/wwl01.dbf                            1510535/DBBak2/oradata/WWL/wwl02.dbf                            1510535/DBBak2/oradata/WWL/wwl03.dbf                            1510535 7 rows selected. SQL> 2、删除测试表SQL> drop table wwl002 purge; Table dropped. SQL> drop table wwl003 purge; Table dropped. SQL> drop table wwl004 purge; Table dropped. SQL> drop table wwl005 purge; Table dropped. SQL> conn / as sysdbaConnected. 3、对数据库执行了DML操作后，数据库的SCN号改变了。SQL> select current_scn from v$database; CURRENT_SCN-----------   1511437  4、开始执行restore，到备份时候的状态：RMAN> restore database; Starting restore at 13-JUL-12using target database control file insteadof recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=47 devtype=DISK channel ORA_DISK_1: starting datafilebackupset restorechannel ORA_DISK_1: specifying datafile（s）to restore from backup setrestoring datafile 00001 to/DBBak2/oradata/WWL/system01.dbfrestoring datafile 00002 to/DBBak2/oradata/WWL/undotbs01.dbfrestoring datafile 00003 to/DBBak2/oradata/WWL/sysaux01.dbfrestoring datafile 00004 to/DBBak2/oradata/WWL/users01.dbfrestoring datafile 00005 to/DBBak2/oradata/WWL/wwl01.dbfrestoring datafile 00006 to/DBBak2/oradata/WWL/wwl02.dbfrestoring datafile 00007 to/DBBak2/oradata/WWL/wwl03.dbfchannel ORA_DISK_1: reading from backuppiece /DBSoft/product/10.2.0/db_1/dbs/01nft4mu_1_1channel ORA_DISK_1: restored backup piece 1piecehandle=/DBSoft/product/10.2.0/db_1/dbs/01nft4mu_1_1 tag=TAG20120712T095437channel ORA_DISK_1: restore complete,elapsed time: 00:01:06Finished restore at 13-JUL-12 5、开始执行恢复，到我们删除表之前的状态：SQL> recover database until change1511297;ORA-00279: change 1436429 generated at07/12/2012 09:54:38 needed for thread 1ORA-00289: suggestion :/DBSoft/product/10.2.0/db_1/dbs/arch1_3_788372282.dbfORA-00280: change 1436429 for thread 1 isin sequence #3  Specify log: {<RET>=suggested |filename | AUTO | CANCEL}autoORA-00279: change 1440657 generated at07/12/2012 14:00:52 needed for thread 1ORA-00289: suggestion :/DBSoft/product/10.2.0/db_1/dbs/arch1_1_788450452.dbfORA-00280: change 1440657 for thread 1 isin sequence #1  ORA-00279: change 1440855 generated at 07/12/201215:08:58 needed for thread 1ORA-00289: suggestion :/DBSoft/product/10.2.0/db_1/dbs/arch1_1_788454538.dbfORA-00280: change 1440855 for thread 1 isin sequence #1  ORA-00279: change 1441316 generated at07/12/2012 15:19:50 needed for thread 1ORA-00289: suggestion :/DBSoft/product/10.2.0/db_1/dbs/arch1_1_788455190.dbfORA-00280: change 1441316 for thread 1 isin sequence #1  ORA-00279: change 1442275 generated at07/12/2012 15:52:01 needed for thread 1ORA-00289: suggestion : /DBSoft/product/10.2.0/db_1/dbs/arch1_1_788457121.dbfORA-00280: change 1442275 for thread 1 isin sequence #1  ORA-00279: change 1442953 generated at07/12/2012 16:25:06 needed for thread 1ORA-00289: suggestion :/DBSoft/product/10.2.0/db_1/dbs/arch1_1_788459106.dbfORA-00280: change 1442953 for thread 1 isin sequence #1  ORA-00279: change 1462958 generated at07/12/2012 16:28:16 needed for thread 1ORA-00289: suggestion :/DBSoft/product/10.2.0/db_1/dbs/arch1_2_788459106.dbfORA-00280: change 1462958 for thread 1 is insequence #2ORA-00278: log file"/DBSoft/product/10.2.0/db_1/dbs/arch1_1_788459106.dbf" nolonger needed for this recovery  ORA-00279: change 1462963 generated at07/12/2012 17:17:59 needed for thread 1ORA-00289: suggestion :/DBSoft/product/10.2.0/db_1/dbs/arch1_1_788462279.dbfORA-00280: change 1462963 for thread 1 isin sequence #1  ORA-00279: change 1483784 generated at07/12/2012 17:54:25 needed for thread 1ORA-00289: suggestion :/DBSoft/product/10.2.0/db_1/dbs/arch1_2_788462279.dbfORA-00280: change 1483784 for thread 1 isin sequence #2ORA-00278: log file"/DBSoft/product/10.2.0/db_1/dbs/arch1_1_788462279.dbf" nolonger needed for this recovery  ORA-00279: change 1486119 generated at07/12/2012 20:35:27 needed for thread 1ORA-00289: suggestion :/DBSoft/product/10.2.0/db_1/dbs/arch1_1_788474127.dbfORA-00280: change 1486119 for thread 1 isin sequence #1  ORA-00279: change 1487388 generated at07/12/2012 21:31:17 needed for thread 1ORA-00289: suggestion :/DBSoft/product/10.2.0/db_1/dbs/arch1_1_788477477.dbfORA-00280: change 1487388 for thread 1 isin sequence #1  Log applied.Media recovery complete.SQL> 6、执行完恢复之后，SCN被清空SQL> select current_scn from v$database; CURRENT_SCN-----------         0 7、这个时候我们需要对redo也进行清空SQL> alter database open restlogs; 8、由此可以见得，数据已经恢复回来了：SQL> select * from tab; TNAME                          TABTYPE  CLUSTERID------------------------------ -----------------WWL001                         TABLEWWL002                         TABLEWWL003                         TABLEWWL004                         TABLEWWL005                         TABLE SQL> select * from wwl005;        ID NAME---------- ------------        1 wwl        2 prodence        3 woo        4 xgx        5 cms SQL> 相关阅读：探索Oracle之RMAN_01概念 http://www.linuxidc.com/Linux/2012-05/60530.htm探索Oracle之RMAN_02基本使用 http://www.linuxidc.com/Linux/2012-05/60578.htm??索Oracle之RMAN_03非一致性备份 http://www.linuxidc.com/Linux/2012-05/61025.htm探索Oracle之RMAN_04非一致性备份 http://www.linuxidc.com/Linux/2012-05/61180.htm探索Oracle之RMAN_05增量备份 http://www.linuxidc.com/Linux/2012-05/61181.htm探索Oracle之RMAN_06备份策略 http://www.linuxidc.com/Linux/2012-05/61450.htm探索Oracle之RMAN_07单个数据文件丢失恢复 http://www.linuxidc.com/Linux/2012-06/63524.htm探索Oracle之RMAN_07整个业务表空间丢失恢复 http://www.linuxidc.com/Linux/2012-07/64582.htm探索Oracle之RMAN_07 磁盘损坏数据丢失恢复 http://www.linuxidc.com/Linux/2012-07/64588.htm探索Oracle之RMAN_07 数据库所有文件全部丢失恢复 http://www.linuxidc.com/Linux/2012-07/64587.htm探索Oracle之RMAN_07 重做日志redu文件丢失恢复 http://www.linuxidc.com/Linux/2012-07/64586.htm探索Oracle之RMAN_07 参数文件丢失恢复 http://www.linuxidc.com/Linux/2012-07/64585.htm探索Oracle之RMAN_07控制文件丢失恢复 http://www.linuxidc.com/Linux/2012-07/64584.htm探索Oracle之RMAN_07 system表空间丢失恢复 http://www.linuxidc.com/Linux/2012-07/64583.htm探索Oracle不完全恢复之--基于SCN恢复 第一篇探索Oracle不完全恢复之--基于cancel恢复 第一篇相关资讯      Oracle不完全恢复 
  • Oracle数据库完全恢复和不完全恢复  （09/29/2014 20:13:21）
  • 探索Oracle不完全恢复之--基于  （07/31/2012 21:01:22）
  • 探索Oracle不完全恢复之--基于SCN  （07/31/2012 20:58:32）
  • 探索Oracle不完全恢复之--基于备份  （07/31/2012 21:02:22）
  • 探索Oracle不完全恢复之--基于  （07/31/2012 21:00:44）
  • 探索Oracle不完全恢复之--基于时间  （07/31/2012 20:57:33）
本文评论 查看全部评论 （0）
表情： 姓名： 字数