Re: Datagaurd without catalog database

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Tue, 2 Dec 2014 10:52:17 -0600
Message-ID: <CAEueRAW2khVTTNN6WzadZBjzB-QzQAnRH-g1=amm8TcFMTASbA_at_mail.gmail.com>

It sounds like a one-off situation. Maybe that client had standby file management set to manual. I have never run into this problem and have set up this scenario many times. I'm a big advocate of the catalog but it is not necessary for offloading backups to a standby.

Seth Miller

On Mon, Dec 1, 2014 at 11:01 PM, Syed Jaffar Hussain < sjaffarhussain_at_gmail.com> wrote:

> Seth,
>
> One of our clients encountered a wired issue where backups on standby
> failing whenever a new datafile is being added to the primary database.
> Oracle suggested to resync the catalog just before the backups. Therefore,
> this assumes that catalog is required.
>
> On Mon, Dec 1, 2014 at 7:34 PM, Seth Miller <sethmiller.sm_at_gmail.com>
> wrote:
>
>> Syed,
>>
>> Please provide more detail on this comment. What capabilities are
>> disabled by not having a catalog in place?
>>
>> *"If you are planning to offload RMAN backups to your DR databases, then,
>> you must use the catalog"*
>>
>> Seth Miller
>>
>>
>> On Mon, Dec 1, 2014 at 5:13 AM, Syed Jaffar Hussain <
>> sjaffarhussain_at_gmail.com> wrote:
>>
>>> Dear Walid,
>>>
>>> If you are planning to offload RMAN backups to your DR databases, then,
>>> you must use the catalog, otherwise, need not to worry.
>>> Just a quick question on restore. If you want to restore a database to a
>>> month back date, how are you going to do it?
>>>
>>> Regards,
>>>
>>>
>>> On Mon, Dec 1, 2014 at 10:24 AM, walid kaakati <
>>> dmarc-noreply_at_freelists.org> wrote:
>>>
>>>> Hi list,
>>>>
>>>> we are configuring a physical standby database without a recover
>>>> catalog database, is this a correct configuration regarding RMAN and
>>>> recovery senarios ? , backups are taken on Primay and standby used only for
>>>> failover.
>>>>
>>>> Best wishes to all of you.
>>>>
>>>
>>>
>>>
>>> --
>>> Best Regards,
>>>
>>> Syed Jaffar Hussain
>>> Oracle ACE Director
>>> <http://apex.oracle.com/pls/otn/f?p=19297:4:4640302666204919::NO:4:P4_ID:186>
>>> Oracle Certified Master (10g)
>>> <http://education.oracle.com/education/otn/shussain.html>
>>> Lead-author Expert Oracle RAC 12c <http://www.apress.com/9781430250449>
>>> Co-author Oracle 11gR1/R2 RAC Essentials
>>> <http://link.packtpub.com/yNZicz>
>>> *Oracle Magazine DBA of year (2011)*
>>> OCP 8i/9i/10g/11g DBA, RAC Certified Expert, ITIL V3 foundation certified
>>> Charity : www.sajcharity.org
>>> I blog at : http://jaffardba.blogspot.com/
>>> LinkedIn : http://www.linkedin.com/in/sjaffarhussain
>>> Follow me on twitter : http://twitter.com/#!/sjaffarhussain
>>> --------------------
>>> "Winners don't do different things. They do things differently."
>>>
>>
>>
>
>
> --
> Best Regards,
>
> Syed Jaffar Hussain
> Oracle ACE Director
> <http://apex.oracle.com/pls/otn/f?p=19297:4:4640302666204919::NO:4:P4_ID:186>
> Oracle Certified Master (10g)
> <http://education.oracle.com/education/otn/shussain.html>
> Lead-author Expert Oracle RAC 12c <http://www.apress.com/9781430250449>
> Co-author Oracle 11gR1/R2 RAC Essentials <http://link.packtpub.com/yNZicz>
>
> *Oracle Magazine DBA of year (2011)*
> OCP 8i/9i/10g/11g DBA, RAC Certified Expert, ITIL V3 foundation certified
> Charity : www.sajcharity.org
> I blog at : http://jaffardba.blogspot.com/
> LinkedIn : http://www.linkedin.com/in/sjaffarhussain
> Follow me on twitter : http://twitter.com/#!/sjaffarhussain
> --------------------
> "Winners don't do different things. They do things differently."
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 02 2014 - 17:52:17 CET