Re: Oracle Export while insertion

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Mon, 26 Apr 2004 18:32:03 +1000
Message-ID: <408cc8fe$0$26367$afc38c87@news.optusnet.com.au>

Ursula Lee wrote:
> So do u have any suggestion on what to use for Oracle Backup on data,
> instead of Export?

What's wrong with normal physical backups? You simply copy the data files whilst their in use (remembering to put them into hot backup mode first, and remembering also to take them out of hot backup mode when you've done).

If you want an even simpler life, learn how to do a hot backup with RMAN. I'll give you a clue: in 9i, the command is "backup database;"... it doesn't get much simpler, does it?

Physical backups, whether done hot or cold, are (in archivelog mode, at least) fully recoverable, partially recoverable or anywhere in between. Provided you look after your archives, you are guaranteed never to lose a committed transaction.

Regards
HJR Received on Mon Apr 26 2004 - 03:32:03 CDT