基于时间的备份保留策略的rman研究

最新推荐文章于 2024-10-02 00:27:17 发布
最新推荐文章于 2024-10-02 00:27:17 发布
阅读量101 收藏
点赞数
文章标签： 数据库

1 实验准备

a）物理和逻辑上检查

SQL> col file_name for a70 wrapped
SQL> select file_name,status from dba_data_files where file_id=4;

FILE_NAME                                                              STATUS
---------------------------------------------------------------------- ---------
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_7wvsw7hg_.dbf        AVAILABLE

SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='USERS';

TABLESPACE_NAME                STATUS
------------------------------ ---------
USERS                          ONLINE


b）large_pool

SQL> select * from v$sgastat where pool like '%large%';

POOL         NAME                            BYTES
------------ -------------------------- ----------
large pool   PX msg pool                    902160
large pool   free memory                   3292144

c）NLS_DATE_FORMAT

 >vim .bash_profile
 >export NLS_DATE_FORMAT='YYYY-MM-DD:HH24:MI:SS'
 >. .bash_profile


d）control_file_record_keep_time

SQL> show parameter control_

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7


e）清空环境

RMAN> list backup;


RMAN> list copy;

specification does not match any archive log in the recovery catalog

f）配置时间窗口为1 days

RMAN> CONFIGURE RETENTION POLICY TO recovery window of 1 days;

new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
......


2 对report obsolete的影响 

RMAN> backup tablespace users;
......
Finished backup at 2012-10-09:10:14:46

RMAN> backup tablespace users; //对users备份两次，当超过备份保留策略时，rman会将老的备份标志为obsolete
......
Finished backup at 2012-10-09:10:17:13


[root@think ~]# date
Tue Oct  9 10:31:03 CST 2012
[root@think ~]# date -s "Tue Oct  9 23:59:00 CST 2012"
Tue Oct  9 23:59:00 CST 2012
[root@think ~]# date
Tue Oct  9 23:59:03 CST 2012
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 9 23:59:19 2012
RMAN> report obsolete;
...
no obsolete backups found


[root@think ~]# date
Tue Oct  9 10:31:03 CST 2012
[root@think ~]# date -s "Tue Oct  10 10:17:00 CST 2012"
Tue Oct  10 10:17:00 CST 2012
[root@think ~]# date
Tue Oct  10 10:17:00 CST 2012
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 10 10:17:5 2012
RMAN> report obsolete;

using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           3      2012-10-09:10:14:46
  Backup Piece       3      2012-10-09:10:14:46 /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_10_09/o1_mf_nnndf_TAG20121009T101445_87724os6_.bkp


[root@think ~]# export LANG=en_US
[root@think ~]# date
Mon Oct 15 10:28:03 CST 2012
[root@think ~]# date -s "Mon Oct 9 10:28:03 CST 2012"
Tue Oct  9 10:28:03 CST 2012
[root@think ~]# date
Tue Oct  9 10:28:06 CST 2012
[root@think ~]# su - oracle
[oracle@think ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 9 10:28:20 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1312966189)

RMAN> report obsolete;

using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
no obsolete backups found


3 对report need backup的影响 

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 9 11:14:16 2012
RMAN> list backup;
BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
3       Full    13.09M     DISK        00:00:01     2012-10-09:10:14:46
......
BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
4       Full    13.09M     DISK        00:00:01     2012-10-09:10:17:13
......
RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------
1    2658  /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_7wvsw7b2_.dbf
2    2658  /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_7wvsw7gf_.dbf
3    2658  /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_7wvsw7bd_.dbf
5    126   /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_7wvsxyqt_.dbf
6    122   /u01/app/oracle/oradata/ORCL/datafile/o1_mf_ts_1_7x5v2q05_.dbf

[root@think ~]# export LANG=en_US
[root@think ~]# date
Wed Oct 10 21:20:03 CST 2012
[root@think ~]# date -s "Wed Oct 11 21:20:03 CST 2012"
Thu Oct 11 21:20:03 CST 2012
[root@think ~]# date
Thu Oct 11 21:20:06 CST 2012
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Oct 11 21:20:54 2012
RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------
1    2660  /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_7wvsw7b2_.dbf
2    2660  /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_7wvsw7gf_.dbf
3    2660  /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_7wvsw7bd_.dbf
4    2     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_7wvsw7hg_.dbf
5    128   /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_7wvsxyqt_.dbf
6    124   /u01/app/oracle/oradata/ORCL/datafile/o1_mf_ts_1_7x5v2q05_.dbf


那么当出现report obsolete时，会立即报告report need backup?

[root@think ~]# export LANG=en_US
[root@think ~]# date
Wed Oct 10 10:19:16 CST 2012
[root@think ~]# date -s "Tue Oct  10 10:17:00 CST 2012"
Wed Oct 10 10:17:00 CST 2012
[root@think ~]# date
Wed Oct 10 10:17:03 CST 2012
[root@think ~]# su - oracle
[oracle@think ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Oct 10 10:17:14 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1312966189)

RMAN> report obsolete
2> ;

