Yes, a logical backup is an export. And for that, the database must be
up and running. Another method to ensure consistency (if one is worried
about that) is to make sure that no one is on the system, place it in
restricted mode, export, and then disable the restricted mode.
> Isn't logical backup simply export? You can always do it while the database
> is being used. If you're concerned about exporting inconsistent data (data
> are constantly being modified during the export process), add the parameter
> consistent=y to exp.
> Yong Huang
> > There's a discussion on this within the past day on this newsgroup.
> > Basically NO, unless you are in archivelog mode.
> > >In which state can/should the database be taken logical backups?
> > >Open or Closed?
> > >In other words, while the database is being accessed by users, can we
> > >take logical backups?
> > >Thanks in advance.
> > >Sent via Deja.com http://www.deja.com/
> > >Before you buy.
> > _______________
> > Jay M. Scheiner
> > Programmer/Analyst
> > Wolpoff & Abramson, LLP
> > remove _nospm_ from email address
> > Opinions are my own only!
Raytheons Systems at
USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my