meta données pour cette page
  •  

Ceci est une ancienne révision du document !

FLASHBACK

Prérequis
Lister les restore point
SET lines 600
col NAME format a40
SELECT NAME, TO_CHAR(SCN) SCN, TIME, DATABASE_INCARNATION#, GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE/1024/1024/1024 GB 
FROM V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE='YES';

== Lister les flashback log == <code PLSQL> SELECT log# as “Log No”, thread# as “Thread No”, sequence# as “Seq No”, name, bytes/1024/1024 as “Size(MB)”, first_change# as “First Chg No”, first_time from v$flashback_database_logfile order by first_time; </code> == Faire un Flashback == <code PLSQL> FLASHBACK DATABASE TO RESTORE POINT 'before_upgrade'; ou FLASHBACK DATABASE TO SCN 202381; </code> == supprimer un restore point == <code PLSQL> DROP RESTORE POINT good_data; </code>