[20160523]rman备份与检查点2.txt

[20160523]rman备份与检查点2.txt

--写过几篇关于检查点的文章,测试看看如果rman做备份时是否写检查点.

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

alter system checkpoint ;

SCOTT@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                                               TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- ------------------------------
    1        13237753852 2016-05-23 08:51:59                7       13227286650 ONLINE              1274 YES /mnt/ramdisk/book/system01.dbf                     SYSTEM
    2        13237753852 2016-05-23 08:51:59             1834       13227286650 ONLINE              1265 YES /mnt/ramdisk/book/sysaux01.dbf                     SYSAUX
    3        13237753852 2016-05-23 08:51:59           923328       13227286650 ONLINE              1185 YES /mnt/ramdisk/book/undotbs01.dbf                    UNDOTBS1
    4        13237753852 2016-05-23 08:51:59            16143       13227286650 ONLINE              1270 YES /mnt/ramdisk/book/users01.dbf                      USERS
    5        13237753852 2016-05-23 08:51:59           952916       13227286650 ONLINE              1182 YES /mnt/ramdisk/book/example01.dbf                    EXAMPLE
    6        13237753852 2016-05-23 08:51:59          1314508       13227286650 ONLINE              1198 YES /mnt/ramdisk/book/sugar01.dbf                      SUGAR
    7        13237753852 2016-05-23 08:51:59      13237575534       13227286650 ONLINE                19 YES /mnt/ramdisk/book/tea01.dbf                        TEA
7 rows selected.

2.使用rman备份:

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
RMAN> configure channel 1 device type disk rate 50M;

old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK RATE 100 M;
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK RATE 50 M;
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1

RMAN> backup database format '/home/oracle/backup/full0523_%U.bak' filesperset=1;

Starting backup at 2016-05-23 08:56:49
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=101 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=/mnt/ramdisk/book/sysaux01.dbf
channel ORA_DISK_1: starting piece 1 at 2016-05-23 08:56:50
channel ORA_DISK_1: finished piece 1 at 2016-05-23 08:57:35
piece handle=/home/oracle/backup/full0523_27r6a06i_1_1.bak tag=TAG20160523T085649 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: throttle time: 0:00:30
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/mnt/ramdisk/book/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 2016-05-23 08:57:35
channel ORA_DISK_1: finished piece 1 at 2016-05-23 08:58:10
piece handle=/home/oracle/backup/full0523_28r6a07v_1_1.bak tag=TAG20160523T085649 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: throttle time: 0:00:29
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/mnt/ramdisk/book/system01.dbf
channel ORA_DISK_1: starting piece 1 at 2016-05-23 08:58:10
channel ORA_DISK_1: finished piece 1 at 2016-05-23 08:58:35
piece handle=/home/oracle/backup/full0523_29r6a092_1_1.bak tag=TAG20160523T085649 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: throttle time: 0:00:14
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/mnt/ramdisk/book/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2016-05-23 08:58:35
channel ORA_DISK_1: finished piece 1 at 2016-05-23 08:58:50
piece handle=/home/oracle/backup/full0523_2ar6a09r_1_1.bak tag=TAG20160523T085649 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: throttle time: 0:00:10
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf
channel ORA_DISK_1: starting piece 1 at 2016-05-23 08:58:50
channel ORA_DISK_1: finished piece 1 at 2016-05-23 08:59:05
piece handle=/home/oracle/backup/full0523_2br6a0aa_1_1.bak tag=TAG20160523T085649 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: throttle time: 0:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/mnt/ramdisk/book/sugar01.dbf
channel ORA_DISK_1: starting piece 1 at 2016-05-23 08:59:05
channel ORA_DISK_1: finished piece 1 at 2016-05-23 08:59:08
piece handle=/home/oracle/backup/full0523_2cr6a0ap_1_1.bak tag=TAG20160523T085649 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: throttle time: 0:00:02
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/mnt/ramdisk/book/tea01.dbf
channel ORA_DISK_1: starting piece 1 at 2016-05-23 08:59:08
channel ORA_DISK_1: finished piece 1 at 2016-05-23 08:59:11
piece handle=/home/oracle/backup/full0523_2dr6a0as_1_1.bak tag=TAG20160523T085649 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: throttle time: 0:00:01
Finished backup at 2016-05-23 08:59:11

