Re: clearing dba_registered_archive_logs
Date: Fri, 14 Sep 2018 12:22:34 +1000
Message-Id: <2D1AB9F3-D52B-474A-907F-C62FC6B14076_at_gmail.com>
Try this:
Rman> crosscheck foreign archivelog all;
Rman> delete expired foreign archivelog all;
Cheers,
> On 14 Sep 2018, at 11:31 am, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:
Leng
>
> Hi. I appreciate the response. However, because the logs have already been deleted I just get an error message about the file not being present. THe logs still show up on the dba_registered_archive_log view. So I just need to remove them from the view, they are already gone from asm.
>
>> On Thu, Sep 13, 2018 at 8:23 PM Vishnu <vishnukumarmp_at_gmail.com> wrote:
>> Hi Andrew, Check this Support note
>>
>> How To Delete Archive Logs From Downstream Database (Doc ID 2011174.1)
>>
>> Thanks,
>> Vishnu
>>
>>> On Thu, Sep 13, 2018 at 7:57 PM Andrew Kerber <andrew.kerber_at_gmail.com> wrote:
>>> I have deleted a large number of files manually due to space considerations from asm, all are in this path:+RECOVERY/FOREIGNARCHIVELOG/dbname. However, the deleted files still show up in dba_registered_archive_logs. This is a downstream capture database, so the logs came in from another database and were mined for data, and I manually deleted them. Now I need to clear them from the dba_registered_archive_logs view. Any ideas on how to do that? Crosscheck archivelog all in rman isnt even aware of them.
>>>
>>> --
>>> Andrew W. Kerber
>>>
>>> 'If at first you dont succeed, dont take up skydiving.'
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 14 2018 - 04:22:34 CEST