Wednesday, May 28, 2014

Configure channel using net service name

1.Script to configure channel using net service name
run
{
allocate channel c2 device type disk
connect 'sys/sys123@CVRMAN';
backup tablespace users;
}

 run
2> {
3> allocate channel c2 device type disk
4> connect 'sys/sys123@CVRMAN';
5> backup tablespace users;
6> }

allocated channel: c2
channel c2: SID=58 device type=DISK

Starting backup at 28-MAY-14
channel c2: starting compressed full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/cvrman/datafile/users.259.847354795
channel c2: starting piece 1 at 28-MAY-14
channel c2: finished piece 1 at 28-MAY-14
piece handle=+DATA/cvrman/backupset/2014_05_28/nnndf0_tag20140528t110852_0.409.848747337 tag=TAG20140528T110852 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:07
Finished backup at 28-MAY-14
released channel: c2


No comments: