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

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Fix the logging option in primary and recreate the standby.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 23:00:15 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.