dba:oracle:howtos:howto_database
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
dba:oracle:howtos:howto_database [2023/01/31 08:26] – removed - external edit (Unknown date) 127.0.0.1 | dba:oracle:howtos:howto_database [2023/01/31 08:26] (current) – ↷ Page moved from dba:oracle:howto_database to dba:oracle:howtos:howto_database dodger | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== [HOWTO] Flashback Database ====== | ||
+ | |||
+ | |||
+ | <code sql> | ||
+ | CREATE RESTORE POINT CORRUPTION_KILLER ; | ||
+ | col scn format 999999999999999 | ||
+ | SELECT NAME, SCN, TIME, DATABASE_INCARNATION#, | ||
+ | GUARANTEE_FLASHBACK_DATABASE, | ||
+ | FROM V$RESTORE_POINT; | ||
+ | </ | ||