OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Data Archiving

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data Archiving [message #227503]

Wed, 28 March 2007 07:33

saikatermail
Messages: 20
Registered: November 2006
Location: Hyderabad

Junior Member

How to do Archiving in Oracle 9i

Report message to a moderator

Re: Data Archiving [message #227511 is a reply to message #227503]

Wed, 28 March 2007 07:47

ebrian
Messages: 2794
Registered: April 2006

Senior Member

I assume you mean archivelog ? Check Changing the Database Archiving Mode.

Report message to a moderator

Re: Data Archiving [message #227714 is a reply to message #227511]

Thu, 29 March 2007 02:48

saikatermail
Messages: 20
Registered: November 2006
Location: Hyderabad

Junior Member

Data Archiving Means To take the Backup of History Tables in a External Device such as Tape with the same layout.

Report message to a moderator

Re: Data Archiving [message #227734 is a reply to message #227714]

Thu, 29 March 2007 04:03

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Not really sure what you mean by "same layout", but one method to archive data is to use EXPORT. You could dump the data to disk and then copy to tape.

Report message to a moderator

Previous Topic:	how to get the output from dbms_job written to a file
Next Topic:	Oracle and Windows Clusters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:25:02 CDT 2024