Hi,
Here is our setup for ur RMAN backup. We take a full backup (level 0) each week in the night from sunday to monday and incremental cumulative backup each other day. Backup are stored in a ASM Diskgroup. After the backup "we backup the backup" on a windows disk and those copy are written on tape by our techno team.
The command used to transfer form ASM to the windows disk is :
run{
allocate channel ch1 device type sbt parms="SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=R:\BackupRman\Prod)" format 'backupset_%%d_bk%%s_pc%%p_cp%%c_%%T';
backup backupset completed after 'sysdate - 12/24';
}
Last night, our backup failed so I wanted to delete it and restart it.
Here what I had this morning :
RMAN> list backup summary;
utilisation du fichier de contr¶le de la base de donnÚes cible au lieu du catalogue de rÚcupÚration
Liste des sauvegardes
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
33472 B 0 A * 2016/11/07 1 2 YES PROD_D_FULL_20161107_08H47
33473 B 0 A * 2016/11/07 1 2 YES PROD_D_FULL_20161107_08H47
33474 B 0 A * 2016/11/07 1 2 YES PROD_D_FULL_20161107_08H47
33480 B A A * 2016/11/07 1 2 YES PROD_A_FULL_20161107_08H47
33481 B F A DISK 2016/11/07 1 1 NO TAG20161107T111546
33483 B F A DISK 2016/11/07 1 1 NO TAG20161107T151116
33484 B 1 A * 2016/11/08 1 2 YES PROD_D_INC_20161108_00H30
33485 B 1 A * 2016/11/08 1 2 YES PROD_D_INC_20161108_00H30
33486 B A A * 2016/11/08 1 2 YES PROD_A_INC_20161108_00H30
33487 B A A * 2016/11/08 1 2 YES PROD_A_INC_20161108_00H30
33488 B A A * 2016/11/08 1 2 YES PROD_A_INC_20161108_00H30
33489 B A A * 2016/11/08 1 2 YES PROD_A_INC_20161108_00H30
33490 B F A * 2016/11/08 1 2 NO TAG20161108T003259
33491 B F A SBT_TAPE 2016/11/08 1 1 NO TAG20161108T003330
So i deleted backup set from last night
delete noprompt backupset 33484,33485,33486,33487,33488,33489,33490;
after the delete , backup still appear but the type changed to SBT_TAPE. The backup file were deleted physically in our ASM diskgroup
RMAN> list backup summary;
Liste des sauvegardes
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
33472 B 0 A * 2016/11/07 1 2 YES PROD_D_FULL_20161107_08H47
33473 B 0 A * 2016/11/07 1 2 YES PROD_D_FULL_20161107_08H47
33474 B 0 A * 2016/11/07 1 2 YES PROD_D_FULL_20161107_08H47
33480 B A A * 2016/11/07 1 2 YES PROD_A_FULL_20161107_08H47
33481 B F A DISK 2016/11/07 1 1 NO TAG20161107T111546
33483 B F A DISK 2016/11/07 1 1 NO TAG20161107T151116
33484 B 1 A SBT_TAPE 2016/11/08 1 1 YES PROD_D_INC_20161108_00H30
33485 B 1 A SBT_TAPE 2016/11/08 1 1 YES PROD_D_INC_20161108_00H30
33486 B A A SBT_TAPE 2016/11/08 1 1 YES PROD_A_INC_20161108_00H30
33487 B A A SBT_TAPE 2016/11/08 1 1 YES PROD_A_INC_20161108_00H30
33488 B A A SBT_TAPE 2016/11/08 1 1 YES PROD_A_INC_20161108_00H30
33489 B A A SBT_TAPE 2016/11/08 1 1 YES PROD_A_INC_20161108_00H30
33490 B F A SBT_TAPE 2016/11/08 1 1 NO TAG20161108T003259
33491 B F A SBT_TAPE 2016/11/08 1 1 NO TAG20161108T003330
So I did a crosscheck and a delete expire backup.
Then I took a new incremental backup.
Those backup always appears when I list my backup :
Liste des sauvegardes
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
33472 B 0 A * 2016/11/07 1 2 YES PROD_D_FULL_20161107_08H47
33473 B 0 A * 2016/11/07 1 2 YES PROD_D_FULL_20161107_08H47
33474 B 0 A * 2016/11/07 1 2 YES PROD_D_FULL_20161107_08H47
33480 B A A * 2016/11/07 1 2 YES PROD_A_FULL_20161107_08H47
33481 B F A DISK 2016/11/07 1 1 NO TAG20161107T111546
33483 B F A DISK 2016/11/07 1 1 NO TAG20161107T151116
33484 B 1 A SBT_TAPE 2016/11/08 1 1 YES PROD_D_INC_20161108_00H30
33485 B 1 A SBT_TAPE 2016/11/08 1 1 YES PROD_D_INC_20161108_00H30
33486 B A A SBT_TAPE 2016/11/08 1 1 YES PROD_A_INC_20161108_00H30
33487 B A A SBT_TAPE 2016/11/08 1 1 YES PROD_A_INC_20161108_00H30
33488 B A A SBT_TAPE 2016/11/08 1 1 YES PROD_A_INC_20161108_00H30
33489 B A A SBT_TAPE 2016/11/08 1 1 YES PROD_A_INC_20161108_00H30
33492 B 1 A * 2016/11/08 1 2 YES PROD_D_INC_20161108_09H38
33493 B 1 A * 2016/11/08 1 2 YES PROD_D_INC_20161108_09H38
33494 B 1 A * 2016/11/08 1 2 YES PROD_D_INC_20161108_09H38
33495 B F A DISK 2016/11/08 1 1 NO TAG20161108T094205
33496 B A A * 2016/11/08 1 2 YES PROD_A_INC_20161108_09H38
33497 B A A * 2016/11/08 1 2 YES PROD_A_INC_20161108_09H38
33498 B A A * 2016/11/08 1 2 YES PROD_A_INC_20161108_09H38
33499 B A A * 2016/11/08 1 2 YES PROD_A_INC_20161108_09H38
33500 B F A * 2016/11/08 1 2 NO TAG20161108T094513
33501 B F A SBT_TAPE 2016/11/08 1 1 NO TAG20161108T094606
Someone has an idea?