Re: Datagaurd without catalog database

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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <http://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 <http://twitter.com/#%21/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 <http://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 <http://twitter.com/#%21/sjaffarhussain>
>> --------------------
>> "Winners don't do different things. They do things differently."
>>
>>

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