请问下大家有遇到这个问题吗？
在oracle 12c rman中通过设置CONFIGURE RETENTION POLICY TO REDUNDANCY 1;加rman delete noprompt obsolete; 去实现过期备份文件自动删除。
DB数据文件与归档文件的备份所产生的备份文件是可以自动标识出过期并自动删除的。
但发现无法删除备份的控制文件，这些备份的控制文件为永不过期？
这是哪里设置不对还是DB的BUB:
RMAN> show all;
RMAN configuration parameters for database with db_unique_name TE12C are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_%F’;
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 ‘/u01/app/ora12c/oracle/product/12.2.0/db_1/dbs/snapcf_te12c.f’; # default
RMAN> list backup of controlfile;
List of Backup Sets
BS Key Type LV Size Device Type Elapsed Time Completion Time
1 Full 17.94M DISK 00:00:01 2020-06-09 15:33:41
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20200609T153340
Piece Name: /u01/app/ora12c/oracle/fast_recovery_area/te12c/TE12C/autobackup/2020_06_09/o1_mf_s_1042644820_hfygtoc4_.bkp
Control File Included: Ckp SCN: 996437 Ckp time: 2020-06-09 15:33:40
BS Key Type LV Size Device Type Elapsed Time Completion Time
2 Full 17.97M DISK 00:00:01 2021-02-03 15:08:17
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20210203T150816
Piece Name: /u01/app/ora12c/oracle/fast_recovery_area/te12c/TE12C/autobackup/2021_02_03/o1_mf_s_1063552096_j1nlz1th_.bkp
Control File Included: Ckp SCN: 19098457 Ckp time: 2021-02-03 15:08:16
BS Key Type LV Size Device Type Elapsed Time Completion Time
3 Full 17.97M DISK 00:00:01 2021-08-27 17:48:27
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20210827T174826
Piece Name: /u01/app/ora12c/oracle/fast_recovery_area/te12c/TE12C/autobackup/2021_08_27/o1_mf_s_1081705706_jlkf7cmz_.bkp
Control File Included: Ckp SCN: 30347197 Ckp time: 2021-08-27 17:48:26
BS Key Type LV Size Device Type Elapsed Time Completion Time
8 Full 17.97M DISK 00:00:01 2021-09-02 09:45:49
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20210902T094548
Piece Name: /u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_c-3112643872-20210902-00
Control File Included: Ckp SCN: 31210228 Ckp time: 2021-09-02 09:45:48
BS Key Type LV Size Device Type Elapsed Time Completion Time
13 Full 17.97M DISK 00:00:01 2021-09-02 10:39:37
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20210902T103936
Piece Name: /u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_c-3112643872-20210902-01
Control File Included: Ckp SCN: 31213378 Ckp time: 2021-09-02 10:39:36
BS Key Type LV Size Device Type Elapsed Time Completion Time
18 Full 17.97M DISK 00:00:01 2021-09-02 10:45:41
BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20210902T104540
Piece Name: /u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_c-3112643872-20210902-02
Control File Included: Ckp SCN: 31213690 Ckp time: 2021-09-02 10:45:40
BS Key Type LV Size Device Type Elapsed Time Completion Time
20 Full 17.97M DISK 00:00:01 2021-09-02 11:00:57
BP Key: 20 Status: AVAILABLE Compressed: NO Tag: TAG20210902T110056
Piece Name: /u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_c-3112643872-20210902-03
Control File Included: Ckp SCN: 31214660 Ckp time: 2021-09-02 11:00:56
#!/bin/bash
. /home/oracle/.bash_profile
rman target / < BACKUP as compressed backupset full FORMAT '/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_full_%d_%T_%s.bak' database filesperset 50; delete noprompt obsolete; EOF
评论
有用 0RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/oracle/fast_recovery_area/te12c/TE12C/autobackup/2020_06_09/o1_mf_s_1042644820_hfygtoc4_.bkp RECID=1 STAMP=1042644821
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/oracle/fast_recovery_area/te12c/TE12C/autobackup/2021_02_03/o1_mf_s_1063552096_j1nlz1th_.bkp RECID=2 STAMP=1063552097
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/oracle/fast_recovery_area/te12c/TE12C/autobackup/2021_08_27/o1_mf_s_1081705706_jlkf7cmz_.bkp RECID=3 STAMP=1081705707
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_c-3112643872-20210902-00 RECID=8 STAMP=1082195149
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_c-3112643872-20210902-01 RECID=13 STAMP=1082198377
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_c-3112643872-20210902-02 RECID=18 STAMP=1082198741
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_c-3112643872-20210902-03 RECID=20 STAMP=1082199657
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_c-3112643872-20210902-04 RECID=25 STAMP=1082223236
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_full_TE12C_20210902_59.bak RECID=26 STAMP=1082223594
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_full_TE12C_20210902_60.bak RECID=27 STAMP=1082223629
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_full_TE12C_20210902_61.bak RECID=28 STAMP=1082223666
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_full_TE12C_20210902_62.bak RECID=29 STAMP=1082223750
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_c-3112643872-20210902-05 RECID=30 STAMP=1082223775
Crosschecked 13 objects
RMAN> delete noprompt expired backup;
using channel ORA_DISK_1
specification does not match any backup in the repository
RMAN> show all;
RMAN configuration parameters for database with db_unique_name TE12C are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/ora12c/dbbackup/rmanbak/ora12c/ora12c_%F';
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 1 DAYS;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/ora12c/oracle/product/12.2.0/db_1/dbs/snapcf_te12c.f'; # default
RMAN> delete noprompt expired;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "archivelog, backuppiece, backupset, backup, controlfilecopy, copy, datafilecopy, expired, force, foreign, noprompt, obsolete, proxy, preplugin"
RMAN-01007: at line 1 column 24 file: standard input
RMAN>
评论 有用 0
墨值悬赏