事先配置上ASM的+RECOVERY,使用前提必须启用归档模式。
安装的时候可以选择启用,如果没设置按照下面手工设置:
*******************************************************************
alter system set db_recovery_file_dest_size=2G;
alter system set db_recovery_file_dest='+RECOVERY' scope=spfile sid='*';
************************************************************************
注:在RAC环境下,只需要启动其中一个节点操作即可,另外一个节点要关闭,不然会抛出错误,如下:
SQL> alter database flashback on;
alter database flashback
on
*
ERROR at line 1:
ORA-38777: database must not be started in any
other instance.
*********************************************************
export ORACLE_SID=rac1
sqlplus /nolog
conn /as sysdba
shutdown immediate
startup mount
alter databae flashback on;
alter database open;
启动另外被关闭的节点
***********************************************************
查看结果
SQL> show parameter db
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TRUE
db_block_size integer 8192
db_cache_advice string ON
db_cache_size big integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string +DATA
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
db_domain string
db_file_multiblock_read_count integer 16
db_file_name_convert string
db_files integer 200
db_flashback_retention_target integer 1440
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_keep_cache_size big integer 0
db_name string rac
db_recovery_file_dest string +RECOVERY
db_recovery_file_dest_size big integer 2G
db_recycle_cache_size big integer 0
db_unique_name string rac
db_writer_processes integer 1
dbwr_io_slaves integer 0
rdbms_server_dn string
standby_archive_dest string /rac2_arch
standby_file_management string MANUAL
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
-------------------------------
关闭
------
关闭flashback:
关闭数据库:
SQL>shutdown immediate
启动到mount方式
SQL>startup mount;
关闭闪回
SQL> alter database flashback off;
关于Oracle闪回的打开和关闭,主要就是需要注意以下几点:
1、闪开打开的前提是数据库归档必须打开
2、闪回打开/关闭和归档打开/关闭一样,都是在mount模式下
3、如果要在打开闪回的数据库上关闭归档则必须先关闭依赖于归档的闪回功能
查看flashback是否开启:select name,flashback_on from v$database; 查看闪回恢复区及大小是否设置:show parameter db_recovery; 先设置闪回恢复区的大小:alter system set db_recovery_file_dest_size='2G'; 再设置闪回恢复区路径:alter system set db_recovery_file_dest='E:\oracle\product\10.2.0\db_recovery_file_dest'; 设置数据库回退的时间,默认1440分钟为一天时间:alter system set db_flashback_retention_target = 1440;