First page Back Continue Last page Graphics

...SRR Architectural Changes...

V$LOG_HISTORY and V$OFFLINE_RANGE
- Not cleared during RESETLOGS
- New columns RESETLOGS_CHANGE# and RESETLOGS_TIME
V$DATABASE_INCARNATION
- Records parent/child relationship of incarnations
- RESETLOGS ID for each incarnation
- New column FLASHBACK_DATABASE_ALLOWED
  - Possible to flashback to some point in that incarnation?

Notes:

Architecture changes (continued):
Dynamic performance views V$LOG_HISTORY and V$OFFLINE_RANGE are not cleared by RESETLOGS operations.
The V$LOG_HISTORY and V$OFFLINE_RANGE views contain new columns that hold the SCN and date of the database incarnation that the log belongs to.
The dynamic performance view V$DATABASE_INCARNATION contains new columns to support the tracking of the parent / child relationship between incarnations and the RESETLOGS identifier for each incarnation. Release 2 adds a new column, FLASHBACK_DATABASE_ALLOWED, which is demonstrated next in this lesson.