Home » Server Options » Replication » backup and restore (Oracle 10g)
backup and restore [message #286214] Thu, 06 December 2007 22:49 Go to next message
mdvreddy
Messages: 17
Registered: November 2007
Location: x
Junior Member
I have various oracle database systems having version 10g. I need to resotre data(data,structure,tables,proc,package and all objects) from one database to another database very frequently. Currenlty using exp/imp utilities. I really would like to know any other tools/utilities can be used other than imp/exp and impd/expd utilities. Is there any way to use RMAN in this regard and all database DBF files ,sizes, tablespace names are different accros DB systems. Could please anyone suggest the way minize of restoration of dumps and can go for best method.
Re: backup and restore [message #286218 is a reply to message #286214] Thu, 06 December 2007 23:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can use RMAN duplicate, if you want to duplicate the whole database.
You can use transportable tablespace.
You can use Streams or materialized views.
All depend on your needs.

Regards
Michel
Re: backup and restore [message #286652 is a reply to message #286218] Sun, 09 December 2007 07:07 Go to previous messageGo to next message
mdvreddy
Messages: 17
Registered: November 2007
Location: x
Junior Member
thanks michel.I am new to RAM, Could you please explain me whole process like what need to be done on source DB and target DB systems. It seems only RMAN duplicate would be possible in my case since my production DB having 20+ schemas and having no connection with DEVELOPMENT DB systems. do we required droping of all schemas before doing this process. please explain in details. thanks in advance.
Re: backup and restore [message #286653 is a reply to message #286652] Sun, 09 December 2007 07:10 Go to previous messageGo to next message
mdvreddy
Messages: 17
Registered: November 2007
Location: x
Junior Member
continuation... do we require dropping of all tablespaces and datafiles before we apply RMAN duplicate.
Re: backup and restore [message #286655 is a reply to message #286653] Sun, 09 December 2007 07:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RMAN "duplicate" duplicates the whole database.
All is covered is details in documentation.
Database Backup and Recovery Advanced User's Guide

Regards
Michel

Re: backup and restore [message #287415 is a reply to message #286655] Wed, 12 December 2007 03:39 Go to previous message
mdvreddy
Messages: 17
Registered: November 2007
Location: x
Junior Member
Thanks for your information and i will check.
Previous Topic: Oracle Materialize View - High Redo Generation
Next Topic: Help in Replication, step to create updateble M.V.
Goto Forum:
  


Current Time: Thu Dec 08 06:06:06 CST 2016

Total time taken to generate the page: 0.17708 seconds