Shulou(Shulou.com)05/31 Report--

This article will explain in detail the analysis of flashback flashback technology for you. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

# # enabling flasbback

SQL > alter system set db_recovery_file_dest_size=80g scope=spfile

Set the flashback zone location:

SQL > alter system set db_recovery_file_dest='/workdb/account_flashback_area' scope=spfile

Set the flashback target to 5 days, in minutes, and 1440 minutes per day:

SQL > alter system set db_flashback_retention_target=7200 scope=spfile

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup mount

ORACLE instance started.

Total System Global Area 1056411648 bytes

Fixed Size 2257584 bytes

Variable Size 612371792 bytes

Database Buffers 436207616 bytes

Redo Buffers 5574656 bytes

Database mounted.

SQL > alter database flashback on; # turn off alter database flashback off

Database altered.

SQL > alter database open

# # query the current scn number

SQL > select CURRENT_SCN from v$database

CURRENT_SCN

-

724633

# # query the current log sequence number

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination + ARCH1

Oldest online log sequence 30

Next log sequence to archive 32

Current log sequence 32

# restore database through flashback

Startup mount

# # restore to a specified time point

Flashback database to timestamp (to_date ('2010-01-01 20 HH24:MI:SS'))

Flashback database to timestamp (sysdate-1/24); # # revert to an hour ago

# # restore to the specified SCN

Flashback database to scn *

# # restore to a certain log sequence

Flashback database to sequence=**** thread=1

Alter database open resetlogs

# restore the table through flashback

# # restore deleted tables through flashback, if cyclebin has been enabled

Flashback table to before drop [rename to]

# # go back to one hour ago

Flashback table to timestamp (system-1/24)

# # multiple tables fall back to a specified point in time at the same time

Flashback table to timestamp (system-1/24/60); # # go back to 1 minute ago

# # fallback to the specified scn

Flashback table to scn *

# # fallback starts when it starts

Flashback table to scn * enable triggers

This is the end of the analysis of flashback flashback technology. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

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.