Thursday 20 August 2015

Creating Backups in Default Location Rather than using Format Rman

Solution:
Use below format while disk channel.

RMAN> run{
2> allocate channel c1 type disk format 'C:\app\Dilip\oradata\backup_clone\backup_clone\_%D_%T_%U';
3> allocate channel c2 type disk format 'C:\app\Dilip\oradata\backup_clone\backup_clone\_%D_%T_%U';
4> backup database plus archivelog ;
5> }

allocated channel: c1
channel c1: SID=99 device type=DISK

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


Starting backup at 20-AUG-15
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=7 RECID=13 STAMP=888263407
input archived log thread=1 sequence=8 RECID=14 STAMP=888263640
input archived log thread=1 sequence=9 RECID=15 STAMP=888263680
input archived log thread=1 sequence=10 RECID=16 STAMP=888263953
input archived log thread=1 sequence=11 RECID=17 STAMP=888264014
channel c1: starting piece 1 at 20-AUG-15
channel c2: starting archived log backup set
channel c2: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=7 STAMP=888263082
input archived log thread=1 sequence=2 RECID=8 STAMP=888263086
input archived log thread=1 sequence=3 RECID=9 STAMP=888263089
input archived log thread=1 sequence=4 RECID=10 STAMP=888263217
input archived log thread=1 sequence=5 RECID=11 STAMP=888263344
input archived log thread=1 sequence=6 RECID=12 STAMP=888263362
channel c2: starting piece 1 at 20-AUG-15
channel c1: finished piece 1 at 20-AUG-15
piece handle=C:\APP\DILIP\ORADATA\BACKUP_CLONE\BACKUP_CLONE\_20_20150820_0RQF3LD5_1_1 tag=TAG20150820T200140 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=12 RECID=18 STAMP=888264100
channel c1: starting piece 1 at 20-AUG-15
channel c1: finished piece 1 at 20-AUG-15
piece handle=C:\APP\DILIP\ORADATA\BACKUP_CLONE\BACKUP_CLONE\_20_20150820_0TQF3LD6_1_1 tag=TAG20150820T200140 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
channel c2: finished piece 1 at 20-AUG-15
piece handle=C:\APP\DILIP\ORADATA\BACKUP_CLONE\BACKUP_CLONE\_20_20150820_0SQF3LD5_1_1 tag=TAG20150820T200140 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:02
Finished backup at 20-AUG-15

Starting backup at 20-AUG-15
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\DILIP\ORADATA\CLONE_TEST\SYSTEM01.DBF
input datafile file number=00005 name=C:\APP\DILIP\ORADATA\CLONE_TEST\TT1.DBF
channel c1: starting piece 1 at 20-AUG-15
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00003 name=C:\APP\DILIP\ORADATA\CLONE_TEST\UNDOTBS01.DBF
input datafile file number=00002 name=C:\APP\DILIP\ORADATA\CLONE_TEST\SYSAUX01.DBF
input datafile file number=00004 name=C:\APP\DILIP\ORADATA\CLONE_TEST\TT.DBF
channel c2: starting piece 1 at 20-AUG-15
channel c1: finished piece 1 at 20-AUG-15
piece handle=C:\APP\DILIP\ORADATA\BACKUP_CLONE\BACKUP_CLONE\_20_20150820_0UQF3LD9_1_1 tag=TAG20150820T200144 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:26
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
channel c2: finished piece 1 at 20-AUG-15
piece handle=C:\APP\DILIP\ORADATA\BACKUP_CLONE\BACKUP_CLONE\_20_20150820_0VQF3LD9_1_1 tag=TAG20150820T200144 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:25
including current control file in backup set
channel c1: starting piece 1 at 20-AUG-15
channel c1: finished piece 1 at 20-AUG-15
piece handle=C:\APP\DILIP\ORADATA\BACKUP_CLONE\BACKUP_CLONE\_20_20150820_10QF3LE3_1_1 tag=TAG20150820T200144 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 20-AUG-15

Starting backup at 20-AUG-15
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=13 RECID=19 STAMP=888264134
channel c1: starting piece 1 at 20-AUG-15
channel c1: finished piece 1 at 20-AUG-15
piece handle=C:\APP\DILIP\ORADATA\BACKUP_CLONE\BACKUP_CLONE\_20_20150820_11QF3LE6_1_1 tag=TAG20150820T200214 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 20-AUG-15
released channel: c1
released channel: c2

RMAN>

1 comment:

  1. Blackjack, Casino and Sportsbook Review - DRMCD
    For 제주 출장마사지 those looking to play blackjack, Blackjack is 울산광역 출장안마 an excellent card 순천 출장안마 game, but 제주도 출장마사지 the rules aren't 대전광역 출장샵 that simple. Instead, you pick up your hands,

    ReplyDelete