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

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

Backup and Recovery



Before designing a proper backup strategy for the customer we need to consider the following.
1.The size of the customer database
2.The way how the customer conducts the business(9am-9pm / 24/7 /24/5 etc)

Logical backup cannot be considered as a main backup option since we do not have the concept of recovery with the logical backup.
Recovery is possible only in case of user managed physical backups as well as RMAN backup.
In order to perform recovery, database must and should run in archive log mode.
If the customer conducts his business in 24/7 environment, we cannot take cold backup/offline backup.
For 24/7 customers, we need to implement online backup strategy.
In order to take user managed physical backup we depend on "cp" command.
User managed physical backup does not support Incremental backups.
If the database size is very huge, everyday full backup is not possible. In this case we need to depend on incremental backups.
Incremental backup means taking the backup of only modified blocks.
RMAN supports Incremental backups.
Related Posts Plugin for WordPress, Blogger...

Flag Counter