	AllExperts > Oracle
	Search

Oracle - RMAN Backup Database Instance

Expert: Peter Choi - 11/5/2009

Question
Hi Peter.
Can you explain me, is it possible to backup database instance by using RMAN. I have one database and several instances in it (3 instances), and 6 tablespaces (2 tablespaces for each instance). I need to backup just one instance, like I can do by using expdp. I just run the command: expdp orauser/password dumpfile=data_pump:dump_file_name.dmp schemas=orauser and that's is. The dump file will contain only data (tablespaces) forf this orauser user.
How can I do the same by using RMAN ?

Thanks.

Answer
Hi Magerram,

What is RMAN?
http://www.orafaq.com/wiki/Oracle_database_Backup_and_Recovery_FAQ#What_is_RMAN_...
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/intro005.htm#sthr...

How to setup RMAN?
http://forums.oracle.com/forums/thread.jspa?threadID=358716
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/setup.htm#i101490...

How to use RMAN?
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup.htm#i1005689

While you can continue to use EXPDP to backup your database, RMAN is intended as a tool. An optional component of RMAN is to setup an RMAN Meta-Database. Essentially each RMAN backup information (and generation) is stored in your meta-database. Using RMAN, you can choose which generation to restore from if needed. RMAN can also help with FULL or incremental database backup.

Hope this helps.

Peter

Add to this Answer Ask a Question