Re: rman catalog
Date: Thu, 18 Sep 2014 02:26:36 -0500
Message-ID: <CAO9=aUwMwOZHM4jokO+00=LDOX+uTNhrNAhwXS0UCS=6Lxnd+w_at_mail.gmail.com>
Mark, you are 100% correct. I have used RESTORE ARCHIVELOG FROM SEQUENCE many times.
Chris, the takeaway here should be that if the archive logs were not backed up prior to their removal, you are out of luck.
On Tue, Sep 16, 2014 at 3:38 PM, Powell, Mark <mark.powell2_at_hp.com> wrote:
> What I think this command will do is attempt to locate the archive log
> backups which contain the specified sequence numbers and restore the
> archived redo log files. This requires that the archived redo log files
> were backed up by rman prior to the archived redo log deletion. If true,
> no problem. If the archived redo logs were not backed up with rman prior
> to their deletion then the command will fail.
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Chris King
> *Sent:* Tuesday, September 16, 2014 3:41 PM
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: rman catalog
>
>
>
> Okay, so I'm told that this command he used to restore a single archivelog
> from the database, which uses the rman catalog, even though the archivelog
> no longer existed on disk.:
>
>
>
> RMAN> run {
> ALLOCATE CHANNEL c1 DEVICE TYPE DISK FORMAT = ‘/tmp/<location>';
> RESTORE ARCHIVELOG FROM SEQUENCE 128458 UNTIL SEQUENCE 128510;
> RELEASE CHANNEL c1;
> }
>
>
>
> This still makes no sense to me. Is it possible that rman reconstructs an
> archive log based on sequence information in the catalog?
>
>
>
>
>
> On Tuesday, September 16, 2014 11:42 AM, Don Seiler <don_at_seiler.us> wrote:
>
>
>
> 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.
>
>
>
> Don.
>
>
>
> On Tue, Sep 16, 2014 at 8:53 AM, Chris King <ckaj111_at_yahoo.ca> 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
> http://www.seiler.us
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 18 2014 - 09:26:36 CEST