flashback database.

最新推荐文章于 2023-08-03 13:52:47 发布

yfleng2002

最新推荐文章于 2023-08-03 13:52:47 发布

阅读量1k

点赞数

分类专栏： ORACLE 文章标签： database system date sql

本文链接：https://blog.csdn.net/yfleng2002/article/details/7028109

版权

ORACLE 专栏收录该内容

113 篇文章 1 订阅

订阅专栏

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.