【sql】oracle运维之rman备份情况统计
来源:互联网 发布:php iis配置 编辑:程序博客网 时间:2024/06/06 08:43
------查看备份量
select to_char(start_time, 'yyyymmdd'),
round(sum(a.output_bytes) / 1024 / 1024 / 1024, 2) gb
from v$rman_status a
where a.start_time between trunc(sysdate - 16) and trunc(sysdate)
group by to_char(start_time, 'yyyymmdd')
order by to_char(start_time, 'yyyymmdd')
------每日归档量
select to_char(first_time, 'yyyymmdd'),
round(sum(blocks * block_size / 1024 / 1024 / 1024), 2) as gb
from v$archived_log
where first_time between trunc(sysdate - 8) and trunc(sysdate)
group by to_char(first_time, 'yyyymmdd') order by to_char(first_time, 'yyyymmdd')
-----asm空间量
select name, round(free_mb / 1024, 2) gb from v$asm_diskgroup where name = 'BAK'
select to_char(start_time, 'yyyymmdd'),
round(sum(a.output_bytes) / 1024 / 1024 / 1024, 2) gb
from v$rman_status a
where a.start_time between trunc(sysdate - 16) and trunc(sysdate)
group by to_char(start_time, 'yyyymmdd')
order by to_char(start_time, 'yyyymmdd')
------每日归档量
select to_char(first_time, 'yyyymmdd'),
round(sum(blocks * block_size / 1024 / 1024 / 1024), 2) as gb
from v$archived_log
where first_time between trunc(sysdate - 8) and trunc(sysdate)
group by to_char(first_time, 'yyyymmdd') order by to_char(first_time, 'yyyymmdd')
-----asm空间量
select name, round(free_mb / 1024, 2) gb from v$asm_diskgroup where name = 'BAK'
阅读全文
0 0
- 【sql】oracle运维之rman备份情况统计
- ORACLE 之 rman 备份加密
- oracle学习之:RMAN备份
- oracle学习笔记之_如何在脱机情况下用rman备份oracle数据库
- Oracle RMAN物理备份之RMAN增量备份
- Oracle之rman备份方式半功略
- oracle备份恢复之rman恢复到异机
- oracle备份恢复之rman恢复到异机
- Oracle学习之:Rman备份策略
- ORACLE RMAN备份失败之ORA-19599
- Oracle RMAN物理备份之RMAN配置的含义
- oracle基础--rman服务器管理的备份之备份加密
- ORACLE空间使用情况统计的SQL
- Oracle RMAN 备份命令
- ORACLE 数据库备份----------------rman
- Oracle RMAN备份脚本
- oracle rman增量备份
- Oracle RMan 备份
- 美观实用的 侧导航菜单样式(JS+CSS)
- Django单元测试
- 《机器学习实战》2.K-近邻算法分析与源码实现(文末附官方勘误表)
- 求x的第k位数
- Linux网络编程基础
- 【sql】oracle运维之rman备份情况统计
- 如何用电路区分 OC门与TTL
- SQL语言快速入门
- 欢迎使用CSDN-markdown编辑器
- js中的闭包
- ruby复制对象的方法(dup 和 clone)
- 依赖注入简介(二)
- LeetCode题解:309. Best Time to Buy and Sell Stock with Cooldown
- efi