RE: Nightly Incrementals for a specific user?
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: <lizzpenaorclgrp@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Oct 2006 23:42:55 -0500
I'd use transportable tablespaces for the data and data structures + data
pump exports for any stored pl/sql. This would be the fastest method imo.
Ken
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of laura pena
Sent: Monday, October 23, 2006 11:38 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Nightly Incrementals for a specific user?
Looking for recommendations here.
I need to export a user from an instance (probably exp
maybe RMAN) then apply changes made from that user to
a new database on a nightly basis. The reason I only
want a single user is we currently share an instance
with another application. In addition, this user has
it's own tablespaces (there are no sharing of
tablespaces).
What are dbas recommendation on how to perform this
sort of task?
In summary we would like to perform a full backup of
just a user once, then apply incremental of just that
user to a new system on a nightly basis.
We are running Oracle 9.2.0.3 on solaris going to
oracle 9.2.0.4 on linux.
Our user (schema) is fairly small around 1G in size.
Inserts are about 40k inserts, maybe 2,000
updates/deletes a day. There are around 40 tables in
this schema. The other users in this database are the
large ones and we are not interested in migrating
these other users.
Thanks in advance for your help and advice.
-Lizz
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
