使用flashback闪回删除掉数据的表SQL>SELECT current_scn from v$database; // 查看数据库SCN SQL>ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS'; //更改时间格式 SQL>select * from table1 as of scn XXXX; SQL>select * from table1 as of timestamp '2009/02/09 16:30:00';
可以恢复的,用闪回恢复数据。闪回恢复 SQL>select current_scn from v$database; //查看数据scn SQL>alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; SQL>select sysdate from dual; SQL>select * from table1 as of scn xxxx; SQL>select * from table1 as of timestamp '2009-02-08 14:12:23'
可以的,我试过了啊,linux下oracle10G或者oracle 11G的都可以的。
可以恢复,如果你是再归档模式下 可以flashback恢复或rman恢复
9i以下的版本需要有归档日志才行 10g以上有回闪功能,使用flashback命令可恢复
再归档模式下 可以flashback恢复或rman恢复 例如: SQL>select current_scn from v$database; //查看数据scn SQL>alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; SQL>select sysdate from dual; SQL>select * from table1 as of scn xxxx; SQL>select * from table1 as of timestamp '2009-02-08 14:12:23' 如果是非归档那就恢复不了了。
dml是:insert,update,delete
truncate table 是ddl数据定义语言
// 查看数据库SCN
SQL>ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS';
//更改时间格式
SQL>select * from table1 as of scn XXXX;
SQL>select * from table1 as of timestamp '2009/02/09 16:30:00';
SQL>alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
SQL>select sysdate from dual;
SQL>select * from table1 as of scn xxxx;
SQL>select * from table1 as of timestamp '2009-02-08 14:12:23'
可以的,我试过了啊,linux下oracle10G或者oracle 11G的都可以的。
可以flashback恢复或rman恢复
10g以上有回闪功能,使用flashback命令可恢复
可以flashback恢复或rman恢复
例如:
SQL>select current_scn from v$database; //查看数据scn
SQL>alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
SQL>select sysdate from dual;
SQL>select * from table1 as of scn xxxx;
SQL>select * from table1 as of timestamp '2009-02-08 14:12:23'
如果是非归档那就恢复不了了。