flashback database to restore point guarantee database

SQL*Plus: Release 12.1.0.1.0 Production on Wed Apr 29 20:48:28 2020

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


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 before_upgrade guarantee flashback database;

Restore point created.

SQL> update hr.prueba set salary=99999;

107 rows updated.

SQL> commit;

Commit complete.

SQL> drop table hr.prueba;

Table dropped.

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed Apr 29 20:50:55 2020

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

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> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  835104768 bytes

Fixed Size     2293880 bytes

Variable Size   658509704 bytes

Database Buffers   171966464 bytes

Redo Buffers     2334720 bytes

Database mounted.

SQL> exit

[oracle@localhost ~]$ rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Wed Apr 29 20:51:44 2020

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

connected to target database: ORCL (DBID=1376021099, not open)

RMAN> list restore point all;

using target database control file instead of recovery catalog

SCN              RSP Time  Type       Time      Name

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

5733192                    GUARANTEED 29-APR-20 BEFORE_UPGRADE

RMAN> flashback database to restore point before_upgrade;

Starting flashback at 29-APR-20

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=21 device type=DISK

starting media recovery

media recovery complete, elapsed time: 00:00:01

Finished flashback at 29-APR-20

RMAN> alter database open resetlogs;

Statement processed

RMAN> 

RMAN> list restore point all;

using target database control file instead of recovery catalog

SCN              RSP Time  Type       Time      Name

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

3886948                    GUARANTEED 25-JUL-20 BEFORE_UPGRADE

RMAN> 

RMAN> drop restore point BEFORE_UPGRADE;

Statement processed

RMAN>