Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is an export with consistent=y safe ?

Re: Is an export with consistent=y safe ?

From: <tedchyn_at_yahoo.com>
Date: Tue, 10 Aug 1999 18:44:12 GMT
Message-ID: <7oprto$ojp$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US