Oracle如何開(kāi)啟閃回功能？首先，檢查flashback是否已啟用：SQL> select flashback uuon from V$database flashback uuu如果已啟用fl

Oracle如何開(kāi)啟閃回功能？

首先，檢查flashback是否已啟用：SQL> select flashback uuon from V$database flashback uuu如果已啟用flashback，則不需要執(zhí)行以下操作。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

首先，關(guān)閉數(shù)據(jù)庫(kù)：打開(kāi)時(shí)立即關(guān)閉以裝入狀態(tài)：startupmount修改FLASHBACK函數(shù)：alter database FLASHBACK on open database:alter datebase open