备案控制台
探索云世界
开发者社区 数据库 文章 正文

[20160112]rman会备份空块吗2.txt

2016-01-13 826
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： [20160112]rman会备份空块吗2.txt http://www.itpub.net/thread-2050864-1-1.html --上午zergduan拿出oracle的文档: Database Backup and Recovery Reference http://docs.

[20160112]rman会备份空块吗2.txt

http://www.itpub.net/thread-2050864-1-1.html

--上午zergduan拿出oracle的文档:

Database Backup and Recovery Reference

http://docs.oracle.com/database/121/RCMRF/rcmsynta006.htm#RCMRF107

When unused block compression is applied, RMAN reads only the blocks that are currently allocated to a table. RMAN still
checks each of the blocks to see whether the header has marked the block as unused. If a block has been unused, it is
not written to the backup.

Unused block compression is turned on automatically when all of the following five conditions are true:

The COMPATIBLE initialization parameter is set to 10.2 or higher.

Note: If COMPATIBLE is set to 10.2, then only tablespaces created with 10.2 compatibility are optimized to exclude
blocks that do not currently contain data. If COMPATIBLE is set to 11.0.0 or higher, however, then the first backup that
produces backup sets after COMPATIBLE is set to 11.0.0 or higher updates the headers of all locally managed data files
so that all locally managed data files can be optimized.

There are currently no guaranteed restore points defined for the database.

The data file is locally managed

The data file is being backed up to a backup set as part of a full backup or a level 0 incremental backup

The backup set is created on disk or Oracle Secure Backup is the media manager.

Note: When backing up to a media manager that is not Oracle Secure Backup, RMAN copies all the blocks regardless of
whether they contain data or not.

--还是以测试为准!

1.测试环境:

SCOTT@book> @ &r/ver1

PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

CREATE TABLESPACE SUGAR DATAFILE
  '/mnt/ramdisk/book/sugar01.dbf' SIZE 100M AUTOEXTEND ON NEXT 64M MAXSIZE UNLIMITED
NOLOGGING
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

--上面没有任何对象.

2.开始测试:
SCOTT@book> drop table tt1 purge ;
Table dropped.

SCOTT@book> create table tt1 tablespace sugar as select rownum id,to_char(rownum,'000000')||'TeStAb' name from dual connect by level<=2e5;
Table created.


SCOTT@book> select count(*) from tt1 ;
  COUNT(*)
----------
    200000

backup database  format '/home/oracle/backup/full1_%u' ;

$ ll -l /home/oracle/backup/full*
-rw-r----- 1 oracle oinstall 1569062912 2016-01-13 14:53:42 /home/oracle/backup/full1_1kqr9arj
-rw-r----- 1 oracle oinstall   10059776 2016-01-13 14:53:47 /home/oracle/backup/full1_1lqr9arq

$ strings full1_1kqr9arj | grep TeStAb|wc
200000  200000 2999541

SCOTT@book> truncate table tt1;
Table truncated.

SCOTT@book> alter system checkpoint;
System altered.

SCOTT@book> column PARTITION_NAME noprint
SCOTT@book> select * from dba_extents where owner=user and segment_name='TT1';
OWNER  SEGMENT_NAME          SEGMENT_TYPE       TABLESPACE_NAME   EXTENT_ID    FILE_ID   BLOCK_ID      BYTES     BLOCKS RELATIVE_FNO
------ --------------------  ------------------ ---------------- ---------- ---------- ---------- ---------- ---------- ------------
SCOTT  TT1                   TABLE              SUGAR                     0          6        128      65536          8            6

SCOTT@book> select * from V$RESTORE_POINT;
no rows selected

SCOTT@book> select flashback_on from v$database ;
FLASHBACK_ON
------------------
NO

RMAN> backup database  format '/home/oracle/backup/full2_%u' ;

$ ll -l /home/oracle/backup/full*
-rw-r----- 1 oracle oinstall 1569062912 2016-01-13 14:53:42 /home/oracle/backup/full1_1kqr9arj
-rw-r----- 1 oracle oinstall   10059776 2016-01-13 14:53:47 /home/oracle/backup/full1_1lqr9arq
-rw-r----- 1 oracle oinstall 1563312128 2016-01-13 14:56:21 /home/oracle/backup/full2_1mqr9b0h
-rw-r----- 1 oracle oinstall   10059776 2016-01-13 14:56:33 /home/oracle/backup/full2_1nqr9b10

