Home » RDBMS Server » Backup & Recovery » Which type of backup shall I use? (Oracle 10G, Linux)
Which type of backup shall I use? [message #304296] Tue, 04 March 2008 15:48 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10672
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).
Previous Topic: RMAN backup tablepspace then drop table
Next Topic: Best way to backup a database
Goto Forum:
  


Current Time: Thu Dec 08 04:05:57 CST 2016

Total time taken to generate the page: 0.29118 seconds