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?
 
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
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
tangchunfengCommented:
Oracle Transportable Tablespaces TTS
psoug.org/reference/tts.html
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.