gotchaModerate
Difference between database dump (export) and database backup?
Viewed 0 times
dumpdatabasedifferencebetweenexportandbackup
Problem
What is the drawback using only
EXP or EXPDP command for a database dump (and considering it as a backup) instead of taking backups using BACKUP DATABASE command (via RMAN)? What is a difference between database dump (export) and database backup?Solution
I'll answer this at a high level for you. The two backup methods work at different levels. An
A database dump using
An
In the event of a complete database loss an
For a hobbyist Oracle XE database (that may not be in archivelog mode), backups using
The Oracle Documentation covers this far better than I could ever explain. Oracle® Database Concepts - Backup and Recovery
RMAN backup is a physical backup and a Data Pump backup is a logical backup.A database dump using
expdp is a 1-time export of one or more database schemas. It backs up DDL (table structures, views, synonyms, stored procedures, packages, etc), plus data.An
RMAN backup is a point-in-time backup of an entire database (for the purposes of this question). It backs up the physical blocks that make up the database (data files, control file, archive logs etc) and, in combination with the database archive logs, allows point in time recovery options.In the event of a complete database loss an
RMAN backup can be used to restore the complete database. However, a data dump taken using expdp would need a new database creating before the data could be imported using impdp.For a hobbyist Oracle XE database (that may not be in archivelog mode), backups using
expdp will probably suffice.The Oracle Documentation covers this far better than I could ever explain. Oracle® Database Concepts - Backup and Recovery
Context
StackExchange Database Administrators Q#30545, answer score: 19
Revisions (0)
No revisions yet.