Hi guys!
I have problem with RMAN backup of my 11.2.0.3 database which is hosted on RHEL 6.2 OS. So my main problem is that rman backup script doesnt delete backuped archived logs, and therefor i have logs which are 30+ days old and because of that significant partition space problem.
This is my rman script:
RMAN> #
2> # Full Backup
3> #
4> # Recovery Manager script
5> #
6>
7> connect target *
8> #connect CATALOG rman/****@oemrep;
9>
10> run {
11> #backup database plus archivelog delete input ;
12> BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
13> crosscheck backup;
14> report obsolete;
15> delete obsolete;
16> delete noprompt expired backup;
17> }
18>
19> exit;
RMAN configuration parameters for database:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/oradb2_backup/cf_%d_%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/oradb2_backup/df_%d_%T_%s_%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/db/oracle/11.2.0/dbs/snapcf_oradb2.f'; # default
Please advice, thanks!