Re: About incremental backup in Export.

Raaj wrote:
> 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.
> Hi,
> Also, can we make an incremental backup through EXPORT as we do in
> RMAN(Oracle9i).

>

Performing incremental exports is a depreciated feature: http://asktom.oracle.com/pls/ask/f?p=4950:8:310171716770144362::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:832427034486,

EXP (export) makes a logical backup of your database that, for example, can be used to move your database data from one operating system to another, essentially:
CREATE TABLESPACE...
CREATE USER...
CREATE TABLE...
INSERT INTO table_name...
CREATE INDEX... RMAN makes a physical backup.

Do not rely only on EXP for your backup plan. A full EXP (or expdp for 10g+) in addition to an RMAN backup is a much better idea.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Jul 24 2006 - 06:11:36 CDT