Databases Reference
In-Depth Information
SQL> select name, DATABASE_INCARNATION#, SCN, time
2 from v$restore_point
3 order by scn;
NAME DATABASE_INCARNATION# SCN TIME
---------- --------------------- ---------- --------------------------------
RP1 2 2193924 21-JUL-12 05.39.31.000000000 PM
GRP1 2 2194050 21-JUL-12 05.44.48.000000000 PM
GRP2 2 2194061 21-JUL-12 05.44.58.000000000 PM
RP2 2 2194077 21-JUL-12 05.45.16.000000000 PM
GRP3 2 2195811 21-JUL-12 06.19.15.000000000 PM
GRP4 2 2195894 21-JUL-12 06.19.47.000000000 PM
GRP5 2 2196549 21-JUL-12 06.39.20.000000000 PM
GRP6 2 2196630 21-JUL-12 06.40.30.000000000 PM
GRP7 3 2197224 03-AUG-12 11.04.38.000000000 PM
GRP8 3 2197263 03-AUG-12 11.05.33.000000000 PM
RP9 3 2197281 03-AUG-12 11.05.50.000000000 PM
GRP11 4 2199532 04-AUG-12 01.34.37.000000000 AM
... and so on ...
The various columns of the view are described in the “How It Works” section.
How It Works
When you create a restore point as guaranteed, the database marks the flashback logs as not to be removed when the
fast recovery area runs out of space. The space occupied by these specially marked flashback logs is shown under the
column STORAGE_SIZE in the view V$RESTORE_POINT.
Table
13-3
describes the columns of the view V$RESTORE_POINT.
Table 13-3.
Columns of V$RESTORE_POINT
Column Name
Description
SCN
This is the SCN of the database when the restore point was created.
DATABASE_INCARNATION#
This column displays the incarnation of the database when this restore
point was created. If the database was flashed back and then opened
with
resetlogs
, it creates a new incarnation of the database.
GUARANTEE_FLASHBACK_DATABASE
If the restore point is a guaranteed one, this column holds the value
YES
.
STORAGE_SIZE
This is the storage occupied by the flashback logs of the guaranteed
restore points. In case of normal restore points, this value is 0.
TIME
This is the timestamp when the restore point was created.
NAME
This is the name of the restore point.
PRESERVED
This is a new column in Oracle Database 11g. It shows whether the
restore point must be explicitly deleted.
RESTORE_POINT_TIME
This shows whether you specified a specific time when the restore point
was supposed to be taken. If you didn't specify a time, it's NULL.
CON_ID
The container ID in case of Oracle Database 12.1 and above.
