Shulou(Shulou.com)06/01 Report--

Check to see if the database is in archive mode:

SQL > show parameter db_flashback

NAME TYPE VALUE

-

Db_flashback_retention_target integer 1440

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination / oradata/arch/matrixdg

Oldest online log sequence 65

Next log sequence to archive 0

Current log sequence 67

two。 Set flashback parameters:

SQL > show parameter db_recovery

NAME TYPE VALUE

-

Db_recovery_file_dest string / u2/oracle/fast_recovery_area

Db_recovery_file_dest_size big integer 4122M

As above: db_recovery_file_dest is the flashback path and db_recovery_file_dest_size is the flashback area size.

SQL > show parameter flashback

NAME TYPE VALUE

-

Db_flashback_retention_target integer 1440

For example, db_flashback_retention_target flashback retention time

3. Shut down the database and enable flashback

SQL > shutdown immediate

SQL > startup mount

SQL > alter database flashback on

SQL > alter database open

4. Query flashback status

SQL > select flashback_on from v$database

FLASHBACK_ON

-

YES

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.