Re: Database Archiving

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Wed, 23 Aug 2017 15:56:55 -0700
Message-ID: <CAEueRAU5FqeU8ToRj+V=3Eefq0yz5in1Ps_V6Vt5rNYO7J0R6g_at_mail.gmail.com>



Is the purpose of this database archive to preserve previous states of the data? If so, you might consider that what you might be looking for is a feature included with EE called Flashback Data Archive.

https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS01011

Seth

On Wed, Aug 23, 2017 at 3:12 PM, Bheemsen Aitha <baitha_at_itradenetwork.com> wrote:

> We are doing Option #1 below. The archival process runs every hour to
> archive data to archive schema.
>
>
>
> Thanks
>
> BA
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_
> freelists.org] *On Behalf Of *Vishalaksha Vyas
> *Sent:* Wednesday, August 23, 2017 2:32 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Database Archiving
>
>
>
> Hi,
>
>
>
> I am working on a database archiving project and using a tool that will
> handle the data transfer between source and target based on the rules and
> constraints specified. This tool is not for data life cycle management but
> just a handle to transfer the data.
>
>
>
> The tool will use the DB links to transfer the data between the source and
> archive database.
>
>
>
> Having said that I need some suggestions here in choosing a suitable
> option for archival database location.
>
>
>
> FYI: Oracle application is hosted by Oracle at a different location.
> Servers are *not *on-premise.
>
>
>
> Options are:
>
>
>
> 1. Source and target on the same database. Target (archive) database is
> nothing but would be a different schema in the same database. Basically, we
> will select the data from the different application schemas and will put
> into the archive schema in the same database.
>
>
>
> 2.Preferred solution: Same server for both source and target but both will
> be on different databases. Data will be moved from source database to
> archive database and both the databases will sit on the same server.
>
>
>
> 3. Least preferred solution:- Source on one database server and archive
> database on a different server out of the Oracle virtual network. Archive
> database will be on-premise. Expecting large delays for data transfer
> because of the two server locations.
>
>
>
>
>
> There are pros and cons of these options and I want the expert advice here
> if anyone has experience in this area. Any other suggestions for database
> archiving are also welcome.
>
>
>
>
> Thanks & Regards
> Vishalaksha Vyas
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 24 2017 - 00:56:55 CEST

Original text of this message