Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Incremental backup in no archivelog mode

632301Jan 25 2010 — edited Jan 26 2010

Hello DBA's
Is it possible to take incremental backup in noarchivelog mode if not then why if yes then how we do this?
I oracle 9i and Oracle 10g documentation following line confuse me so plz help me.

"To reduce backup sizes for NOARCHIVELOG databases. Instead of making a whole database backup every time, you can make incremental backups.

As with full backups, if you are in ARCHIVELOG mode, you can make incremental backups if the database is open; _*if the database is in NOARCHIVELOG mode, then you can only make incremental backups after a consistent shutdown*_."

Book name in documentation=Oracle® Database Backup and Recovery Basics
10g Release 2 (10.2)
Part Number B14192-03
Chapter 4.
Topic 4.4

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 23 2010

Added on Jan 25 2010

#general-database-discussions

8 comments

2,418 views