Loading....

 By using a combination of Oracle 10g Block Change Tracking and RMAN Optimised Incremental Backups we can significantly reduce backup durations and more importantly restore and recover time.

The optimised incremental backup will ensure that subsequent incremental backups after a full backup only contain blocks changed since the last backup and will also apply archive logs to the backup on disk so that the backupset on disk can be used to recover the database without applying any archivelog files.

Also, since the backup on disk is actually the image of the database with all recent changes applied to it, we can issue a SWITCH DATABASE TO COPY command in the event of a database crash and bring up the database directly from the backup on disk in a few minutes without having to restore any file from tape.

Note the first run of the RMAN backup command and compare the same with the second run …….. the backup of the database includes an internal recovery operation as well.

 RMAN> run {

allocate channel c1 device type disk format ‘/u02/oradata/backup/bkp.%u’;

recover copy of database with tag ‘LEVEL0_BKP’;

backup incremental level 1 for recover of copy with tag ‘LEVEL0_BKP’ database;

}

  using target database control file instead of recovery catalog
 
allocated channel: c1

channel c1: sid=147 devtype=DISK

Starting recover at 11-MAR-09

no copy of datafile 1 found to recover

no copy of datafile 2 found to recover

no copy of datafile 3 found to recover

no copy of datafile 4 found to recover

no copy of datafile 5 found to recover

no copy of datafile 6 found to recover

no copy of datafile 8 found to recover

Finished recover at 11-MAR-09

Starting backup at 11-MAR-09

channel c1: starting incremental level 1 datafile backupset

channel c1: specifying datafile(s) in backupset

input datafile fno=00001 name=/u02/oradata/rcatd/system01.dbf

input datafile fno=00003 name=/u02/oradata/rcatd/sysaux01.dbf

input datafile fno=00006 name=/u02/oradata/rcatd/rman10d01.dbf

input datafile fno=00002 name=/u02/oradata/rcatd/undotbs01.dbf

input datafile fno=00004 name=/u02/oradata/rcatd/users01.dbf

input datafile fno=00005 name=/u02/oradata/rcatd/rman9d01.dbf

input datafile fno=00008 name=/u02/oradata/rcatd/patrol01.dbf

channel c1: starting piece 1 at 11-MAR-09

channel c1: finished piece 1 at 11-MAR-09

piece handle=/u02/oradata/backup/bkp.09k9l940 tag=TAG20090311T124136 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:01

channel c1: starting incremental level 1 datafile backupset

channel c1: specifying datafile(s) in backupset

including current control file in backupset

including current SPFILE in backupset

channel c1: starting piece 1 at 11-MAR-09

channel c1: finished piece 1 at 11-MAR-09

piece handle=/u02/oradata/backup/bkp.0ak9l941 tag=TAG20090311T124136 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:02

Finished backup at 11-MAR-09

released channel: c1

 RMAN> run {

allocate channel c1 device type disk format ‘/u02/oradata/backup/bkp.%u’;

recover copy of database with tag ‘LEVEL0_BKP’;

backup incremental level 1 for recover of copy with tag ‘LEVEL0_BKP’ database;

}

  using target database control file instead of recovery catalog
 
channel c1: sid=141 devtype=DISK

Starting recover at 11-MAR-09

channel c1: starting incremental datafile backupset restore

channel c1: specifying datafile copies to recover

recovering datafile copy fno=00001 name=/u02/oradata/backup/bkp.01k9l8o8

recovering datafile copy fno=00002 name=/u02/oradata/backup/bkp.04k9l8s7

recovering datafile copy fno=00003 name=/u02/oradata/backup/bkp.02k9l8q0

recovering datafile copy fno=00004 name=/u02/oradata/backup/bkp.05k9l8sm

recovering datafile copy fno=00005 name=/u02/oradata/backup/bkp.06k9l8st

recovering datafile copy fno=00006 name=/u02/oradata/backup/bkp.03k9l8re

recovering datafile copy fno=00008 name=/u02/oradata/backup/bkp.07k9l8t1

channel c1: reading from backup piece /u02/oradata/backup/bkp.09k9l940

channel c1: restored backup piece 1

piece handle=/u02/oradata/backup/bkp.09k9l940 tag=TAG20090311T124136

channel c1: restore complete, elapsed time: 00:00:02

Finished recover at 11-MAR-09

Starting backup at 11-MAR-09

channel c1: starting incremental level 1 datafile backupset

channel c1: specifying datafile(s) in backupset

input datafile fno=00001 name=/u02/oradata/rcatd/system01.dbf

input datafile fno=00003 name=/u02/oradata/rcatd/sysaux01.dbf

input datafile fno=00006 name=/u02/oradata/rcatd/rman10d01.dbf

input datafile fno=00002 name=/u02/oradata/rcatd/undotbs01.dbf

input datafile fno=00004 name=/u02/oradata/rcatd/users01.dbf

input datafile fno=00005 name=/u02/oradata/rcatd/rman9d01.dbf

input datafile fno=00008 name=/u02/oradata/rcatd/patrol01.dbf

channel c1: starting piece 1 at 11-MAR-09

channel c1: finished piece 1 at 11-MAR-09

piece handle=/u02/oradata/backup/bkp.0bk9lak7 tag=TAG20090311T130719 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:07

channel c1: starting incremental level 1 datafile backupset

channel c1: specifying datafile(s) in backupset

including current control file in backupset

including current SPFILE in backupset

channel c1: starting piece 1 at 11-MAR-09

channel c1: finished piece 1 at 11-MAR-09

piece handle=/u02/oradata/backup/bkp.0ck9lake tag=TAG20090311T130719 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:01

Finished backup at 11-MAR-09

released channel: c1

Please follow and like us:

Last Update: June 24, 2009  

June 24, 2009 167 Gavin Soorma
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

, ,

One thought on “10g optimized incremental backups to disk

  1. ictbus

    We also make use of this technology to improve throughput. It’s a good combination together with Tivoli Storage Manager for Databases, the product we use for online backup. Because network bandwidth can be a problem it’s very useful.For people who want to know a little bid more about this (and read Dutch 🙂 ) see here: http://ictbus.nl/index.php?id=11
    or mailto info@ictbus.nl

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?