Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is an export with consistent=y safe ?
In article <37B0281F.E6645B96_at_svendts.dk>,
Tommy Raun <tr_at_svendts.dk> 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
>
tommy, for large database consistent=y will takes a long time. Ted
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Aug 10 1999 - 13:44:12 CDT