Tuesday, March 14, 2006

Step flashback on

when You want to flashback on

- on archivelog
- check db_recovery_file_dest and db_recovery_file_dest_size parameters
- shutdown database
- startup mount
- alter database archivelog;
- alter database open;
- shutdown ;
- startup mount;
- alter database flashback on;
- alter database open;
- check status from

select flashback_on from v$database;
FLA
---
YES

- monitor "select * from v$recovery_file_dest;"

No comments: