clearing dba_registered_archive_logs
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 13 Sep 2018 18:56:12 -0500
Message-ID: <CAJvnOJZSbtYxdhBmnE=kL+ubo__Y9YP+GAXesmJP1VCmoVA81Q_at_mail.gmail.com>
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.
Date: Thu, 13 Sep 2018 18:56:12 -0500
Message-ID: <CAJvnOJZSbtYxdhBmnE=kL+ubo__Y9YP+GAXesmJP1VCmoVA81Q_at_mail.gmail.com>
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 - 01:56:12 CEST