flashback database.

最新推荐文章于 2021-04-08 07:19:00 发布

原创最新推荐文章于 2021-04-08 07:19:00 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#database #system #date #sql

ORACLE 专栏收录该内容

113 篇文章

订阅专栏

本文详细介绍了数据库闪回操作的步骤，包括设置闪回保留目标、启用归档日志、打开数据库等关键步骤，并通过SQL查询验证配置是否生效。演示了如何在特定SCN下进行闪回操作及关闭闪回功能。

1. setup

conn /as sysdba;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT EXCLUSIVE;
ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=90000 SCOPE=BOTH;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE FLASHBACK ON;
ALTER DATABASE OPEN;
PROMPT complete.

2. before operation,execute the follow sql and record the result:

SELECT flashback_on FROM v$database;
SELECT to_char(SYSDATE,'yyyy/mm/dd hh24:mi:ss') as current_time FROM dual;
SELECT CURRENT_SCN FROM V$DATABASE;
PROMPT complete.

3. after operation,replace the scn as the 1 step.

conn /as sysdba;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT EXCLUSIVE;
FLASHBACK DATABASE TO SCN 150400957; 
--or FLASHBACK DATABASE TO TIMESTAMP(to_date('20111130130000','yyyymmddhh24miss'));
alter database open resetlogs;
PROMPT complete.

4. deconfig

conn /as sysdba;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT EXCLUSIVE;
ALTER DATABASE FLASHBACK OFF;
ALTER DATABASE NOARCHIVELOG;
ALTER DATABASE OPEN;
PROMPT complete.