Oracle 10g RAC 备份 RMAN(一)

2014-11-24 18:32:35 · 作者: · 浏览: 3

Recovery Manager: Release 10.2.0.1.0- Production on Thu Sep 27 16:37:55 2012


Copyright (c) 1982, 2005, Oracle. All rights reserved.


connected to target database: MYRAC(DBID=4177338842)


RMAN> list backup;


using target database control file insteadof recovery catalog



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 OFF; #default


CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '%F'; # default


CONFIGURE DEVICE TYPE DISK PARALLELISM 1BACKUP TYPE TO BACKUPSET; # default


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


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


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'/opt/oracle/database/product/10.2.0/db_1/dbs/snapcf_MYRAC1.f';# default



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 archive logbackupset


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=2 sequence=47recid=3 stamp=795108939


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


channel ORA_DISK_1: starting piece 1 at27-SEP-12


channel ORA_DISK_1: finished piece 1 at27-SEP-12


piece handle=/opt/oracle/database/product/10.2.0/db_1/dbs/01nm8tei_1_1tag=TAG20120927T164152 comment=NONE


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


Finished backup at 27-SEP-12



Starting backup at 27-SEP-12


using channel ORA_DISK_1


channel ORA_DISK_1: starting full datafilebackupset


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=00004 name=+DATA/myrac/datafile/undotbs2.263.772910521


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


channel ORA_DISK_1: starting piece 1 at27-SEP-12


RMAN-00571:===========================================================


RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============


RMAN-00571:===========================================================


RMAN-03002: failure of backup plusarchivelog command at 09/27/2012 16:42:58


ORA-19502: write error on file"/opt/oracle/database/product/10.2.0/db_1/dbs/02nm8ter_1_1",blockno 63361 (blocksize=8192)


ORA-27072: File I/O error


Linux Error: 2: No such file or directory


Additional information: 4


Additional information: 63361


Additional information: 102400



重新配置路径


RMAN> configure device type disk backuptype to compressed backupset;



new RMAN configuration parameters:


CONFIGURE DEVICE TYPE DISK BACKUP TYPE TOCOMPRESSED BACKUPSET PARALLELIS