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