The Name of the Lord — this alone is my wealth. I do not tie it up to hide it, nor do I sell it to make my living. || 1 || Pause || The Name is my crop, and the Name is my field. As Your humble servant, I perform devotional worship to You; I seek Your Sanctuary. || 1 || The Name is Maya and wealth for me; the Name is my capital. I do not forsake You; I do not know any
other at all. || 2 || The Name is my family, the Name is my brother. The Name is my companion, who will help me in the
end. || 3 || One whom the Lord keeps detached from Maya — says Kabeer, I am his slave.
Add 3 more tapes making them 4 tapes now :
ob> mkdev -t tape -o -a rac71:/vt2 -v -l vlib -d 2 vt2
ob> mkdev -t tape -o -a rac71:/vt3-v -l vlib -d 3 vt3
ob> mkdev -t tape -o -a rac71:/vt4 -v -l vlib -d 4 vt4
ob>
ob> lsvol -l -L vlib
Inventory of library vlib:
in mte: vacant
in 1: volume VOL000001, barcode 3ff2d1b8ae90103b3b0000c2939ceef, oid 105, 46919616 kb remaining
in 2: unlabeled, barcode 402ee388ae90103b3b0000c2939ceef, oid 101
in 3: unlabeled, barcode 403e1fe2ae90103b3b0000c2939ceef, oid 102
in 4: unlabeled, barcode 40519d6aae90103b3b0000c2939ceef, oid 103
in dte1: vacant
in dte2: vacant
in dte3: vacant
in dte4: vacant
ob>
Create User through GUI as:
Manage -> Users -> Add
Authorize the user through GUI:
Create Database Storage Selectors:
Configure -> Add ->
OR
User can also be added from commandline using the following command:
ob> mkuser -c oracle -p oracle -U oracle -G dba -N no -h *:*:*+rman+cmdline oracle
ob>
Now start RMAN backup from client i.e. rac70 as:
run
{
allocate channel t1 type SBT_TAPE;
allocate channel t2 type SBT_TAPE;
BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG;
release channel t1;
release channel t2;
}
Following is the log of the script of the rman and in the end I have shown the screens in OSB (Oracle Secure Backup) that the backup is now happening in OSB as well.
RMAN> run
{
allocate channel t1 type SBT_TAPE;
allocate channel t2 type SBT_TAPE;
BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG;
release channel t1;
release channel t2;
}2> 3> 4> 5> 6> 7> 8>
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: SID=46 instance=SDIEGO1 device type=SBT_TAPE
channel t1: Oracle Secure Backup
allocated channel: t2
channel t2: SID=54 instance=SDIEGO1 device type=SBT_TAPE
channel t2: Oracle Secure Backup
Starting backup at 25-APR-14
current log archived
channel t1: starting archived log backup set
channel t1: specifying archived log(s) in backup set
input archived log thread=2 sequence=290 RECID=655 STAMP=843230745
input archived log thread=1 sequence=357 RECID=657 STAMP=843230802
input archived log thread=2 sequence=291 RECID=656 STAMP=843230762
input archived log thread=1 sequence=358 RECID=658 STAMP=843230844
input archived log thread=2 sequence=292 RECID=659 STAMP=843232587
input archived log thread=1 sequence=359 RECID=662 STAMP=843232670
input archived log thread=2 sequence=293 RECID=660 STAMP=843232628
input archived log thread=2 sequence=294 RECID=661 STAMP=843232668
input archived log thread=2 sequence=295 RECID=663 STAMP=843232689
input archived log thread=1 sequence=360 RECID=665 STAMP=843232741
input archived log thread=2 sequence=296 RECID=664 STAMP=843232711
input archived log thread=2 sequence=297 RECID=666 STAMP=843232741
input archived log thread=2 sequence=298 RECID=667 STAMP=843247083
input archived log thread=1 sequence=361 RECID=669 STAMP=843271793
input archived log thread=2 sequence=299 RECID=668 STAMP=843257090
input archived log thread=2 sequence=300 RECID=670 STAMP=843292024
input archived log thread=1 sequence=362 RECID=671 STAMP=843312140
input archived log thread=2 sequence=301 RECID=673 STAMP=843328855
input archived log thread=1 sequence=363 RECID=672 STAMP=843326325
input archived log thread=1 sequence=364 RECID=674 STAMP=843328871
input archived log thread=1 sequence=365 RECID=676 STAMP=843365476
input archived log thread=2 sequence=302 RECID=675 STAMP=843343427
input archived log thread=2 sequence=303 RECID=677 STAMP=843373949
input archived log thread=1 sequence=366 RECID=678 STAMP=843404425
input archived log thread=2 sequence=304 RECID=679 STAMP=843418014
input archived log thread=1 sequence=367 RECID=680 STAMP=843429933
input archived log thread=2 sequence=305 RECID=682 STAMP=843430847
input archived log thread=1 sequence=368 RECID=681 STAMP=843430787
input archived log thread=1 sequence=369 RECID=683 STAMP=843430871
input archived log thread=1 sequence=370 RECID=685 STAMP=843465579
input archived log thread=2 sequence=306 RECID=684 STAMP=843458586
input archived log thread=2 sequence=307 RECID=686 STAMP=843472930
input archived log thread=1 sequence=371 RECID=687 STAMP=843501662
input archived log thread=2 sequence=308 RECID=688 STAMP=843501758
input archived log thread=1 sequence=372 RECID=689 STAMP=843517328
input archived log thread=2 sequence=309 RECID=690 STAMP=843518903
input archived log thread=1 sequence=373 RECID=691 STAMP=843523275
input archived log thread=2 sequence=310 RECID=692 STAMP=843544948
input archived log thread=1 sequence=374 RECID=693 STAMP=843559260
input archived log thread=2 sequence=311 RECID=694 STAMP=843565838
input archived log thread=1 sequence=375 RECID=695 STAMP=843588046
channel t1: starting piece 1 at 25-APR-14
channel t2: starting archived log backup set
channel t2: specifying archived log(s) in backup set
input archived log thread=2 sequence=312 RECID=697 STAMP=843606711
input archived log thread=1 sequence=376 RECID=696 STAMP=843602659
input archived log thread=1 sequence=377 RECID=698 STAMP=843620443
input archived log thread=2 sequence=313 RECID=700 STAMP=843636740
input archived log thread=1 sequence=378 RECID=699 STAMP=843636725
input archived log thread=2 sequence=314 RECID=701 STAMP=843636741
input archived log thread=1 sequence=379 RECID=702 STAMP=843638722
input archived log thread=1 sequence=380 RECID=703 STAMP=843681645
input archived log thread=1 sequence=381 RECID=704 STAMP=843689048
input archived log thread=1 sequence=382 RECID=705 STAMP=843724829
input archived log thread=1 sequence=383 RECID=706 STAMP=843768597
input archived log thread=1 sequence=384 RECID=707 STAMP=845548165
input archived log thread=1 sequence=385 RECID=708 STAMP=845549713
input archived log thread=2 sequence=315 RECID=711 STAMP=845549869
input archived log thread=1 sequence=386 RECID=709 STAMP=845549791
input archived log thread=1 sequence=387 RECID=710 STAMP=845549840
input archived log thread=1 sequence=388 RECID=712 STAMP=845549900
input archived log thread=2 sequence=316 RECID=714 STAMP=845549977
input archived log thread=1 sequence=389 RECID=713 STAMP=845549929
input archived log thread=1 sequence=390 RECID=715 STAMP=845549987
input archived log thread=1 sequence=391 RECID=716 STAMP=845550047
input archived log thread=2 sequence=317 RECID=719 STAMP=845550128
input archived log thread=1 sequence=392 RECID=717 STAMP=845550093
input archived log thread=1 sequence=393 RECID=718 STAMP=845550126
input archived log thread=1 sequence=394 RECID=720 STAMP=845550157
input archived log thread=2 sequence=318 RECID=722 STAMP=845571676
input archived log thread=1 sequence=395 RECID=721 STAMP=845550206
input archived log thread=1 sequence=396 RECID=723 STAMP=845571696
input archived log thread=1 sequence=397 RECID=725 STAMP=845573414
input archived log thread=2 sequence=319 RECID=724 STAMP=845573412
input archived log thread=2 sequence=320 RECID=726 STAMP=845577042
input archived log thread=1 sequence=398 RECID=727 STAMP=845577044
input archived log thread=1 sequence=399 RECID=728 STAMP=845578614
input archived log thread=2 sequence=321 RECID=729 STAMP=845578614
input archived log thread=2 sequence=322 RECID=730 STAMP=845590669
input archived log thread=1 sequence=400 RECID=731 STAMP=845611598
input archived log thread=2 sequence=323 RECID=732 STAMP=845615707
input archived log thread=1 sequence=401 RECID=733 STAMP=845650193
input archived log thread=2 sequence=324 RECID=734 STAMP=845656786
input archived log thread=1 sequence=402 RECID=735 STAMP=845658954
input archived log thread=2 sequence=325 RECID=736 STAMP=845658963
input archived log thread=1 sequence=403 RECID=738 STAMP=845659990
input archived log thread=2 sequence=326 RECID=737 STAMP=845659988
input archived log thread=2 sequence=327 RECID=740 STAMP=845660337
input archived log thread=1 sequence=404 RECID=739 STAMP=845660334
input archived log thread=1 sequence=405 RECID=742 STAMP=845661496
input archived log thread=2 sequence=328 RECID=741 STAMP=845661495
input archived log thread=2 sequence=329 RECID=743 STAMP=845677007
input archived log thread=1 sequence=406 RECID=744 STAMP=845697661
input archived log thread=2 sequence=330 RECID=745 STAMP=845706674
input archived log thread=1 sequence=407 RECID=746 STAMP=845736495
input archived log thread=2 sequence=331 RECID=747 STAMP=845746220
input archived log thread=1 sequence=408 RECID=749 STAMP=845773272
input archived log thread=2 sequence=332 RECID=748 STAMP=845763610
channel t2: starting piece 1 at 25-APR-14
channel t1: finished piece 1 at 25-APR-14
piece handle=3ep6krti_1_1 tag=TAG20140425T182949 comment=API Version 2.0,MMS Version 10.4.0.3
channel t1: backup set complete, elapsed time: 00:21:25
channel t1: starting archived log backup set
channel t1: specifying archived log(s) in backup set
input archived log thread=2 sequence=333 RECID=750 STAMP=845784086
input archived log thread=1 sequence=409 RECID=751 STAMP=845809257
input archived log thread=2 sequence=334 RECID=752 STAMP=845823589
input archived log thread=1 sequence=410 RECID=755 STAMP=845829871
input archived log thread=2 sequence=335 RECID=753 STAMP=845829859
input archived log thread=2 sequence=336 RECID=754 STAMP=845829863
input archived log thread=1 sequence=411 RECID=757 STAMP=845830282
input archived log thread=2 sequence=337 RECID=756 STAMP=845830280
input archived log thread=2 sequence=338 RECID=759 STAMP=845835770
input archived log thread=1 sequence=412 RECID=758 STAMP=845835769
input archived log thread=1 sequence=413 RECID=761 STAMP=845836182
input archived log thread=2 sequence=339 RECID=760 STAMP=845836182
channel t1: starting piece 1 at 25-APR-14
channel t2: finished piece 1 at 25-APR-14
piece handle=3fp6krtj_1_1 tag=TAG20140425T182949 comment=API Version 2.0,MMS Version 10.4.0.3
channel t2: backup set complete, elapsed time: 00:21:50
channel t1: finished piece 1 at 25-APR-14
piece handle=3gp6kt5v_1_1 tag=TAG20140425T182949 comment=API Version 2.0,MMS Version 10.4.0.3
channel t1: backup set complete, elapsed time: 00:01:06
Finished backup at 25-APR-14
Starting backup at 25-APR-14
channel t1: starting full datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/sdiego/datafile/sysaux.257.830971359
input datafile file number=00008 name=+DATA/sdiego/datafile/goldengate.270.839193779
input datafile file number=00004 name=+DATA/sdiego/datafile/users.259.845573737
input datafile file number=00007 name=+DATA/sdiego/datafile/read.269.838771155
input datafile file number=00006 name=+DATA/sdiego/datafile/undotbs2.265.830971971
channel t1: starting piece 1 at 25-APR-14
channel t2: starting full datafile backup set
channel t2: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/sdiego/datafile/system.256.830971357
input datafile file number=00003 name=+DATA/sdiego/datafile/undotbs1.258.830971359
input datafile file number=00005 name=+DATA/sdiego/datafile/example.264.830971505
input datafile file number=00010 name=+DATA/sdiego/datafile/ggdata.272.839362901
channel t2: starting piece 1 at 25-APR-14
channel t2: finished piece 1 at 25-APR-14
piece handle=3ip6kt8k_1_1 tag=TAG20140425T185307 comment=API Version 2.0,MMS Version 10.4.0.3
channel t2: backup set complete, elapsed time: 00:07:45
channel t2: starting full datafile backup set
channel t2: specifying datafile(s) in backup set
including current control file in backup set
channel t2: starting piece 1 at 25-APR-14
channel t2: finished piece 1 at 25-APR-14
piece handle=3jp6ktn6_1_1 tag=TAG20140425T185307 comment=API Version 2.0,MMS Version 10.4.0.3
channel t2: backup set complete, elapsed time: 00:01:15
channel t2: starting full datafile backup set
channel t2: specifying datafile(s) in backup set
including current SPFILE in backup set
channel t2: starting piece 1 at 25-APR-14
channel t1: finished piece 1 at 25-APR-14
piece handle=3hp6kt8j_1_1 tag=TAG20140425T185307 comment=API Version 2.0,MMS Version 10.4.0.3
channel t1: backup set complete, elapsed time: 00:10:24
channel t2: finished piece 1 at 25-APR-14
piece handle=3kp6ktq1_1_1 tag=TAG20140425T185307 comment=API Version 2.0,MMS Version 10.4.0.3
channel t2: backup set complete, elapsed time: 00:00:55
Finished backup at 25-APR-14
Starting backup at 25-APR-14
current log archived
channel t1: starting archived log backup set
channel t1: specifying archived log(s) in backup set
input archived log thread=2 sequence=340 RECID=762 STAMP=845838243
channel t1: starting piece 1 at 25-APR-14
channel t2: starting archived log backup set
channel t2: specifying archived log(s) in backup set
input archived log thread=1 sequence=414 RECID=763 STAMP=845838257
channel t2: starting piece 1 at 25-APR-14
channel t1: finished piece 1 at 25-APR-14
piece handle=3lp6ktts_1_1 tag=TAG20140425T190427 comment=API Version 2.0,MMS Version 10.4.0.3
channel t1: backup set complete, elapsed time: 00:00:26
channel t2: finished piece 1 at 25-APR-14
piece handle=3mp6ktts_1_1 tag=TAG20140425T190427 comment=API Version 2.0,MMS Version 10.4.0.3
channel t2: backup set complete, elapsed time: 00:00:35
Finished backup at 25-APR-14
released channel: t1
released channel: t2
RMAN>
Backup was happening in Oracle Secure Backup (OSB) as well:
Naked we come, and naked we go. No one, not even the kings and queens, shall remain. || 1 || The Sovereign Lord is the nine treasures for me. The possessions and the spouse to which the mortal is lovingly attached, are Your wealth, O Lord. || 1 || Pause || They do not come with the mortal, and they do not go with him. What good does it do him, if he has elephants tied up at his doorway? || 2 || The fortress of Sri Lanka was made out of gold, but what could the foolish Raawan take with him when he left? || 3 || Says Kabeer, think of doing some good deeds. In the end, the gambler shall depart empty-handed.
No comments:
Post a Comment