Re: Datagaurd without catalog database
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: De DBA <dedba@xxxxxxxxxx>
- Date: Wed, 3 Dec 2014 07:51:09 -0600
Metalink note 1070039.1. Needed for 11.1 and above.
Sent from my iPad
> On Dec 3, 2014, at 1:16 AM, De DBA <dedba@xxxxxxxxxx> wrote:
>
> Andrew,
>
> I'm almost sure I have restored databases without a catalog from a standby
> backup. Can you point us to the actual quote?
>
> Perhaps this has bearings on the problem that Seth had with cloning the
> database from a standby backup some weeks ago, not sure how that ended. I may
> have missed the solution..
>
> Cheers,
> Tony
>
>> On 03/12/14 13:55, Andrew Kerber wrote:
>> According to oracle doc if you want to use a backup of the standby to
>> restore primary you have to use a recovery catalog. Not sure why.
>>
>> Sent from my iPhone
>>
>> On Dec 2, 2014, at 9:14 PM, Fred Habash <fmhabash@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx>
>>>>>> 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@xxxxxxxxx> 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@xxxxxxxxxxxxx> 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
>>>>>>> Oracle Certified Master (10g)
>>>>>>> Lead-author Expert Oracle RAC 12c
>>>>>>> Co-author Oracle 11gR1/R2 RAC Essentials
>>>>>>> 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
>>>>> Oracle Certified Master (10g)
>>>>> Lead-author Expert Oracle RAC 12c
>>>>> Co-author Oracle 11gR1/R2 RAC Essentials
>>>>> 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."
>
Other related posts:
