关于Flashback database --闪回数据库

最新推荐文章于 2024-06-10 11:15:00 发布

甲骨文可乐

最新推荐文章于 2024-06-10 11:15:00 发布

阅读量709

点赞数

分类专栏：做程序员时积累的Oracle

本文链接：https://blog.csdn.net/u011316319/article/details/9276965

版权

做程序员时积累的Oracle 专栏收录该内容

154 篇文章 1 订阅

订阅专栏

地址：http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9011.htm#SQLRF01801

FLASHBACKDATABASE

Purpose---目的

Use the FLASHBACK DATABASEstatement to return the database to a past time or system changenumber (SCN). This statement provides a fast alternative toperforming incomplete database recovery.

Following a FLASHBACK DATABASEoperation, in order to have write access to the flashed backdatabase, you must reopen it with anALTERDATABASE OPEN RESETLOGSstatement.

注意：使用FLASHBACKDATABASE来闪回数据库，其实是相当一个不完全恢复。但如果文件因介质损坏而丢失，那么只能使用RMAN来恢复，任何闪回的方法都毫无用处，包括flashbackdatabase的不完全恢复。

Prerequisites----应用它的先决条件

You must have the SYSDBA system privilege.A flash recovery area must have been prepared for the database. Thedatabase must have been put inFLASHBACK mode with anALTER DATABASE FLASHBACKON statement unless you are flashing the database backto a guaranteed restore point. The database must be mounted but notopen.

Syntax

flashback_database::=

Description of flashback_database.gif follows
Description of the illustrationflashback_database.gif

TO TIMESTAMPClause

Specify a valid datetime expression.

TO TIMESTAMP reverts the database back to its stateat the specified timestamp.
TO BEFORE TIMESTAMP reverts the database back toits state one second before the specified timestamp.

You can represent the timestamp as an offset from adeterminate value, such asSYSDATE, or as an absolutesystem timestamp.--你可以指定一个确定的类型的值，比如SYSDATA,或者一个绝对系统时间戳来作为TIMESTAMP的值。

文档地址：http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_1004.htm#i2155821

FLASHBACKON Use this clause to putthe database inFLASHBACK mode. When the database isin FLASHBACK mode, Oracle Database automaticallycreates and manages Flashback Database logs in the flash recoveryarea. Users withSYSDBA system privilege can thenissue a FLASHBACK DATABASE statement.

FLASHBACKOFF Use this clause to take the database out ofFLASHBACK mode. Oracle Database stops loggingFlashback data and deletes all existing Flashback Database logs.Any attempt to issue a FLASHBACK DATABASEwill fail with an error.