using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           3      2012-10-09:10:14:46
  Backup Piece       3      2012-10-09:10:14:46 /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_10_09/o1_mf_nnndf_TAG20121009T101445_87724os6_.bkp

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------
1    2659  /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_7wvsw7b2_.dbf
2    2659  /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_7wvsw7gf_.dbf
3    2659  /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_7wvsw7bd_.dbf
5    127   /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_7wvsxyqt_.dbf
6    123   /u01/app/oracle/oradata/ORCL/datafile/o1_mf_ts_1_7x5v2q05_.dbf


4 对optimization的影响

备份优化与速度无关，而是针对是否对只读表空间进行备份

SQL> alter tablespace users read only;

Tablespace altered.


RMAN> CONFIGURE BACKUP OPTIMIZATION on;

new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored

RMAN> backup database;  //虽然users下线，而且备份优化也开了，但是第一次rman仍然会把users拿去备份

Starting backup at 2012-10-09:12:16:15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=139 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_7wvsw7b2_.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_7wvsw7bd_.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_7wvsw7hg_.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_7wvsxyqt_.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_ts_1_7x5v2q05_.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_7wvsw7gf_.dbf
channel ORA_DISK_1: starting piece 1 at 2012-10-09:12:16:16
channel ORA_DISK_1: finished piece 1 at 2012-10-09:12:17:01
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_10_09/o1_mf_nnndf_TAG20121009T121616_87798jhg_.bkp tag=TAG20121009T121616 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 2012-10-09:12:17:03
channel ORA_DISK_1: finished piece 1 at 2012-10-09:12:17:04
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_10_09/o1_mf_ncsnf_TAG20121009T121616_87799z8h_.bkp tag=TAG20121009T121616 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 2012-10-09:12:17:04

RMAN> backup database;  //第二次users就被rman自动踢掉了

Starting backup at 2012-10-09:12:17:22
using channel ORA_DISK_1
skipping datafile 4; already backed up 1 time(s)
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_7wvsw7b2_.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_7wvsw7bd_.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_7wvsxyqt_.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_ts_1_7x5v2q05_.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_7wvsw7gf_.dbf
channel ORA_DISK_1: starting piece 1 at 2012-10-09:12:17:23


[root@think ~]# export LANG=en_US
[root@think ~]# date
Tue Oct  9 12:21:44 CST 2012
[root@think ~]# date -s "Tue Oct  10 10:21:44 CST 2012"
Wed Oct 10 10:21:44 CST 2012
[root@think ~]# date
Wed Oct 10 10:21:45 CST 2012

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Oct 10 10:21:59 2012
RMAN> backup database;

Starting backup at 2012-10-10:10:22:11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=145 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_7wvsw7b2_.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_7wvsw7bd_.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_7wvsw7hg_.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_7wvsxyqt_.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_ts_1_7x5v2q05_.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_7wvsw7gf_.dbf
channel ORA_DISK_1: starting piece 1 at 2012-10-10:10:22:12


5 实验总结：

在recovery window of 1 days的假设下(此处的半天、一整天、1.5天是个大概的量)：

㈠ optimization和read only下：半天
㈡ report obsolete：一整天
㈢ report need backup：1.5天


