41 lines
1.6 KiB
Plaintext
Executable File
41 lines
1.6 KiB
Plaintext
Executable File
-- create a Restore Point guarantee
|
|
create restore point BEFORE_BILLING_FUEL guarantee flashback database;
|
|
|
|
-- drop a Restore Point
|
|
drop restore point BEFORE_BILLING_FUEL;
|
|
|
|
-------------------------------
|
|
-- list Restore Points
|
|
-- based on Vishal Gupta script
|
|
-------------------------------
|
|
set lines 180 pages 100
|
|
|
|
DEFINE BYTES_FORMAT="9,999,999"
|
|
DEFINE BYTES_HEADING="MB"
|
|
DEFINE BYTES_DIVIDER="1024/1024"
|
|
|
|
PROMPT *****************************************************************
|
|
PROMPT * Restore Points
|
|
PROMPT *****************************************************************
|
|
|
|
COLUMN time HEADING "Time" FORMAT a18
|
|
COLUMN name HEADING "Name" FORMAT a40
|
|
COLUMN guarantee_flashback_database HEADING "Guar|ant'd" FORMAT a5
|
|
COLUMN preserved HEADING "Pre|ser|ved" FORMAT a3
|
|
COLUMN restore_point_time HEADING "Restore|Point|Time" FORMAT a18
|
|
COLUMN scn HEADING "SCN" FORMAT 999999999999999
|
|
COLUMN database_incarnation# HEADING "DB|Inc#" FORMAT 9999
|
|
COLUMN storage_size HEADING "Size(&&BYTES_HEADING)" FORMAT &&BYTES_FORMAT
|
|
|
|
SELECT TO_CHAR(r.time,'DD-MON-YY HH24:MI:SS') time
|
|
, r.name
|
|
, r.guarantee_flashback_database
|
|
, r.preserved
|
|
, r.database_incarnation#
|
|
, r.scn
|
|
, (r.storage_size)/&&BYTES_DIVIDER storage_size
|
|
, TO_CHAR(r.restore_point_time,'DD-MON-YY HH24:MI:SS') restore_point_time
|
|
FROM v$restore_point r
|
|
ORDER BY r.time
|
|
;
|