oracle闪回时间限制 Oracle如何开启闪回功能？

Oracle如何开启闪回功能？首先，检查flashback是否已启用：SQL> select flashback uuon from V$database flashback uuu如果已启用fl

Oracle如何开启闪回功能？

首先，检查flashback是否已启用：SQL> select flashback uuon from V$database flashback uuu如果已启用flashback，则不需要执行以下操作。CD/u01 MKDIR flashback SQL> alter system set DBurecoveryufileudestsize=30G scope=both SQL> alter system set DBurecoveryufileu01/flashback scope=both SQL> shutdown immediate SQL> startup mount SQL> alter database archivelog SQL> alter database flashback on SQL> alter database openuon fromV$database FLASHBACK命令如下：SQL>alter database FLASHBACK on SQL>alter database FLASHBACK off

首先，关闭数据库：打开时立即关闭以装入状态：startupmount修改FLASHBACK函数：alter database FLASHBACK on open database:alter datebase open