Discussion:
clearing dba_registered_archive_logs
Andrew Kerber
2018-09-13 23:56:12 UTC
Permalink
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.'
Vishnu
2018-09-14 01:23:24 UTC
Permalink
Hi Andrew, Check this Support note

How To Delete Archive Logs From Downstream Database (Doc ID 2011174.1)

Thanks,
Vishnu
Post by Andrew Kerber
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 Kerber
2018-09-14 01:31:35 UTC
Permalink
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.
Post by Vishnu
Hi Andrew, Check this Support note
How To Delete Archive Logs From Downstream Database (Doc ID 2011174.1)
Thanks,
Vishnu
Post by Andrew Kerber
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.'
Leng
2018-09-14 02:22:34 UTC
Permalink
Try this:

Rman> crosscheck foreign archivelog all;
Rman> delete expired foreign archivelog all;

Cheers,
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.
Post by Vishnu
Hi Andrew, Check this Support note
How To Delete Archive Logs From Downstream Database (Doc ID 2011174.1)
Thanks,
Vishnu
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.'
Andrew Kerber
2018-09-14 14:01:37 UTC
Permalink
Hi. No that didnt work. It didnt even look at the foreign archive logs.
It only looked at the regular archive logs. Probably a bug.
Post by Leng
Rman> crosscheck foreign archivelog all;
Rman> delete expired foreign archivelog all;
Cheers,
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.
Post by Vishnu
Hi Andrew, Check this Support note
How To Delete Archive Logs From Downstream Database (Doc ID 2011174.1)
Thanks,
Vishnu
Post by Andrew Kerber
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.'
--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'
Loading...