fitzjarrell_at_cox.net wrote:
> Glen wrote:
>
>>DB is 9.2.0.7
>>
>>I am having a couple of RMAN issues on one database, the most pressing
>>being it is not marking or deleting old backups.
>>
>>I've set up 2 RMAN jobs in OEM, a weekly job to run on sunday night to
>>do an incremental level 0 backup, and a job to run every other day of
>>the week to do an incremental level 1. Archive logs are deleted after
>>they have been backed up twice and older than 7 days. Retention policy
>>was set to a recovery window of 3 days.
>>
>>Today I noticed a couple of things, the first being the jobs are not
>>showing up in the history tab in OEM, checking the server itself I see
>>that they have been running as backups are in the backup directory
>>specified, they are just not being recorded in OEM.
>>
>>The second thing I noticed is that old backups are not being deleted. So
>> I logged into RMAN on the server itself, run a crosscheck database
>>command, do a list of backups, and it shows backups back to the date Nov
>>5th (today is the 14th) There are RMAN backups in the directory going
>>back to Oct 22. When I run a "delete obsolete" or "delete obsolete
>>recovery window of 7 days;" it returns a message that there are no
>>obsolete backups. I've changed the retention setting to 2 or 3 days, and
>>still getting the same message when trying to delete the old backups.
>>
>>I suppose I could just use the OS to delete the old backups, but I want
>>to find out why RMAN is not doing what(I think) is it being told to do.
>>
>>I must be missing something here, but what?
>>
>>tia
>
>
>
> Connect to the RMAN repository and type:
>
> show all;
>
> Then post what RMAN reports.
>
> David Fitzjarrell
>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'e:\backup\rman\online\%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'C:\ORACLE\ORA92\DATABASE\SNCFPTMS9.ORA'; # default
RMAN>
Received on Tue Nov 14 2006 - 10:07:56 CST