$ strings full2_1mqr9b0h | grep TeStAb|wc
  17877   17877  268097

--与前面的帖子相互呼应,证明我的观点是对的.

3.看看增量备份的情况:
RMAN> backup incremental level 0 database format '/home/oracle/backup/full_inc0_%u';

$ ll -l /home/oracle/backup/full*
-rw-r----- 1 oracle oinstall 1569062912 2016-01-13 14:53:42 /home/oracle/backup/full1_1kqr9arj
-rw-r----- 1 oracle oinstall   10059776 2016-01-13 14:53:47 /home/oracle/backup/full1_1lqr9arq
-rw-r----- 1 oracle oinstall 1563312128 2016-01-13 14:56:21 /home/oracle/backup/full2_1mqr9b0h
-rw-r----- 1 oracle oinstall   10059776 2016-01-13 14:56:33 /home/oracle/backup/full2_1nqr9b10
-rw-r----- 1 oracle oinstall 1564147712 2016-01-13 15:03:28 /home/oracle/backup/full_inc0_1oqr9bds
-rw-r----- 1 oracle oinstall   10059776 2016-01-13 15:03:32 /home/oracle/backup/full_inc0_1pqr9be3

$ strings full_inc0_1oqr9bds | grep TeStAb|wc
  17877   17877  268097

--依旧一样的.

4.加入full参数看看:
RMAN> backup full database  format '/home/oracle/backup/full3_%u' ;

$ ll -l /home/oracle/backup/full*
-rw-r----- 1 oracle oinstall 1569062912 2016-01-13 14:53:42 /home/oracle/backup/full1_1kqr9arj
-rw-r----- 1 oracle oinstall   10059776 2016-01-13 14:53:47 /home/oracle/backup/full1_1lqr9arq
-rw-r----- 1 oracle oinstall 1563312128 2016-01-13 14:56:21 /home/oracle/backup/full2_1mqr9b0h
-rw-r----- 1 oracle oinstall   10059776 2016-01-13 14:56:33 /home/oracle/backup/full2_1nqr9b10
-rw-r----- 1 oracle oinstall 1564172288 2016-01-13 15:09:54 /home/oracle/backup/full3_1qqr9bpu
-rw-r----- 1 oracle oinstall   10059776 2016-01-13 15:09:59 /home/oracle/backup/full3_1rqr9bq6
-rw-r----- 1 oracle oinstall 1564147712 2016-01-13 15:03:28 /home/oracle/backup/full_inc0_1oqr9bds
-rw-r----- 1 oracle oinstall   10059776 2016-01-13 15:03:32 /home/oracle/backup/full_inc0_1pqr9be3

$ strings full3_1qqr9bpu |   grep TeStAb|wc
  17877   17877  268097

--依旧一样的.

--补充一下10g的测试:

SCOTT@test> @ &r/ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- ----------------------------------------------------------------
x86_64/Linux 2.4.xx            10.2.0.4.0     Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

CREATE TABLESPACE MSSM DATAFILE
  '/mnt/ramdisk/test/mssm01.dbf' SIZE 16256K AUTOEXTEND OFF
LOGGING
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;
--注意建立的表空间是EXTENT MANAGEMENT LOCAL AUTOALLOCATE.

SCOTT@test> select * from V$RESTORE_POINT;
no rows selected

SCOTT@test> select flashback_on from v$database ;
FLASHBACK_ON
------------------
NO

SCOTT@test> create table tt1 tablespace mssm as select rownum id,to_char(rownum,'000000')||'TeStAb' name from dual connect by level<=2e5;
Table created.

RMAN> backup tablespace mssm format '/home/oracle/mssm1/mssm1_%u';

$ ll -l mssm*
-rw-r----- 1 oracle oinstall 5570560 2016-01-13 15:38:09 mssm1_11qr9df1

$ strings mssm1_11qr9df1 | grep TeStAb|wc
200000  200000 2999626

SCOTT@test> truncate table tt1  ;
Table truncated.

$ ll -l mssm*
-rw-r----- 1 oracle oinstall 5570560 2016-01-13 15:38:09 mssm1_11qr9df1
-rw-r----- 1 oracle oinstall  581632 2016-01-13 15:39:25 mssm2_12qr9dhd

