| backup and restore [message #286214] |
Thu, 06 December 2007 22:49  |
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 #286652 is a reply to message #286218] |
Sun, 09 December 2007 07:07  |
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
