RESTORE POINT GOOD_DATA - FLASHBACK TABLE TO RESTORE POINT

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> create restore point good_data;

Restore point created.

SQL> show user;

USER is "SYS"

SQL> 

SQL> update prueba set salary=30000;

update prueba set salary=30000

       *

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> update hr.prueba set salary=30000;

107 rows updated.

SQL> commit;

Commit complete.

SQL> flashback table hr.prueba to restore point good_data;

flashback table hr.prueba to restore point good_data

                   *

ERROR at line 1:

ORA-08189: cannot flashback the table because row movement is not enabled

SQL> alter table hr.prueba enable row movement;

Table altered.

SQL> flashback table hr.prueba to restore point good_data;

Flashback complete.

[oracle@localhost ~]$ rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Thu May 28 21:25:33 2020

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1376021099)

RMAN> list restore point all;

using target database control file instead of recovery catalog

SCN              RSP Time  Type       Time      Name

---------------- --------- ---------- --------- ----

2200587                               28-MAY-20 GOOD_DATA

RMAN> drop restore point good_data;

Statement processed

RMAN> list restore point all;

SCN              RSP Time  Type       Time      Name

---------------- --------- ---------- --------- ----

RMAN>