Re: RMAN vs EXP/IMP

From: Irudaya Raj <jirudayaraj_at_gmail.com>
Date: 22 Mar 2005 07:07:59 -0800
Message-ID: <1111504079.777472.243810@g14g2000cwa.googlegroups.com>

RMAN is a utility that is created/supported by Oracle. RMAN has the intelligence to backup the database when its online without putting any of the Tablespaces in Backup mode. Moreover RMAN only backs up used blocks within a Datafile. Backup/Restore is many many times faster with RMAN.

When compared with EXP/IMP:
This option should be used only in case of emergencies,eg: Like you would want to do some structural change to the schema, before you do them you could export the schema and import the same later on if needed.
I use it at times to solve Row Chaining on a object that has a CLOB column in it.
There are plenty of other reasons which you can give for not using EXP/IMP against RMAN.

Although RMAN is much more complex to implement than EXPORT/IMPORT its the preferred/suggested method to backup your database. Received on Tue Mar 22 2005 - 09:07:59 CST