Oracle Masters

Welcome to Oracle Masters. The portal, as the tagline says, is for anything Oracle. FAQs, Certifications, Resources! In addtion, there will be pages on real life scenarios, Oracle internals, approaching the DBA job at various stages in your career and many other useful resources.Further, if you have a question, you can ask it and we will answer it at the earliest!
So join in. Learn, share and prosper!
Register with us!

Ramesh Menon
Oracle Certified Master - 10g
Oracle Certified RAC Expert - 10g
Oracle Certified Professional - 11g

Are you interested in Weekend/Online Training in Oracle DBA? Do you have business/consulting requirements? Click here Enquiry Form to leave your requirements or mail me at Ramesh Menon

Architecture andHA - RAC & Dataguard FAQs

Thursday, 12 Aug 2010 1:02 AM

one of datafile shows recovery in my standby database

By tdomf_2a078

1 Reply »

Hi,

One of my datafile in standby database shows recover mode.
can any one help me how to solve this issue.

I have created one table in one tablespace in production database, today i have applied the archive files in standby database, after that i have opened the standby database in read only mode to check the table. But the table is
corrupted saying block corrupted at block Num 3.

regards

Popularity: 3% [?]

Backup/Recovery andHA - RAC & Dataguard FAQs

Wednesday, 19 May 2010 8:14 AM

Recover physical standby database after loss of archive log – roll forward

By Ramesh Menon

No Replies »

This tutorial simulates a scenario, where in you are unable to recover your standby database because of a corrupted archive log file. The premise is that the archive log is corrupted on both production and standby, and we do not have a backup of this archive log.

The tutorial shows an example of how we can use RMAN incremental backup to recover the standby in such a scenario.

Read the rest of this entry »

Popularity: 7% [?]

HA - RAC & Dataguard FAQs

Sunday, 28 Feb 2010 8:09 PM