Re: Datagaurd without catalog database

From: Fred Habash <fmhabash_at_gmail.com>
Date: Tue, 2 Dec 2014 22:25:02 -0500
Message-ID: <CADpeV5yx9gzo_OjrFOHv6rAVc3sA2No0TUCv5xXYbyHGYMsS5A_at_mail.gmail.com>

Syed ..
Ignore my last reply. I missed your reply. Can you please elaborate on the nature of this 'weird' behavior. A bug?

---

Thank you.
On Dec 2, 2014 10:14 PM, "Fred Habash" <fmhabash_at_gmail.com> wrote:

> I also would like to ask why a recovery catalog needed at all. We do it
> all the time, restore standby backups, recover, then activate using standby
> CF. With primary CF, I can do a full recovery using ORLs and open normal.
> But this is not necessary.
> Give me when scenario where a backup on the standby does not protect you
> from assuming there are no gaps in log shipping.
>
> --------
> Thank you.
> On Dec 2, 2014 11:54 AM, "Seth Miller" <sethmiller.sm_at_gmail.com> wrote:
>
>> 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 Wed Dec 03 2014 - 04:25:02 CET