admin operations for restore point - flashback operations

restorepoints: Restore points.sql

--Creating Normal and Guaranteed Restore Points

CREATE RESTORE POINT before_upgrade;


CREATE RESTORE POINT before_upgrade GUARANTEE FLASHBACK DATABASE;


--Listing Restore Points
set lines 200
SELECT NAME, SCN, TIME, DATABASE_INCARNATION#,
GUARANTEE_FLASHBACK_DATABASE,STORAGE_SIZE
FROM V$RESTORE_POINT;

COLUMN scn FOR 999999999999999
COLUMN storage_size FOR 999999999999
COLUMN name FOR A40
SET PAGESIZE 60
set lines 200
SELECT NAME, SCN, TIME, DATABASE_INCARNATION#,
GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE
FROM V$RESTORE_POINT
WHERE GUARANTEE_FLASHBACK_DATABASE='YES';
      
--Dropping Restore Points

DROP RESTORE POINT before_app_upgrade;
Restore point dropped."

FLASHBACK DATABASE TO RESTORE POINT 'before_upgrade';
FLASHBACK DATABASE TO SCN 202381;