Re: Datagaurd without catalog database
- From: pavan kumar <pavan_843@xxxxxxxxxxx>
- To: "andrew.kerber@xxxxxxxxx" <andrew.kerber@xxxxxxxxx>, "fmhabash@xxxxxxxxx" <fmhabash@xxxxxxxxx>
- Date: Wed, 3 Dec 2014 06:41:41 +0000 (UTC)
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@xxxxxxxxx>
To: "fmhabash@xxxxxxxxx" <fmhabash@xxxxxxxxx>
Cc: "sethmiller.sm@xxxxxxxxx" <sethmiller.sm@xxxxxxxxx>; Syed Jaffar Hussain
<sjaffarhussain@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
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@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.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."
--
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."
Other related posts:
