oracle flashback database
来源:互联网 发布:学生 阿里云 编辑:程序博客网 时间:2024/05/22 04:42
这里简单介绍下flashback database,这个既可以在RMAN中执行,也可以再SQL*PLUS执行,有时候还是挺实用的
必备条件:
1:必须是归档模式
2:必须指定flash recovery area
SQL> show parameter db_recovery
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
db_recovery_file_dest string /app/oracle/flash_recovery_area --闪回区路径,如果是RAC,放在共享存储中
db_recovery_file_dest_size big integer 10G --闪回区大小,该空间大小建议可以放入所有数据库文件
以上参数的设置相信大家都会alter system set xxxxxx='';接下来介绍下打开闪回功能:
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38759: Database must be mounted by only one instance and not open.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 5049942016 bytes
Fixed Size 2090880 bytes
Variable Size 1375733888 bytes
Database Buffers 3657433088 bytes
Redo Buffers 14684160 bytes
Database mounted.
SQL> 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.
SQL> alter database archivelog;
Database altered.
SQL> alter database flashback on;
Database altered.
SQL> alter database open;
Database altered.
SQL> alter database force logging;
Database altered.
SQL> SELECT FLASHBACK_ON,FORCE_LOGGING FROM V$DATABASE;
FLASHBACK_ON FOR
------------------ ---
YES YES
相信大家看的很明白了,一定是要在mount模式,而且归档一定要打开,数据库要force logging。
SQL> set num 16
SQL> SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER FROM DUAL;
GET_SYSTEM_CHANGE_NUMBER
------------------------
122693676204
SQL> conn test/test
Connected.
SQL> select table_name from user_tables;
TABLE_NAME
------------------------------
TB2
FLASH_VERSION
TB1
TBL_ORACLE_FDW
SQL> drop table tb1 purge;
Table dropped.
SQL> drop table tb2 purge;
Table dropped.
SQL> conn /as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 5049942016 bytes
Fixed Size 2090880 bytes
Variable Size 1375733888 bytes
Database Buffers 3657433088 bytes
Redo Buffers 14684160 bytes
Database mounted.
SQL> FLASHBACK DATABASE TO SCN 122693676204 ;
Flashback complete.
SQL> alter database open resetlogs;
Database altered.
SQL> conn test/test
Connected.
SQL> select table_name from user_tables;
TABLE_NAME
------------------------------
TB2
FLASH_VERSION
TB1
TBL_ORACLE_FDW
可以看到TB1和TB2都回来了,好了flashback的使用就介绍到这里
- Oracle Flashback之Flashback database
- Oracle Flashback之flashback database
- oracle flashback database
- oracle flashback database
- ORACLE FLASHBACK DATABASE 总结
- oracle dg flashback database
- Oracle Flashback技术之Flashback Database
- ORACLE FLASHBACK DATABASE 知识整理
- Oracle Flashback技术总结(一)—— Flashback Database
- Oracle flashback database to scn 实战
- Oracle 闪回特性(FLASHBACK DATABASE)
- Oracle Flashback Database and Restore Points 说明
- Oracle Flashback Database闪回恢复
- Oracle 闪回特性(FLASHBACK DATABASE)
- Oracle 闪回特性(FLASHBACK DATABASE)
- Oracle 闪回特性(FLASHBACK DATABASE)
- Oracle 闪回特性(FLASHBACK DATABASE)
- Oracle 闪回特性(FLASHBACK DATABASE)
- anroid 利用方向传感器或者加速度传感器实现手机或者平板6个方向操作
- Closed-form Solution
- oracle 备份恢复概要介绍
- c#链接Oracle
- http 之session和cookie
- oracle flashback database
- 超过上百假《钢铁侠3》影片在线观看网站,不断跳出广告并骗取你的信息
- Android编程心得-SharedPreference中putStringset存取数据
- Word中的EQ域输入公式详解
- C++之模板
- android 屏幕分辨率问题
- phonegap for ios 建立、打包、运行详细流程 黑喂狗
- RedHat Linux磁盘空间不足 和 挂载新硬盘方法
- 使用eclipse生成java doc文档 【转】