Enable Flashback Database Oracle 10g

SQL> select * from v$flashback_database_log;

SQL> show parameter db_file

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=2g;

System altered.

SQL>  alter system set db_recovery_file_dest=’/rman/ora_flashback’;

System altered.

shutdown immediate;

startup mount;

SQL> alter system set db_flashback_retention_target=4320;
#for retaining for 3 days

System altered.

SQL> alter database flashback on;

Database altered.

SQL> alter database open;

Database altered.

Advertisements

One thought on “Enable Flashback Database Oracle 10g

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s