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

最新推荐文章于 2022-07-15 17:13:01 发布
最新推荐文章于 2022-07-15 17:13:01 发布
阅读量64 收藏
点赞数

[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;
}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-2105221/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267265/viewspace-2105221/

cuixun7780
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
rman备份_八条SQL助你检查RMAN备份是否成功
weixin_39966765的博客
12-06 865
概述关于Oracle数据库的RMAN备份，除了邮件外，是否能通过其它方式检查RMAN备份的成功与失败呢？其实我们可以通过下面SQL脚本来检查1、查看某个时间段RMAN备份失败的记录可以在视图v$rman_status查看在RMAN里面执行的一些操作,例如删除归档日志等。如果要查看RMAN的输出，可以查看V$RMAN_OUTPUT，V$RMAN_OUTPUT 视图记录了RMAN生成的信息，这是在内存...
查询rman备份信息常用指令
热门推荐
深蓝@黄炎龙
05-26 1万+
查询rman备份信息常用指令 ----登陆到rman $rman target / ----以精简的格式查看备份信息 RMAN> list backup of database summary; List of Backups =============== Key     TY LV S Device Type Completion Time#Pieces #Copies Co
ORACLE 查看RMAN的备份信息总结
weixin_33690367的博客
07-19 606
    关于Oracle数据库的RMAN备份，除了邮件外，是否能通过其它方式检查RMAN备份的成功与失败呢？其实我们可以通过下面SQL脚本来检查某个时间段备份失败的记录： SELECT * FROM V$RMAN_STATUS WHERE START_TIME >= TO_DATE(&START_TIME,'YYYY-MM-DD HH24:MI:SS')  AND END_TIME...
rman备份检查
cm333666的博客
06-15 205
今天使用RMAN的备份检查命令对数据库进行了检查： backup validate database可以检查数据库的物理错误和逻辑错误。 RMAN> backup validate database; 启动...
Oracle查看RMAN备份情况
m0_37625564的博客
12-04 3349
Oracle查看RMAN备份情况 查看近两天的备份情况 set linesize 180 pagesize 200 col inc_lev for 9999 col device_type for a8 col bs_key for 99999 col elap_MIN FOR 999999 SELECT bs.recid bs_key , DECODE(backup_type, 'L', 'Archived Redo Logs', 'D', 'Datafile Full Backup', 'I', '
Oracle RMAN增量备份恢复测试记录.docx
05-20
8. **执行备份检查。** 9. **再次执行恢复数据库。** 10. **打开数据库验证数据。** 11. **恢复测试小结。** **3.3、基于SCN的恢复** **测试目的：** 测试基于SCN恢复数据库的能力。 **测试步骤：** 1. **恢复并...
rman备份恢复详细方案.docx
06-28
### RMAN备份恢复详细方案 #### 一、RMAN（Recovery Manager）概述 RMAN是Oracle数据库管理系统中用于备份和恢复的重要工具。它能够帮助DBA高效地完成数据库文件、归档日志以及控制文件的备份与恢复工作。与传统...
windows下的oracle数据库rman自动备份和恢复文档.docx
06-22
### Windows 下 Oracle 数据库 RMAN 自动备份与恢复详解 #### RMAN 简介 RMAN (Recovery Manager)，是 Oracle 提供的一款强大的备份与恢复工具，它随 Oracle 服务器软件一同安装，并且用于执行数据库文件、归档...
RMAN管理的备份和恢复.pdf
08-01
2. **控制文件**: RMAN通过读取目标数据库的控制文件来获取备份所需的信息，包括数据文件、归档日志文件以及检查点SCN等。 3. **通道(Channel)**: 为了加速备份过程，RMAN支持创建多个通道。根据不同的备份介质类型...
查看rman备份进度
sqlora的专栏
06-08 613
查看rman备份进度
查看oracle备份状态,RMAN笔记之查询rman备份信息状态
weixin_26968079的博客
04-05 2177
查询rman备份状态主要是通过视图V$RMAN_STATUS来进行，这个视图可以让你看见你在RMAN里面执行的操作。在V$RMAN_STATUS中，最主要的列是OPERATION和status。Operation的值有rman、backup、list、report。Status的值有running、running with warnings、running with errors、complete...
RMAN详细教程(二) —— 备份、检查、维护、恢复
Ruishine的博客
07-15 3778
RMAN详细教程(二) —— 备份、检查、维护、恢复
RMAN备份进度查看-监控
喝醉酒的小白
07-10 3655
v$session_longops SID：通道的会话号。 TOTALWORK：该行（聚合行或细节行）的任务需要处理的工作量 SOFAR：已完成的工作量 ORACLE 查看RMAN的备份信息总结
查看归档日志及rman备份文件
大叶梧桐的博客
02-16 4418
[root@his1 /]# ls ----查看**/**根目录下的文件 archive boot dev home lib64 media mnt opt rman sbin srv tmp usr bin cgroup etc lib lost+found misc net proc root s...
常用RMAN备份命令和查看备份命令
Monkey·D·Boy的秘宝
03-12 6294
rman备份命令 backup database 备份整个数据库 backup database including current controlfile 备份整个数据库还包括现在的controlfile backup database plus archivelog all 备份整个数据库还包括全部的archivelog bac...
RMAN备份进度查询
Warrior 技术大杂论
05-07 5502
查看已经完成和未完成的RMAN备份进度set line 9999 col opname for a35 col start_time for a19 SELECT SID, SERIAL#,opname, to_char(start_time,'yyyy-mm-dd HH24:MI:SS') start_time, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*1
rman备份+完全备份+完全备份案例+查看备份集和备份段信息+备份表空间案例+查看备份的表空间users信息...
weixin_34006965的博客
06-05 253
rman备份 1要做备份操作，数据库模式需要为存档模式 完全备份 1完全备份就是对数据库使用过的所有数据块进行备份，没有使用过的数据块是不做备份的。在进行完全备份时，rman将数据文件中所有的非空白数据块都复制到备份集中 2rman可对数据文件进行完全备份或者增量备份，但是对控制文件和日志文件只能进行完全备份。 3在一个完全数据库备份中，将所有的数据库文...
如何查rman每个数据文件的备份开始及结束时间
宁静以致远
07-28 2193
 select * from V$BACKUP_ASYNC_IO。这个视图能比较好的反应每个文件的备份间隔。
Oracle 9i RMAN备份与恢复关键技术详解
2. **第9章 RMAN备份**： - 这一章详细讲解了如何使用RMAN进行数据备份，包括全库备份、增量备份、差异备份以及归档日志备份等不同类型的备份策略。 3. **第10章 RMAN还原与恢复**： - 在这个部分，读者会学习...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值