Delete archive logs and backup

eleting acrhive logs


RMAN> delete noprompt archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=152 device type=DISK
List of Archived Log Copies for database with db_unique_name SANDEEP
=====================================================================

Key Thrd Seq S Low Time
------- ---- ------- - ---------
1 1 119 A 02-APR-10
Name: D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_02\O1_MF_1_119_5VD7V6Z6_.ARC

2 1 120 A 02-APR-10
Name: D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_02\O1_MF_1_120_5VDQ0YOR_.ARC

3 1 121 A 02-APR-10
Name: D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_02\O1_MF_1_121_5VDTLZOZ_.ARC

4 1 122 A 02-APR-10
Name: D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_03\O1_MF_1_122_5VF6FVQ6_.ARC

5 1 123 A 03-APR-10
Name: D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_03\O1_MF_1_123_5VFMO6JK_.ARC

6 1 124 A 03-APR-10
Name: D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_04\O1_MF_1_124_5VJONNMM_.ARC

7 1 125 A 04-APR-10
Name: D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_04\O1_MF_1_125_5VJWQ8RH_.ARC

deleted archived log
archived log file name=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_02\O1_MF_1_119_5VD7V6Z6_.ARC RECID=1 STAMP=715283195
deleted archived log
archived log file name=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_02\O1_MF_1_120_5VDQ0YOR_.ARC RECID=2 STAMP=715298748
deleted archived log
archived log file name=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_02\O1_MF_1_121_5VDTLZOZ_.ARC RECID=3 STAMP=715302396
deleted archived log
archived log file name=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_03\O1_MF_1_122_5VF6FVQ6_.ARC RECID=4 STAMP=715314513
deleted archived log
archived log file name=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_03\O1_MF_1_123_5VFMO6JK_.ARC RECID=5 STAMP=715328085
deleted archived log
archived log file name=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_04\O1_MF_1_124_5VJONNMM_.ARC RECID=6 STAMP=715428398
deleted archived log
archived log file name=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\ARCHIVELOG\2010_04_04\O1_MF_1_125_5VJWQ8RH_.ARC RECID=7 STAMP=715435645
Deleted 7 objects


RMAN>




RMAN> delete backup; (delete noprompt backup of database;)

using channel ORA_DISK_1

List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
5 5 1 1 AVAILABLE DISK D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_02\O1_MF_NNNDF_TAG20100402T205507_5VDLWZ
6 6 1 1 AVAILABLE DISK D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\AUTOBACKUP\2010_04_02\O1_MF_S_715294825_5VDM6VJ8_.BKP

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_02\O1_MF_NNNDF_TAG20100402T205507_5VDLWZ18_.BKP RECID=5 STAMP=715294
deleted backup piece
backup piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\AUTOBACKUP\2010_04_02\O1_MF_S_715294825_5VDM6VJ8_.BKP RECID=6 STAMP=715294827
Deleted 2 objects


RMAN>