flashback 汇总
来源:互联网 发布:知乎为什么也叫b乎 编辑:程序博客网 时间:2024/06/14 09:12
flashback query
select * from t as of timestamp to_date(sysdate,'yyyy-mm-dd hh24:mi:ss')
select * from t as of scn 46210894
flashback table
flashback table to before drop
alter table name enable row move
flashback table to scn 542640
flashback versions query中出现的伪列,放在这里备查。
scn:
select versions_operation,versions_startscn,versions_endscn,
versions_starttime,versions_endtime,versions_xid,id,name
from t versions between scn minvalue and maxvalue
--=========================================
timestamp:
select versions_operation,versions_startscn,versions_endscn,
versions_starttime,versions_endtime,versions_xid,id,name
from t versions between timestamp minvalue and maxvalue
select * form v$flash_recovery_area_usage
select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;
show parameter recover
rman target /
crosscheck archivelog all
delete expirec archivelog all
delete archivelog unitl time 'sysdate-1'
shutdown immediate;
startup mount
ater database noarchivelog;
alter database open;
shutdwn immiediate;
startup mount
alter database archivelog
archive log list
alter database open
select group#,sequence# from v$log
alter database clear unarchived logfile group 1;
- flashback 汇总
- Oracle的Flashback用法汇总
- Oracle的Flashback用法汇总
- Oracle的Flashback用法汇总
- Oracle的Flashback用法汇总
- flashback
- Flashback
- flashback
- flashback
- Flashback
- flashback
- flashback
- flashback
- flashback
- Flashback
- flashback
- flashback
- Flashback
- OCA-UNIT8-DATA
- vs 使用小技巧
- Android开发过程中如何进行算法与界面的优化?
- Web项目中解析XML文件
- OCA-UNIT9-UNDO(深入解析)
- flashback 汇总
- HTC G2 Magic 获取root权限教程
- Java中发送邮件
- hdu 2243 AC自动机+矩阵快速幂
- XP上配置Objective-c 环境
- Android4.0 Loaders使用方式解析
- Flex中解析地址栏传递的参数
- 垂直同步、绘制效率、显示器刷新频率与帧率
- MySql 自动 插入当前时间