Home » RDBMS Server » Backup & Recovery » Standby in R/W mode with Flashback (10.2.0.2)
Standby in R/W mode with Flashback [message #313247] Fri, 11 April 2008 04:03 Go to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
We have a Primary database which is located at main office and now we would like to create a Physical standby of this at our development center.
We cannot use the the dataguard for auto log transfer,the only possibility is we can receive the archive logs for a day from primary which is done by a nightly batch job.
Is it possible for us to setup a physical standby in Read-Write mode with Flashback so we can test our database whenever we need and make changes and can apply the logs from primary and revert to consistent state with standby
The oracle dataguard docs ´have not specified the scenario which we need to configure.

Thanks
preet
Re: Standby in R/W mode with Flashback [message #313255 is a reply to message #313247] Fri, 11 April 2008 04:33 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes, it is possible the way you say and it is automatically handled in 11g.

Regards
Michel
Previous Topic: restore and recover a RAC, ASM, Cluster 10g Database backup to a filesystem box?
Next Topic: RMAN backup cant start
Goto Forum:
  


Current Time: Fri Nov 22 18:27:36 CST 2024