OraFAQ Forum: Data Guard » Apply standby redo log to physical stby db.

Home » Server Options » Data Guard » Apply standby redo log to physical stby db. (Oracle rdbms - 11.2.0.1 OS - HP UX 11.31)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Apply standby redo log to physical stby db. [message #585461]

Sun, 26 May 2013 00:36

karkerabhaskar
Messages: 2
Registered: May 2011

Junior Member

Hi all,

Facing a problem in the following scenario.

I have dataguard configuration operating in maximum availability mode with a local standby db (A - lgwr sync not using real time apply) and a remote standby db (B - lgwr async). I then simualted a crash of my primary database with batch jobs running. Since the stby db A is in lgwr sync option ,all the commited data in the current online redo log has been transmitted to stby A and is present in its stby redo log (Group 2).How do I apply this stby redo log to the remote stby db.

Tried the following methods.
1.ftp the stby redo log to the remote db and tried to regiter it, got an error that it is not completely archived.
2.issued the recover standby database command and supplied the stby redo log when it asked for the sequence in the stby redo, got an error saying there is corruption in a block(tried this option multiple times ended up with the same result.)

Regars.

Report message to a moderator

Re: Apply standby redo log to physical stby db. [message #585472 is a reply to message #585461]

Sun, 26 May 2013 02:57

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Start redo apply on B; bring up A as primary; start propagating redo to B. B's log gap detection should kick in and automatically request whatever it is missing. Have you configured the broker? It is very good at automating all of this.
--
update: typo

[Updated on: Sun, 26 May 2013 02:57]

Report message to a moderator

Re: Apply standby redo log to physical stby db. [message #585483 is a reply to message #585472]

Sun, 26 May 2013 06:11

karkerabhaskar
Messages: 2
Registered: May 2011

Junior Member

Is there no way I can apply the stby redo directly to Db B (remote stby db), I donot want to activate db A(local standby),as it is requesting the same redo data the only difference being the redo data is in a stby redo logfile.

Report message to a moderator

Re: Apply standby redo log to physical stby db. [message #585486 is a reply to message #585483]

Sun, 26 May 2013 06:27

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

I do not see why you would not bring up A as the primary: that would be the only reason for having run it in SYNC mode. However, I think you are saying that you want to bring up B as the primary. Well, try it: you can probably bring it up with zero data loss. Check the SCN to find out. I hope you have database flashback enabled: it makes repeated tests of this sort of thing much easier.

Report message to a moderator

Re: Apply standby redo log to physical stby db. [message #588699 is a reply to message #585486]

Thu, 27 June 2013 08:48

kjosh2008
Messages: 2
Registered: April 2011
Location: nangal

Junior Member

How to check total size of library cache and data dictionary. which parameter.

-regards

kshitij joshi

Report message to a moderator

Re: Apply standby redo log to physical stby db. [message #588700 is a reply to message #588699]

Thu, 27 June 2013 08:55

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ How is this related to the current topic?
2/ Why do you need that?

Regards
Michel

Report message to a moderator

Previous Topic:	LGWR SYNC
Next Topic:	Data Guard - Log Sync issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 22:35:45 CST 2025