Re: Doublt related to Data Guard with primary database and standby database readonly

Logical standby allows you turn it to read write, create tables, then turn it back to read only

2017-12-11 5:54 GMT+11:00 Matthew Parker <dimensional.dba_at_comcast.net>:

> You are asking for a Logical Standby instead of a Physical Standby.
>
> https://docs.oracle.com/database/121/SBYDB/create_ls.htm#SBYDB00300
>
>
>
>
>
>
>
> *Matthew Parker*
>
> *Chief Technologist*
>
> *Dimensional DBA*
>
> *425-891-7934 <(425)%20891-7934> (cell)*
>
> *D&B *047931344
>
> *CAGE *7J5S7
>
> *Dimensional.dba_at_comcast.net* <Dimensional.dba_at_comcast.net>
>
> *View Matthew Parker's profile on LinkedIn*
> <http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
>
> www.dimensionaldba.com
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_
> freelists.org] *On Behalf Of *Eriovaldo Andrietta
> *Sent:* Sunday, December 10, 2017 9:52 AM
> *To:* ORACLE-L <oracle-l_at_freelists.org>
> *Subject:* Doublt related to Data Guard with primary database and standby
> database readonly
>
>
>
> Hello:
>
>
>
> I am tallking about Oracle 12c R1 version.
>
>
>
> I would like to know what is the way to make available a Oracle schema to
> the end user, considering :
>
>
>
> 1.) There is primary database where Data Guard is running and apply redo
> log into a standby database read only.
>
> 2.) The end users need to execute query in the instance of the standby
> database, but they do not get create tables in this read only standby
> database, by default.
>
> 3.) Currently they get only query data in the standby database.
>
>
>
> My doubt is :
>
>
>
> Is there a way to create an schema in the same server that the standby
> database is installed, in order to allow the end user execute query and
> create tables and others objects ?
>
>
>
> Notes : The purpose is avoid lot of users use the primary database.
>
> All end user has an schema in the primary database that will have your
> session killed when connect on this.
>
> Only schemas used by application will be allowed in the primary database
> in order to get better performance in the primary database.
>
>
>
> ​​
>
> Is valid the idea of to create a new instance in the server where standby
> is installed and create a pdb with synonyms for all objects created based
> on the standby database (via dblink)
>
> ​ ?​
>
>
>
> Does anyone have any experience with this scenary ?
>
>
>
> Thanks and Regards
>
> Eriovaldo
>
>
>

-- 
Regards,
Wil

--
http://www.freelists.org/webpage/oracle-l