| Which type of backup shall I use? [message #304296] |
Tue, 04 March 2008 15:48  |
ottsompol
Messages: 9
Registered: December 2007
|
Junior Member |
|
|
Hello,
My organization is running a vendor supplied database. There are schema updates, table structure changes, new procedures, triggers etc. almost weekly. What would be a backup plan for this environment? We are using IMP/EXP to backup the entire schema is this is best option?
|
|
|
|
| Re: Which type of backup shall I use? [message #304298 is a reply to message #304296] |
Tue, 04 March 2008 16:19  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Depends on the nature of data, volume of data and time you can afford to restore the data (downtime).
EXP/IMP are not really backup. It is just a logical way to move the data around.
If you loose your database, you need to startover (create new database, import all the data back). If the volume of
data is high, these could take a while.
And, you can only go back to the point where you took the export.
If the data is volatile, go for hot backup (RMAN , whatever).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
