一、启用闪回数据库
闪回数据库相关参数db_flashback_retention_target,意为闪回日志的保留期限,单位为分钟
1)修改闪回日志的保存目标为2天
SYS@ORA10G>show parameter flash
NAME TYPE VALUE
------------------------------------ ----------- ---------------
db_flashback_retention_target integer 1440
SYS@ORA10G>
SYS@ORA10G>alter system set db_flashback_retention_target=2880;
System altered.
SYS@ORA10G>
SYS@ORA10G>show parameter flash
NAME TYPE VALUE
------------------------------------ ----------- ---------------
db_flashback_retention_target integer 2880
SYS@ORA10G>
2)查看是否开启闪回,未开启,在mount模式下启动闪回
SYS@ORA10G> select flashback_on from v$database;
FLASHBACK_ON
------------------
NO
SYS@ORA10G>
SYS@ORA10G> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@ORA10G>
SYS@ORA10G> startup mount;
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 1219184 bytes
Variable Size 121636240 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
Database mounted.
SYS@ORA10G>
3)启动闪回,报错,数据库要求在归档模式,启动归档
SYS@ORA10G>alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38707: Media recovery is not enabled.
SYS@ORA10G>
SYS@ORA10G>archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 3
Current log sequence 5
SYS@ORA10G>
SYS@ORA10G>alter database archivelog;
Database altered.
SYS@ORA10G>
4)启动闪回数据库
SYS@ORA10G> alter database flashback on;
Database altered.
SYS@ORA10G> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
SYS@ORA10G> alter database open;
Database altered.
SYS@ORA10G>
二、闪回数据库的步骤
1)关闭数据库
2)启动数据库到mount状态[exclusive模式]
3)闪回至某个时间点,SCN或还原点
4)使用resetlogs打开数据库
三、
不能使用闪回数据库的情况
1)
已经还原或重新创建了控制文件
2)
已经删除了表空间
3)
已经收缩了数据文件
四、闪回数据库的方法
1)sqlplus下基于SCN闪回
FLASHBACK [STANDBY] DATABASE [] TO
[BEFORE] SCN
2)
sqlplus下
基于时间戳闪回
FLASHBACK [STANDBY] DATABASE [] TO
[BEFORE] TIMESTMP
3)
sqlplus下
基于还原点闪回
FLASHBACK [STANDBY] DATABASE [] TO
[BEFORE] RESTORE POINT
4)RMAN下
基于时间
戳闪回
RMAN> FLASHBACK DATABASE TO TIME = "TO_DATE('2012-08-03 14:51:13','YYYY-MM-DD HH24:MI:SS')";
5)
RMAN下
基于SCN
闪回
RMAN> FLASHBACK DATABASE TO SCN=23565;
7)
RMAN下
基于:归档序号
RMAN> FLASHBACK DATABASE TO SEQUENCE=223 THREAD=1;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/685769/viewspace-749364/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/685769/viewspace-749364/