Is an export with consistent=y safe ?

From: Tommy Raun <tr_at_svendts.dk>
Date: Tue, 10 Aug 1999 15:24:47 +0200
Message-ID: <37B0281F.E6645B96@svendts.dk>

I am writing a backup script for a Oracle 7 server. I'll like to make a online backup in NON-ARCHIVELOG mode.

An export seem to be the only choice. The command for doing that would be:

exp consistent=y buffer=300000 file=exp.dmp full=y

However in chapter 23 in Oracle Server Adminstrator's Guide I read the following
sentens:
"Database exports are not a substitute for operating system backups and cannot provide the same complete recovery advantages that the built-in functionality of Oracle offers"

Why is the export not 'a substitute for the system backup'? Is something important missing in the exportfile or is the data not really consistent?
--

Regards

	Tommy Raun
	tr_at_svendts.dk

Received on Tue Aug 10 1999 - 08:24:47 CDT