Re: Datagaurd without catalog database
Date: Wed, 03 Dec 2014 06:41:42 +0000
Message-ID: <1854576678.2160207.1417588902027.JavaMail.yahoo_at_jws10947.mail.sg3.yahoo.com>
Hi,
If your controlfile is not backed up and existence one got corrupted, then what would be the case to restore standby backups.So It's just an another sort of safe backup step/procedure... cataloging backups of your database. - ThanksPavan Kumar N
From: Andrew Kerber <andrew.kerber_at_gmail.com> To: "fmhabash_at_gmail.com" <fmhabash_at_gmail.com> Cc: "sethmiller.sm_at_gmail.com" <sethmiller.sm_at_gmail.com>; Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Wednesday, 3 December 2014 9:25 AM Subject: Re: Datagaurd without catalog database
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.orgI blog at : http://jaffardba.blogspot.com/ LinkedIn : http://www.linkedin.com/in/sjaffarhussain Follow me on twitter : http://twitter.com/#!/sjaffarhussain --------------------Received on Wed Dec 03 2014 - 07:41:42 CET
"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.orgI 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