Aw: Re: Datagaurd without catalog database

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