Snapshot of Data on another database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Snapshot of Data on another database

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577

    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.

  2. #2
    Join Date
    May 2001
    Posts
    73
    Consider setting up Logical Standby.
    OCP 7.3,8.0,8i,9i

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    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

  4. #4
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    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

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you database must be tiny to make you consider export/import as an option to take snapshots of data

    read about read-only snapshots

  6. #6
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    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.

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  8. #8
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Thanks slimdave,

    Whs the author for the book.

    Thanks
    Ron
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  9. #9
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    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
  •  


Click Here to Expand Forum to Full Width