Re: backup of 10g ?

On May 2, 2:18 pm, Joe <joe1..._at_tlen.pl> wrote:
> if one makes a backup with expdp.exe, does this dump file contain all
> information in order to reproduce db?

That is what is called a "logical backup." As Raju indicated, it may contain all the information you need.

However, note that Oracle specifically recommends a physical backup. You can only avoid losing transactional data with a physical backup. Oracle people often consider the term "backup" to refer to physical backup, and don't consider a logical backup a "real" backup.

What you need to do depends on your requirements. If you have a production database, you need a physical backup. If you are distributing data among customers or other databases, you may need a logical backup. If you are cloning databases, you probably want to use RMAN these days. If you have a data warehouse, you may be able to depend on it's feeds to have backups and may not need a backup at all.

What is most important then, is explicit requirements. Right on its heels is not losing data.

jg

--
@home.com is bogus.
hahaha!  http://www.newlaunches.com/archives/business_20the_business_magazine_should_practice_what_it_preaches.php