Pages

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