公司某生产系统,每天凌晨一点做数据库全被。crontab调用rman脚本实现其数据库备份,备份目录是通过NFS挂载到本地,有同事发现该目录有7.5T的空间一直留有5月1号至今的备份集为能释放。登陆主机进行查看;

RMAN备份集不能有效释放空间

下面是备份脚本,以及删除脚本
[oracle@uasdb1 ~]$ more /home/oracle/nfs/rman_level0.sh
#!/bin/bash
source ~/.bash_profile
rman target / nocatalog log /home/oracle/nfs/rman_full.log append << EOF
run
{allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup filesperset 3 as compressed backupset database format '/home/oracle/nfs/fulldata%d%T%s%p';
sql 'alter system archive log current';
sql 'alter system archive log current';
sql 'alter system archive log current';
sql 'alter system archive log current';
sql 'alter system archive log current';
backup archivelog all format '/home/oracle/nfs/arch
%d%T%s%p' delete input;
backup current controlfile format '/home/oracle/nfs/ctl
%d%T%s_%p';
}
EOF
rman target / nocatalog log /home/oracle/nfs/rman_delete.log append << EOF
allocate channel for maintenance type disk;
crosscheck backupset;
crosscheck archivelog all;
delete noprompt expired backup;
crosscheck copy;
report obsolete;
delete noprompt obsolete;
EOF

脚本两部分,一部分是备份数据库,第二部分是删除过期失效备份集,没有问题;

查看RMAN的保留周期;
RMAN备份集不能有效释放空间

自己动手删除一下过期备份看看
RMAN备份集不能有效释放空间

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


