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
<mailto: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
<mailto: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
<mailto: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 <mailto: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 <mailto: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
<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."
