Re: clearing dba_registered_archive_logs

From: Vishnu <vishnukumarmp_at_gmail.com>
Date: Thu, 13 Sep 2018 21:23:24 -0400
Message-ID: <CABkZzkd6sEGiS3TPginMU0c2bmyU6i5uW+y4cXmLP6HJprMdpg_at_mail.gmail.com>



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.'
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 14 2018 - 03:23:24 CEST

Original text of this message