Re: Backup/Recovery with EXP80

From: Darren Smith <dsmith_at_nospamming.au.oracle.com>
Date: Fri, 22 Oct 1999 17:08:49 +0800
Message-ID: <381029A1.C70A03C3@nospamming.au.oracle.com>

No this is not a new feature. EXP80 is the NT version of Oracle Export Utility. It allows you to export any or all of the database to a dump file with the database still running. With the exported dump file you can import it on another platform, import specific tables/tablespaces etc only. The backup you would be referring to in NOARCHIVELOG mode would have to ba a cold backup to be a consistent backup - this means that the database would have to be shut down.

Hope this helps...

Christ Follower wrote:

> I noticed that there are parameters for EXP80 (Oracle 8.0.5) named
> POINT_IN_TIME_RECOVER (default to N) and RECOVERY_TABLESPACES (no
> default). Is this new stuff in Oracle8? How does this feature compare
> to BACKUP in NONARCHIVELOG mode? Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Darren Smith
Oracle Australia

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Oct 22 1999 - 04:08:49 CDT