So do u have any suggestion on what to use for Oracle Backup on data,
instead of Export?
Howard J. Rogers wrote:
> Ursula Lee wrote:
>
>> Hi all,
>>
>> (FYI...Oracle 9.0.2.0.1 running on UNIX HP-UX11)
>> I would like to ask if we can do Oracle Export for backup while the
>> insertion is still occurring?
>
>
>
> Of course you can. Why not ask yourself a different question: if I am
> inserting into a table, does that stop you selecting from the table? And
> if it doesn't stop you, then why would export (which is merely doing a
> clever sort of select) behave differently?
>
> What will be included in the export, of course, will *not* include the
> records inserted before the export began (if you say CONSISTENT=Y) or
> before the export of that particular table began (if CONSISTENT=N).
>
> Freshly-inserted records will therefore not get included.
>
>
>> Is there a great impact on this?
>
>
> Of course. Export is selecting records. Export is therefore doing work
> against your database. That extra work might or might not be noticeable
> as an impact, though: it depends on how well behaved your database is
> without export running.
>
>> Problem is we can't stop the process but want to do the Export for
>> backup at night time.
>
>
> Export is not a viable or valid backup solution. It is a valid
> complement to a physical backup, but it should not be relied upon on its
> own.
>
> Regards
> HJR
Received on Sun Apr 25 2004 - 21:00:49 CDT