$ strings mssm2_12qr9dhd | grep TeStAb|wc
  17003   17003  255031

$ strings mssm2_12qr9dhd | grep TeStAb | grep -v ',$'|wc
     54      54     796


$ strings mssm2_12qr9dhd | grep TeStAb | grep -v ',$'> aaa.txt

$ cat aaa.txt
select
  DBMS_ROWID.ROWID_BLOCK_NUMBER (ROWID) N10
  ,DBMS_ROWID.ROWID_ROW_NUMBER (ROWID) N20
  from tt1 where id in (
000001, 000320, 000635, 000950, 001265, 001580, 001895, 002210, 002525, 002840,
003155, 003470, 003785, 004100, 004415, 004730, 005045, 005360, 005675, 005990,
006305, 006620, 006935, 007250, 007565, 007880, 008510, 008825, 009140, 009455,
009770, 010081, 010382, 010683, 010984, 011285, 011586, 011887, 012188, 012489,
012790, 013091, 013392, 013693, 013994, 014295, 014596, 014897, 015198, 015499,
015800, 016101, 016402, 016703);

SCOTT@test> @ /home/oracle/mssm1/aaa.txt
N10        N20
---- ----------
  18          0
  19          0
  20          0
  21          0
  22          0
  23          0
  24          0
  25          0
  26          0
  27          0
  28          0
  29          0
  30          0
  31          0
  32          0
  33          0
  34          0
  35          0
  36          0
  37          0
  38          0
  39          0
  40          0
  41          0
  42          0
  43          0
  45          0
  46          0
  47          0
  48          0
  49          0
  50          0
  51          0
  52          0
  53          0
  54          0
  55          0
  56          0
  57          0
  58          0
  59          0
  60          0
  61          0
  62          0
  63          0
  64          0
  65          0
  66          0
  67          0
  68          0
  69          0
  70          0
  71          0
  72          0

54 rows selected.

WITH a
     AS (    SELECT 16 + ROWNUM x
               FROM DUAL
         CONNECT BY LEVEL <= 56)
SELECT x
  FROM a
WHERE x NOT IN ( select
  DBMS_ROWID.ROWID_BLOCK_NUMBER (ROWID) N10
  --,DBMS_ROWID.ROWID_ROW_NUMBER (ROWID) N20
  from tt1 where id in (
000001, 000320, 000635, 000950, 001265, 001580, 001895, 002210, 002525, 002840,
003155, 003470, 003785, 004100, 004415, 004730, 005045, 005360, 005675, 005990,
006305, 006620, 006935, 007250, 007565, 007880, 008510, 008825, 009140, 009455,
009770, 010081, 010382, 010683, 010984, 011285, 011586, 011887, 012188, 012489,
012790, 013091, 013392, 013693, 013994, 014295, 014596, 014897, 015198, 015499,
015800, 016101, 016402, 016703));

    X
-----
   17
   44

SCOTT@test> alter system dump datafile 6 block 17 ;
System altered.

SCOTT@test> alter system dump datafile 6 block 44 ;
System altered.

