Re: rman catalog
From: Chris King <ckaj111_at_yahoo.ca>
Date: Tue, 16 Sep 2014 09:53:17 -0700
Message-ID: <1410886397.87236.YahooMailNeo_at_web141404.mail.bf1.yahoo.com>
Okay. Thanks for your feedback everyone! I'll ask the dba who said this could be done to give me the instructions on how he did it, and post my findings. Thanks all! On Tuesday, September 16, 2014 10:08 AM, Mayen Shah <mshah_at_travelclick.com> wrote: You are correct Chris….RMAN will need physical archived logs. The repository (control file or catalog) contains only metadata. Thanks - Mayen From:oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chris King Sent: Tuesday, September 16, 2014 9:54 AM To: oracle-l_at_freelists.org Subject: rman catalog 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! TravelClick Privacy Policy This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of TravelClick. Before opening any attachments, please check them for viruses and defects.
Date: Tue, 16 Sep 2014 09:53:17 -0700
Message-ID: <1410886397.87236.YahooMailNeo_at_web141404.mail.bf1.yahoo.com>
Okay. Thanks for your feedback everyone! I'll ask the dba who said this could be done to give me the instructions on how he did it, and post my findings. Thanks all! On Tuesday, September 16, 2014 10:08 AM, Mayen Shah <mshah_at_travelclick.com> wrote: You are correct Chris….RMAN will need physical archived logs. The repository (control file or catalog) contains only metadata. Thanks - Mayen From:oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chris King Sent: Tuesday, September 16, 2014 9:54 AM To: oracle-l_at_freelists.org Subject: rman catalog 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! TravelClick Privacy Policy This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of TravelClick. Before opening any attachments, please check them for viruses and defects.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 16 2014 - 18:53:17 CEST