Control File Copy 6 2018:04:26 15:00:56 /u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_uasdb.f
Backup Set 7181 2018:05:20 03:35:33
Backup Piece 7181 2018:05:20 03:35:33 /home/oracle/nfs/ctl_UASDB_20180520_7261_1
Backup Set 7182 2018:05:20 03:35:33
Backup Piece 7182 2018:05:20 03:35:33 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180520-01
Backup Set 7183 2018:05:21 01:41:17
Backup Piece 7183 2018:05:21 01:41:17 /home/oracle/nfs/full_data_UASDB_20180521_7263_1
Backup Set 7185 2018:05:21 01:51:17
Backup Piece 7185 2018:05:21 01:51:17 /home/oracle/nfs/full_data_UASDB_20180521_7264_1
Backup Set 7184 2018:05:21 01:48:52
Backup Piece 7184 2018:05:21 01:48:52 /home/oracle/nfs/full_data_UASDB_20180521_7265_1
Backup Set 7186 2018:05:21 02:02:30
Backup Piece 7186 2018:05:21 02:02:30 /home/oracle/nfs/full_data_UASDB_20180521_7266_1
Backup Set 7187 2018:05:21 02:18:49
Backup Piece 7187 2018:05:21 02:18:49 /home/oracle/nfs/full_data_UASDB_20180521_7267_1
Backup Set 7188 2018:05:21 02:28:34
Backup Piece 7188 2018:05:21 02:28:34 /home/oracle/nfs/full_data_UASDB_20180521_7268_1
Backup Set 7191 2018:05:21 02:47:22
Backup Piece 7191 2018:05:21 02:47:22 /home/oracle/nfs/full_data_UASDB_20180521_7269_1
Backup Set 7193 2018:05:21 02:51:43
Backup Piece 7193 2018:05:21 02:51:43 /home/oracle/nfs/full_data_UASDB_20180521_7270_1
Backup Set 7189 2018:05:21 02:29:01
Backup Piece 7189 2018:05:21 02:29:01 /home/oracle/nfs/full_data_UASDB_20180521_7271_1
Backup Set 7190 2018:05:21 02:32:07
Backup Piece 7190 2018:05:21 02:32:07 /home/oracle/nfs/full_data_UASDB_20180521_7272_1
Backup Set 7192 2018:05:21 02:50:07
Backup Piece 7192 2018:05:21 02:50:07 /home/oracle/nfs/full_data_UASDB_20180521_7273_1
Backup Set 7194 2018:05:21 03:07:22
Backup Piece 7194 2018:05:21 03:07:22 /home/oracle/nfs/full_data_UASDB_20180521_7274_1
Backup Set 7195 2018:05:21 03:18:25
Backup Piece 7195 2018:05:21 03:18:25 /home/oracle/nfs/full_data_UASDB_20180521_7275_1
Backup Set 7196 2018:05:21 03:18:55
Backup Piece 7196 2018:05:21 03:18:55 /home/oracle/nfs/full_data_UASDB_20180521_7276_1
Backup Set 7197 2018:05:21 03:22:20
Backup Piece 7197 2018:05:21 03:22:20 /home/oracle/nfs/full_data_UASDB_20180521_7277_1
Backup Set 7198 2018:05:21 03:22:30
Backup Piece 7198 2018:05:21 03:22:30 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180521-00
Backup Set 7200 2018:05:21 03:37:19
Backup Piece 7200 2018:05:21 03:37:19 /home/oracle/nfs/arch_UASDB_20180521_7279_1
Backup Set 7201 2018:05:21 03:37:20
Backup Piece 7201 2018:05:21 03:37:20 /home/oracle/nfs/arch_UASDB_20180521_7280_1
Backup Set 7199 2018:05:21 03:37:19
Backup Piece 7199 2018:05:21 03:37:19 /home/oracle/nfs/arch_UASDB_20180521_7281_1
Backup Set 7202 2018:05:21 03:37:20
Backup Piece 7202 2018:05:21 03:37:20 /home/oracle/nfs/arch_UASDB_20180521_7282_1
Backup Set 7203 2018:05:21 03:37:24
Backup Piece 7203 2018:05:21 03:37:24 /home/oracle/nfs/ctl_UASDB_20180521_7283_1
Backup Set 7204 2018:05:21 03:37:25
Backup Piece 7204 2018:05:21 03:37:25 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180521-01
Backup Set 7205 2018:05:22 01:41:12
Backup Piece 7205 2018:05:22 01:41:12 /home/oracle/nfs/full_data_UASDB_20180522_7285_1
Backup Set 7207 2018:05:22 01:51:24
Backup Piece 7207 2018:05:22 01:51:24 /home/oracle/nfs/full_data_UASDB_20180522_7286_1
Backup Set 7206 2018:05:22 01:47:09
Backup Piece 7206 2018:05:22 01:47:09 /home/oracle/nfs/full_data_UASDB_20180522_7287_1
Backup Set 7208 2018:05:22 02:02:04
Backup Piece 7208 2018:05:22 02:02:04 /home/oracle/nfs/full_data_UASDB_20180522_7288_1
Backup Set 7209 2018:05:22 02:16:14
Backup Piece 7209 2018:05:22 02:16:14 /home/oracle/nfs/full_data_UASDB_20180522_7289_1
Backup Set 7210 2018:05:22 02:28:11
Backup Piece 7210 2018:05:22 02:28:11 /home/oracle/nfs/full_data_UASDB_20180522_7290_1
Backup Set 7213 2018:05:22 02:47:10
Backup Piece 7213 2018:05:22 02:47:10 /home/oracle/nfs/full_data_UASDB_20180522_7291_1
Backup Set 7214 2018:05:22 02:48:45
Backup Piece 7214 2018:05:22 02:48:45 /home/oracle/nfs/full_data_UASDB_20180522_7292_1
Backup Set 7211 2018:05:22 02:28:37
Backup Piece 7211 2018:05:22 02:28:37 /home/oracle/nfs/full_data_UASDB_20180522_7293_1
Backup Set 7212 2018:05:22 02:31:34
Backup Piece 7212 2018:05:22 02:31:34 /home/oracle/nfs/full_data_UASDB_20180522_7294_1
Backup Set 7215 2018:05:22 02:49:31
Backup Piece 7215 2018:05:22 02:49:31 /home/oracle/nfs/full_data_UASDB_20180522_7295_1
Backup Set 7216 2018:05:22 03:07:03
Backup Piece 7216 2018:05:22 03:07:03 /home/oracle/nfs/full_data_UASDB_20180522_7296_1
Backup Set 7217 2018:05:22 03:16:10
Backup Piece 7217 2018:05:22 03:16:10 /home/oracle/nfs/full_data_UASDB_20180522_7297_1
Backup Set 7218 2018:05:22 03:16:43
Backup Piece 7218 2018:05:22 03:16:43 /home/oracle/nfs/full_data_UASDB_20180522_7298_1
Backup Set 7219 2018:05:22 03:21:12
Backup Piece 7219 2018:05:22 03:21:12 /home/oracle/nfs/full_data_UASDB_20180522_7299_1
Backup Set 7220 2018:05:22 03:21:19
Backup Piece 7220 2018:05:22 03:21:19 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180522-00
Backup Set 7224 2018:05:22 03:35:39
Backup Piece 7224 2018:05:22 03:35:39 /home/oracle/nfs/arch_UASDB_20180522_7301_1
Backup Set 7221 2018:05:22 03:35:28
Backup Piece 7221 2018:05:22 03:35:28 /home/oracle/nfs/arch_UASDB_20180522_7302_1
Backup Set 7223 2018:05:22 03:35:37
Backup Piece 7223 2018:05:22 03:35:37 /home/oracle/nfs/arch_UASDB_20180522_7303_1
Backup Set 7222 2018:05:22 03:35:37
Backup Piece 7222 2018:05:22 03:35:37 /home/oracle/nfs/arch_UASDB_20180522_7304_1
Backup Set 7225 2018:05:22 03:35:45
Backup Piece 7225 2018:05:22 03:35:45 /home/oracle/nfs/ctl_UASDB_20180522_7305_1
Backup Set 7226 2018:05:22 03:35:45
Backup Piece 7226 2018:05:22 03:35:45 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180522-01
Backup Set 7227 2018:05:23 01:40:31
Backup Piece 7227 2018:05:23 01:40:31 /home/oracle/nfs/full_data_UASDB_20180523_7307_1
Backup Set 7229 2018:05:23 01:50:57
Backup Piece 7229 2018:05:23 01:50:57 /home/oracle/nfs/full_data_UASDB_20180523_7308_1
Backup Set 7228 2018:05:23 01:48:00
Backup Piece 7228 2018:05:23 01:48:00 /home/oracle/nfs/full_data_UASDB_20180523_7309_1
Backup Set 7230 2018:05:23 02:01:26
Backup Piece 7230 2018:05:23 02:01:26 /home/oracle/nfs/full_data_UASDB_20180523_7310_1
Backup Set 7231 2018:05:23 02:17:14
Backup Piece 7231 2018:05:23 02:17:14 /home/oracle/nfs/full_data_UASDB_20180523_7311_1
Backup Set 7232 2018:05:23 02:28:01
Backup Piece 7232 2018:05:23 02:28:01 /home/oracle/nfs/full_data_UASDB_20180523_7312_1
Backup Set 7235 2018:05:23 02:45:56
Backup Piece 7235 2018:05:23 02:45:56 /home/oracle/nfs/full_data_UASDB_20180523_7313_1
Backup Set 7237 2018:05:23 02:50:01
Backup Piece 7237 2018:05:23 02:50:01 /home/oracle/nfs/full_data_UASDB_20180523_7314_1
Backup Set 7233 2018:05:23 02:28:28
Backup Piece 7233 2018:05:23 02:28:28 /home/oracle/nfs/full_data_UASDB_20180523_7315_1
Backup Set 7234 2018:05:23 02:31:24
Backup Piece 7234 2018:05:23 02:31:24 /home/oracle/nfs/full_data_UASDB_20180523_7316_1
Backup Set 7236 2018:05:23 02:49:29
Backup Piece 7236 2018:05:23 02:49:29 /home/oracle/nfs/full_data_UASDB_20180523_7317_1
Backup Set 7238 2018:05:23 03:05:56
Backup Piece 7238 2018:05:23 03:05:56 /home/oracle/nfs/full_data_UASDB_20180523_7318_1
Backup Set 7239 2018:05:23 03:16:47
Backup Piece 7239 2018:05:23 03:16:47 /home/oracle/nfs/full_data_UASDB_20180523_7319_1
Backup Set 7240 2018:05:23 03:17:23
Backup Piece 7240 2018:05:23 03:17:23 /home/oracle/nfs/full_data_UASDB_20180523_7320_1
Backup Set 7241 2018:05:23 03:20:46
Backup Piece 7241 2018:05:23 03:20:46 /home/oracle/nfs/full_data_UASDB_20180523_7321_1
Backup Set 7242 2018:05:23 03:20:50
Backup Piece 7242 2018:05:23 03:20:50 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180523-00
Backup Set 7245 2018:05:23 03:34:45
Backup Piece 7245 2018:05:23 03:34:45 /home/oracle/nfs/arch_UASDB_20180523_7323_1
Backup Set 7243 2018:05:23 03:34:44
Backup Piece 7243 2018:05:23 03:34:44 /home/oracle/nfs/arch_UASDB_20180523_7324_1
Backup Set 7244 2018:05:23 03:34:44
Backup Piece 7244 2018:05:23 03:34:44 /home/oracle/nfs/arch_UASDB_20180523_7325_1
Backup Set 7246 2018:05:23 03:34:52
Backup Piece 7246 2018:05:23 03:34:52 /home/oracle/nfs/arch_UASDB_20180523_7326_1
Backup Set 7247 2018:05:23 03:34:55
Backup Piece 7247 2018:05:23 03:34:55 /home/oracle/nfs/ctl_UASDB_20180523_7327_1
Backup Set 7248 2018:05:23 03:34:56
Backup Piece 7248 2018:05:23 03:34:56 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180523-01
Backup Set 7249 2018:05:24 01:41:27
Backup Piece 7249 2018:05:24 01:41:27 /home/oracle/nfs/full_data_UASDB_20180524_7329_1
Backup Set 7251 2018:05:24 01:51:18
Backup Piece 7251 2018:05:24 01:51:18 /home/oracle/nfs/full_data_UASDB_20180524_7330_1
Backup Set 7250 2018:05:24 01:48:00
Backup Piece 7250 2018:05:24 01:48:00 /home/oracle/nfs/full_data_UASDB_20180524_7331_1
Backup Set 7252 2018:05:24 02:02:43
Backup Piece 7252 2018:05:24 02:02:43 /home/oracle/nfs/full_data_UASDB_20180524_7332_1
Backup Set 7253 2018:05:24 02:17:11
Backup Piece 7253 2018:05:24 02:17:11 /home/oracle/nfs/full_data_UASDB_20180524_7333_1
Backup Set 7254 2018:05:24 02:28:11
Backup Piece 7254 2018:05:24 02:28:11 /home/oracle/nfs/full_data_UASDB_20180524_7334_1
Backup Set 7257 2018:05:24 02:47:42
Backup Piece 7257 2018:05:24 02:47:42 /home/oracle/nfs/full_data_UASDB_20180524_7335_1
Backup Set 7259 2018:05:24 02:50:41
Backup Piece 7259 2018:05:24 02:50:41 /home/oracle/nfs/full_data_UASDB_20180524_7336_1
Backup Set 7255 2018:05:24 02:28:41
Backup Piece 7255 2018:05:24 02:28:41 /home/oracle/nfs/full_data_UASDB_20180524_7337_1
Backup Set 7256 2018:05:24 02:31:57
Backup Piece 7256 2018:05:24 02:31:57 /home/oracle/nfs/full_data_UASDB_20180524_7338_1
Backup Set 7258 2018:05:24 02:49:25
Backup Piece 7258 2018:05:24 02:49:25 /home/oracle/nfs/full_data_UASDB_20180524_7339_1
Backup Set 7260 2018:05:24 03:07:38
Backup Piece 7260 2018:05:24 03:07:38 /home/oracle/nfs/full_data_UASDB_20180524_7340_1
Backup Set 7261 2018:05:24 03:17:10
Backup Piece 7261 2018:05:24 03:17:10 /home/oracle/nfs/full_data_UASDB_20180524_7341_1
Backup Set 7262 2018:05:24 03:18:16
Backup Piece 7262 2018:05:24 03:18:16 /home/oracle/nfs/full_data_UASDB_20180524_7342_1
Backup Set 7263 2018:05:24 03:22:11
Backup Piece 7263 2018:05:24 03:22:11 /home/oracle/nfs/full_data_UASDB_20180524_7343_1
Backup Set 7264 2018:05:24 03:22:12
Backup Piece 7264 2018:05:24 03:22:12 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180524-00
Backup Set 7265 2018:05:24 03:35:36
Backup Piece 7265 2018:05:24 03:35:36 /home/oracle/nfs/arch_UASDB_20180524_7345_1
Backup Set 7267 2018:05:24 03:36:30
Backup Piece 7267 2018:05:24 03:36:30 /home/oracle/nfs/arch_UASDB_20180524_7346_1
Backup Set 7268 2018:05:24 03:36:31
Backup Piece 7268 2018:05:24 03:36:31 /home/oracle/nfs/arch_UASDB_20180524_7347_1
Backup Set 7266 2018:05:24 03:35:46
Backup Piece 7266 2018:05:24 03:35:46 /home/oracle/nfs/arch_UASDB_20180524_7348_1
Backup Set 7269 2018:05:24 03:36:40
Backup Piece 7269 2018:05:24 03:36:40 /home/oracle/nfs/ctl_UASDB_20180524_7349_1
Backup Set 7270 2018:05:24 03:36:41
Backup Piece 7270 2018:05:24 03:36:41 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180524-01
Backup Set 7271 2018:05:25 01:40:38
Backup Piece 7271 2018:05:25 01:40:38 /home/oracle/nfs/full_data_UASDB_20180525_7351_1
Backup Set 7273 2018:05:25 01:51:14
Backup Piece 7273 2018:05:25 01:51:14 /home/oracle/nfs/full_data_UASDB_20180525_7352_1
Backup Set 7272 2018:05:25 01:48:06
Backup Piece 7272 2018:05:25 01:48:06 /home/oracle/nfs/full_data_UASDB_20180525_7353_1
Backup Set 7274 2018:05:25 02:01:43
Backup Piece 7274 2018:05:25 02:01:43 /home/oracle/nfs/full_data_UASDB_20180525_7354_1
Backup Set 7275 2018:05:25 02:17:27
Backup Piece 7275 2018:05:25 02:17:27 /home/oracle/nfs/full_data_UASDB_20180525_7355_1
Backup Set 7276 2018:05:25 02:27:41
Backup Piece 7276 2018:05:25 02:27:41 /home/oracle/nfs/full_data_UASDB_20180525_7356_1
Backup Set 7279 2018:05:25 02:46:40
Backup Piece 7279 2018:05:25 02:46:40 /home/oracle/nfs/full_data_UASDB_20180525_7357_1
Backup Set 7281 2018:05:25 02:51:12
Backup Piece 7281 2018:05:25 02:51:12 /home/oracle/nfs/full_data_UASDB_20180525_7358_1
Backup Set 7277 2018:05:25 02:28:02
Backup Piece 7277 2018:05:25 02:28:02 /home/oracle/nfs/full_data_UASDB_20180525_7359_1
Backup Set 7278 2018:05:25 02:31:11
Backup Piece 7278 2018:05:25 02:31:11 /home/oracle/nfs/full_data_UASDB_20180525_7360_1
Backup Set 7280 2018:05:25 02:48:48
Backup Piece 7280 2018:05:25 02:48:48 /home/oracle/nfs/full_data_UASDB_20180525_7361_1
Backup Set 7282 2018:05:25 03:06:11
Backup Piece 7282 2018:05:25 03:06:11 /home/oracle/nfs/full_data_UASDB_20180525_7362_1
Backup Set 7283 2018:05:25 03:16:36
Backup Piece 7283 2018:05:25 03:16:36 /home/oracle/nfs/full_data_UASDB_20180525_7363_1
Backup Set 7284 2018:05:25 03:18:37
Backup Piece 7284 2018:05:25 03:18:37 /home/oracle/nfs/full_data_UASDB_20180525_7364_1
Backup Set 7285 2018:05:25 03:20:54
Backup Piece 7285 2018:05:25 03:20:54 /home/oracle/nfs/full_data_UASDB_20180525_7365_1
Backup Set 7286 2018:05:25 03:21:00
Backup Piece 7286 2018:05:25 03:21:00 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180525-00
Backup Set 7287 2018:05:25 03:35:12
Backup Piece 7287 2018:05:25 03:35:12 /home/oracle/nfs/arch_UASDB_20180525_7367_1
Backup Set 7288 2018:05:25 03:35:12
Backup Piece 7288 2018:05:25 03:35:12 /home/oracle/nfs/arch_UASDB_20180525_7368_1
Backup Set 7289 2018:05:25 03:35:12
Backup Piece 7289 2018:05:25 03:35:12 /home/oracle/nfs/arch_UASDB_20180525_7369_1
Backup Set 7290 2018:05:25 03:35:23
Backup Piece 7290 2018:05:25 03:35:23 /home/oracle/nfs/arch_UASDB_20180525_7370_1
Backup Set 7291 2018:05:25 03:35:26
Backup Piece 7291 2018:05:25 03:35:26 /home/oracle/nfs/ctl_UASDB_20180525_7371_1
Backup Set 7292 2018:05:25 03:35:27
Backup Piece 7292 2018:05:25 03:35:27 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180525-01
Backup Set 7293 2018:05:26 01:40:32
Backup Piece 7293 2018:05:26 01:40:32 /home/oracle/nfs/full_data_UASDB_20180526_7373_1
Backup Set 7295 2018:05:26 01:51:05
Backup Piece 7295 2018:05:26 01:51:05 /home/oracle/nfs/full_data_UASDB_20180526_7374_1
Backup Set 7294 2018:05:26 01:47:58
Backup Piece 7294 2018:05:26 01:47:58 /home/oracle/nfs/full_data_UASDB_20180526_7375_1
Backup Set 7296 2018:05:26 02:01:51
Backup Piece 7296 2018:05:26 02:01:51 /home/oracle/nfs/full_data_UASDB_20180526_7376_1
Backup Set 7297 2018:05:26 02:17:09
Backup Piece 7297 2018:05:26 02:17:09 /home/oracle/nfs/full_data_UASDB_20180526_7377_1
Backup Set 7298 2018:05:26 02:28:01
Backup Piece 7298 2018:05:26 02:28:01 /home/oracle/nfs/full_data_UASDB_20180526_7378_1
Backup Set 7301 2018:05:26 02:46:39
Backup Piece 7301 2018:05:26 02:46:39 /home/oracle/nfs/full_data_UASDB_20180526_7379_1
Backup Set 7303 2018:05:26 02:50:50
Backup Piece 7303 2018:05:26 02:50:50 /home/oracle/nfs/full_data_UASDB_20180526_7380_1
Backup Set 7299 2018:05:26 02:28:25
Backup Piece 7299 2018:05:26 02:28:25 /home/oracle/nfs/full_data_UASDB_20180526_7381_1
Backup Set 7300 2018:05:26 02:31:31
Backup Piece 7300 2018:05:26 02:31:31 /home/oracle/nfs/full_data_UASDB_20180526_7382_1
Backup Set 7302 2018:05:26 02:49:04
Backup Piece 7302 2018:05:26 02:49:04 /home/oracle/nfs/full_data_UASDB_20180526_7383_1
Backup Set 7304 2018:05:26 03:06:15
Backup Piece 7304 2018:05:26 03:06:15 /home/oracle/nfs/full_data_UASDB_20180526_7384_1
Backup Set 7305 2018:05:26 03:15:54
Backup Piece 7305 2018:05:26 03:15:54 /home/oracle/nfs/full_data_UASDB_20180526_7385_1
Backup Set 7306 2018:05:26 03:18:10
Backup Piece 7306 2018:05:26 03:18:10 /home/oracle/nfs/full_data_UASDB_20180526_7386_1
Backup Set 7307 2018:05:26 03:20:55
Backup Piece 7307 2018:05:26 03:20:55 /home/oracle/nfs/full_data_UASDB_20180526_7387_1
Backup Set 7308 2018:05:26 03:21:00
Backup Piece 7308 2018:05:26 03:21:00 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180526-00
Backup Set 7309 2018:05:26 03:34:56
Backup Piece 7309 2018:05:26 03:34:56 /home/oracle/nfs/arch_UASDB_20180526_7389_1
Backup Set 7311 2018:05:26 03:34:58
Backup Piece 7311 2018:05:26 03:34:58 /home/oracle/nfs/arch_UASDB_20180526_7390_1
Backup Set 7310 2018:05:26 03:34:57
Backup Piece 7310 2018:05:26 03:34:57 /home/oracle/nfs/arch_UASDB_20180526_7391_1
Backup Set 7312 2018:05:26 03:35:00
Backup Piece 7312 2018:05:26 03:35:00 /home/oracle/nfs/arch_UASDB_20180526_7392_1
Backup Set 7313 2018:05:26 03:35:03
Backup Piece 7313 2018:05:26 03:35:03 /home/oracle/nfs/ctl_UASDB_20180526_7393_1
Backup Set 7314 2018:05:26 03:35:04
Backup Piece 7314 2018:05:26 03:35:04 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180526-01
Backup Set 7315 2018:05:27 01:40:15
Backup Piece 7315 2018:05:27 01:40:15 /home/oracle/nfs/full_data_UASDB_20180527_7395_1
Backup Set 7317 2018:05:27 01:51:01
Backup Piece 7317 2018:05:27 01:51:01 /home/oracle/nfs/full_data_UASDB_20180527_7396_1
Backup Set 7316 2018:05:27 01:47:43
Backup Piece 7316 2018:05:27 01:47:43 /home/oracle/nfs/full_data_UASDB_20180527_7397_1
Backup Set 7318 2018:05:27 02:01:10
Backup Piece 7318 2018:05:27 02:01:10 /home/oracle/nfs/full_data_UASDB_20180527_7398_1
Backup Set 7319 2018:05:27 02:16:38
Backup Piece 7319 2018:05:27 02:16:38 /home/oracle/nfs/full_data_UASDB_20180527_7399_1
Backup Set 7320 2018:05:27 02:27:59
Backup Piece 7320 2018:05:27 02:27:59 /home/oracle/nfs/full_data_UASDB_20180527_7400_1
Backup Set 7323 2018:05:27 02:46:18
Backup Piece 7323 2018:05:27 02:46:18 /home/oracle/nfs/full_data_UASDB_20180527_7401_1
Backup Set 7325 2018:05:27 02:51:01
Backup Piece 7325 2018:05:27 02:51:01 /home/oracle/nfs/full_data_UASDB_20180527_7402_1
Backup Set 7321 2018:05:27 02:28:25
Backup Piece 7321 2018:05:27 02:28:25 /home/oracle/nfs/full_data_UASDB_20180527_7403_1
Backup Set 7322 2018:05:27 02:31:34
Backup Piece 7322 2018:05:27 02:31:34 /home/oracle/nfs/full_data_UASDB_20180527_7404_1
Backup Set 7324 2018:05:27 02:49:06
Backup Piece 7324 2018:05:27 02:49:06 /home/oracle/nfs/full_data_UASDB_20180527_7405_1
Backup Set 7326 2018:05:27 03:05:44
Backup Piece 7326 2018:05:27 03:05:44 /home/oracle/nfs/full_data_UASDB_20180527_7406_1
Backup Set 7327 2018:05:27 03:16:43
Backup Piece 7327 2018:05:27 03:16:43 /home/oracle/nfs/full_data_UASDB_20180527_7407_1
Backup Set 7328 2018:05:27 03:18:20
Backup Piece 7328 2018:05:27 03:18:20 /home/oracle/nfs/full_data_UASDB_20180527_7408_1
Backup Set 7329 2018:05:27 03:20:25
Backup Piece 7329 2018:05:27 03:20:25 /home/oracle/nfs/full_data_UASDB_20180527_7409_1
Backup Set 7330 2018:05:27 03:20:30
Backup Piece 7330 2018:05:27 03:20:30 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180527-00
Backup Set 7334 2018:05:27 03:35:03
Backup Piece 7334 2018:05:27 03:35:03 /home/oracle/nfs/arch_UASDB_20180527_7411_1
Backup Set 7333 2018:05:27 03:35:00
Backup Piece 7333 2018:05:27 03:35:00 /home/oracle/nfs/arch_UASDB_20180527_7412_1
Backup Set 7331 2018:05:27 03:34:54
Backup Piece 7331 2018:05:27 03:34:54 /home/oracle/nfs/arch_UASDB_20180527_7413_1
Backup Set 7332 2018:05:27 03:35:00
Backup Piece 7332 2018:05:27 03:35:00 /home/oracle/nfs/arch_UASDB_20180527_7414_1
Backup Set 7335 2018:05:27 03:35:07
Backup Piece 7335 2018:05:27 03:35:07 /home/oracle/nfs/ctl_UASDB_20180527_7415_1
Backup Set 7336 2018:05:27 03:35:08
Backup Piece 7336 2018:05:27 03:35:08 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180527-01
Backup Set 7337 2018:05:28 01:41:09
Backup Piece 7337 2018:05:28 01:41:09 /home/oracle/nfs/full_data_UASDB_20180528_7417_1
Backup Set 7339 2018:05:28 01:51:29
Backup Piece 7339 2018:05:28 01:51:29 /home/oracle/nfs/full_data_UASDB_20180528_7418_1
Backup Set 7338 2018:05:28 01:47:57
Backup Piece 7338 2018:05:28 01:47:57 /home/oracle/nfs/full_data_UASDB_20180528_7419_1
Backup Set 7340 2018:05:28 02:02:19
Backup Piece 7340 2018:05:28 02:02:19 /home/oracle/nfs/full_data_UASDB_20180528_7420_1
Backup Set 7341 2018:05:28 02:17:10
Backup Piece 7341 2018:05:28 02:17:10 /home/oracle/nfs/full_data_UASDB_20180528_7421_1
Backup Set 7342 2018:05:28 02:27:59
Backup Piece 7342 2018:05:28 02:27:59 /home/oracle/nfs/full_data_UASDB_20180528_7422_1
Backup Set 7345 2018:05:28 02:47:19
Backup Piece 7345 2018:05:28 02:47:19 /home/oracle/nfs/full_data_UASDB_20180528_7423_1
Backup Set 7347 2018:05:28 02:51:57
Backup Piece 7347 2018:05:28 02:51:57 /home/oracle/nfs/full_data_UASDB_20180528_7424_1
Backup Set 7343 2018:05:28 02:28:26
Backup Piece 7343 2018:05:28 02:28:26 /home/oracle/nfs/full_data_UASDB_20180528_7425_1
Backup Set 7344 2018:05:28 02:31:48
Backup Piece 7344 2018:05:28 02:31:48 /home/oracle/nfs/full_data_UASDB_20180528_7426_1
Backup Set 7346 2018:05:28 02:49:35
Backup Piece 7346 2018:05:28 02:49:35 /home/oracle/nfs/full_data_UASDB_20180528_7427_1
Backup Set 7348 2018:05:28 03:06:58
Backup Piece 7348 2018:05:28 03:06:58 /home/oracle/nfs/full_data_UASDB_20180528_7428_1
Backup Set 7349 2018:05:28 03:16:59
Backup Piece 7349 2018:05:28 03:16:59 /home/oracle/nfs/full_data_UASDB_20180528_7429_1
Backup Set 7350 2018:05:28 03:19:11
Backup Piece 7350 2018:05:28 03:19:11 /home/oracle/nfs/full_data_UASDB_20180528_7430_1
Backup Set 7351 2018:05:28 03:21:47
Backup Piece 7351 2018:05:28 03:21:47 /home/oracle/nfs/full_data_UASDB_20180528_7431_1
Backup Set 7352 2018:05:28 03:21:51
Backup Piece 7352 2018:05:28 03:21:51 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180528-00
Backup Set 7356 2018:05:28 03:36:18
Backup Piece 7356 2018:05:28 03:36:18 /home/oracle/nfs/arch_UASDB_20180528_7433_1
Backup Set 7355 2018:05:28 03:36:15
Backup Piece 7355 2018:05:28 03:36:15 /home/oracle/nfs/arch_UASDB_20180528_7434_1
Backup Set 7353 2018:05:28 03:34:34
Backup Piece 7353 2018:05:28 03:34:34 /home/oracle/nfs/arch_UASDB_20180528_7435_1
Backup Set 7354 2018:05:28 03:34:41
Backup Piece 7354 2018:05:28 03:34:41 /home/oracle/nfs/arch_UASDB_20180528_7436_1
Backup Set 7357 2018:05:28 03:36:29
Backup Piece 7357 2018:05:28 03:36:29 /home/oracle/nfs/ctl_UASDB_20180528_7437_1
Backup Set 7358 2018:05:28 03:36:30
Backup Piece 7358 2018:05:28 03:36:30 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180528-01
Backup Set 7374 2018:05:29 03:23:51
Backup Piece 7374 2018:05:29 03:23:51 /u01/app/oracle/product/11.2.0/db_1/dbs/c-1064374702-20180529-00
Backup Set 7377 2018:05:29 03:38:10
Backup Piece 7377 2018:05:29 03:38:10 /home/oracle/nfs/arch_UASDB_20180529_7455_1
Backup Set 7375 2018:05:29 03:38:08
Backup Piece 7375 2018:05:29 03:38:08 /home/oracle/nfs/arch_UASDB_20180529_7456_1
Backup Set 7379 2018:05:29 03:38:15
Backup Piece 7379 2018:05:29 03:38:15 /home/oracle/nfs/ctl_UASDB_20180529_7459_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_1 channel at 05/29/2018 11:25:19
ORA-19606: Cannot copy or restore to snapshot control file

