Re: RAMAN is not backing a set of archivelogs from the database server

Hey there,

Are these the oldest archivelogs? If so what is CONTROL_FILE_RECORD_KEEP_TIME set to, please? The suggestion below assumes archivelogs are older than the keep time. If they are not, send more details. Happy to help.

RMAN only manage archivelogs that are listed in the controlfile. Details about archivelogs are retained in the controlfile upto the CONTROL_FILE_RECORD_KEEP_TIME (default is 7 days). If archivelogs are older than CONTROL_FILE_RECORD_KEEP_TIME then 'catalog start' will not appear to add older archivelogs because they will automatically age out.

If these archivelogs are older and they have not been backed up yet then consider:

1. Increasing the CONTROL_FILE_RECORD_KEEP_TIME using 'alter system set control_file_record_keep_time=[*Number of Days*] scope=spfile;'
2. Using rman to backup the archivelogs

> Hi,
>
> You have to catalog them in your controlfile or rman catalog (with catalog
> start with command) then backup them and delete them using RMAN...
>
>
>
>
> On Wed, May 19, 2021, 00:05 Ashoke Mandal <ramukam1983_at_gmail.com> wrote:
>
>> Hello, One of my Oracle 11.2.0.3 databases is behaving unusually. There
>> are 13 archivelogs files sitting at archivelog directory on the
>> database server. I have verified using the following command that these 13
>> archive logs are not backed up. But when I run the archivelog backup or
>> full backup including archivelog it doesn't backup these 13 archivelogs. It
>> backs up other archivelogs though.
>>
>> RMAN> LIST BACKUP OF ARCHIVELOG FROM TIME 'sysdate-40';
>>
>> I am not able to run "CROSSCHECK ARCHIVELOG ALL;" and getting the error
>>
>> RMAN> CROSSCHECK ARCHIVELOG ALL;
>> specification does not match any archived log in the repository
>>
>> Any idea how to backup these 13 archivelogs? I can delete these
>> archivelogs and move on but I was looking for a way to back these up.
>>
>> Thanks,
>> Ashoke
>>
>>

--
http://www.freelists.org/webpage/oracle-l