Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Logical Incremental Backups

In case of incremental backups, oracle takes the backup of only modified objects.

 

Note : The biggest dis-advantage is, even if a single record is modified, it considers the entire segment.

 

"inctype" is the parameter that we use to take the incremental backups. The possible options for inctype are :

                1.complete

                2.incremental

                3.cumulative

inctype=complete/incremental/cumulative

 

inctype=complete is the base backup for incremental backups. It takes the backup of entire database and it also maintains some information in the data dictionary tables which is required for next incrementals.

inctype=incremental takes the backup of all modified objects till the last incremental or cumulative or complete whichever appears first.

inctype=cumulative takes the backup of all modified objects till the last cumulative or complete whichever appears first.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Flag Counter