Oracle 10g RAC 备份 RMAN

[Oracle@node1 dbs]$ rman target / 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;# defaultCONFIGURE BACKUP OPTIMIZATION OFF; #defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; #defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; #defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO "%F"; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1BACKUP TYPE TO BACKUPSET; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICETYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 1; # defaultCONFIGURE MAXSETSIZE TO UNLIMITED; #defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; #defaultCONFIGURE ENCRYPTION ALGORITHM "AES128"; #defaultCONFIGURE ARCHIVELOG DELETION POLICY TONONE; # defaultCONFIGURE 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-12current log archivedallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=133 instance=MYRAC1devtype=DISKchannel ORA_DISK_1: starting archive logbackupsetchannel ORA_DISK_1: specifying archivelog（s） in backup setinput archive log thread=1 sequence=88recid=1 stamp=795093263input archive log thread=1 sequence=89recid=2 stamp=795108837input archive log thread=1 sequence=90recid=4 stamp=795112903input archive log thread=2 sequence=47recid=3 stamp=795108939input archive log thread=2 sequence=48recid=5 stamp=795112824channel ORA_DISK_1: starting piece 1 at27-SEP-12channel ORA_DISK_1: finished piece 1 at27-SEP-12piece handle=/opt/oracle/database/product/10.2.0/db_1/dbs/01nm8tei_1_1tag=TAG20120927T164152 comment=NONEchannel ORA_DISK_1: backup set complete,elapsed time: 00:00:07Finished backup at 27-SEP-12 Starting backup at 27-SEP-12using channel ORA_DISK_1channel ORA_DISK_1: starting full datafilebackupsetchannel ORA_DISK_1: specifying datafile（s）in backupsetinput datafile fno=00001name=+DATA/myrac/datafile/system.259.772910401input datafile fno=00003name=+DATA/myrac/datafile/sysaux.261.772910481input datafile fno=00002name=+DATA/myrac/datafile/undotbs1.260.772910465input datafile fno=00004 name=+DATA/myrac/datafile/undotbs2.263.772910521input datafile fno=00005name=+DATA/myrac/datafile/users.264.772910533channel ORA_DISK_1: starting piece 1 at27-SEP-12RMAN-00571:===========================================================RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============RMAN-00571:===========================================================RMAN-03002: failure of backup plusarchivelog command at 09/27/2012 16:42:58ORA-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 errorLinux Error: 2: No such file or directoryAdditional information: 4Additional information: 63361Additional information: 102400 重新配置路径RMAN> configure device type disk backuptype to compressed backupset; new RMAN configuration parameters:CONFIGURE DEVICE TYPE DISK BACKUP TYPE TOCOMPRESSED BACKUPSET PARALLELISM 1;new RMAN configuration parameters aresuccessfully storedreleased channel: ORA_DISK_1RMAN> 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 storedRMAN> 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.fnew RMAN configuration parameters aresuccessfully storedRMAN> show all; RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1;# defaultCONFIGURE BACKUP OPTIMIZATION OFF; #defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; #defaultCONFIGURE 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; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 1; # defaultCONFIGURE CHANNEL 1 DEVICE TYPE DISKFORMAT "+backup/bak_%U";CONFIGURE MAXSETSIZE TO UNLIMITED; #defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; #defaultCONFIGURE ENCRYPTION ALGORITHM "AES128"; #defaultCONFIGURE ARCHIVELOG DELETION POLICY TONONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO"+BACKUP/snapcf_myrac1.f"; RMAN> backup database plus archivelog; Starting backup at 27-SEP-12current log archivedallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=133 instance=MYRAC1devtype=DISKchannel ORA_DISK_1: starting compressedarchive log backupsetchannel ORA_DISK_1: specifying archivelog（s） in backup setinput archive log thread=1 sequence=88recid=1 stamp=795093263input archive log thread=1 sequence=89recid=2 stamp=795108837input archive log thread=1 sequence=90recid=4 stamp=795112903input archive log thread=1 sequence=91recid=7 stamp=795115175input archive log thread=2 sequence=47 recid=3stamp=795108939input archive log thread=2 sequence=48recid=5 stamp=795112824input archive log thread=2 sequence=49recid=6 stamp=795115090channel ORA_DISK_1: starting piece 1 at27-SEP-12channel ORA_DISK_1: finished piece 1 at27-SEP-12piece handle=+BACKUP/bak_03nm8vl8_1_1tag=TAG20120927T171935 comment=NONEchannel ORA_DISK_1: backup set complete,elapsed time: 00:00:11Finished backup at 27-SEP-12 Starting backup at 27-SEP-12using channel ORA_DISK_1channel ORA_DISK_1: starting compressedfull datafile backupsetchannel ORA_DISK_1: specifying datafile（s）in backupsetinput datafile fno=00001name=+DATA/myrac/datafile/system.259.772910401input datafile fno=00003name=+DATA/myrac/datafile/sysaux.261.772910481input datafile fno=00002name=+DATA/myrac/datafile/undotbs1.260.772910465input datafile fno=00004name=+DATA/myrac/datafile/undotbs2.263.772910521input datafile fno=00005name=+DATA/myrac/datafile/users.264.772910533channel ORA_DISK_1: starting piece 1 at27-SEP-12channel ORA_DISK_1: finished piece 1 at27-SEP-12piece handle=+BACKUP/bak_04nm8vll_1_1tag=TAG20120927T171949 comment=NONEchannel ORA_DISK_1: backup set complete,elapsed time: 00:01:35Finished backup at 27-SEP-12 Starting backup at 27-SEP-12current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting compressedarchive log backupsetchannel ORA_DISK_1: specifying archivelog（s） in backup setinput archive log thread=1 sequence=92recid=8 stamp=795115285input archive log thread=2 sequence=50recid=9 stamp=795115204channel ORA_DISK_1: starting piece 1 at27-SEP-12channel ORA_DISK_1: finished piece 1 at27-SEP-12piece handle=+BACKUP/bak_05nm8vos_1_1tag=TAG20120927T172132 comment=NONEchannel ORA_DISK_1: backup set complete,elapsed time: 00:00:03Finished backup at 27-SEP-12 Starting Control File and SPFILE Autobackupat 27-SEP-12piecehandle=+BACKUP/autobackup_control_c-4177338842-20120927-00 comment=NONEFinished Control File and SPFILE Autobackupat 27-SEP-12 共享磁盘查看:ASMCMD> pwd+backupASMCMD> lsMYRAC/autobackup_control_c-4177338842-20120927-00bak_03nm8vl8_1_1bak_04nm8vll_1_1bak_05nm8vos_1_1snapcf_myrac1.fASMCMD>其实这些都是快捷方式连接到 MYRAC下面ASMCMD> ls -lsType Redund Striped Time Sys Block_Size Blocks Bytes Space Name Y MYRAC/ N autobackup_control_c-4177338842-20120927-00 =>+BACKUP/MYRAC/AUTOBACKUP/2012_09_27/s_795115295.260.795115299 N bak_03nm8vl8_1_1=>+BACKUP/MYRAC/BACKUPSET/2012_09_27/annnf0_TAG20120927T171935_0.256.795115181 N bak_04nm8vll_1_1 => +BACKUP/MYRAC/BACKUPSET/2012_09_27/nnndf0_TAG20120927T171949_0.257.795115191 N bak_05nm8vos_1_1 =>+BACKUP/MYRAC/BACKUPSET/2012_09_27/annnf0_TAG20120927T172132_0.258.795115295 N snapcf_myrac1.f => +BACKUP/MYRAC/CONTROLFILE/Backup.259.795115295Oracle SQL细节总结之constraint约束Oracle 10g RAC 切换到归档模式相关资讯 RMAN

RMAN故障一例（归档的备份，从不（今 20:42）
RMAN的FORMATA格式说明（03月10日）
Oracle 11g RMAN复制数据库的测试（01月19日）

RMAN数据库迁移（05月22日）
使用RMAN复制恢复开发库环境（02月17日）
Oracle 11g RMAN跨平台传输表空间（01月19日）

本文评论查看全部评论（0）