Re: Rman purging issue

Posted by Sumair on Jun 27, 2016; 9:53am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Rman-purging-issue-tp1089p1091.html

Hi,

The backups which run on local mount point are full backups.

We performed 2 activities recently, we reduced cpu from db server and increased space on the /backup mount point. earlier it was 2 tb and now its 2.4 tb.

2)1949622.1 RMAN not Reporting any Backups as Obsolete
RMAN> list incarnation of database;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       SCC      2409180462       CURRENT 1          19-JUL-2013 14:40:46


daily backup

RUN
{
ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '/backup/scc/rmanbackups/%U';
ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '/backup/scc/rmanbackups/%U';
ALLOCATE CHANNEL d3 DEVICE TYPE DISK FORMAT '/backup/scc/rmanbackups/%U';
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG TAG='SCCDB_FULL_BACKUP';
BACKUP CURRENT CONTROLFILE;
RELEASE CHANNEL d1;
RELEASE CHANNEL d2;
RELEASE CHANNEL d3;
}
LIST BACKUP SUMMARY;
REPORT OBSOLETE DEVICE TYPE DISK;
EXIT;


weekly backup

RUN
{
ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '/backup/scc/rmanbackups/fri_full_bk
p/DB_WITH_ARCHIVE_FRI_%U';
ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '/backup/scc/rmanbackups/fri_full_bk
p/DB_WITH_ARCHIVE_FRI_%U';
ALLOCATE CHANNEL d3 DEVICE TYPE DISK FORMAT '/backup/scc/rmanbackups/fri_full_bk
p/DB_WITH_ARCHIVE_FRI_%U';
ALLOCATE CHANNEL d4 DEVICE TYPE DISK FORMAT '/backup/scc/rmanbackups/fri_full_bk
p/DB_WITH_ARCHIVE_FRI_%U';
ALLOCATE CHANNEL d5 DEVICE TYPE DISK FORMAT '/backup/scc/rmanbackups/fri_full_bk
p/DB_WITH_ARCHIVE_FRI_%U';
ALLOCATE CHANNEL d6 DEVICE TYPE DISK FORMAT '/backup/scc/rmanbackups/fri_full_bk
p/DB_WITH_ARCHIVE_FRI_%U';
backup AS COMPRESSED backupset database plus archivelog;
backup current controlfile;
RELEASE CHANNEL d1;
RELEASE CHANNEL d2;
RELEASE CHANNEL d3;
RELEASE CHANNEL d4;
RELEASE CHANNEL d5;
RELEASE CHANNEL d6;
}
LIST BACKUP SUMMARY;
REPORT OBSOLETE DEVICE TYPE DISK;
EXIT;


should i post the details here for list of backups report obsolete etc here? can i send it as attachment