1、rac資料庫調整為歸檔模式步驟:
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資料庫啟動閃回特性步驟:
确認資料已經運作在歸檔模式中:
sql> archive log list;
sql> alter database flashback on;
注意:可以根據需要為特定的表空間打開或關閉閃回:
sql> alter tablespace users flashback on;
sql> alter tablespace users flashback off;
sql> select name,log_mode,flashback_on from v$database;
最新内容請見作者的github頁:http://qaseven.github.io/