oracle 11g单表恢复

文档课题：oracle 11g单表恢复.
数据库：oracle 11.2.0.4 64位
系统：oel 7.9 64位
1、非rman方式
1.1、flashback恢复
[oracle@oel ~]$ export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
[oracle@oel ~]$ export NLS_LANG=AMERICAN
[oracle@oel ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 5 09:55:09 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> conn leo/leo;
Connected.
SQL> create table test as select * from all_objects;

Table created.

SQL> select count(*) from test;

  COUNT(*)
----------
     84209

SQL> delete from test where rownum<40000;

2000 rows deleted.

SQL> commit;

Commit complete.

SQL> select count(*) from test;

  COUNT(*)
----------
         0

SQL> conn / as sysdba    
Connected.

SQL> select count(*) from leo.test as of timestamp to_timestamp('2022-12-05 10:00:00','yyyy-mm-dd hh24:mi:ss');

  COUNT(*)
----------
     84209

SQL> flashback table leo.test to timestamp to_timestamp('2022-12-05 10:00:00','yyyy-mm-dd hh24:mi:ss');
flashback table leo.test to timestamp to_timestamp('2022-12-05 10:00:00','yyyy-mm-dd hh24:mi:ss')
                    *
ERROR at line 1:
ORA-08189: cannot flashback the table because row movement is not enabled


SQL> alter table leo.test enable row movement;

Table altered.

SQL> flashback table leo.test to timestamp to_timestamp('2022-12-05 10:00:00','yyyy-mm-dd hh24:mi:ss');

Flashback complete.

SQL> select count(*) from leo.test;

  COUNT(*)
----------
     84209
1.2、创建副表
SQL> conn leo/leo;
Connected.
SQL> host date
Mon Dec  5 10:27:50 CST 2022

SQL> delete from test;

84212 rows deleted.

SQL> commit;

Commit complete.

SQL> select count(*) from test;

  COUNT(*)
----------
         0

SQL> conn / as sysdba     
Connected.

SQL> select count(*) from leo.test as of timestamp  to_timestamp('2022-12-05 10:27:50','yyyy-mm-dd hh24:mi:ss');

  COUNT(*)
----------
     84212

SQL> create table leo.testbak as select * from leo.test as of timestamp to_timestamp('2022-12-05 10:27:50','yyyy-mm-dd hh24:mi:ss');

Table created.

SQL> conn leo/leo;
Connected.
SQL> select count(*) from testbak;

  COUNT(*)
----------
     84212

说明：创建的副表不会有原表存在的主键等约束.
参考网址：https://www.jianshu.com/p/9eb51510b1fc