Re: About incremental backup in Export.

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 Sat Jul 22 2006 - 08:05:59 CDT