iteye_4537
关注
RMAN 配置保留策略
fsfsdfsdw的博客
11-18 289
RMAN 配置保留策略
rman的基于窗口的备份保留策略学习
weixin_34112208的博客
10-18 89
例如： rman>configure retention policy to recovery window of 7 days; 那么就是说，至少要使得保留下来的备份，可以支持恢复到从当前回溯7天前到现在为止，任意时间点的状态。 如果1号和15号分别作了一个全备份，看看到24号的时候： 往回看，7天前的日子是 18日。那么就需要至少保留15号的全备份和此后的归档日志。 那么1号的...
Backup And Recovery User's Guide-RMAN备份概念-备份保留期策略-恢复窗口
cmff98425的博客
02-20 132
恢复窗口 恢复窗口是一个时间期间，开始于当前时间，向回在时间上扩展到可恢复的点。 可恢复的点是一个假想的基于时间点恢复的早期的时间，即你可以从介质失败恢复到的最早的时间点。 例，...
RMAN兼容性、控制文件自动备份、保存时间、备份策略、备份脚本（二）
weixin_34066347的博客
04-16 138
RMAN 程序的兼容性 RMAN 环境由以下5部分组成：(1) RMAN executable(2) Recovery catalog database(3) Recovery catalog schema in the recovery catalog database(4) Target database(5) Auxiliary database (used f...
oracle10g_rman_语法测试_4
09-18 106
RMAN> configure backup optimization clear;--打回原形,就是恢复默认old RMAN configuration parameters:CONFIGURE BACKUP ...
RMAN 删除无效 过期备份
JIANGJIAN12345的专栏
03-05 3256
删除无效备份（根据备份策略不需要的）：DELETE OBSOLETE; 删除过期备份（实际已经不存，空有一条记录）：DELETE EXPIRED; 文档如下： Crosschecks update outdated RMAN repository information about backups whose repository records do not match their p
oracle的rman备份保留天数,RMAN 基于时间的备份保留策略调整
weixin_39806388的博客
04-10 731
最近收到邮件通知说存储空间不够，一看原来是RAMN的备份集占用的大量的存储空间。看看这些备份集居然有两个月前的，难怪存储空间不够用呢。RMAN> show all;RMAN 配置参数为:CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 60 DAYS;SQL> show parameter control_file_record_keep...
mysql备份保留时间_RMAN 基于时间的备份保留策略调整
weixin_39565300的博客
02-27 195
我们知道nocatalog模式下ramn的备份信息都保留在控制文件中。RMAN备份集的信息在控制文件中的保留天数，取决于初始化参数control最近收到邮件通知说存储空间不够，一看原来是RAMN的备份集占用的大量的存储空间。看看这些备份集居然有两个月前的，，难怪存储空间不够用呢。RMAN> show all;RMAN 配置参数为:CONFIGURE RETENTION POLICY TO R...
超经典的Oraclerman增量备份恢复策略.pdf
07-04
6. 备份脚本：具体的RMAN脚本操作步骤包括使用run块，设置控制文件记录保留时间，配置保留策略，优化备份设置，控制文件的自动备份，以及指定备份文件的格式和备份集的压缩。 通过RMAN脚本进行备份时，可以实现很多...
Oracle：EM中设置基于磁盘的备份配置和备份策略
12-14
Oracle企业版管理器（EM）提供了设置基于磁盘的备份配置和备份策略的功能，这对于确保数据库的安全性和可恢复性至...通过合理配置备份策略和管理备份保留，可以有效优化存储资源，提高备份效率，同时保证数据的完整性。
oracle11g_rman备份还原初步方案（20190524）.docx
05-29
RMAN还支持增量数据块级别的备份，这种备份方式更加节省时间和存储空间，因为它仅备份自上次备份以来发生更改的数据块。 #### 二、备份策略选择 ##### 2.1 备份方法 - **逻辑备份** - 使用`exp`进行逻辑备份、...
解决rman无法自动删除过期备份和归档
huyangg的专栏
06-20 4520
rman的删除语句如下： run { delete noprompt obsolete; crosscheck backup; delete noprompt expired backup; crosscheck archivelog all; delete noprompt expired archivelog all; delete noprompt archivelog all
RMAN备份脚本
东城绝神
09-26 2915
一、关于RMAN备份的相关参数介绍： 命令行参数 TARGET #为目标数据库定义的一个连接字符串，当连接到一个目标数据库时，该连续是SYSDBA连接。该用户拥有启动和关闭数据库的权利，必须属于OSDBA组，必须建立一个口令文件允许SYSDBA连接。 CATALOG #连接到恢复目录。 NOCATALOG #不运用恢复目录。与CATALOG参数互斥 CMDFILE #定义了输出命令文
MySQL之复合查询与内外连接
zdlynj的博客
09-30 1220
前面我们讲解的mysql表的查询都是对一张表进行查询，即数据的查询都是在某一时刻对一个表进行操作的。而在实际开发中，我们往往还需要对多个表同时进行查询。我们这里使用的测试表，为雇员信息表(来自Oracle 9i的经典测试表)：EMP员工表，DEPT部门表，SALGRADE工资等级表。
点评项目-2-完善注册登录业务
m0_75138009的博客
09-29 582
需要处理的业务：在网页发送 /user/code 路径下的 post 请求后，我们需要检验手机号后，向合法的手机号发送一个随机生成的电话号。
World of Warcraft [CLASSIC][80][Grandel] Call to Arms: Victory in Wintergrasp
最新发布
qq 117791303
10-02 283
Wintergrasp 冬拥湖 120 VS 120
Spring的热部署工具和数据库密码加盐操作
2301_77053417的博客
09-28 791
加密过程：用户输入的密码+盐值 --> 字符串1，然后使用md5对字符串1加密得到字符串2，然后字符串2+盐值 --> 字符串3，这个字符串3就是存储在数据库中的密文。背景：如果我们的密码明文存储在数据库中，要是被窃取了是非常的危险的，所以我们在数据库中存储的密码不能是明文的，需要进行加密后存储，也就是数据库中存储的是密文。解密过程：取出数据库中的盐值和用户输入的密码得到字符串1，使用md5对字符串1加密得到字符串2，然后验证字符串2和数据库中的密文即可。做好以上的步骤，你项目中的热部署就已经做好了。
Redis事务
zhzjn的博客
09-30 364
Redis事务可以通过MULTI、EXEC、WATCH和DISCARD指令来实现。1. MULTI指令：表示事务的开始，之后的所有指令都会被逐一记录，但不会立即执行。2. EXEC指令：表示事务的执行，会按照记录的指令逐一执行。3. WATCH指令：可以监视一个或多个键的变化，如果在事务执行期间被其他客户端修改，事务会被回滚。4. DISCARD指令：表示事务的撤销，可以放弃之前记录的指令。
RMAN自动备份与恢复策略详解
在Oracle环境中，可以使用RMAN的`configure`命令设置各种备份参数，例如备份的保留策略、备份的通道数量、备份介质类型等。这些设置会影响RMAN执行备份时的行为。 5. **RMAN还原与恢复**： - **恢复整个数据库**...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值