flashback database.
发布时间:2020-12-15 06:34:04 所属栏目:百科 来源:网络整理
导读:? 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 oper
?
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.
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.
conn /as sysdba; SHUTDOWN IMMEDIATE; STARTUP MOUNT EXCLUSIVE; ALTER DATABASE FLASHBACK OFF; ALTER DATABASE NOARCHIVELOG; ALTER DATABASE OPEN; PROMPT complete. (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |