s*********1 发帖数: 103 | 1 小弟不小心在几个表里deleted some rows in oracle, 试了试flashback, 还是解不了
问题,求高人指点。
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
昨天 //SQL> delete from plus_purl_request where id_of_job = 'CBG100049';
今天//SQL> select * from plus_purl_request where id_of_job = 'CBG100049';
no rows selected
SQL> alter table plus_purl_request enable row movement;
Table altered.
SQL> FLASHBACK TABLE plus_purl_request TO TIMESTAMP TO_TIMESTAMP('04/09/2013
19:00:00','MM/DD/YYYY HH24:MI:SS');
FLASHBACK TABLE plus_purl_request TO TIMESTAMP TO_TIMESTAMP('04/09/2013 19:
00:00','MM/DD/YYYY HH24:MI:SS')
*
ERROR at line 1:
ORA-01466: unable to read data - table definition has changed
SQL> alter database archivelog;
Database altered.
SQL> alter database flashback on;
Database altered.
SQL> FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('04/09/2013 19:30:00','MM/
DD/YYYY HH24:MI:SS');
FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('04/09/2013 19:30:00','MM/DD/
YYYY HH24:MI:SS')
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel | d*****e 发帖数: 151 | 2 只能之前的备份来恢复了。因为你操作之前没有打开flashback。 |
|