oracle rman保留策略及delete命令使用

最新推荐文章于 2021-04-09 11:23:41 发布
最新推荐文章于 2021-04-09 11:23:41 发布
阅读量699 收藏 1
点赞数 1
分类专栏： 数据库 文章标签： oracle rman 数据安全
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lichx123/article/details/99038899
版权

今日学习Oracle rman备份保留策略，归档删除策略，发现delete obsolete命令不考虑归档删除策略，只遵从备份保留策略，delete archive log 只遵从归档删除策略，不考虑备份保留策略，实验验证一下。

1 数据库环境
1.1 数据库版本
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
1.2 数据库日志模式
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     1
Next log sequence to archive   3
Current log sequence           3
1.3 rman参数配置
RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL11G 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 ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl11g.f'; # default
2 设置备份保留策略及归档删除策略
2.1 保留策略采用默认设置，保留一个有效备份。
2.2 设置归档删除策略为备份到磁盘设备两次
RMAN>  configure archivelog deletion policy to backed up 2 times to device type disk;

old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
new RMAN configuration parameters are successfully stored
3 验证delete obsolete命令
3.1 备份归档日志
RMAN> backup archivelog all;
3.2 检查以下废弃的备份及文件
RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           1      03-AUG-19
  Backup Piece       1      03-AUG-19          /home/oracle/backup/c_ORCL11G_20190803_1
Backup Set           2      03-AUG-19
  Backup Piece       2      03-AUG-19          /home/oracle/backup/ctl_04u899pu_20190803_4;

上面两个备份时以前的控制文件备份

3.3 切换日志，产生几个归档
RMAN> sql 'alter system switch logfile';

sql statement: alter system switch logfile
3.4 做一个数据库全备
RMAN> back up database;
3.5 检查以下废弃的文件
RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          3      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_5_gl9cvbtm_.arc
Archive Log          1      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_8_gmqbfowj_.arc
Archive Log          2      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_9_gmqbjrmd_.arc
Archive Log          5      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_7_gl9df4p5_.arc
Archive Log          6      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_4_gl9clfkz_.arc
Archive Log          4      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_6_gl9cxkm7_.arc
Archive Log          7      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_10_gmqgf8cl_.arc
Archive Log          8      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_8_gmqgf8jr_.arc
Archive Log          9      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_9_gmqgf905_.arc
Backup Set           1      03-AUG-19
  Backup Piece       1      03-AUG-19          /home/oracle/backup/c_ORCL11G_20190803_1
Backup Set           2      03-AUG-19
  Backup Piece       2      03-AUG-19          /home/oracle/backup/ctl_04u899pu_20190803_4;
Archive Log          13     03-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_03/o1_mf_1_1_gnb29x1t_.arc
Backup Set           3      03-AUG-19
  Backup Piece       3      03-AUG-19          /home/oracle/backup/c_ORCL11G_%l_20190803_6
Archive Log          14     04-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_04/o1_mf_1_1_gnfccmyr_.arc
Archive Log          15     10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_2_gnvx3c6q_.arc
Archive Log          16     10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_3_gnvxwrj5_.arc
Backup Set           4      10-AUG-19
  Backup Piece       4      10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxws3s_.bkp
Backup Set           5      10-AUG-19
  Backup Piece       5      10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxwt66_.bkp
Archive Log          17     10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_4_gnvy7rm9_.arc
Backup Set           6      10-AUG-19
  Backup Piece       6      10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxwv8t_.bkp
Archive Log          18     10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_5_gnvy9x45_.arc
Archive Log          19     10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_6_gnvyb315_.arc

从输出来看，数据库全备之前产生的归档日志及其备份都被标识为废弃文件

3.6 删除废弃的文件
RMAN> delete noprompt 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
-------------------- ------ ------------------ --------------------
Archive Log          3      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_5_gl9cvbtm_.arc
Archive Log          1      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_8_gmqbfowj_.arc
Archive Log          2      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_9_gmqbjrmd_.arc
Archive Log          5      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_7_gl9df4p5_.arc
Archive Log          6      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_4_gl9clfkz_.arc
Archive Log          4      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_6_gl9cxkm7_.arc
Archive Log          7      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_10_gmqgf8cl_.arc
Archive Log          8      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_8_gmqgf8jr_.arc
Archive Log          9      27-JUL-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_9_gmqgf905_.arc
Backup Set           1      03-AUG-19
  Backup Piece       1      03-AUG-19          /home/oracle/backup/c_ORCL11G_20190803_1
Backup Set           2      03-AUG-19
  Backup Piece       2      03-AUG-19          /home/oracle/backup/ctl_04u899pu_20190803_4;
Archive Log          13     03-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_03/o1_mf_1_1_gnb29x1t_.arc
Backup Set           3      03-AUG-19
  Backup Piece       3      03-AUG-19          /home/oracle/backup/c_ORCL11G_%l_20190803_6
Archive Log          14     04-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_04/o1_mf_1_1_gnfccmyr_.arc
Archive Log          15     10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_2_gnvx3c6q_.arc
Archive Log          16     10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_3_gnvxwrj5_.arc
Backup Set           4      10-AUG-19
  Backup Piece       4      10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxws3s_.bkp
Backup Set           5      10-AUG-19
  Backup Piece       5      10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxwt66_.bkp
Archive Log          17     10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_4_gnvy7rm9_.arc
Backup Set           6      10-AUG-19
  Backup Piece       6      10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxwv8t_.bkp
Archive Log          18     10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_5_gnvy9x45_.arc
Archive Log          19     10-AUG-19          /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_6_gnvyb315_.arc
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_5_gl9cvbtm_.arc RECID=3 STAMP=1014719046
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_8_gmqbfowj_.arc RECID=1 STAMP=1014719046
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_9_gmqbjrmd_.arc RECID=2 STAMP=1014719046
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_7_gl9df4p5_.arc RECID=5 STAMP=1014719047
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_4_gl9clfkz_.arc RECID=6 STAMP=1014719047
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_6_gl9cxkm7_.arc RECID=4 STAMP=1014719047
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_10_gmqgf8cl_.arc RECID=7 STAMP=1014720040
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_8_gmqgf8jr_.arc RECID=8 STAMP=1014720040
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_9_gmqgf905_.arc RECID=9 STAMP=1014720041
deleted backup piece
backup piece handle=/home/oracle/backup/c_ORCL11G_20190803_1 RECID=1 STAMP=1015326317
deleted backup piece
backup piece handle=/home/oracle/backup/ctl_04u899pu_20190803_4; RECID=2 STAMP=1015326527
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_03/o1_mf_1_1_gnb29x1t_.arc RECID=13 STAMP=1015330237
deleted backup piece
backup piece handle=/home/oracle/backup/c_ORCL11G_%l_20190803_6 RECID=3 STAMP=1015326746
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_04/o1_mf_1_1_gnfccmyr_.arc RECID=14 STAMP=1015437812
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_2_gnvx3c6q_.arc RECID=15 STAMP=1015914731
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_3_gnvxwrj5_.arc RECID=16 STAMP=1015915544
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxws3s_.bkp RECID=4 STAMP=1015915545
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxwt66_.bkp RECID=5 STAMP=1015915546
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_4_gnvy7rm9_.arc RECID=17 STAMP=1015915896
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxwv8t_.bkp RECID=6 STAMP=1015915547
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_5_gnvy9x45_.arc RECID=18 STAMP=1015915965
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_6_gnvyb315_.arc RECID=19 STAMP=1015915971
Deleted 22 objects

数据库备份之前产生的备份集及归档日志都被删除了，检查以下现有备份文件及归档日志，没有归档日志，备份集只剩一下数据库全备的：

RMAN> list backup;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    1.03G      DISK        00:00:27     10-AUG-19
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20190810T065316
        Piece Name: /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_nnndf_TAG20190810T065316_gnvybw9j_.bkp
  List of Datafiles in backup set 7
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1028593    10-AUG-19 /u01/app/oracle/oradata/orcl11g/system01.dbf
  2       Full 1028593    10-AUG-19 /u01/app/oracle/oradata/orcl11g/sysaux01.dbf
  3       Full 1028593    10-AUG-19 /u01/app/oracle/oradata/orcl11g/undotbs01.dbf
  4       Full 1028593    10-AUG-19 /u01/app/oracle/oradata/orcl11g/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    9.67M      DISK        00:00:01     10-AUG-19
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20190810T065316
        Piece Name: /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_ncsnf_TAG20190810T065316_gnvyd0dg_.bkp
  SPFILE Included: Modification time: 10-AUG-19
  SPFILE db_unique_name: ORCL11G
  Control File Included: Ckp SCN: 1028605      Ckp time: 10-AUG-19
RMAN> list archivelog all;

specification does not match any archived log in the repository
4 验证delete archivelog命令
4.1 更改归档删除策略为None，归档删除策略为未经备份的归档日志也可以删除。
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO None;

old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
new RMAN configuration parameters are successfully stored
4.2 产生几个归档日志
RMAN> sql 'alter system switch logfile';

sql statement: alter system switch logfile

RMAN> sql 'alter system switch logfile';

sql statement: alter system switch logfile

RMAN>  sql 'alter system switch logfile';

sql statement: alter system switch logfile


RMAN>
RMAN> list archivelog all;

List of Archived Log Copies for database with db_unique_name ORCL11G
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
20      1    7       A 10-AUG-19
        Name: /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_7_gnvzpxgh_.arc

21      1    8       A 10-AUG-19
        Name: /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_8_gnvzq4ch_.arc

22      1    9       A 10-AUG-19
        Name: /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_9_gnvzq9jc_.arc
4.3 系统中没有obsolete文件
RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found
4.4 删除归档日志
RMAN> delete noprompt archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK
List of Archived Log Copies for database with db_unique_name ORCL11G
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
20      1    7       A 10-AUG-19
        Name: /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_7_gnvzpxgh_.arc

21      1    8       A 10-AUG-19
        Name: /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_8_gnvzq4ch_.arc

22      1    9       A 10-AUG-19
        Name: /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_9_gnvzq9jc_.arc

deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_7_gnvzpxgh_.arc RECID=20 STAMP=1015917405
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_8_gnvzq4ch_.arc RECID=21 STAMP=1015917412
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_9_gnvzq9jc_.arc RECID=22 STAMP=1015917417
Deleted 3 objects


RMAN>

删除了刚才产生的归档日志，这些归档日志是当前备份保留策略所需要的，也没有备份。可见，delete archivelog命令并不考虑数据库备份策略。

5 结论

从上面的实验上来看，delete archivelog命令只遵循归档日志删除策略，delete obsolete命令只遵循备份保留策略，因此，在使用时要注意二者的相互影响，即delete obsolete 命令可以破坏归档日志删除策略，delete archivelog 可以破坏备份保留策略，在使用脚本自动备份时，要仔细分析和验证，避免造成意外的结果，而在dataguard环境尤其要谨慎使用delete obsolete 命令，避免删除未传输的日志。

lichx123
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
11gR2 RMAN归档日志删除策略
congxinlan3332的博客
09-14 258
从11gR2开始，RMAN引入了归档删除策略的配置，下面我们通过简单的例子来讨论这个功能：数据库版本：SQL> select * from v$version; BANNER------------------...
oracle 取消rman,关于Oracle RMAN 归档删除策略
weixin_42299560的博客
04-06 253
RMAN> show all;CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;在Oracle10g 11g 中 归档删除策略 缺省是没有配置的；那么这时去删除未应用过的的归档日志会是怎么一种情况：RMAN> delete archivelog all;released channel: ORA_DISK_1allocated channel:...
RMAN-Configuring an Archived Redo Log Deletion Policy
congjiong8459的博客
02-25 273
在RMAN的备份策略中有两条关于归档日志的策略： 一个是归档日志备份备份副本的个数。 CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; ...
聊聊RMAN的ARCHIVELOG DELETION参数
Data & Analysis
12-28 2798
RMAN是Oracle推出的官方备份还原工具。经过几个大版本的发展，RMAN已经支持多种备份介质和恢复策略的主要工具，也是业界普遍认可是Oracle备份还原官方策略。 Archivelog是Oracle备份还原策略的重要组成元素，不完全备份+连续的归档日志可以让我们将数据库恢复到发生故障点，实现数据的无损失恢复。但是，现实生活中archive log给没有经验的运维人员也带来了不少的问题，归档空...
oracle归档日志 delete obsolete 保留一次全备,RMAN备份实施方法
weixin_39638309的博客
04-05 232
RMAN备份实施操作1.硬件环境与软件环境1、硬件环境：p5952、软件环境：AIX6.1 x86_64+Oracle 10g(10.1.0.1) RAC注意：RAC环境下只需在一个节点上执行备份操作即可。2.修改非归档模式为归档模式使用Rman备份最好数据库运行在归档模式下，如果系统运行在非归档模式下，需要修改非归档模式为归档模式。修改方法如下：(一)关闭数据库。关闭之前备份已有的数据，改变数据...
rman配置及rman常用命令操作
09-10
4. 设置保留策略：RMAN 提供了多种保留策略，如 `CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;` 保留足够恢复到最近7天的备份，`CONFIGURE RETENTION POLICY TO REDUNDANCY 5;` 保留最新的5份备份，而...
rman.zip_oracle_rman
09-23
Oracle RMAN（Recovery Manager）是Oracle数据库管理系统中一个强大的备份和恢复工具，它提供了全面的数据保护方案。在Oracle环境中，RMAN能够执行各种备份操作，包括冷备份和热备份，以确保数据的安全性和可恢复性...
RMAN.rar_oracle_rman
09-24
RMAN的`DELETE OBSOLETE`命令可以帮助自动清理过期的备份集，而`CATALOG`和`NOCATALOG`选项则用于管理备份元数据的存储位置，可以是数据库控制文件或者RMAN的恢复目录。 最后，RMAN还提供了报告和分析功能，如`LIST...
oracle RMAN备份命令
08-21
RMAN通过与数据库服务器交互，可以执行多种备份策略，确保数据的安全性和可用性。下面将详细介绍RMAN的一些关键命令和流程。 首先，要切换数据库到归档模式，这是进行完整备份的基础。在SQL*Plus环境中，需要以DBA...
oracle Rman删除归档脚本for windows
11-11
Oracle RMAN 删除归档脚本 for Windows Oracle RMAN（Recovery Manager）是一款强大的备份和恢复工具，用于管理 Oracle 数据库的备份和恢复。然而，RMAN 占用的磁盘空间可能会变得越来越大，从而影响数据库的性能...
oracle清除过期备份,rman delete obsolete删除过期备份集问题
weixin_36054213的博客
04-03 641
os : Redhat5.5db：Oracle 11.2.0.1问题：备份策略，把当天备份的备份集删除了！有遇到过这问题的吗？贴下rman脚本，以及日志--保留策略为7天using target database control file instead of recovery catalogRMAN configuration parameters for database with db_un...
RMAN ---delete obsolete 不能删除 控制文件copy
xxjj2003的专栏
10-08 863
RMAN ---delete obsolete 不能删除 控制文件copy lixora   RMAN ---delete obsolete  不能删除 控制文件copy 说明 /tmp/contrlfile   /tmp/controlfile.bkp    /home/oracle/control01.ctl  已经通过os命令删除了 现在的疑问是如何删除这些...
oracle数据库备份过期,RMAN 备份过期不能自动删除
weixin_39648492的博客
04-06 355
备份脚本如下： $BAK_LEVEL 是一个变量 根据星期得出备份级别周天0级，周三1级其余2级run{configure retention policy to recovery window of 7 days;configure controlfile autobackup on;allocate channel c1 type disk;allocate channel c2 ty...
oracle 怎么自动清归档,rman每日做数据库全备，为什么不能自动清归档日志，郁闷中！...
weixin_31515619的博客
04-09 182
数据库是10.2.0.4每日备份脚本是：run {configure retention policy to recovery window of 6 days;configure controlfile autobackup on;configure controlfile autobackup format for device type disk to '/backup/%F';alloca...
oracle清除过期备份,oracle rman 不能发现及删除过期备份问题
weixin_36173545的博客
04-03 462
问题是这样的。我们有一套数据库，大概4t的数据库量。rman备份到本地文件系统，因为挂载的存储空间有限，每周六晚做一次全备后，上一次的全备就应该删除。配置了rman的脚本为：CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default之前一直运行正常，但这周一(即8月10日)早上检查，发现8.8及8.1的备份都在，文件系统使用率95%。rman tar...
rman命令总结
袁子建
06-25 818
RMAN命令详解和常用汇总 转摘汇集，日后使用 本文链接：https://blog.csdn.net/EVISWANG/article/details/50448370 http://blog.itpub.net/25904686/viewspace-742701/ https://blog.csdn.net/zq9017197/article/details/6869579 https://www.cnblogs.com/polestar/archive/2013/02/06/2902598.html .
RMAN delete noprompt obsolete参数研究
Kay的博客
05-16 6292
RMAN delete noprompt obsolete参数研究 经过测试发现，delete noprompt obsolete;只会根据RMAN的保留策略为参考，如果在T0时间点存在多个归档日志，在T1时间点做了RMAN全备，此时report obsolete；那么T0时间点的归档日志都会被标记为过期，再根据保留策略RMAN会清理归档日志。 备注：如果有0级备份、1级备份，做完1级备份之后，会...
oracle rman delete backupset,RMAN Crosscheck后delete obsolete遇到RMAN-06091的解决
weixin_39632693的博客
04-04 478
先摘录一段对CROSSCHECK的描述当archivelog或是backup被手工删除后，需要运行crosscheck.该命令确保recoverycatalog或是控制文件中记录的数据与硬盘上的文件一致。对于找不到的文件，CROSSCHECK会把它的状态标为EXPIRED.然后，你运行DELETEEXPIRED命令就可以把rman repository中的相关记录和硬盘上的文件删除。如果有些文件被...
oracle数据库RMAN 下的 delete 命令如何使用？
天哥--天行健君子以自强不息
09-14 2113
0.删除之前通常先进行检查 RMAN> crosscheck copy;RMAN> crosscheck backup; RMAN> crosscheck backupset; RMAN> crosscheck archivelog all;   1.删除过期备份。当使用RMAN命令执行备份操作时，RMAN会根据备份冗余策略确定备份是否过期。 RMAN> ...
oracle rman 语法
最新发布
05-16
Oracle RMAN（Recovery Manager）是一个强大的工具，它提供了灵活的命令集来管理数据库备份和恢复。RMAN语法有很多用途，包括备份、恢复等操作。 备份语法： RMAN备份语法包括备份数据库、备份特定文件/表空间、...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值