Re: About incremental backup in Export.

Hi,

   Also, can we make an incremental backup through EXPORT as we do in RMAN(Oracle9i).

Regards,
Raaj
Charles Hooper wrote:
> Raaj wrote:
> > Hi,
> > I am currently working with Oracle9i on RhL platforms. Can we make an
> > incremental export in Oracle like in RMAN what we do.
> > What is the disadvantage in taking cold backup after shutting down
> > the databse with SHUTDOWN ABORT. Is it like the SCN values in Datafile
> > headers and Controfile will not be consistent?
> > Please correct me if i am wrong.
> >
> > Regards,
> > Raaj
>
> >From the Oracle 8i Administrator's Guide (paraphrased):
> SHUTDOWN ABORT will require instance recovery procedures -
> transactions that were in process when SHUTDOWN ABORT was executed are
> not rolled back.
>
> >From the Oracle 8i Oracle Backup and Recovery Guide (paraphrased):
> An inconsistent backup is made with the database open or if the
> database is shut down abnormally (in archive redo log mode, should not
> create an inconsistent backup when not in archive redo log mode). A
> consistent backup is a backup that is made after the database is closed
> cleanly - a consistent backup does not require instance recovery.
>
> >From the Oracle 10g R2 Concepts manual:
> "The only way to make a consistent whole database backup is to shut
> down the
> database with the NORMAL, IMMEDIATE, or TRANSACTIONAL options and make
> the
> backup while the database is closed. If a database is not shut down
> cleanly, for
> example, an instance fails or you issue a SHUTDOWN ABORT statement,
> then the
> database's datafiles are always inconsistent-unless the database is a
> read-only
> database."
>
> All backups performed without shutting down the database are considered
> inconsistent.
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.
Received on Sun Jul 23 2006 - 22:19:21 CDT