一 首先檢視是否開啟閃回: SQL> select flashback_on from V$database; FLASHBACK_ON ------------------ NO 二 如果已經開啟了閃回,無須執行下面的操作。 cd /u01 mkdir flashback(生成閃回目錄) SQL> alter system set db_recovery_file_dest_size=30G scope=both; SQL> alter system set db_recovery_file_dest="/u01/flashback" scope=both; SQL> shutdown immediate SQL> startup mount SQL> alter database archivelog; SQL> alter database flashback on; SQL> alter database open; 三 再進行確認: SQL> select flashback_on from V$database; FLASHBACK_ON ------------------ YES
一 首先檢視是否開啟閃回: SQL> select flashback_on from V$database; FLASHBACK_ON ------------------ NO 二 如果已經開啟了閃回,無須執行下面的操作。 cd /u01 mkdir flashback(生成閃回目錄) SQL> alter system set db_recovery_file_dest_size=30G scope=both; SQL> alter system set db_recovery_file_dest="/u01/flashback" scope=both; SQL> shutdown immediate SQL> startup mount SQL> alter database archivelog; SQL> alter database flashback on; SQL> alter database open; 三 再進行確認: SQL> select flashback_on from V$database; FLASHBACK_ON ------------------ YES