1、RAC數(shù)據(jù)庫(kù)調(diào)整為歸檔模式步驟：
SQL> alter system set cluster_database=false scope=spfile sid='orcl1'; SQL> alter system set db_recovery_file_dest='+ORAFLASH' scope=spfile; SQL> alter system set db_recovery_file_dest_size=20g scope=spfile; $ srvctl stop database -d orcl $ sqlplus / as sysdba; SQL> startup mount; SQL> alter database archivelog; SQL> alter system set cluster_database=true scope=spfile sid='orcl1'; SQL> shutdown immediate; $ srvctl start database -d orcl SQL> select name,log_mode,flashback_on from v$database; |
2、RAC數(shù)據(jù)庫(kù)啟動(dòng)閃回特性步驟：
確認(rèn)數(shù)據(jù)已經(jīng)運(yùn)行在歸檔模式中：
SQL> archive log list; SQL> alter system set cluster_database=false scope=spfile sid='orcl1'; SQL> alter system set db_recovery_file_dest='+ORAFLASH' scope=spfile; SQL> alter system set db_recovery_file_dest_size=20g scope=spfile; $ srvctl stop database -d orcl SQL> startup mount; SQL> alter database flashback on; SQL> alter system set cluster_database=true scope=spfile sid='orcl1'; SQL> shutdown immediate; $ srvctl start database -d orcl |
注意：可以根據(jù)需要為特定的表空間打開或關(guān)閉閃回：
SQL> alter tablespace users flashback on;
SQL> alter tablespace users flashback off;
SQL> select name,log_mode,flashback_on from v$database;