Re: rman catalog

  • From: Don Seiler <don@xxxxxxxxx>
  • To: ckaj111@xxxxxxxx
  • Date: Tue, 16 Sep 2014 10:42:37 -0500

At this point the archivelog would be marked as EXPIRED by crosscheck. You
are right in that the catalog only contains metadata. If the archivelog
file itself has been deleted and you don't have a backup or copy, then it's
likely that you won't be able to get it back.

Perhaps your DBA friend meant he could restore it from a backup that was
also cataloged. The catalog itself is more or less just an index.


On Tue, Sep 16, 2014 at 8:53 AM, Chris King <ckaj111@xxxxxxxx> wrote:

> If an archivelog has been physically removed from a system, but there's
> metadata in the rman catalog for that log, can it be restored from the
> catalog? I thought the catalog contained only the metadata, but a dba just
> told me he could restore from the catalog, even though the file was no
> longer available on the system.
> This is Oracle version 11.2.
> Thanks!

Don Seiler

Other related posts: