Wednesday, December 5, 2007

rman backup for a norchivelog db in ASM

rman backupset in ASM for a noarchivelog db

use asmcmd in ASM instance to create the directory +DGRP1/testasm/rman

then from target db

configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '+DGRP1/testasm/rman/%F';
configure channel device type disk format '+DGRP1/testasm/rman/%U';




startup mount


RMAN> backup database;

Starting backup at 05-DEC-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DGRP1/testasm/datafile/system.257.640537143
input datafile fno=00003 name=+DGRP1/testasm/datafile/sysaux.258.640537199
input datafile fno=00002 name=+DGRP1/testasm/datafile/undotbs1.259.640537235
input datafile fno=00004 name=+DGRP1/testasm/datafile/users.260.640537243
channel ORA_DISK_1: starting piece 1 at 05-DEC-07
channel ORA_DISK_1: finished piece 1 at 05-DEC-07
piece handle=+DGRP1/testasm/rman/09j2rria_1_1 tag=TAG20071205T165848 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 05-DEC-07

Starting Control File and SPFILE Autobackup at 05-DEC-07
piece handle=+DGRP1/testasm/rman/c-4233323468-20071205-00 comment=NONE
Finished Control File and SPFILE Autobackup at 05-DEC-07

No comments: