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';

<br />

Lister les flashback log
 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;
Faire un Flashback
FLASHBACK DATABASE TO RESTORE POINT 'before_upgrade';
ou
FLASHBACK DATABASE TO SCN 202381;
supprimer un restore point
DROP RESTORE POINT good_data;