RMAN keeping more then 2 copies of datafiles
We have RMAN configured as follows
Retention window of 1 day
backup type is copy
Full backup plus archive log is done every night
Before the backup, we also run --> Delete obsolete noprompt
The database size is 30 GB
We are backing up the database to disk drive "D" from where it is backed up onto tape drive
The Disk Drive "D" where we are backing up the database is 60 GB in size
The problem we are having is that even with the retention window of 1 day, at least 2 copies of database files
are being kept in the database (sometimes 3 copies) PLUS the archive logs and autobackup of spfile and controlfile and due to this
Retention window of 1 day
backup type is copy
Full backup plus archive log is done every night
Before the backup, we also run --> Delete obsolete noprompt
The database size is 30 GB
We are backing up the database to disk drive "D" from where it is backed up onto tape drive
The Disk Drive "D" where we are backing up the database is 60 GB in size
The problem we are having is that even with the retention window of 1 day, at least 2 copies of database files
are being kept in the database (sometimes 3 copies) PLUS the archive logs and autobackup of spfile and controlfile and due to this
0