Home » Server Options » Data Guard » DB update from Standby to PROD
DB update from Standby to PROD [message #259570] Thu, 16 August 2007 00:31 Go to next message
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
Re: DB update from Standby to PROD [message #259813 is a reply to message #259570] Thu, 16 August 2007 10:39 Go to previous messageGo to next message
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.
Re: DB update from Standby to PROD [message #259879 is a reply to message #259570] Thu, 16 August 2007 14:07 Go to previous messageGo to next message
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
Re: DB update from Standby to PROD [message #259882 is a reply to message #259879] Thu, 16 August 2007 14:14 Go to previous messageGo to next message
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?
Re: DB update from Standby to PROD [message #259885 is a reply to message #259882] Thu, 16 August 2007 14:25 Go to previous messageGo to next message
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).

Re: DB update from Standby to PROD [message #259886 is a reply to message #259885] Thu, 16 August 2007 14:26 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
MIKE thats correct you are right for such a case.
Re: DB update from Standby to PROD [message #259888 is a reply to message #259886] Thu, 16 August 2007 14:28 Go to previous messageGo to next message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

But of course I am Cool
Re: DB update from Standby to PROD [message #259896 is a reply to message #259888] Thu, 16 August 2007 14:58 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Thumbs Up Razz
Previous Topic: Redo Application in Failover
Next Topic: DG and multiplexing
Goto Forum:
  


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