Re: Why export has conventional path?

Sybrand Bakker wrote:

> The direct export mode reads directly from the database, it doesn't issue
> ordinary selects.
> Hence, it doesn't use the normal read consistency model. I'm not going to
> bet how many administrators run a direct export on a database with other
> users connected! Actually, the only way to get a correct full database
> export is to kick everyone out and make sure the database is in restricted
> session.
> The risk of running an export in direct mode is getting an inconsistent
> export, if you don't kick everyone out. It is the same as creating a backup,
> storing the tape in the same room as the server, and never test the recovery
> scenario. (Don't think this doesn't happen, it does)

Direct export can create consistent backup. Add consistent=y in the parfile. (and warn users that they are working at their own risk ;-)

Adam Received on Mon Apr 10 2000 - 00:00:00 CDT