Home » Server Options » Data Guard » Physical standby database (oracle 9.2.0.6.0, HP-Ux 11.11)
Physical standby database [message #419211] Thu, 20 August 2009 07:36 Go to next message
gk85
Messages: 3
Registered: August 2009
Junior Member
Hi all,

One of my DBA has created physical standby database without enabling the force logging option in the primary database.

Now I am facing problem during switchover ie data block corrupted.

I have checked dbv utility.. It shows block already marked corrupted. Block contains indexes. Corrupted indexes are created with nologging option.

How could I resolve this issue?

Regards,
GK

Re: Physical standby database [message #419212 is a reply to message #419211] Thu, 20 August 2009 07:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Fix the logging option in primary and recreate the standby.

Regards
Michel
Re: Physical standby database [message #419289 is a reply to message #419212] Thu, 20 August 2009 23:47 Go to previous messageGo to next message
gk85
Messages: 3
Registered: August 2009
Junior Member
Hi Michel,

Thanks for your reply.

This is a critical database. Can it be resolved without recreating the standby database by just enabling the force logging option in primary database and recreating those indexes with logging option?

Regards,
GK
Re: Physical standby database [message #419300 is a reply to message #419289] Fri, 21 August 2009 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe b ut if this is a critical database I prefer the safe way even if it takes longer.

Regards
Michel
Re: Physical standby database [message #419366 is a reply to message #419289] Fri, 21 August 2009 09:53 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check Recovering After the NOLOGGING Clause Is Specified.

However, as Michel already mentioned, it may simply require rebuilding the standby.
Re: Physical standby database [message #419419 is a reply to message #419366] Sat, 22 August 2009 00:25 Go to previous message
gk85
Messages: 3
Registered: August 2009
Junior Member
Hi Michel/Ebrian,

Thanks for your reply.

Will follow this steps and let you know.

Regards
GK
Previous Topic: Standby only using 1 standby log
Next Topic: unable to perform tablespace pitr in data guard
Goto Forum:
  


Current Time: Thu Mar 28 09:15:02 CDT 2024