--我看了一下转储,块17 frmt: 0x02 chkval: 0x1ade type: 0x10=DATA SEGMENT HEADER - UNLIMITED
--块44 ,第1条记录是8195,尾部字符估计正好是2c(ASCII),导致漏掉.
--使用bvi看看备份文件:
..
0004FFD0  41 62 2C 00 02 03 C2 52 61 0D 20 30 30 38 31 39 Ab,....Ra. 00819
0004FFE0  36 54 65 53 74 41 62 2C 00 02 03 C2 52 60 0D 20 6TeStAb,....R`.
0004FFF0  30 30 38 31 39 35 54 65 53 74 41 62 2C 06 73 09 008195TeStAb,.s.
..
--可以确定非常不巧合,这样就掉1块.这样算下来数据文件是mssm,truncate后多备份56块.

SCOTT@test> column PARTITION_NAME noprint
SCOTT@test> select * from dba_extents  where owner=user and segment_name='TT1';
OWNER  SEGMENT_NAME         SEGMENT_TYPE       TABLESPACE_NAME   EXTENT_ID    FILE_ID   BLOCK_ID      BYTES     BLOCKS RELATIVE_FNO
------ -------------------- ------------------ ---------------- ---------- ---------- ---------- ---------- ---------- ------------
SCOTT  TT1                  TABLE              MSSM                      0          6         17      65536          8            6
SCOTT  TT1                  TABLE              MSSM                      1          6         25      65536          8            6
SCOTT  TT1                  TABLE              MSSM                      2          6         33      65536          8            6
SCOTT  TT1                  TABLE              MSSM                      3          6         41      65536          8            6
SCOTT  TT1                  TABLE              MSSM                      4          6         49      65536          8            6
SCOTT  TT1                  TABLE              MSSM                      5          6         57      65536          8            6
SCOTT  TT1                  TABLE              MSSM                      6          6         65      65536          8            6
SCOTT  TT1                  TABLE              MSSM                      7          6         73      65536          8            6

SCOTT  TT1                  TABLE              MSSM                      8          6         81      65536          8            6
SCOTT  TT1                  TABLE              MSSM                      9          6         89      65536          8            6
SCOTT  TT1                  TABLE              MSSM                     10          6         97      65536          8            6
SCOTT  TT1                  TABLE              MSSM                     11          6        105      65536          8            6
SCOTT  TT1                  TABLE              MSSM                     12          6        113      65536          8            6
SCOTT  TT1                  TABLE              MSSM                     13          6        121      65536          8            6
SCOTT  TT1                  TABLE              MSSM                     14          6        129      65536          8            6
SCOTT  TT1                  TABLE              MSSM                     15          6        137      65536          8            6
SCOTT  TT1                  TABLE              MSSM                     16          6        265    1048576        128            6
SCOTT  TT1                  TABLE              MSSM                     17          6        393    1048576        128            6
SCOTT  TT1                  TABLE              MSSM                     18          6        521    1048576        128            6
SCOTT  TT1                  TABLE              MSSM                     19          6        649    1048576        128            6
SCOTT  TT1                  TABLE              MSSM                     20          6        777    1048576        128            6
21 rows selected.


-- 验证看看.
SCOTT@test> drop table tt1 purge ;
Table dropped.

RMAN> backup tablespace mssm format '/home/oracle/mssm1/mssm3_%u';

$ ll -l mssm*
-rw-r----- 1 oracle oinstall 5570560 2016-01-13 15:38:09 mssm1_11qr9df1
-rw-r----- 1 oracle oinstall  581632 2016-01-13 15:39:25 mssm2_12qr9dhd
-rw-r----- 1 oracle oinstall  581632 2016-01-13 16:12:48 mssm3_13qr9fg0

--昏,drop后,备份大小一样.不探究了.

文章标签：
关系型数据库
Oracle
测试技术
数据库
lfreeali
目录
相关文章
lfreeali
|
Oracle 关系型数据库
[20180423]关于rman备份的问题2.txt
[20180423]关于rman备份的问题2.txt --//别人问的问题,rman备份放在哪里的问题. SCOTT@book> @ ver1 PORT_STRING                    VERSION        BANNER --...
lfreeali
907 0
lfreeali
|
Oracle 关系型数据库 Linux
[20180115]RMAN-06820.txt
[20180115]RMAN-06820.txt --//在备库做归档备份出现RMAN-06820的问题。就是如果在备库做全表，因为要做主库日志切换，一般执行rman target /会出现问题。
lfreeali
1384 0
lfreeali
|
Oracle 关系型数据库 测试技术
[20171225]RMAN-06808.txt
[20171225]RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect.txt --//朋友拿我的一些例子来测试遇到的RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect问题.
lfreeali
931 0
lfreeali
|
关系型数据库
[20171221]RMAN-05501.txt
[20171221]RMAN-05501 aborting duplication of target database.txt --//昨天使用rman duplicate建立dg,出现如下错误: rman > duplicate target database for standby from active database; .
lfreeali
1042 0
lfreeali
|
Oracle 关系型数据库
[20171130]关于rman的一些总结.txt
[20171130]关于rman的一些总结.txt --//最近一直做rman相关测试,测试那个乱,没办法.无法从周围的人获得帮助,纯粹是自己的乱猜,乱测,不知道别人是否能看懂我写的东西.
lfreeali
1066 0
lfreeali
|
关系型数据库 Linux 数据库
[20171116]11GR2控制文件自动备份.txt
20171116]11GR2控制文件自动备份.txt SYS@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER ---------------------------...
lfreeali
941 0
lfreeali
|
Oracle 关系型数据库 API
[20170208]rman tape.txt
[20170208]rman tape.txt --前一阵子,同事测试使用磁带做rman备份,留下一些备份信息在控制文件,要清除. --我依稀记得我以前也干过这些事情,晚上看了一下书: Apress.
lfreeali
959 0
lfreeali
|
关系型数据库 Oracle Linux
[20161230]rman checksyntax2.txt
[20161230]rman checksyntax2.txt --曾经写过一篇rman checksyntax的问题,这个问题存在10g: http://blog.
lfreeali
736 0
lfreeali
|
Oracle 关系型数据库 Linux
[20161212]备份archivelog.txt
[20161212]备份archivelog.txt --许多人都知道如果执行backup database plus archivelog;实际上是先执行如下: 1.
lfreeali
713 0
lfreeali
|
SQL Oracle 关系型数据库
[20161214]rman checksyntax.txt
[20161214]rman checksyntax.txt --rman在命令行使用参数checksyntax可以检查命令语法是否正确,而且并不会真正执行.但是昨天在恢复一个10g的数据库时遇到问题,做 --一个记录: 1.
lfreeali
917 0

热门文章

最新文章

  • 1
    随机生成UserAgent的python库（fake-useragent库）
  • 2
    使用zxing识别一幅包含多个二维码的图片
  • 3
    阿里云的SLB，植入cookie和重写cookie有什么区别？
  • 4
    基于Flink的实时日志分析系统实践
  • 5
    如何在服务器上跑python程序
  • 6
    电池技术多年没有较大发展，成为移动设备最大制约
  • 7
    Spread for WinRT 7新功能使用指南
  • 8
    codeforces Soldier and Number Game（dp+素数筛选）
  • 9
    九度oj-1001-Java
  • 10
    Android:随笔——对页面的View进行截图
  • 1
    分解商业周期时间序列：线性滤波器、HP滤波器、Baxter滤波器、Beveridge Nelson分解等去趋势2
    9
  • 2
    分解商业周期时间序列：线性滤波器、HP滤波器、Baxter滤波器、Beveridge Nelson分解等去趋势法1
    9
  • 3
    灰色关联分析(Grey Relation Analysis,GRA)中国经济社会发展指标
    9
  • 4
    极值分析：分块极大值BLOCK-MAXIMA、阈值超额法、广义帕累托分布GPD拟合降雨数据时间序列
    9
  • 5
    GARCH-DCC模型和DCC（MVT）建模估计
    8
  • 6
    ARIMA、ARIMAX、 动态回归和OLS 回归预测多元时间序列
    10
  • 7
    R语言预测期货波动率的实现：ARCH与HAR-RV与GARCH，ARFIMA模型比较
    10
  • 8
    spss modeler用决策树神经网络预测ST的股票
    9
  • 9
    K-means和层次聚类分析癌细胞系微阵列数据和树状图可视化比较
    8
  • 10
    matlab中使用VMD(变分模态分解)对信号去噪
    8

    • 相关电子书

    更多
  • 低代码开发师（初级）实战教程
  • 冬季实战营第三期：MySQL数据库进阶实战
  • 阿里巴巴DevOps 最佳实践手册
    • 下一篇
    阿里云oss简介和使用流程
    为什么选择阿里云什么是云计算全球基础设施技术领先稳定可靠安全合规分析师报告
    产品和定价全部产品免费试用产品动态产品定价价格计算器云上成本管理
    解决方案技术解决方案
    文档与社区文档开发者社区天池大赛培训与认证
    权益中心免费试用高校计划企业扶持计划推荐返现计划
    支持与服务基础服务企业增值服务迁云服务官网公告健康看板信任中心
    关注阿里云
    关注阿里云公众号或下载阿里云APP，关注云资讯，随时随地运维管控云服务
    阿里云APP阿里云微信
    联系我们：4008013260
    法律声明Cookies政策廉正举报安全举报联系我们加入我们
    阿里巴巴集团淘宝网天猫全球速卖通阿里巴巴国际交易市场1688阿里妈妈飞猪阿里云计算AliOS万网高德UC友盟优酷钉钉支付宝达摩院淘宝海外阿里云盘饿了么
    © 2009-2024 Aliyun.com 版权所有 增值电信业务经营许可证： 浙B2-20080101 域名注册服务机构许可： 浙D3-20210002 京D3-20220015
    浙公网安备 33010602009975号浙B2-20080101-4