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
Messages: 9
Registered: December 2007
Junior Member

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: 10677
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: Recover the old snapshot of view.
Goto Forum:

Current Time: Wed Aug 23 03:19:36 CDT 2017

Total time taken to generate the page: 0.01791 seconds