OraFAQ Forum: Server Administration » Instance with ReadOnly and ReadWrite Access

Home » RDBMS Server » Server Administration » Instance with ReadOnly and ReadWrite Access (11.2.0.3,Redhat 6 )

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

Instance with ReadOnly and ReadWrite Access [message #604709]

Fri, 03 January 2014 04:27

preet_kumar
Messages: 204
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 ?

Report message to a moderator

Re: Instance with ReadOnly and ReadWrite Access [message #604710 is a reply to message #604709]

Fri, 03 January 2014 04:38

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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

Report message to a moderator

Re: Instance with ReadOnly and ReadWrite Access [message #604713 is a reply to message #604710]

Fri, 03 January 2014 05:17

preet_kumar
Messages: 204
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.

Report message to a moderator

Re: Instance with ReadOnly and ReadWrite Access [message #604714 is a reply to message #604713]

Fri, 03 January 2014 05:25

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

It's not great practice but you can have more than one database instance served by one Oracle home.

HTH
-g

Report message to a moderator

Re: Instance with ReadOnly and ReadWrite Access [message #604720 is a reply to message #604714]

Fri, 03 January 2014 07:21

EdStevens
Messages: 1376
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).

Report message to a moderator

Re: Instance with ReadOnly and ReadWrite Access [message #604726 is a reply to message #604720]

Fri, 03 January 2014 08:24

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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

Report message to a moderator

Re: Instance with ReadOnly and ReadWrite Access [message #604731 is a reply to message #604709]

Fri, 03 January 2014 09:29

tim2boles
Messages: 38
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).

Report message to a moderator

Re: Instance with ReadOnly and ReadWrite Access [message #604737 is a reply to message #604714]

Fri, 03 January 2014 10:31

EdStevens
Messages: 1376
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.

Report message to a moderator

Re: Instance with ReadOnly and ReadWrite Access [message #604918 is a reply to message #604737]

Mon, 06 January 2014 02:54

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Thanks for the tip.

Report message to a moderator

Previous Topic:	Character Code Chart for AL32UTF8 on Oracle 11
Next Topic:	space recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 12:57:32 CDT 2025