Hello,
We are having 2 node 11g RAC (ASM) cluster & had set up one ASM disk as FRA on which daily rman backup is performed now as FRA is running out of space we are required to backup FRA so I backup FRA using backup recovery area; now after that all my backups in list backupset summary command are coming as below
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
263 B F A * 28-MAR-11 1 2 YES BACKUP_PRODAILY_032811100000
264 B F A * 28-MAR-11 1 2 YES BACKUP_PRODAILY_032811100000
265 B F A * 28-MAR-11 1 2 YES BACKUP_PRODAILY_032811100000
& for each backup peice I am having two copies one on tape & other on FRA so now I want to remove one copy of every peice i.e FRA's one so taht FRA can be empty, Please tell me how can I delete one copy of each backupset as both copies are having same backupset set but hav different BP KEY as below
RMAN> list backupset 263;
List of Backup Sets
===================
BS Key Type LV Size
------- ---- -- ----------
263 Full 1001.36M
List of Datafiles in backup set 263
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
10 Full 124174871 28-MAR-11 +DATAPROD/prod/datafile/system.278.742062987
12 Full 124174871 28-MAR-11 +DATAPROD/prod/datafile/undotbs1.258.742063665
15 Full 124174871 28-MAR-11 +DATAPROD/prod/datafile/apps_ts_media.271.742062841
18 Full 124174871 28-MAR-11 +DATAPROD/prod/datafile/apps_ts_queues.285.742063093
27 Full 124174871 28-MAR-11 +DATAPROD/prod/datafile/apps_ts_tx_idx.259.742062485
29 Full 124174871 28-MAR-11 +DATAPROD/prod/datafile/apps_ts_tx_idx.266.742062695
30 Full 124174871 28-MAR-11 +DATAPROD/prod/datafile/ctxd.295.742063149
42 Full 124174871 28-MAR-11 +DATAPROD/prod/datafile/apps_ts_media.327.742654423
50 Full 124174871 28-MAR-11 +DATAPROD/prod/datafile/xxmpcd_ts_tx_idx.336.742838847
Backup Set Copy #1 of backup set 263
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:07:47 28-MAR-11 YES BACKUP_PRODAILY_032811100000
List of Backup Pieces for backup set 263 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
651 1 AVAILABLE +FRAPROD/prod/backupset/2011_03_28/nnndf0_backup_prodaily_032811100000_0.393.747007719
Backup Set Copy #2 of backup set 263
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
SBT_TAPE 00:07:47 25-APR-11 YES BACKUP_PRODAILY_032811100000
List of Backup Pieces for backup set 263 Copy #2
BP Key Pc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
1036 1 AVAILABLE 3764a8c0:4daeb8e0:06c8:0001 FRA_BKP<PROD_361:747007718:1>.dbf
So please tell me how can I remove just one copy so that FRA can be empty.
Thanks & Regards
Saransh Soni