Archive Data in Oracle Database

Hi Experts

I have Huge Oracle RAC Database 11g, I need to archive the data to external stand alonce server

the data contains only in one tablespace in 2 tow tables ...

I have no archive log mode ... and I dont want to use this method.

any Idea ... I heard about Archiving Data in oracle .. any body can help me please.



Haidar1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wasim Akram ShaikCommented:
can you brief more on this?
 
archiving? do you mean removing the data from source database from 2 tables and place it in a different(target database).

Don't you need the source data ever?

if this is the case, and you don't want to achieve this by applying archive logs from souce database then you can do this by the oracle traditional way of exporting and importing the database

export the table data from source database
and import into the target wherever you need. and if you need detailed information about importing and exporting then you can refer to the below sites.

Oracle Data Pump:

http://www.oracle-base.com/articles/10g/OracleDataPump10g.php 

Oracle traditional import:

http://www.oracle-dba-online.com/export_and_import.htm
0
Haidar1Author Commented:
Thanks for youre reply ...

I mean removing old data from source database and keeping them when ever I need them.
I know there is several ways ... like exporting database, create link to other stand alone server and inserting the recored after that deleted from the production...etc...

I read the following link... I thout there is way to do data archvieing ...

Archiving Data
http://docs.oracle.com/cd/E20465_01/doc/doc.50/e18695/sys_admin.htm
0
tangchunfengCommented:
Oracle Transportable Tablespaces TTS
psoug.org/reference/tts.html
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

slightwv (䄆 Netminder) Commented:
>>I read the following link...

From the link you posted:
"archive the traffic logs or audit history for stored procedure auditing and user role auditing"

That is specific to That particular product.  There is no generic 'archive table' process in Oracle.  You will need to create your own using available technology.

There might be other options depending on your archive 'schedule'.  For example, if you 'archive' on a date/time schedule and are licensed for it, partitioning might be the best option.

If it is archiving on a single 'delete' operation then triggers are probably your best bet.  Create a local 'rows to archive' table for the trigger to insert into then some process to move the rows to the archive database.

I would not do this in one step since the archive database will always need to be up and running.  If it was ever down the trigger would fail.



0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Haidar1Author Commented:
Thanks slightwv,,,

I would erally appreciate if you van give me more explination ...

Regards
0
slightwv (䄆 Netminder) Commented:
If you required more information why did you close the question?

Can I also ask why you gave a penalty grade of 'B'?

>>I would erally appreciate if you van give me more explination ...

Explanation of what?

0
Haidar1Author Commented:
I closed the questoin, becuase I dont want to bother others experts ....any how since you are not satisfy
with B, next time I will make sure to give you A, LOL, and when you said

"That is specific to That particular product.  There is no generic 'archive table' process in Oracle.  You will need to create your own using available technology."

I dont understand which product ... can you explain more if possible.

Regards



0
slightwv (䄆 Netminder) Commented:
>>any how since you are not satisfy with B,

It's not that I'm not satisfied but that is a penalty and I was just wondering why you chose to give that grade.  That implies I did not provide a complete answer.  If I did not, you should have asked for clarification.

http://www.experts-exchange.com/help.jsp#hs=29&hi=403


>>I dont understand which product ... can you explain more if possible.

The link you posted was for:

Oracle® Database Firewall Administration Guide

In that doc there is the following:

Archive Data and Manage archive the traffic logs or audit history for stored procedure auditing and user role auditing. Archive Configuration archives system configuration data, including the baseline policies.
0
Haidar1Author Commented:


Well I give this grade ... because .... at least you give the answer where I was confusing ... I really apprecite your care... even when you read the link, becuaes other they don't bother them self do so.

So Thanks for that ... I like to appreciate people how helped me to clarify information I have doupt on it.


Regareds
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.