Standby Database [message #253397] |
Mon, 23 July 2007 14:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balaji1482
Messages: 312 Registered: July 2007 Location: INDIA
|
Senior Member |
![YES](/forum/theme/orafaq/images/yahoo.png)
|
|
hi friends,
Could anybody help me
what are the steps involved in to convert the READ ONLY standby database into READ WRITE database.
Regards,
Balaji
|
|
|
|
|
Re: Standby Database [message #253550 is a reply to message #253397] |
Tue, 24 July 2007 03:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
garg_puneet
Messages: 5 Registered: July 2007
|
Junior Member |
|
|
it depends which standby u r using if it is physical standby that u cannot open in read write mode untill u shutdown your primary but in logical yes u can open in read write mode 4 reporting purpose................
Thanks
puneet
|
|
|
Re: Standby Database [message #253555 is a reply to message #253550] |
Tue, 24 July 2007 04:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68651 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Reporting does not need read/write, read only is sufficient.
You can open a physical standby in read/write mode, you just have to know that then you lose the relation with the primary that is the previous standby database is no more a standby for the primary but a clone with its own life.
Regards
Michel
[Updated on: Tue, 24 July 2007 04:28] Report message to a moderator
|
|
|