-
Snapshot of Data on another database
Hi,
We have 2 databases one internal OLTP database and another external
which our clients access.
We want to have a snapshot of the internal database on our external
database so that our clients can have read only access to the external
database.
I came up with the following solutions
Export the whole schema and import it into the external database. But
this has turned out to be a pain as I will have to drop the schema and
recreate it and then import the tables.
Implement views on the external database for each and every table in
the internal database, but this will increase the load on our internal
database and more important since our internal database is licensed on
Named user plus, every client of ours that connect to our database
will be a Named User. (Our external database is licensed on number of
processors but since views will access the internal database through
database links oracle treats these as Users)
Is there any other better solution to do this.
Maybe Replication....
Please suggest.
Thanks
Ron
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
Consider setting up Logical Standby.
OCP 7.3,8.0,8i,9i
-
How big is the database?
You say you need a snapshot of the 'database' by exporting 'whole schema'? Do you need the entire database or just one schema?
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
snapshot replication is not a bad idea in this case ... Will the
external database be "read-only" ? If so, then nonupdateable
snapshots is probably a good way to go...
HTH
Gregg
-
you database must be tiny to make you consider export/import as an option to take snapshots of data
read about read-only snapshots
-
Hi,
I just need a snapshot of one particular schema and the size is somewhere around 10Gigs and growing by around 200-300 MB pe month.
Where do I find good documentation and information on Read only snapshots. Its basically replication isnt it. How complicated wou;d it be to implement this.
Thanks
Ron
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
I would have a read of the Advanced Replication guide -- it contains a lot more information than you actually need, but you'll probably be a lot more comfortable with the environment afterwards.
Anyway, it's only 360 pages.
-
Thanks slimdave,
Whs the author for the book.
Thanks
Ron
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
I think Slimdave might be refering to this, or the equivalent for your Oracle version. Don't quote me though!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|