www.eygle.com

« PowerPoint不能输入中文 - 令人抓狂的诡异 | Blog首页 | 10.2.0.4 LGWR Trace Warning: Log Write Time »

工作日志：闪回查询及scn_to_timestamp

作者：eygle |【转载时请以超链接形式标明文章出处和作者信息及本声明】
链接：http://www.eygle.com/archives/2009/11/scn_to_timestamp.html

---

上周在培训期间，一个客户的数据库出了误UPDATE的问题，修改错了数据，请求我帮忙恢复。

闪回查询在这类误操作中非常有用，只要发现的及时，数据可以快速的闪回回来，我想这是开发人员也应该掌握的SQL查询。

记录一下工作日志：

SQL> desc lm_mtrp_syn_channelinfo
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 CHANNELID                                          NUMBER
 SGWID                                              VARCHAR2(50)
 SERVICETYPE                                        VARCHAR2(50)
 SPNUMBER                                           VARCHAR2(50)
 CMD                                                VARCHAR2(50)
 CREATETIME                                         DATE
 MORE                                               VARCHAR2(500)

SQL> select count(*) from lm_mtrp_syn_channelinfo;

  COUNT(*)
----------
        21

SQL> select dbms_flashback.get_system_change_number from dual;

GET_SYSTEM_CHANGE_NUMBER
------------------------
               708677858

SQL> select count(*) from lm_mtrp_syn_channelinfo as of scn 708600000;            

  COUNT(*)
----------
        21

SQL> select count(*) from lm_mtrp_syn_channelinfo as of scn 708000000;

  COUNT(*)
----------
        21

SQL> select scn_to_timestamp(708000000) from dual;

SCN_TO_TIMESTAMP(708000000)
---------------------------------------------------------------------------
05-NOV-09 01.37.08.000000000 PM

SQL> create table lm_temp as select * from lm_mtrp_syn_channelinfo as of scn 708000000;

Table created.

-The End-

By eygle on 2009-11-11 14:28 | Comments (3) | Posted to FAQ | Edit |

相关文章	随机文章
Oracle11g的新特性:Database和SQL重演(replay) 修改默认的undo_retention参数设置 How to maintain Oracle10g Recyclebin? Oracle10g New Feature:闪回恢复区空间管理 Oracle 10gR2 Study Notes:New View V$FLASH_RECOVERY_AREA_USAGE	Install MT plugins-Scode 1 SUN的DISKSUITE IT168约以100万美元收购ITPUB 墨墨恢复健康 - 病好了 周末看片-关于莉莉周的一切

留言 (3)

Posted by: l1t at November 12, 2009 11:12 AM

Posted by: 安佰胜 at November 12, 2009 4:33 PM

Posted by: 安佰胜 at November 12, 2009 4:36 PM

发表留言:

Name(*):
Email(*):

You Link: Remember Me? YesNo
验证码(*): (输入验证码后方可评论,谢谢支持)
Comments: