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;"
Tuesday, March 14, 2006
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment