删除rman 备份集（为了安全起见，只在实验环境下使用）

最新推荐文章于 2024-05-20 07:30:00 发布
最新推荐文章于 2024-05-20 07:30:00 发布
阅读量8.5k 收藏 9
点赞数 3
分类专栏： 学习笔记 文章标签： rman oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kobe24shou/article/details/19003199
版权

[oracle@ls ~]$ rman target /    

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Feb 8 19:38:49 2014

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

connected to target database: LS1 (DBID=393688816)

RMAN> list backup;  查看备份集

using target database control file instead of recovery catalog

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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    1.01G      DISK        00:01:26     08-FEB-14      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T093116
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnndf_TAG20140208T093116_9hdhxnw7_.bkp
  List of Datafiles in backup set 6
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1633376    08-FEB-14 /u01/oradata/ls1/system01.dbf
  2       Full 1633376    08-FEB-14 /u01/oradata/ls1/sysaux01.dbf
  3       Full 1633376    08-FEB-14 /u01/oradata/ls1/undotbs01.dbf
  4       Full 1633376    08-FEB-14 /u01/oradata/ls1/users01.dbf
  5       Full 1633376    08-FEB-14 /u01/oradata/ls1/test01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    9.36M      DISK        00:00:04     08-FEB-14      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T093116
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsnf_TAG20140208T093116_9hdj0q15_.bkp
  SPFILE Included: Modification time: 08-FEB-14
  SPFILE db_unique_name: LS1
  Control File Included: Ckp SCN: 1633432      Ckp time: 08-FEB-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Incr 0  1.02G      DISK        00:01:57     08-FEB-14      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T190540
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnnd0_TAG20140208T190540_9hfklqdz_.bkp
  List of Datafiles in backup set 8
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1640770    08-FEB-14 /u01/oradata/ls1/system01.dbf
  2    0  Incr 1640770    08-FEB-14 /u01/oradata/ls1/sysaux01.dbf
  3    0  Incr 1640770    08-FEB-14 /u01/oradata/ls1/undotbs01.dbf
  4    0  Incr 1640770    08-FEB-14 /u01/oradata/ls1/users01.dbf
  5    0  Incr 1640770    08-FEB-14 /u01/oradata/ls1/test01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9       Incr 0  9.36M      DISK        00:00:04     08-FEB-14      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T190540
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsn0_TAG20140208T190540_9hfkpns8_.bkp
  SPFILE Included: Modification time: 08-FEB-14
  SPFILE db_unique_name: LS1
  Control File Included: Ckp SCN: 1640825      Ckp time: 08-FEB-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10      Incr 1  232.00K    DISK        00:00:52     08-FEB-14      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T190903
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnnd1_TAG20140208T190903_9hfkrzhr_.bkp
  List of Datafiles in backup set 10
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    1  Incr 1640881    08-FEB-14 /u01/oradata/ls1/system01.dbf
  2    1  Incr 1640881    08-FEB-14 /u01/oradata/ls1/sysaux01.dbf
  3    1  Incr 1640881    08-FEB-14 /u01/oradata/ls1/undotbs01.dbf
  4    1  Incr 1640881    08-FEB-14 /u01/oradata/ls1/users01.dbf
  5    1  Incr 1640881    08-FEB-14 /u01/oradata/ls1/test01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Incr 1  9.36M      DISK        00:00:03     08-FEB-14      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T190903
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsn1_TAG20140208T190903_9hfktsmw_.bkp
  SPFILE Included: Modification time: 08-FEB-14
  SPFILE db_unique_name: LS1
  Control File Included: Ckp SCN: 1640904      Ckp time: 08-FEB-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
12      51.41M     DISK        00:00:05     08-FEB-14      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T192917
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_annnn_TAG20140208T192917_9hflyxjl_.bkp

  List of Archived Logs in backup set 12
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    27      1502570    12-JAN-14 1513949    12-JAN-14
  1    28      1513949    12-JAN-14 1540850    12-JAN-14
  1    29      1540850    12-JAN-14 1544165    14-JAN-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
13      233.96M    DISK        00:00:27     08-FEB-14      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T192917
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_annnn_TAG20140208T192917_9hflz5dd_.bkp

  List of Archived Logs in backup set 13
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1       1543639    14-JAN-14 1557052    17-JAN-14
  1    2       1557052    17-JAN-14 1571616    18-JAN-14
  1    3       1571616    18-JAN-14 1591933    07-FEB-14
  1    4       1591933    07-FEB-14 1599836    07-FEB-14
  1    5       1599836    07-FEB-14 1631824    08-FEB-14
  1    6       1631824    08-FEB-14 1642550    08-FEB-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    1.02G      DISK        00:03:04     08-FEB-14      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T193000
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnndf_TAG20140208T193000_9hfm08o3_.bkp
  List of Datafiles in backup set 14
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1642588    08-FEB-14 /u01/oradata/ls1/system01.dbf
  2       Full 1642588    08-FEB-14 /u01/oradata/ls1/sysaux01.dbf
  3       Full 1642588    08-FEB-14 /u01/oradata/ls1/undotbs01.dbf
  4       Full 1642588    08-FEB-14 /u01/oradata/ls1/users01.dbf
  5       Full 1642588    08-FEB-14 /u01/oradata/ls1/test01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    9.36M      DISK        00:00:02     08-FEB-14      
        BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T193000
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsnf_TAG20140208T193000_9hfm62xh_.bkp
  SPFILE Included: Modification time: 08-FEB-14
  SPFILE db_unique_name: LS1
  Control File Included: Ckp SCN: 1642738      Ckp time: 08-FEB-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
16      150.50K    DISK        00:00:00     08-FEB-14      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T193308
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_annnn_TAG20140208T193308_9hfm645o_.bkp

  List of Archived Logs in backup set 16
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       1642550    08-FEB-14 1642744    08-FEB-14

RMAN> delete backupset 6;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=148 device type=DISK

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
6       6       1   1   AVAILABLE   DISK        /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnndf_TAG20140208T093116_9hdhxnw7_.bkp

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnndf_TAG20140208T093116_9hdhxnw7_.bkp RECID=6 STAMP=838978276
Deleted 1 objects

RMAN> list backupset;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    9.36M      DISK        00:00:04     08-FEB-14      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T093116
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsnf_TAG20140208T093116_9hdj0q15_.bkp
  SPFILE Included: Modification time: 08-FEB-14
  SPFILE db_unique_name: LS1
  Control File Included: Ckp SCN: 1633432      Ckp time: 08-FEB-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Incr 0  1.02G      DISK        00:01:57     08-FEB-14      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T190540
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnnd0_TAG20140208T190540_9hfklqdz_.bkp
  List of Datafiles in backup set 8
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1640770    08-FEB-14 /u01/oradata/ls1/system01.dbf
  2    0  Incr 1640770    08-FEB-14 /u01/oradata/ls1/sysaux01.dbf
  3    0  Incr 1640770    08-FEB-14 /u01/oradata/ls1/undotbs01.dbf
  4    0  Incr 1640770    08-FEB-14 /u01/oradata/ls1/users01.dbf
  5    0  Incr 1640770    08-FEB-14 /u01/oradata/ls1/test01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9       Incr 0  9.36M      DISK        00:00:04     08-FEB-14      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T190540
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsn0_TAG20140208T190540_9hfkpns8_.bkp
  SPFILE Included: Modification time: 08-FEB-14
  SPFILE db_unique_name: LS1
  Control File Included: Ckp SCN: 1640825      Ckp time: 08-FEB-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10      Incr 1  232.00K    DISK        00:00:52     08-FEB-14      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T190903
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnnd1_TAG20140208T190903_9hfkrzhr_.bkp
  List of Datafiles in backup set 10
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    1  Incr 1640881    08-FEB-14 /u01/oradata/ls1/system01.dbf
  2    1  Incr 1640881    08-FEB-14 /u01/oradata/ls1/sysaux01.dbf
  3    1  Incr 1640881    08-FEB-14 /u01/oradata/ls1/undotbs01.dbf
  4    1  Incr 1640881    08-FEB-14 /u01/oradata/ls1/users01.dbf
  5    1  Incr 1640881    08-FEB-14 /u01/oradata/ls1/test01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Incr 1  9.36M      DISK        00:00:03     08-FEB-14      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T190903
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsn1_TAG20140208T190903_9hfktsmw_.bkp
  SPFILE Included: Modification time: 08-FEB-14
  SPFILE db_unique_name: LS1
  Control File Included: Ckp SCN: 1640904      Ckp time: 08-FEB-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
12      51.41M     DISK        00:00:05     08-FEB-14      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T192917
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_annnn_TAG20140208T192917_9hflyxjl_.bkp

  List of Archived Logs in backup set 12
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    27      1502570    12-JAN-14 1513949    12-JAN-14
  1    28      1513949    12-JAN-14 1540850    12-JAN-14
  1    29      1540850    12-JAN-14 1544165    14-JAN-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
13      233.96M    DISK        00:00:27     08-FEB-14      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T192917
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_annnn_TAG20140208T192917_9hflz5dd_.bkp

  List of Archived Logs in backup set 13
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1       1543639    14-JAN-14 1557052    17-JAN-14
  1    2       1557052    17-JAN-14 1571616    18-JAN-14
  1    3       1571616    18-JAN-14 1591933    07-FEB-14
  1    4       1591933    07-FEB-14 1599836    07-FEB-14
  1    5       1599836    07-FEB-14 1631824    08-FEB-14
  1    6       1631824    08-FEB-14 1642550    08-FEB-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    1.02G      DISK        00:03:04     08-FEB-14      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T193000
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnndf_TAG20140208T193000_9hfm08o3_.bkp
  List of Datafiles in backup set 14
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1642588    08-FEB-14 /u01/oradata/ls1/system01.dbf
  2       Full 1642588    08-FEB-14 /u01/oradata/ls1/sysaux01.dbf
  3       Full 1642588    08-FEB-14 /u01/oradata/ls1/undotbs01.dbf
  4       Full 1642588    08-FEB-14 /u01/oradata/ls1/users01.dbf
  5       Full 1642588    08-FEB-14 /u01/oradata/ls1/test01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    9.36M      DISK        00:00:02     08-FEB-14      
        BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T193000
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsnf_TAG20140208T193000_9hfm62xh_.bkp
  SPFILE Included: Modification time: 08-FEB-14
  SPFILE db_unique_name: LS1
  Control File Included: Ckp SCN: 1642738      Ckp time: 08-FEB-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
16      150.50K    DISK        00:00:00     08-FEB-14      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20140208T193308
        Piece Name: /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_annnn_TAG20140208T193308_9hfm645o_.bkp

  List of Archived Logs in backup set 16
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       1642550    08-FEB-14 1642744    08-FEB-14

RMAN> delete backupset;  删除全部备份集

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
7       7       1   1   AVAILABLE   DISK        /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsnf_TAG20140208T093116_9hdj0q15_.bkp
8       8       1   1   AVAILABLE   DISK        /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnnd0_TAG20140208T190540_9hfklqdz_.bkp
9       9       1   1   AVAILABLE   DISK        /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsn0_TAG20140208T190540_9hfkpns8_.bkp
10      10      1   1   AVAILABLE   DISK        /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnnd1_TAG20140208T190903_9hfkrzhr_.bkp
11      11      1   1   AVAILABLE   DISK        /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsn1_TAG20140208T190903_9hfktsmw_.bkp
12      12      1   1   AVAILABLE   DISK        /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_annnn_TAG20140208T192917_9hflyxjl_.bkp
13      13      1   1   AVAILABLE   DISK        /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_annnn_TAG20140208T192917_9hflz5dd_.bkp
14      14      1   1   AVAILABLE   DISK        /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnndf_TAG20140208T193000_9hfm08o3_.bkp
15      15      1   1   AVAILABLE   DISK        /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsnf_TAG20140208T193000_9hfm62xh_.bkp
16      16      1   1   AVAILABLE   DISK        /u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_annnn_TAG20140208T193308_9hfm645o_.bkp

Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsnf_TAG20140208T093116_9hdj0q15_.bkp RECID=7 STAMP=838978374
deleted backup piece
backup piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnnd0_TAG20140208T190540_9hfklqdz_.bkp RECID=8 STAMP=839012743
deleted backup piece
backup piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsn0_TAG20140208T190540_9hfkpns8_.bkp RECID=9 STAMP=839012868
deleted backup piece
backup piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnnd1_TAG20140208T190903_9hfkrzhr_.bkp RECID=10 STAMP=839012943
deleted backup piece
backup piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsn1_TAG20140208T190903_9hfktsmw_.bkp RECID=11 STAMP=839013001
deleted backup piece
backup piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_annnn_TAG20140208T192917_9hflyxjl_.bkp RECID=12 STAMP=839014157
deleted backup piece
backup piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_annnn_TAG20140208T192917_9hflz5dd_.bkp RECID=13 STAMP=839014165
deleted backup piece
backup piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnndf_TAG20140208T193000_9hfm08o3_.bkp RECID=14 STAMP=839014200
deleted backup piece
backup piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsnf_TAG20140208T193000_9hfm62xh_.bkp RECID=15 STAMP=839014386
deleted backup piece
backup piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_annnn_TAG20140208T193308_9hfm645o_.bkp RECID=16 STAMP=839014388
Deleted 10 objects
RMAN> list backupset;

