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:
Post a Comment