Re: Database Archiving

Vishalaksha,

There are some people on this forum...well only one actually...that try to answer on behalf of others. Mladen has a right to his own opinion but not the slightest scintilla to mine.

I will not be so arrogant to assume you are working on a database warehouse project based on your original email but if you are, that is definitely valid information.

Mladen's opinion that FDA is not being used by many people has no relevance whatsoever to the conversation or whether or not it is a good solution for your environment.

While he will continue to attempt to hijack this thread, please continue to interact with the rest of this forum. Most of us want to help and share relevant information.

Seth

On Thu, Aug 24, 2017 at 7:11 AM, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> From what the OP wrote, it looks more like a data warehouse project. If I
> am not mistaken, he has specified transporting data into another DB over db
> links. Flashback data archive, or "total recall" as it was known in 11G,
> cannot be used for that. Oracle launched "Total Recall" as a separately
> priced option in 11G, but nobody was buying it, so they decided to give it
> away in 12c. Still, I don't see many people using it, even as a free option.
> Regards
>
>
> On Wed, 23 Aug 2017 15:56:55 -0700
> Seth Miller <sethmiller.sm_at_gmail.com> wrote:
>
> > 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
> > >
>
>
> --
> Mladen Gogala
> Oracle DBA
> Tel: (347) 321-1217
>

--
http://www.freelists.org/webpage/oracle-l