暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
首页 / Oracle 备份保留策略对目标备份恢复区域的影响

Oracle 备份保留策略对目标备份恢复区域的影响

askTom 2017-03-09
175

问题描述

嗨，

备份保留策略对备份恢复区域rman命令有什么影响？
我在FRA中拥有所有备份，并且我想将备份恢复区域设置为目标 (磁盘) 以具有 “替代” 备份，但是我不确定这在备份的备份保留策略中的效果。此恢复区域备份是否会使FRA中的其余备份过时？

在oracle文档中 (http://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV89558) 我可以看到 “备份恢复区域” rman命令被视为备份的备份，例如备份备份。这就是他们所说的:

查看备份保留策略对备份的影响

对于基于冗余的备份保留策略，备份集被视为备份的一个实例。即使存在形成备份集的备份片段的多个副本 (例如，备份集已从磁盘备份到磁带)，此语句也是正确的。

对于恢复窗口保留策略，备份集的所有副本都已过时，或者都没有。在查看列表和报告命令的输出时，这一点最容易掌握。



但是我不确定这是否也适用于备份恢复区域命令。



提前谢谢你。

问候
奥斯卡

专家解答

似乎包括了恢复区域的备份。我会拿一些表空间的副本

C:\temp>rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Sat Mar 11 11:07:24 2017

Copyright (c) 1982, 2016, Oracle and/or its affiliates.  All rights reserved.

connected to target database: NP12 (DBID=1950473453)

RMAN> backup tablespace example;

Starting backup at 11-MAR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=366 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=00007 name=C:\ORACLE\ORADATA\NP12\EXAMPLE01.DBF
channel ORA_DISK_1: starting piece 1 at 11-MAR-17
channel ORA_DISK_1: finished piece 1 at 11-MAR-17
piece handle=C:\ORACLE\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110732_DD6THNGO_.BKP tag=TAG20170311T110732 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 11-MAR-17

RMAN> backup tablespace example;

Starting backup at 11-MAR-17
using channel ORA_DISK_1
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=C:\ORACLE\ORADATA\NP12\EXAMPLE01.DBF
channel ORA_DISK_1: starting piece 1 at 11-MAR-17
channel ORA_DISK_1: finished piece 1 at 11-MAR-17
piece handle=C:\ORACLE\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110740_DD6THWNP_.BKP tag=TAG20170311T110740 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 11-MAR-17

RMAN> backup tablespace example;

Starting backup at 11-MAR-17
using channel ORA_DISK_1
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=C:\ORACLE\ORADATA\NP12\EXAMPLE01.DBF
channel ORA_DISK_1: starting piece 1 at 11-MAR-17
channel ORA_DISK_1: finished piece 1 at 11-MAR-17
piece handle=C:\ORACLE\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110745_DD6TJ215_.BKP tag=TAG20170311T110745 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 11-MAR-17

复制


现在拿一下FRA的备份

RMAN> BACKUP RECOVERY AREA to destination 'c:\temp\fra';

Starting backup at 11-MAR-17
using channel ORA_DISK_1
specification does not match any archived log in the repository
specification does not match any datafile copy in the repository
channel ORA_DISK_1: input backup set: count=11, stamp=938344052, piece=1
channel ORA_DISK_1: starting piece 1 at 11-MAR-17
channel ORA_DISK_1: backup piece C:\ORACLE\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110732_DD6THNGO_.BKP
piece handle=C:\TEMP\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110732_DD6TO0KM_.BKP comment=NONE
channel ORA_DISK_1: finished piece 1 at 11-MAR-17
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=12, stamp=938344060, piece=1
channel ORA_DISK_1: starting piece 1 at 11-MAR-17
channel ORA_DISK_1: backup piece C:\ORACLE\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110740_DD6THWNP_.BKP
piece handle=C:\TEMP\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110740_DD6TO1M7_.BKP comment=NONE
channel ORA_DISK_1: finished piece 1 at 11-MAR-17
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=13, stamp=938344065, piece=1
channel ORA_DISK_1: starting piece 1 at 11-MAR-17
channel ORA_DISK_1: backup piece C:\ORACLE\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110745_DD6TJ215_.BKP
piece handle=C:\TEMP\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110745_DD6TO2O3_.BKP comment=NONE
channel ORA_DISK_1: finished piece 1 at 11-MAR-17
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
Finished backup at 11-MAR-17

复制


当我们列出备份时，FRA的副本不是独立备份，而是现有备份的副本

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size
------- ---- -- ----------
11      Full    97.28M
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 4315525    11-MAR-17 C:\ORACLE\ORADATA\NP12\EXAMPLE01.DBF

  Backup Set Copy #1 of backup set 11
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     11-MAR-17       NO         TAG20170311T110732

    List of Backup Pieces for backup set 11 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    11      1   AVAILABLE   C:\ORACLE\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110732_DD6THNGO_.BKP

  Backup Set Copy #2 of backup set 11
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     11-MAR-17       NO         TAG20170311T110732

    List of Backup Pieces for backup set 11 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    14      1   AVAILABLE   C:\TEMP\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110732_DD6TO0KM_.BKP

BS Key  Type LV Size
------- ---- -- ----------
12      Full    97.28M
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 4315551    11-MAR-17 C:\ORACLE\ORADATA\NP12\EXAMPLE01.DBF

  Backup Set Copy #1 of backup set 12
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     11-MAR-17       NO         TAG20170311T110740

    List of Backup Pieces for backup set 12 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    12      1   AVAILABLE   C:\ORACLE\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110740_DD6THWNP_.BKP

  Backup Set Copy #2 of backup set 12
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     11-MAR-17       NO         TAG20170311T110740

    List of Backup Pieces for backup set 12 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    15      1   AVAILABLE   C:\TEMP\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110740_DD6TO1M7_.BKP

BS Key  Type LV Size
------- ---- -- ----------
13      Full    97.28M
  List of Datafiles in backup set 13
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 4315570    11-MAR-17 C:\ORACLE\ORADATA\NP12\EXAMPLE01.DBF

  Backup Set Copy #1 of backup set 13
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     11-MAR-17       NO         TAG20170311T110745

    List of Backup Pieces for backup set 13 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    13      1   AVAILABLE   C:\ORACLE\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110745_DD6TJ215_.BKP

  Backup Set Copy #2 of backup set 13
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     11-MAR-17       NO         TAG20170311T110745

    List of Backup Pieces for backup set 13 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    16      1   AVAILABLE   C:\TEMP\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110745_DD6TO2O3_.BKP


So when I look at my default redundancy


RMAN> show all;

RMAN configuration parameters for database with db_unique_name NP12 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\12.1.0.2\DATABASE\SNCFNP12.ORA'; # default

复制


然后要求删除过时的备份


RMAN> delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           11     11-MAR-17
  Backup Piece       14     11-MAR-17          C:\TEMP\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110732_DD6TO0KM_.BKP
Backup Set           11     11-MAR-17
  Backup Piece       11     11-MAR-17          C:\ORACLE\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110732_DD6THNGO_.BKP
Backup Set           12     11-MAR-17
  Backup Piece       12     11-MAR-17          C:\ORACLE\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110740_DD6THWNP_.BKP
Backup Set           12     11-MAR-17
  Backup Piece       15     11-MAR-17          C:\TEMP\FRA\NP12\BACKUPSET\2017_03_11\O1_MF_NNNDF_TAG20170311T110740_DD6TO1M7_.BKP


复制


您可以看到c:\ temp \ fra副本也包含在列表中。
oracleasktom
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论

相关阅读

Oracle RAC 一键安装翻车？手把手教你如何排错！
Lucifer三思而后行
594次阅读
2025-04-15 17:24:06
【纯干货】Oracle 19C RU 19.27 发布，如何快速升级和安装？
Lucifer三思而后行
560次阅读
2025-04-18 14:18:38
XTTS跨版本迁移升级方案（11g to 19c RAC for Linux）
zwtian
482次阅读
2025-04-08 09:12:48
Oracle数据库一键巡检并生成HTML结果，免费脚本速来下载!
陈举超
472次阅读
2025-04-20 10:07:02
【ORACLE】记录一些ORACLE的merge into语句的BUG
DarkAthena
457次阅读
2025-04-22 00:20:37
【ORACLE】你以为的真的是你以为的么?--ORA-38104: Columns referenced in the ON Clause cannot be updated
DarkAthena
430次阅读
2025-04-22 00:13:51
Oracle 19c RAC更换IP实战，运维必看！
szrsu
430次阅读
2025-04-08 23:57:08
【活动】分享你的压箱底干货文档，三篇解锁进阶奖励！
墨天轮编辑部
414次阅读
2025-04-17 17:02:24
火焰图--分析复杂SQL执行计划的利器
听见风的声音
358次阅读
2025-04-17 09:30:30
3月“墨力原创作者计划”获奖名单公布
墨天轮编辑部
356次阅读
2025-04-15 14:48:05