Re: Is an export with consistent=y safe ?

Ofcourse it is Safe.
Ofcourse Export Backup is not a Substitute for Physical Backups.

Usally a Combination of Cold/Hot backups and Export Backup can provide various options during Database Recovery..

Pls Reas Backup & Recovery Guide for more details...

-Thiru

Tommy Raun wrote:

> 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 - 13:09:24 CDT