oracle sql and dba tutorial logo

Oracle DBA

Learn Oracle 11g / 12c Database Admin step by step



Oracle SQL

Tutorial for Oracle SQL

 

Oracle DBA Interview Questions

Most asked Oracle DBA Interview Questions.

60 Technical Questions
42 Backup & Recovery Questions

Unix For Oracle DBA 20 Questions


Download Oracle 11g / 12 c Software

Links to Download Oracle 12c / 11g for Linux, Windows etc.



Incrementally Updating Backup Copy and Block Change Tracking

Incrementally Updating Backups

RMAN also lets you incrementally update a database backup with the changes instead of creating a separate incremental backup each time. The advantage of updating a database backup is that it will take less time to recover.

To incrementally update data file backups:

  1. First we need to create a full image copy backup of the database with a specified tag.
  2. At regular intervals, make a level 1 incremental backup of database with the same tag.
  3. Apply the incremental backup to the most recent backup with the same tag.

Example

RUN
{
  RECOVER COPY OF DATABASE WITH TAG 'updated_db_bck';
  BACKUP
    INCREMENTAL LEVEL 1
    FOR RECOVER OF COPY WITH TAG 'updated_db_bck'
    DATABASE;
}

You can run the script daily and RMAN will automatically

1st Run
Creates a complete backup

2nd Run
Takes incremental backup

3rd Run and so on
Takes a incremental backup and updates the complete backup with it

Block Change Tracking for faster Incremental Backups

When you take RMAN incremental backups RMAN has to scan each block in datafiles to determine whether it has changed or not, this takes quite a time. This time can be reduced by enabling block change tracking

 When you enable block change tracking then Oracle will create a Block Change Tracking File in which Oracle will maintain the status of blocks whether it is changed or not. So that when you take RMAN incremental backup, RMAN will scan this file instead of whole datafile to determine which blocks are changed. This makes incremental backups faster.

Enabling Block Change Tracking

To Enable Block Change Tracking give the following command when the database is in opened or mounted state

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

 The Block Change Tracking File by default is located in the directory mentioned in DB_CREATE_FILE_DEST parameter.

If you want to have the file in another location then you can mention the location by typing the following command

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
  USING FILE '/u02/oracle/test/block_chg_file/test_db_block_change_track.f' REUSE;

Disabling Block Change Tracking

 SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;

To Know the Status of Block Change Tracking

SQL> SELECT STATUS, FILENAME FROM V$BLOCK_CHANGE_TRACKING;

 

 

 

 


HomeContact Us

Data Loader

Data Loader is a simple yet powerful tool to
export and import Data between many common database formats


Forms Data Loader

Tool to load data into Oracle E-Business Suite R12 / Oracle Apps using Macros and Forms Record and Playback

Interface Computers Academy © 2007-2017 All Rights Reserved