Re: Aw: Re: Datagaurd without catalog database
Date: Wed, 3 Dec 2014 09:49:15 -0600
Message-Id: <02217FCF-A333-4CF1-91A8-D6B1DA57C00E_at_gmail.com>
As I recall, if using a catalog, rman will create the control file as either standby or primary as appropriate. I'm not sure what else it will do for you.
Sent from my iPad
> On Dec 3, 2014, at 9:27 AM, Ingrid Voigt <giantpanda_at_gmx.net> wrote:
>
> I second Tony.
>
> At least for complete / point in time recovery of the whole database you can use backups
> of a physical standby even without recovery catalog:
>
> 1. Switchover to standby
> 2. Stop redo transport / apply; disable configuration
> 3. duplicate database (until time) => primary gets rebuilt.
> 4. enable configuration and failover immediate back to primary
> (5. Rebuild standby)
>
> It works fine in recovery tests, never had to use it in Prod.
>
>
> Best regards
> Ingrid
>
>
>
> Gesendet: Mittwoch, 03. Dezember 2014 um 14:51 Uhr
> Von: "Andrew Kerber" <andrew.kerber_at_gmail.com>
> An: "De DBA" <dedba_at_tpg.com.au>
> Cc: "sethmiller.sm_at_gmail.com" <sethmiller.sm_at_gmail.com>, "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> Betreff: Re: Datagaurd without catalog database
> 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-lReceived on Wed Dec 03 2014 - 16:49:15 CET