Hi Mark,
The option below was applied:
1) You can create a user database such that each user schema has read
only database link access to the standby.
Thanks and Regards
Eriovaldo
2017-12-11 18:29 GMT-02:00 Mark W. Farnham <mwf@xxxxxxxx>:
You can also do a couple other things:
1) You can create a user database such that each user schema has read
only database link access to the standby.
2) You can create a user database and supply it with extracts from the
read only database as needed either via datapump, ctas from the readonly
database, or sqlplus copy depending on the volume and structure of your
tables that you need the “users” to have at their fingertips.
3) IF the periodicity with which you need fresh data is reasonable,
you can cancel recovery, clone the standby, rename and start the clone, and
resume recovery on the actual standby. This is very useful, for example,
for financial reporting based on weekly frozen data (typically after the
generate receivables function is complete), or monthly for purposes of
meaningful forecasts without drift for long view analytics, rather than “Am
I going to make my sales quota today.”
Whether or not any of these three alternative solutions is optimal for you
depends a great deal on your exact situation and the goal you are trying to
achieve.
mwf
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@
freelists.org] *On Behalf Of *dba Wilson
*Sent:* Sunday, December 10, 2017 5:02 PM
*To:* dimensional.dba@xxxxxxxxxxx
*Cc:* Eriovaldo Andrietta; ORACLE-L
*Subject:* 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@xxxxxxxxxxx>:
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@xxxxxxxxxxx* <Dimensional.dba@xxxxxxxxxxx>
*View Matthew Parker's profile on LinkedIn*
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
www.dimensionaldba.com
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@
freelists.org] *On Behalf Of *Eriovaldo Andrietta
*Sent:* Sunday, December 10, 2017 9:52 AM
*To:* ORACLE-L <oracle-l@xxxxxxxxxxxxx>
*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