specification does not match any backup in the repository

Delete命令可以用来删除指定的备份或者用来删除废弃或者是过期的备份集

如删除指定的备份集与备份片
RMAN> DELETE BACKUPPIECE 101;
RMAN> DELETE CONTROLFILECOPY '/tmp/control01.ctl';
RMAN> DELETE BACKUP OF TABLESPACE users DEVICE TYPE sbt;
删除过期或者废弃了的备份
RMAN> DELETE EXPIRED BACKUP;
RMAN> DELETE NOPROMPT OBSOLETE;
RMAN> DELETE OBSOLETE REDUNDANCY = 3;
RMAN> DELETE OBSOLETE RECOVERY WINDOW OF 7 DAYS;
删除指定的备份归档

RMAN> DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = 300;


lsdb
关注
  • 3
    点赞
  • 踩
  • 9
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
RMAN删除备份集_笔记
撞强※非专业，更专注
03-30 5822
1自动删除 删除归档日志 delete input;   report obsolete命令报告过期备份 RMAN> report obsolete; delete obsolete删除所有以前的备份（包括数据文件、归档、控制文件） RMAN> delete obsolete; RMAN> crosscheck archivelog all;   2手动删除 手工删除备份集，
【转】RMAN删除过期备份或非过期备份
weixin_30895723的博客
06-07 347
（一）删除备份--DELETE命令用于删除RMAN备份记录及相应的物理文件。当使用RMAN执行备份操作时，会在RMAN资料库（RMAN Repository）中生成RMAN备份记录，默认情况下RMAN备份记录会被存放在目标数据库的控制文件中，如果配置了恢复目录（Recovery Catalog），那么该备份记录也会被存放到恢复目录中。RMAN中的DELETE命令就是用来删除记录（某些情况...
【Oracle篇】rman工具实用指南：常用命令详解与实践（第二篇，总共八篇）
最新发布
奈斯DBA的博客
05-20 1543
rman工具实用指南，了解rman工具中的backup、list、restore、recover、delete、report、configure、set、crosscheck、validate、Switch、blockrecover、catalog、convert等命令的使用。
RMAN 备份恢复、删除归档
howard_shooter的博客
03-26 1405
通过设置备份策略，决定哪些备份是obsolete，obsolete的备份并不会自动删除，需要手工删除： list backup report obsolete delete obsolete 使用RMAN既可以做单独的tablespace备份，datafile备份，也可以做全库备份：backup database format '/u01/app/oracle/backup-rman/db_%d_%T_%U.bak'; 或直接 backup database; 会备份到db_recovery_file_
Oracle 如何删除控制文件中rman备份到磁带的备份集信息(RMAN-06091)
dbhang的博客
09-23 1531
如何删除控制文件中rman备份到磁带的备份集信息 SQL> select name,block_size*file_size_blks/1024/1024 bytes from v$controlfile; NAME BYTES ------------------------------ ---------- /oracle/app/data/control01.ctl 66.46875 /oracle/app/data/contro
配置RMAN清除已应用到备库的归档日志
cuchou5321的博客
09-12 421
DataGuard的配置中，有时我们需要利用RMAN自动从FRA清除已经应用到备库的归档日志。当数据库满足下列条件时，FRA下的归档日志将被自动清除。 1)11g之前，如果不使用mandatory ARCHIVELOG目标，...
Oracle Rman备份集在异机恢复
03-25
Oracle Rman备份集在异机恢复
LINUX环境下使用RMAN开展数据库备份--ZW.doc
10-28
运维
EBS R12.2环境克隆（使用rman备份）
04-26
### EBS R12.2环境克隆（使用rman备份） #### 概述 本文档旨在详细介绍如何通过Oracle的Recovery Manager (RMAN)工具来进行EBS (Enterprise Business Suite) R12.2环境的克隆过程。该方法不仅能够有效备份数据，还...
rman.rar_8YA_oracle_oracle windows环境备份脚本_rman
09-24
Oracle数据库在Windows环境下的备份是数据库管理中的重要环节，RMAN（Recovery Manager）是Oracle提供的一款强大的数据库备份和恢复工具。"rman.rar_8YA_oracle_oracle windows环境备份脚本_rman"这个压缩包文件显然...
Oracle RMAN自动备份在LINUX环境下的配置与实现.pdf
09-06
在Linux环境下配置Oracle RMAN自动备份，可以帮助数据库管理员实现高效、安全的数据保护策略，减轻日常维护工作量。 1. RMAN体系结构： - RMAN工具：这是用户与RMAN交互的接口，通常通过SQL*Plus或OEM（Oracle ...
oracle dump备份 清理,清理RMAN备份数据中的过期数据
weixin_29051149的博客
04-04 415
好几天没开VM学习ORACLE今天启动出现下面错误：[root@web1 bdump]# pwd/opt/oracle/admin/testdb2/bdump[root@web1 bdump]#cat alert_oradb.logundo_tablespace = UNDOTBS1remote_login_passwordfile= EXCLUSIVEdb_domain...
linux rman删除备份,无法删除RMAN过期备份
weixin_39966225的博客
05-12 729
RMAN> report obsolete直接delete会报这个错误：RMAN> delete obsolete;RMAN 保留策略将应用于该命令将 RMAN 保留策略设置为冗余 1分配的通道: ORA_DISK_1通道 ORA_DISK_1: sid=136 devtype=DISK释放的通道: ORA_DISK_1crosscheck也不行RMAN> crosscheck ...
DM8的备份与还原
weixin_43322993的博客
10-22 378
DM8的备份与还原 一、脱机备份与还原 1，首先先暂停DmSeivice服务 2，进入DM8安装目录的bin目录下启动dmrman 3，进行脱机备份，输入正确的dm.ini文件路径后，full代表全量备份，如果不写默认全量备份，在指定备份的备份集目录以及命名即可。 4，可以通过show命令来查看备份集，通过查看可以看到备份集的一些信息，包括备份的内容，还有时间，以及一些数据库得配置等等。 5，通过check命令可以检查备份集 6，检查无误后，可以对数据库执行恢复。 7，恢复完成后，启动Dm
RMAN详细教程(二) —— 备份、检查、维护、恢复
Ruishine的博客
07-15 3748
RMAN详细教程(二) —— 备份、检查、维护、恢复
Oracle数据库rman清除归档备份日志操作
weixin_42188415的博客
09-11 1330
Oracle数据库rman清除归档备份日志操作 linux环境下 rman target/ 进入rman crosscheck backup; list backup of archivelog all; 查看所有归档备份文件 delete backup of archivelog all completed before time ‘sysdate-7’;清理归档日志的备份文件...
linux rman删除备份,【RMAN】【RMAN命令】DELETE 命令(5)--删除特定备份集(不提示)
weixin_31588005的博客
05-12 229
删除特定备份集(不提示)RMAN>delete noprompt backupset 16;▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼RMAN> list backupset summary;使用目标数据库控制文件替代恢复目录备份列表===============关键字 TY LV S 设备类型 完成时间 段数 副本数 压缩标记...
"使用Oracle RMAN备份和恢复管理器进行数据库备份和恢复操作
在使用RMAN进行备份之前，必须启动Oracle的归档日志功能。 为了检查数据库的归档日志模式，首先需要使用DBA用户登录系统，并执行如下的SQL代码： SELECT log_mode from v$database; 如果查询结果为NOARCHIVELOG，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值