Tuesday, October 22, 2013

Activating flashback feature in Oracle 10g

Here are steps used to activate the flashback feature in oracle 10g.

1.Enable archivelog mode
2.Configure the flash recovery area
3. > shutdown immedaite;
4. > startup mount;
5. > alter database flashback on;
6. > alter database open;
7. > select flashback_on from v$database;
8. > alter database flashback off;

No comments:

Post a Comment