RMANWinxx 11201记录.docVIP

RMANWinxx 11201记录 RMAN:Winxx11.2.0.1记录xx年4月30日1:04=RAC+11.2.0.1+WindowsxxRMAN备份与恢复=事前检查=RMAN的配置参数RMANshow all;RMAN configurationparameters are:CONFIGURE RETENTIONPOLICY TOREDUNDANCY1;#defaultCONFIGURE BACKUPOPTIMIZATION OFF;#defaultCONFIGURE DEFAULTDEVICE TYPETO DISK;#defaultCONFIGURE CONTROLFILEAUTOBACKUP OFF;#defaultCONFIGURE CONTROLFILEAUTOBACKUP FORMATFOR DEVICE TYPE DISKTO%F;#defaultCONFIGURE DEVICETYPE DISKPARALLELISM1BACKUP TYPETO BACKUPSET;#defaultCONFIGURE DATAFILEBACKUP COPIESFOR DEVICETYPE DISKTO1;#defaultCONFIGURE ARCHIVELOGBACKUP COPIESFOR DEVICETYPE DISKTO1;#defaultCONFIGURE CHANNELDEVICETYPE DISK FORMAT/u01/app/oracle/rmanbak/df_%d_%U;CONFIGURE MAXSETSIZETO UNLIMITED;#defaultCONFIGURE ENCRYPTIONFOR DATABASEOFF;#defaultCONFIGURE ENCRYPTIONALGORITHMAES128;#defaultCONFIGURE ARCHIVELOGDELETION POLICYTO NONE;#defaultCONFIGURE SNAPSHOTCONTROLFILE NAMETO/u01/app/oracle/10g/dbs/snapcf_orcl.f;#defaul=RMAN备份=CMDRMAN Target/RMANrunallocate channelt1type disk;/表示开t1通道;allocate channelt2type disk;/表示开t2通道;sqlalter systemarchive logcurrent;/备份开始前切一次所有节点的归档日志；backup databasetagdbfullbackupformat=E:backupdb_%d_%U_%T;/备份数据文件名称为db_数据库名称_一个唯一的文件名_年月日backup currentcontrolfile format=E:backupct_%d_%U_%T;/备份控制文件名称为ct_数据库名称_一个唯一的文件名_年月日backup spfileforma=E:backupsp_%d_%U_%T;/备份参数文件名称为sp_数据库名称_一个唯一的文件名_年月日release channelt1;/释放通道t1;release channelt2;/释放通道t2;=分区归档使用的第1页=/开双通道备份全库，数据文件、控制文件、参数文件=可选调整主库参数文件备库使用create pfile=D:test.orafrom spfile;放至备机,内容为1.修改控制文件参数，及主库的RAC环境参数；=数据迁移至备机=调整备库的参数文件=SQLstartup nomountpfile=D:.ora;/使用备库正常的参数文件启动至nomount状态；SQLcreate spfilefrom pfile=D:.ora;/为备库创建默认的spfile;SQLshutdown immediate;/关库SQLstartup nomount;/启动至nomount状态=RMAN恢复控制文件=CMDRMAN Target/RMANrestore controlfilefrom/u01/rmanbak/c-2562551067-xx0310-00;/备库恢复控制文件=特殊备库恢复备份集的存放位置与主库的存在路径不一至时，执行=RMANcatalog startwith/u01/rmanbak;/注册rman备份集到控制文件,/u01/rmanbak为备库恢复备份集存放位置=RMAN恢复数据文件、临时文件=1.先在主库生成修改数据文件、临时文件命令selectset newnamefor datafile|file#|to|name|;from v$datafileunion allselectset newnamefor tempfile|file#|to|name|;from v$tempfile;修改to后路径为备库新的路径；2.备库RMAN下执行修改【需要在mount下执行】RMANrunCONFIGURE DEVICETYPEDISKPARALLELISM4;/4通道数分区归档使用的第2页/4通道数set newnamefor datafile1toD:appAdministratororadataORCLsystem.256.790889029;set newnamefor datafile2toD:appAdministratororadataORCLsysaux.257.790889031;set newnamefor datafile3toD:appAdministratororadataORCLundotbs1.258.790889031;set newnamefor datafile4toD:appAdministratororadataORCLusers.259.790889031;set newnamefor datafile5toD:appAdministratororadataORCLundotbs2.267.790889413;set newnamefor datafile6toD:appAdministratororadataORCLzltoolstbs.273.790896719;set newnamefor datafile7toD:appAdministratororadataORCLzl9baseitem.274.790896731;set newnamefor datafile8toD:appAdministratororadataORCLzl9patient.275.790896739;set newnamefor datafile9toD:appAdministratororadataORCLzl9expense.276.790896751;set newnamefor datafile10toD:appAdministratororadataORCLzl9medlst.277.790896775;set newnamefor datafile11toD:appAdministratororadataORCLzl9duerec.278.790896785;set newnamefor datafile12toD:appAdministratororadataORCLzl9cisrec.279.790896791;set newnamefor datafile13toD:appAdministratororadataORCLzl9eprlob.280.790896811;set newnamefor datafile14toD:appAdministratororadataORCLzl9eprdat.281.790896821;set newnamefor datafile15toD:appAdministratororadataORCLzl9cisaudit.282.790896839;set newnamefor datafile16toD:appAdministratororadataORCLzl9indexhis.283.790896845;set newnamefor datafile17toD:appAdministratororadataORCLzl9indexcis.284.790896885;set newnamefor datafile18toD:appAdministratororadataORCLzlbakxx.285.790896913;set newnamefor datafile19toD:appAdministratororadataORCLzl9mtlbase.286.790896937;set newnamefor datafile20toD:appAdministratororadataORCLzl9mtlrec.287.790896943;set newnamefor datafile21toD:appAdministratororadataORCLzl9indexmtl.288.790896949;set newnamefor datafile22toD:appAdministratororadataORCLzl9blooddata.dbf;set newnamefor datafile23toD:appAdministratororadataORCLzlplat_interface.dbf;set newnamefor datafile24toD:appAdministratororadataORCLzl9wizarddata.dbf;set newnamefor datafile25toD:appAdministratororadataORCLzl9indexpss.dbf;set newnamefor tempfile1toD:appAdministratororadataORCLtemp.266.790889225;set newnamefor tempfile2toD:appAdministratororadataORCLzltoolstmp.289.790896957;restore database;switch datafileall;switch tempfileall;=SQL调整REDO日志路径=1.先在主库生成REDO日志路径selectalter databaserename file|member|to|D:appAdministratororadataORCL|substr(member,22)|;from v$logfile;2.在备库mount状态下执行SQLalter databaserename file+DATA/orcl/onlinelog/group_1.262.790889209toD:appAdministratororadataORCLgroup_1.262.790889209;alter databaserename file+DATA/orcl/onlinelog/group_1.263.790889209toD:appAdministratororadataORCLgroup_1.263.790889209;alter databaserename file+DATA/orcl/onlinelog/group_3.268.790889455toD:appAdministratororadataORCLgroup_3.268.790889455;alter databaserename file+DATA/orcl/onlinelog/group_3.269.790889457toD:appAdministratororadataORCLgroup_3.269.790889457;alter databaserename file+DATA/orcl/onlinelog/group_4.270.790889457toD:appAdministratororadataORCLgroup_4.270.790889457;alter databaserename file+DATA/orcl/onlinelog/group_4.271.790889459toD:appAdministratororadataORCLgroup_4.271.790889459;分区归档使用的第3页=RMAN下进行介质恢复=RMANrecover database/介质恢复RMANalter databaseopen resetlogs;/使用resetlogs打开数据库特殊说明1.报错RMANalter databaseopen resetlogs;使用目标数据库控制文件替代恢复目录RMAN-00571:=RMAN-00569:=ERROR MESSAGESTACK FOLLOWS=RMAN-00571:=RMAN-03002:alter db命令(在04/30/xx00:13:24上)失败ORA-01194:文件1需要更多的恢复来保持一致性ORA-01110:数据文件1:D:APPADMINISTRATORORADATAORCLSYSTEM.256.790889029处理方式SQLalter systemset_allow_resetlogs_corruption=true scope=spfile;系统已更改。 SQLshutdown immediate;SQLstartup mount;CMDRMAN Target/RAMNalter databaseopen resetlogs;成功=参考-查看rman完整的进度SQLselect sid,serial#,context,sofar as已恢复大小,totalwork as总需恢复大小,round(sofar/totalwork*100,2)as完成比例,(last_update_time-start_time)*24*60as已花费分钟数,time_remaining/60as预计还需分钟数,time_remaining/60/60as预计还需小时数from v$session_longopswhere opnamelikeRM