OraFAQ Forum: Data Guard » DB update from Standby to PROD

Home » Server Options » Data Guard » DB update from Standby to PROD

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

DB update from Standby to PROD [message #259570]

Thu, 16 August 2007 00:31

shilpa_sudhakar
Messages: 25
Registered: March 2006
Location: Australia

Junior Member

Hi All,

Our PROD system failed on Monday morning due to patch failure. So we switched over to Standby system.

We have applied the patches on PROD properly and now PROD works fine. But users have been using Standby database since 3 days.
Now we want to switch back to PROD.

The issue is archive logging is enabled at both PROD and Standby

The last arc number for PROD is 6944 and for Standby is 6675.

So i cant copy the arc files from Standby to PROD.

Is there any way i can get the data from Standby into PROD for the 3 days.

Any suggestions will be appreciated.

Thanks and Regards,
Shilpa

Report message to a moderator

Re: DB update from Standby to PROD [message #259813 is a reply to message #259570]

Thu, 16 August 2007 10:39

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

One option could be if you took database backup 3days before then now you can take incremental backup and apply that backup on your server.

Report message to a moderator

Re: DB update from Standby to PROD [message #259879 is a reply to message #259570]

Thu, 16 August 2007 14:07

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

One question I have is whether it was a switchover or failover process you went through. If you did a failover, it's pretty much one-way (unless Dreamz workaround works for you). You might be able to create a Standby database from a backup of the (current) production database, patch that, and then do a switchover. That would be, I imagine, the dataguard way.

Mike

Report message to a moderator

Re: DB update from Standby to PROD [message #259882 is a reply to message #259879]

Thu, 16 August 2007 14:14

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Mike if i'm not wrong you trying to say that
OP take backup on standby machine and do the same process as we do for creating DG!! for making PRIMARY runable.??
is it?

Report message to a moderator

Re: DB update from Standby to PROD [message #259885 is a reply to message #259882]

Thu, 16 August 2007 14:25

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

Hello, Dreamz! I'm only describing a standard recovery from failover. After failover, two machines end up looking like this: The Primary machine with no database on it, and a Standby machine hosting the (new) primary database. To recover, you create a standby database on the Primary machine and then do a switchover.

Once that's done, you are back to "normal" with the Primary DB on the Primary machine and the Standby DB on the Standby machine. At least, that's my understanding of it.

Note: It's different than recovering from a "switchover", because there is no Standby database on the Primary machine after a failover. You are basically recreating the Dataguard environment with a Physical Standby database on the Primary machine, then doing a switchover so that the Primary database is where it belongs (on the Primary machine).

Report message to a moderator