Tuesday, December 6, 2011

RMAN Incrementally updated backups

This feature enables you to create an image of data file and roll forward the image copy backups with regularly create incremental backups of the database. The image copy is updated with all changes up to the SCN of incremental backup that was taken.

This feature reduces the restoration time especially when Recovery time Objective (RTO) is set for mission critical databases. In case of any recovery required you never have more than one day of redo logs to apply.

For example: - Run this script on a regular basis to implement an updated backup strategy
RUN {
ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT ‘/oradata/rman/backup.%u’;
RECOVER COPY OF DATABASE WITH TAG 'incr_backup_update';
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_backup_update' ATABASE;
}

• The BACKUP INCREMENTAL LEVEL 1... FOR RECOVER OF COPY WITH TAG... command creates a level 0 backup of the datafile, if there is no level 0 backup. In all subsequent runts, It produce’s level1 incremental backups of data file.

• The RECOVER COPY OF DATABASE WITH TAG... command causes RMAN to apply any incremental level 1 backups to a set of datafile copies with the same tag and roll forwards the image copies.

Incremental Merge backup’s strategy is the fast and easy way to restore entire database.

If you are backing up your database using Incremental merge backup then you can recovery the entire database very fast and easily by using SWITCH command. This command will point the controlfile to the backup of the data files that are present on the disk.

Let’s simulate a database failure by removing all or few data files. Make sure your database has been successfully backed up before you remove the files.

Mount the database and use SWITCH DATABASE TO COPY command to point the database to the backups available on disk.

SYS@DBTEST>startup mount
SYS@DBTEST>switch database to copy;
SYS@DBTEST>Recovery the database;
SYS@DBTEST>Alter database open;

Please note that we didn’t restored backup from backup disk or media, we have pointed the database to backup.

Regards
Satishbabu Gunukula
http://www.oracleracexpert.com

4 comments:

  1. • I love your blog! I hope to see more posts from you in the future. Really great!!!* yahoo mail sign up

    ReplyDelete
  2. Thank you for posting my blog! I enjoyed reading it. I'll keep in mind you as a back from currently on. I want to encourage you to continue your excellent writing. Visit Here: Rcedutalent
    Thank you for posting my blog! I enjoyed reading it. I'll keep in mind you as a back from currently on. I want to encourage you to continue your excellent writing. Visit Here: Rcedutalent

    ReplyDelete
  3. The Survey will be conducted in a monitored environment in the sampled schools. Sampling Design for NAS 2021 intends to support the predefined and agreed objectives of the national assessment, NAS Question Paper 2023 Students who have been Searching Online for NAS Question Paper 2023 can get from Here, Officials of the National Council for Education Research and Training Conducting the National Achievement Survey NAS.

    ReplyDelete
  4. Every one deserves to be happy in their family or relationships, I was lucky enough to get my husband back , Doctor Robbinson helped me he is authentic , My Husband left me for 8 months and I was devastated and couldn't find any way out to get him back i tried all ways. At some point I was depressed, while i was reading through some post on the internet where people testified about how Dr Robbinson helped them Solve similar problems I contacted him and he never hesitated to help me as well, My husband is back home, my happiness is restored
    Text/call: +12267705795
    Email: Drrobbinssonspiritualhome@gmail.com

    ReplyDelete