SLTechnology News&Howtos › Database ›

Oracle turns on flashback

Shulou Source: shulou.com Published: 2022-06-01 11:57:26 10月04日 Update

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