Tuesday, May 13, 2014

Configruing RMAN channel with maximum piece size and disk rate


1. Configuring RMAN channel with maximum piece size set to 100m and disk rate is set to 5M

RMAN> run
{
allocate channel ch1
device type disk
format '+DATA'
MAXPIECESIZE=100M
RATE=5M;
backup
datafile 1,2,3;
}

2.output of the backup with the maximum piecesize and disk rate

RMAN> run
2> {
3> allocate channel ch1
4> device type disk
5> format '+DATA'
6> MAXPIECESIZE=100M
7> RATE=5M;
8> backup
9> datafile 1,2,3;
10> }

allocated channel: ch1
channel ch1: SID=43 device type=DISK

Starting backup at 14-MAY-14
channel ch1: starting compressed full datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
input datafile file number=00003 name=+DATA/cvrman/datafile/undotbs1.258.847354795
channel ch1: starting piece 1 at 14-MAY-14
channel ch1: finished piece 1 at 14-MAY-14
piece handle=+DATA/cvrman/backupset/2014_05_14/nnndf0_tag20140514t021001_0.283.847505403 tag=TAG20140514T021001 comment=NONE
channel ch1: starting piece 2 at 14-MAY-14
channel ch1: finished piece 2 at 14-MAY-14
piece handle=+DATA/cvrman/backupset/2014_05_14/nnndf0_tag20140514t021001_0.293.847505547 tag=TAG20140514T021001 comment=NONE
channel ch1: starting piece 3 at 14-MAY-14
channel ch1: finished piece 3 at 14-MAY-14
piece handle=+DATA/cvrman/backupset/2014_05_14/nnndf0_tag20140514t021001_0.289.847505643 tag=TAG20140514T021001 comment=NONE
channel ch1: backup set complete, elapsed time: 00:05:16
channel ch1: throttle time: 0:00:37
channel ch1: starting compressed full datafile backup set
channel ch1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ch1: starting piece 1 at 14-MAY-14
channel ch1: finished piece 1 at 14-MAY-14
piece handle=+DATA/cvrman/backupset/2014_05_14/ncsnf0_tag20140514t021001_0.271.847505721 tag=TAG20140514T021001 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:03
channel ch1: throttle time: 0:00:01
Finished backup at 14-MAY-14
released channel: ch1

3.List the backup with piecesize 100m. Total backupset size of 268.42M is split into 3 backuppiece as per the below ouput

RMAN> list backup tag="TAG20140514T021001";


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
46      Full    268.42M    DISK        00:05:11     14-MAY-14
  List of Datafiles in backup set 46
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1054181    14-MAY-14 +DATA/cvrman/datafile/system.256.847354793
  2       Full 1054181    14-MAY-14 +DATA/cvrman/datafile/sysaux.257.847354793
  3       Full 1054181    14-MAY-14 +DATA/cvrman/datafile/undotbs1.258.847354795

  Backup Set Copy #1 of backup set 46
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:05:11     14-MAY-14       YES        TAG20140514T021001

    List of Backup Pieces for backup set 46 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    55      1   AVAILABLE   +DATA/cvrman/backupset/2014_05_14/nnndf0_tag20140514t021001_0.283.847505403
    56      2   AVAILABLE   +DATA/cvrman/backupset/2014_05_14/nnndf0_tag20140514t021001_0.293.847505547
    57      3   AVAILABLE   +DATA/cvrman/backupset/2014_05_14/nnndf0_tag20140514t021001_0.289.847505643


No comments: