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

下面是备份脚本,以及删除脚本 [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/full_data_%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> 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

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