Oracle 10g RAC 备份 RMAN(二)

2014-11-24 18:32:35 · 作者: · 浏览: 1
M 1;


new RMAN configuration parameters aresuccessfully stored


released channel: ORA_DISK_1


RMAN> configure channel 1 device typedisk format '+backup/bak_%U';



new RMAN configuration parameters:


CONFIGURE CHANNEL 1 DEVICE TYPE DISKFORMAT '+backup/bak_%U';


new RMAN configuration parameters aresuccessfully stored


RMAN> CONFIGURE CONTROLFILE AUTOBACKUPFORMAT FOR DEVICE TYPE DISK TO '+backup/autobackup_control_%F';



old RMAN configuration parameters:


CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '+DATA/MYRAC/controlfile/autobackup_control_%F';


new RMAN configuration parameters:


CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '+backup/autobackup_control_%F';


new RMAN configuration parameters aresuccessfully stored



RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '+backup/snapcf_myrac1.f';



snapshot control file name set to:+backup/snapcf_myrac1.f


new RMAN configuration parameters aresuccessfully stored


RMAN> show all;



RMAN configuration parameters are:


CONFIGURE RETENTION POLICY TO REDUNDANCY 1;# default


CONFIGURE BACKUP OPTIMIZATION OFF; #default


CONFIGURE DEFAULT DEVICE TYPE TO DISK; #default


CONFIGURE CONTROLFILE AUTOBACKUP ON;


CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '+backup/autobackup_control_%F';


CONFIGURE DEVICE TYPE DISK BACKUP TYPE TOCOMPRESSED BACKUPSET PARALLELISM 1;


CONFIGURE DATAFILE BACKUP COPIES FOR DEVICETYPE DISK TO 1; # default


CONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 1; # default


CONFIGURE CHANNEL 1 DEVICE TYPE DISKFORMAT '+backup/bak_%U';


CONFIGURE MAXSETSIZE TO UNLIMITED; #default


CONFIGURE ENCRYPTION FOR DATABASE OFF; #default


CONFIGURE ENCRYPTION ALGORITHM 'AES128'; #default


CONFIGURE ARCHIVELOG DELETION POLICY TONONE; # default


CONFIGURE SNAPSHOT CONTROLFILE NAME TO'+BACKUP/snapcf_myrac1.f';



RMAN> backup database plus archivelog;




Starting backup at 27-SEP-12


current log archived


allocated channel: ORA_DISK_1


channel ORA_DISK_1: sid=133 instance=MYRAC1devtype=DISK


channel ORA_DISK_1: starting compressedarchive log backupset


channel ORA_DISK_1: specifying archivelog(s) in backup set


input archive log thread=1 sequence=88recid=1 stamp=795093263


input archive log thread=1 sequence=89recid=2 stamp=795108837


input archive log thread=1 sequence=90recid=4 stamp=795112903


input archive log thread=1 sequence=91recid=7 stamp=795115175


input archive log thread=2 sequence=47 recid=3stamp=795108939


input archive log thread=2 sequence=48recid=5 stamp=795112824


input archive log thread=2 sequence=49recid=6 stamp=795115090


channel ORA_DISK_1: starting piece 1 at27-SEP-12


channel ORA_DISK_1: finished piece 1 at27-SEP-12


piece handle=+BACKUP/bak_03nm8vl8_1_1tag=TAG20120927T171935 comment=NONE


channel ORA_DISK_1: backup set complete,elapsed time: 00:00:11


Finished backup at 27-SEP-12



Starting backup at 27-SEP-12


using channel ORA_DISK_1


channel ORA_DISK_1: starting compressedfull datafile backupset


channel ORA_DISK_1: specifying datafile(s)in backupset


input datafile fno=00001name=+DATA/myrac/datafile/system.259.772910401


input datafile fno=00003name=+DATA/myrac/datafile/sysaux.261.772910481


input datafile fno=00002name=+DATA/myrac/datafile/undotbs1.260.772910465


input datafile fno=00004name=+DATA/myrac/datafile/undotbs2.263.772910521


input datafile fno=00005name=+DATA/myrac/datafile/users.264.772910