Re: Datagaurd without catalog database

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 3 Dec 2014 07:51:09 -0600
Message-Id: <39C9CA72-58CC-4894-AEA5-7A58F008A10D_at_gmail.com>



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_at_tpg.com.au> 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_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 
>>>>>>> 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."
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 03 2014 - 14:51:09 CET

Original text of this message