A SCN can be useful to determine to which point in time an imcomplete recovery must be execute. Prior to a test or something dangerous, you can query your SCN so you can recovery or flashback to this SCN discarding changes to your database. The current SCN can be queried as follows:
SQL> select current_scn from v$database ;
CURRENT_SCN
-----------
927043
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment