Round 1: BR*Tools x RMAN – Incremental Backups

Since this is a big topic to put together with practical examples I will start with Incremental backups. Which tool is best? Up to you… the main difference is: BR*Tools is file based while RMAN is block based. I will only compare how to achieve the same result using both tools.

Notice that key commands are highlighted in different colors to make it easy to understand the syntax/parameters on RMAN and then in BR*Tools.

Backup full online (level 0) with compression and validate.

RMAN:

run{ 
allocate channel c1 device type disk;
backup as compressed backupset incremental level 0 database;
restore database validate;
}

BR*Tools:

brbackup –u / –m full –t online –d disk –k yes –w

Backup incremental (level 1).

RMAN:

RMAN> backup incremental level 1 database

BR*Tools:

brbackup –u / –m incr –t online –d disk

If you look at oracle’s alert log while performing the backup with BR*Tools, you will notice that brbackup will put the tablespace in backup mode and simply copy the datafiles to the disk location specified in the parameter backup_root_dir in the init<SID>.sap file under $ORACLE_HOME/dbs.

In the first example, the parameter –k yes means “Yes, please compress the backup”… this will by default simply zip the files and you’ll see that the datafiles will have the extension .Z at the end of each file name. The command used to compress the datafiles is specified by the parameter compress_cmd.

The second example is quite different. For level 1 backups, brbackup automatically use RMAN and the backup is performed, you can even check it on RMAN with list backupset command.

Advertisements

About Bruno Carvalho

Coffee addicted tech guy.
This entry was posted in ORACLE Database and tagged , , , , , , , , , . Bookmark the permalink.

2 Responses to Round 1: BR*Tools x RMAN – Incremental Backups

  1. jaswanth says:

    Hi Bruno,

    Your page is very informative, when I tried to execute BRtool command for incremental backup.

    I got below error from BRbackup:

    xxxxxxxxxx:oraers 13> brbackup –u / –m incr –t online –d disk
    BR0051I BRBACKUP 7.20 (30)
    BR0154E Unexpected option value ‘–u’ found at position 1
    BR0154E Unexpected option value ‘/’ found at position 2
    BR0154E Unexpected option value ‘–m’ found at position 3
    BR0154E Unexpected option value ‘incr’ found at position 4
    BR0154E Unexpected option value ‘–t’ found at position 5
    BR0154E Unexpected option value ‘online’ found at position 6
    BR0154E Unexpected option value ‘–d’ found at position 7
    BR0154E Unexpected option value ‘disk’ found at position 8

    BR0056I End of database backup: beuovukz.log 2016-11-25 10.53.09
    BR0280I BRBACKUP time stamp: 2016-11-25 10.53.09
    BR0054I BRBACKUP terminated with errors

    Can I have your advise please?

    Regards,
    Jaswanth

    • Hello Jaswanth, thank you for your comment. It looks like a characterset issue… you could try to paste the command to notepad and ensure that the “-” (hyphens) are not changed by a program like MS Word.
      Best regards,
      Bruno Carvalho

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s