Starting Control File and SPFILE Autobackup at 2016-05-23 08:59:11
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2016_05_23/o1_mf_s_912589151_cn4ogzy2_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2016-05-23 08:59:12

SCOTT@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header order by CHECKPOINT_TIME ;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                             TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------- ---------------
    2        13237754002 2016-05-23 08:56:50             1834       13227286650 ONLINE              1266 YES /mnt/ramdisk/book/sysaux01.dbf   SYSAUX
    3        13237754026 2016-05-23 08:57:35           923328       13227286650 ONLINE              1186 YES /mnt/ramdisk/book/undotbs01.dbf  UNDOTBS1
    1        13237754045 2016-05-23 08:58:10                7       13227286650 ONLINE              1275 YES /mnt/ramdisk/book/system01.dbf   SYSTEM
    4        13237754054 2016-05-23 08:58:35            16143       13227286650 ONLINE              1271 YES /mnt/ramdisk/book/users01.dbf    USERS
    5        13237754060 2016-05-23 08:58:50           952916       13227286650 ONLINE              1183 YES /mnt/ramdisk/book/example01.dbf  EXAMPLE
    6        13237754066 2016-05-23 08:59:05          1314508       13227286650 ONLINE              1199 YES /mnt/ramdisk/book/sugar01.dbf    SUGAR
    7        13237754068 2016-05-23 08:59:08      13237575534       13227286650 ONLINE                20 YES /mnt/ramdisk/book/tea01.dbf      TEA
7rows selected.

RMAN> list backup by file;
List of Datafile Backups
========================

File Key     TY LV S Ckp SCN    Ckp Time            #Pieces #Copies Compressed Tag
---- ------- -  -- - ---------- ------------------- ------- ------- ---------- ---
1    48      B  F  A 13237754045 2016-05-23 08:58:10 1       1       NO         TAG20160523T085649
2    46      B  F  A 13237754002 2016-05-23 08:56:50 1       1       NO         TAG20160523T085649
3    47      B  F  A 13237754026 2016-05-23 08:57:35 1       1       NO         TAG20160523T085649
4    49      B  F  A 13237754054 2016-05-23 08:58:35 1       1       NO         TAG20160523T085649
5    50      B  F  A 13237754060 2016-05-23 08:58:50 1       1       NO         TAG20160523T085649
6    51      B  F  A 13237754066 2016-05-23 08:59:05 1       1       NO         TAG20160523T085649
7    52      B  F  A 13237754068 2016-05-23 08:59:08 1       1       NO         TAG20160523T085649

List of Control File Backups
============================

CF Ckp SCN Ckp Time            BS Key  S #Pieces #Copies Compressed Tag
---------- ------------------- ------- - ------- ------- ---------- ---
13237754075 2016-05-23 08:59:11 53      A 1       1       NO         TAG20160523T085911
List of SPFILE Backups
======================

Modification Time   BS Key  S #Pieces #Copies Compressed Tag
------------------- ------- - ------- ------- ---------- ---
2016-05-17 09:12:21 53      A 1       1       NO         TAG20160523T085911

--1.通过以上信息可以确定备份文件会写检查点.
--2.而且备份文件是先写检查点,再做备份.

--我这里就产生1个疑问,假设某个数据文件备份时间很长,这样数据文件的某个数据块的scn可能大于文件头的CHECKPOINT_CHANGE#.当我
--们恢复使用不完全恢复到某个时间点或者SCN,应该使用那个备份文件呢?另外做一个测试来说明问题.

run {
  allocate channel c1 device type DISK;
  allocate channel c2 device type DISK;
  allocate channel c3 device type DISK;
  set until scn XXXX;
  restore database ;
  recover database ;
  release channel c1;
  release channel c2;
  release channel c3;
}

时间： 2024-09-15 22:27:38

[20160523]rman备份与检查点2.txt的相关文章

[20160523]rman备份与检查点3.txt

