Home » RDBMS Server » Server Administration » Instance with ReadOnly and ReadWrite Access (11.2.0.3,Redhat 6 )
Instance with ReadOnly and ReadWrite Access [message #604709] Fri, 03 January 2014 04:27 Go to next message
preet_kumar
Messages: 158
Registered: March 2007
Senior Member
I am using Oracle 11g on Redhat and would like to create a replica of our production DB which will be used by our developers.The Replica will by synced using DG and located in our office premises.
Now as the replica instance is in Readonly state our developers needs a ReadWrite Schema with few tables which extracts information from the Replica.
In this case do i have to create a separate Instance for the Developer or can i use the same Instance with read-write Schema ?
Re: Instance with ReadOnly and ReadWrite Access [message #604710 is a reply to message #604709] Fri, 03 January 2014 04:38 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
No. Your Standby database is in read-only mode to stay in sync with the Primary. That's what it's for. You should create a development instance and refresh it from live as and when needed.

HTH
-g
Re: Instance with ReadOnly and ReadWrite Access [message #604713 is a reply to message #604710] Fri, 03 January 2014 05:17 Go to previous messageGo to next message
preet_kumar
Messages: 158
Registered: March 2007
Senior Member
Thanks.

Yes i know Standby is used as Read Only but would like to know if i need to have separate Oracle Home or can use the same home for both the instance.
Re: Instance with ReadOnly and ReadWrite Access [message #604714 is a reply to message #604713] Fri, 03 January 2014 05:25 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
It's not great practice but you can have more than one database instance served by one Oracle home.

HTH
-g
Re: Instance with ReadOnly and ReadWrite Access [message #604720 is a reply to message #604714] Fri, 03 January 2014 07:21 Go to previous messageGo to next message
EdStevens
Messages: 255
Registered: September 2013
Senior Member
gazzag wrote on Fri, 03 January 2014 05:25
It's not great practice but you can have more than one database instance served by one Oracle home.

HTH
-g


And why is it not "great practice"? What are the problems with running multiple databases from the same home? (not to be confused with the question of running multiple databases on the same host, regardless of home).
Re: Instance with ReadOnly and ReadWrite Access [message #604726 is a reply to message #604720] Fri, 03 January 2014 08:24 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
Naturally it depends on one's individual circumstances and/or requirements. However, one reason that springs to mind is that any maintenance done on the Oracle home may require both instances to be shut down.

HTH
-g
Re: Instance with ReadOnly and ReadWrite Access [message #604731 is a reply to message #604709] Fri, 03 January 2014 09:29 Go to previous messageGo to next message
tim2boles
Messages: 30
Registered: August 2008
Location: Clarksburg, WV
Member
There is a different approach that you might consider. Instead of having a physical standby database you might want to use a logical standby database (LGSTBD). A LGSTBD can still be maintained using Data Guard but it does not have the same restrictions as a physical standby database. You can have additional tables, different users, you can limit who can change information in the tables, different procedures. It is a very "cool" concept. And if anything ever happens to your primary database you can still activate your logical standby database as part of your disaster resovery setup.


From the Docuemntation....
http://docs.oracle.com/cd/B19306_01/server.102/b14239/log_apply.htm

Logical standby databases can be opened in read/write mode, but the target tables being maintained by the logical standby database are opened in read-only mode for reporting purposes (providing the database guard was set appropriately).
Re: Instance with ReadOnly and ReadWrite Access [message #604737 is a reply to message #604714] Fri, 03 January 2014 10:31 Go to previous messageGo to next message
EdStevens
Messages: 255
Registered: September 2013
Senior Member
gazzag wrote on Fri, 03 January 2014 05:25
It's not great practice but you can have more than one database instance served by one Oracle home.

HTH
-g



Would be better to simply say "here are some things to consider ..." instead of throwing out a blanket statement that a newbie will tend to take as an iron-clad rule for all time.

Re: Instance with ReadOnly and ReadWrite Access [message #604918 is a reply to message #604737] Mon, 06 January 2014 02:54 Go to previous message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
Thanks for the tip.
Previous Topic: Character Code Chart for AL32UTF8 on Oracle 11
Next Topic: space recovery
Goto Forum:
  


Current Time: Thu Aug 21 19:08:59 CDT 2014

Total time taken to generate the page: 0.07900 seconds