报错了,这个在印象里是个bug,下面是解决方法;
RMAN> show SNAPSHOT CONTROLFILE NAME;

RMAN configuration parameters for database with db_unique_name UASDB are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_uasdb.f'; # default

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_uasdb-temp.f';

new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_uasdb-temp.f';
new RMAN configuration parameters are successfully stored

RMAN> exit

Recovery Manager complete.
[oracle@uasdb1 dbs]$ ls
c-1064374702-20180426-01 c-1064374702-20180504-00 c-1064374702-20180511-00 c-1064374702-20180518-01 c-1064374702-20180526-00
c-1064374702-20180427-00 c-1064374702-20180504-01 c-1064374702-20180511-01 c-1064374702-20180519-00 c-1064374702-20180526-01
c-1064374702-20180427-01 c-1064374702-20180505-00 c-1064374702-20180512-00 c-1064374702-20180519-01 c-1064374702-20180527-00
c-1064374702-20180428-00 c-1064374702-20180505-01 c-1064374702-20180512-01 c-1064374702-20180520-00 c-1064374702-20180527-01
c-1064374702-20180428-01 c-1064374702-20180506-00 c-1064374702-20180513-00 c-1064374702-20180520-01 c-1064374702-20180528-00
c-1064374702-20180429-00 c-1064374702-20180506-01 c-1064374702-20180513-01 c-1064374702-20180521-00 c-1064374702-20180528-01
c-1064374702-20180429-01 c-1064374702-20180507-00 c-1064374702-20180514-00 c-1064374702-20180521-01 c-1064374702-20180529-00
c-1064374702-20180430-00 c-1064374702-20180507-01 c-1064374702-20180514-01 c-1064374702-20180522-00 c-1064374702-20180529-01
c-1064374702-20180430-01 c-1064374702-20180507-02 c-1064374702-20180515-00 c-1064374702-20180522-01 hc_uasdb.dat
c-1064374702-20180501-00 c-1064374702-20180508-00 c-1064374702-20180515-01 c-1064374702-20180523-00 init.ora
c-1064374702-20180501-01 c-1064374702-20180508-01 c-1064374702-20180516-00 c-1064374702-20180523-01 inituasdb.ora
c-1064374702-20180502-00 c-1064374702-20180509-00 c-1064374702-20180516-01 c-1064374702-20180524-00 lkUASDB
c-1064374702-20180502-01 c-1064374702-20180509-01 c-1064374702-20180517-00 c-1064374702-20180524-01 orapwuasdb
c-1064374702-20180503-00 c-1064374702-20180510-00 c-1064374702-20180517-01 c-1064374702-20180525-00 snapcf_uasdb.f
c-1064374702-20180503-01 c-1064374702-20180510-01 c-1064374702-20180518-00 c-1064374702-20180525-01 spfileuasdb.ora
[oracle@uasdb1 dbs]$ mv snapcf_uasdb.f snapcf_uasdb.f.bak
[oracle@uasdb1 dbs]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Tue May 29 16:19:52 2018

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

connected to target database: UASDB (DBID=1064374702)

RMAN> crosscheck controlfilecopy '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_uasdb.f';

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1683 device type=DISK
validation failed for control file copy
control file copy file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_uasdb.f RECID=6 STAMP=974473256
Crosschecked 1 objects

RMAN> delete expired controlfilecopy '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_uasdb.f';

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1683 device type=DISK
List of Control File Copies

Key S Completion Time Ckp SCN Ckp Time


6 X 2018:04:26 15:00:56 1776916296 2018:04:26 15:00:56
Name: /u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_uasdb.f
Tag: TAG20180426T150056

Do you really want to delete the above objects (enter YES or NO)? yes
deleted control file copy
control file copy file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_uasdb.f RECID=6 STAMP=974473256
Deleted 1 EXPIRED objects

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME clear;

old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_uasdb-temp.f';
RMAN configuration parameters are successfully reset to default value

RMAN> show SNAPSHOT CONTROLFILE NAME;

RMAN configuration parameters for database with db_unique_name UASDB are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_uasdb.f'; # default

再次执行删除操作,可以正常执行了。好记性不如烂笔头,记下来吧。