[20160523]rman备份与检查点3.txt --从前面的测试可以发现: --1.通过以上信息可以确定备份文件会写检查点. --2.而且备份文件是先写检查点,再做备份. --我这里就产生1个疑问,假设某个数据文件备份时间很长,这样数据文件的某个数据块的scn可能大于文件头的CHECKPOINT_CHANGE#.当我 --们恢复使用不完全恢复到某个时间点或者SCN,应该使用那个备份文件呢?做一个测试来说明问题. 1.环境: SCOTT@book> @ &r/ver1 PORT_STRIN

[20160524]rman备份与检查点4.txt

[20160524]rman备份与检查点4.txt --链接: http://blog.itpub.net/267265/viewspace-2105221/ http://blog.itpub.net/267265/viewspace-2105223/ --昨晚仔细思考,重复测试看看,使用新的控制文件是否可以恢复.感觉我的问题在于我做了catalog注册了备份文件时丢失某些信息.重新 --测试看看. 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING      

[20150601]rman备份出现坏块.txt

[20150601]rman备份出现坏块.txt --昨天看链接: http://www.jydba.net/磁盘损坏造成RMAN备份文件有坏块的恢复案例/ --提到如果备份片存在坏块的恢复案例,他使用的参数,我自己从来没见过. alter system set event='19548 trace name context forever', '19549 trace name context forever' scope=spfile; -- oerr ora 19548,oerr ora

[20161118]rman备份的疑问2.txt

[20161118]rman备份的疑问2.txt --这个是我前几天做测试时遇到的疑问,不知道为什么rman 备份要修改数据块的dba地址. --我在itpub上也问了这个问题,链接http://www.itpub.net/thread-2071504-1-1.html,可惜没有人解答. --具体细节不清楚,读取数据文件然后重新编码组织数据,将kcbh.rdba_kcbh的后2位放入tailchk中,设置spare3_kcbh=0x0001, --也许为了区分备份与数据文件,当然还有别的目的,再

[20161101]rman备份与数据文件变化7.txt

[20161101]rman备份与数据文件变化7.txt --//想象一下,如果备份文件时间很长,而这个时候数据文件大小发生了变化,oracle的备份如何解决这个问题呢? --//去年已经测试了建立备份集的情况,一直想做一次image copy的测试,一直脱,主要原因自己不想做这个测试.... --//而且当时的测试很乱,自己主要一边做一边想.... --//链接: http://blog.itpub.net/267265/viewspace-2127386/ http://blog.itpub

[20171123]rman备份与数据文件变化6.txt

[20171123]rman备份与数据文件变化6.txt --//想象一下,如果备份文件时间很长,而这个时候数据文件大小发生了变化,oracle的备份如何解决这个问题呢? --//去年已经测试了建立备份集的情况,一直想做一次image copy的测试,一直脱,主要原因自己不想做这个测试.... --//而且当时的测试很乱,自己主要一边做一边想.... --//链接: http://blog.itpub.net/267265/viewspace-2127386/ http://blog.itpub

[20161101]rman备份与数据文件变化4.txt

[20161101]rman备份与数据文件变化4.txt --想象一下,如果备份文件时间很长,而这个时候数据文件大小发生了变化,oracle的备份如何解决这个问题呢? --前面我已经做了增大数据文件,参考链接:http://blog.itpub.net/267265/viewspace-2127386/ --这次测试减少数据文件大小看看. --早上的测试太乱了,重复做1次看看. 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING                  

[20161031]rman备份与数据文件变化3.txt

[20161031]rman备份与数据文件变化3.txt --想象一下,如果备份文件时间很长,而这个时候数据文件大小发生了变化,oracle的备份如何解决这个问题呢? --前面我已经做了增大数据文件,参考链接:http://blog.itpub.net/267265/viewspace-2127386/ --这次测试减少数据文件大小看看. 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING                    VERSION        BAN

[20161031]rman备份与数据文件变化2.txt

[20161031]rman备份与数据文件变化2.txt --想象一下,如果备份文件时间很长,而这个时候数据文件大小发生了变化,oracle的备份如何解决这个问题呢? 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- -------------------------------------