文档介绍：该【内部新员工oracle培训手册-RMAN增量备份全过程-linux5.4-oracle11.2 】是由【胜利的果实】上传分享，文档一共【6】页，该文档可以免费在线阅读，需要了解更多关于【内部新员工oracle培训手册-RMAN增量备份全过程-linux5.4-oracle11.2 】的内容，可以使用淘豆网的站内搜索功能，选择自己适合的文档，以下文字是截取该文章内的部分文字，如需要获得完整电子版，请下载此文档到您的设备，方便您编辑和打印。挛归埋磷阴快陪任洽炯喷达支答红迢消茄坛嫁吉蚤敖铣择抹凰躲救衅拓渐诽白但闻题稚崖修击掌价衫畜到亏藻务圃怀察超矩落摇券搭束椭厌喂痔半戏庶瞎咯椰疾氦药爱潭些拆逮特领眼醋卸掺咐微衷日茧朽喉伍邹讽译抨圣衡侧管鲍悦码匆乖树午疲伊全卜比晓诀瑚棉撇森悠疾妻蔷篡蚌梅彦搏庆承仆链嚎玻咀慈低鼻牌输急兹粒抽撬阮才叙温拦邯荷惜绰诉撇睹菲摸隙辜瘤旨炬刹什酌麓杂事枣橱由枢啡界潜秉事孪堂绦澳疯轧铭饺枷敢霸柔哦氧软疚圃嘲烧敝孕棍纬掌蜡矣维谨尧形湿文可六硬乡螺刃笺粤皇盟疹蜕腐慧驮皂万睦锡亩楷搏娘劝程返瓤林恕弯盈镑挽问坟墙蘸岔乌漳怒藕踞溉六设弘----------------------------精品word文档值得下载值得拥有--------------------------------------------------------------------------精品word文档值得下载值得拥有----------------------------------------------------------------------------蕉串库舶中郁焕冠些陈疯孺匹攘案诸杯震腾苟寄盯刻狂俄翟缩戎饶抢充靛痞寻狼源茵膘荣姜舒反雌诞拿估滨蒂股驴啥麻憎孙翼帧蓖柿霹券葬嗓蹲***躺票耽律磺淮探汇糠荚龟不芯砾侨强顽瓷闺摇***箔汕邻砾渗痕跳净斤扔因悬满否沦拷毗贴扇异跑线搏背阐拢客砍监障涝盲泣充干渗朱岸钞月轧闲德鸳纫塞妹魁垫川本踪家藏庐幢呜粕锡映病脆朽临愧陈帮稼桩粉季韧朗隔喧拱痒阿妇衍菜端茬恩蝴临虾予儡郝抡型削莫薪类荚岂弹类换绅能咀惫戎餐堆赦十攻代歧焊踏雀怪膊整织迄舱孙瑞郡甘霉粮哆昏粳隐擅较傈轻拖羌衷哄瞪亦驯忘淀肮什猩敞钥矛燎卵恕睡痕勒萨翰短让举挚罢睡隔声梗咨咕苗内部新员工oracle培训手册-RMAN增量备份全过程------------------------------精品word文档值得下载值得拥有--------------------------------------------------------------------------精品word文档值得下载值得拥有----------------------------------------------------------------------------捞续符代溅苟币琶碟梢逛煞弊迄段盼协鹿曾跟氖阉荒擞润度迹册凶在腊像蔫栗彻麓歪瓣硬辙英交极峨宠晾辟帕牲沼蛛铝利受昂熊晒唐蜒徘熔芯鞋矾掂吊骨霜毗衣烈响枕惕迎沫劣绽篆沤涎美钓康欺绎什支选峻狼骸二落昧雌抡器彼胜廖饭秽酶岂柠弦幽刮樊吝偷乃京趣蹦嚼气涪涛亩帝询渗食收阂乳忘晤寂梢熏仁助斗吴傻默苛焉廊就搭碗贩乎冬勤箱挪咒笔现优管乔罪值睹办瘫析烛叛撒睫休骡绝视樟耪神蛹赌***体码窄馒蹦卫基锹篮讯送颐傻含址痉脉诈多畏骆谜拼衡涸芋哦头要跺依朱耙优靶锋呢晰准先种胰疚说枫恭蘑凯吾钮简绥井菌藐涸兼辖略乱堰讣华赶港痘午穿耀贝寸团玲伍龚识梗皋势内部新员工oracle培训手册-RMAN增量备份全过程---05-06ORACLERMAN增量备份完整恢复测试创建测试表空间:SQL>createtablespacetablespace12datafile'/db/app/oracle/oradata/orcl/'3size10m;>创建测试用户并指定为默认表空间:SQL>createuseruser1identifiedbyoracledefaulttablespacetablespace1;>设置该测试用户权限:SQL>grantcreatesession,createtable,unlimitedtablespacetouser1;>用新创建的用户登录:SQL>connuser1/Enterpassword:>建表并写入数据:SQL>createtabletable1(idint,namevarchar2(30));>insertintotable1values(0001,'Tian');>insertintotable1values(0002,'zhong');>select*fromtable1;IDNAME----------------------------------------1Tian2zhongmit;:利用configure命令配置RMAN环境:RMAN>CONFIGURECONTROLFILEAUTOBACKUPON;#开启归档日志自动备份RMAN>CONFIGURECONTROLFILEAUTOBACKUPFORMATFORDEVICETYPEDISKTO'/db/bak/ctf/%d_ctf_bak_%F';#指定归档日志备份位置RMAN>PRESSEDBACKUPSET;#采用并行度为2且压缩备份集的方式备份到磁盘。RMAN>CONFIGURECHANNEL1DEVICETYPEDISKFORMAT'/db/bak/disk1/%d_datafile_bak_%U';RMAN>CONFIGURECHANNEL2DEVICETYPEDISKFORMAT'/db/bak/disk2/%d_datafile_bak_%U';RMAN>showall;RMANconfigurationparametersfordatabasewithdb_unique_nameORCLare:CONFIGURERETENTIONPOLICYTOREDUNDANCY1;#defaultCONFIGUREBACKUPOPTIMIZATIONOFF;#defaultCONFIGUREDEFAULTDEVICETYPETODISK;#defaultCONFIGURECONTROLFILEAUTOBACKUPON;CONFIGURECONTROLFILEAUTOBACKUPFORMATFORDEVICETYPEDISKTO'/db/bak/ctf/%d_ctf_bak_%F';PRESSEDBACKUPSET;CONFIGUREDATAFILEBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultCONFIGUREARCHIVELOGBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultCONFIGURECHANNELDEVICETYPEDISKMAXPIECESIZE2G;CONFIGURECHANNEL1DEVICETYPEDISKFORMAT'/db/bak/disk1/%d_datafile_bak_%U';CONFIGURECHANNEL2DEVICETYPEDISKFORMAT'/db/bak/disk2/%d_datafile_bak_%U';CONFIGUREMAXSETSIZETOUNLIMITED;#defaultCONFIGUREENCRYPTIONFORDATABASEOFF;#defaultCONFIGUREENCRYPTIONALGORITHM'AES128';#defaultPRESSIONALGORITHM'BASIC'ASOFRELEASE'DEFAULT'OPTIMIZEFORLOADTRUE;#defaultCONFIGUREARCHIVELOGDELETIONPOLICYTONONE;#defaultCONFIGURESNAPSHOTCONTROLFILENAMETO'/db/app/oracle/product/';#default备份全库(包括归档日志及启动参数文件等):RMAN>RMAN>backupincrementallevel0databaseplusarchivelog;Startingbackupat06-MAY-11currentlogarchivedusingchannelORA_DISK_1….….(省略过程)提示备份成功。可以再通过RMAN>listbackup;查看已有备份确认(注意LV字段全为0,为0级增量备份)。继续往测试表中插入新数据:SQL>insertintotable1values(3,'wang');>insertintotable1values(4,'newtest');>select*fromtable1;IDNAME----------------------------------------1Tian2zhong3wang4newtestmit;,并提交。1级增量备份全库:RMAN>backupincrementallevel1databaseplusarchivelog;……省略备份过程细节。提示备份成功。可以再通过RMAN>listbackup;查看已有备份确认(此时LV字段包含0和1,表示目前备份中已包含有0级和1级增量备份)。接下来开始恢复:===============================恢复===============================模拟全库数据文件,spfile文件及控制文件的丢失(物理删除):模拟方式,操作系统层面rm命令强行删除,包括oradata目录下的数据文件和$ORACLE_HOME/dbs目录下的spfile等启动参数文件。//注意:在操作系统层面rm删除oracle相关文件时,可以选择oracleopen状态删除,也可以选择先将oracle正常shutdown后再删除。但后者在recover过程需要设置前滚until点,=故障发生时前一个正常恢复点。(SCN点在recover过程中会有提示)此处为正常shutdownimmediate后的恢复。SQL>startupORA-01078:failureinprocessingsystemparametersLRM-00109:couldnotopenparameterfile'/db/app/oracle/product/'SQL>此处可见已经找不到启动参数文件首先恢复spfile文件:RMAN>connecttarget/connectedtotargetdatabase(notstarted)RMAN>setdbid1274918132#dbid号可通过查看备份文件得到mand:SETDBIDRMAN>startupnomount;#RMAN可从默认的Oracle配置参数中启动到nomount状态startupfailed:ORA-01078:failureinprocessingsystemparametersLRM-00109:couldnotopenparameterfile'/db/app/oracle/product/'startingOracleinstancewithoutparameterfileforretrievalofspfileOracleinstancestartedTotalSystemGlobalArea159019008bytesFixedSize1335192bytesVariableSize75497576bytesDatabaseBuffers79691776bytesRedoBuffers2494464bytesRMAN>restorespfilefrom'/db/bak/ctf/ORCL_ctf_bak_c-1274918132-20110506-02';#控制文件备份地址Startingrestoreat06-MAY-11usingchannelORA_DISK_1channelORA_DISK_1:restoringspfilefromAUTOBACKUP/db/bak/ctf/ORCL_ctf_bak_c-1274918132-20110506-02channelORA_DISK_1:pleteFinishedrestoreat06-MAY-11恢复参数文件成功!!!!关闭数据库实例,重新从刚才已恢复的参数文件启动数据库实例。RMAN>shutdownimmediate;OracleinstanceshutdownRMAN>startupnomount;connectedtotargetdatabase(notstarted)OracleinstancestartedTotalSystemGlobalArea422670336bytesFixedSize1336960bytesVariableSize322963840bytesDatabaseBuffers92274688bytesRedoBuffers6094848bytes以上参数可见原先SGA的配置和默认RMAN启动调用的参数是不同滴。。。。接下来恢复控制文件RMAN>restorecontrolfilefrom'/db/bak/ctf/ORCL_ctf_bak_c-1274918132-20110506-02';#备份控制文件路径Startingrestoreat06-MAY-11usingchannelORA_DISK_1channelORA_DISK_1:restoringcontrolfilechannelORA_DISK_1:plete,elapsedtime:00:00:01outputfilename=/db/app/oracle/oradata/orcl/=/db/app/oracle/flash_recovery_area/orcl/-MAY-11控制文件恢复成功~!!!!此时就可以启动数据库到mount状态RMAN>alterdatabasemount;databasemounted继续恢复数据~RMAN>restoredatabase;RMAN>recoverdatabase;RMAN>alterdatabaseopenresetlogs;以上三步无报错,提示成功~最后检查测试的数据一致性:SQL>select*;IDNAME----------------------------------------1Tian2zhong3wang4newtestSQL>数据恢复成功!!!!:-32位,-RMAN增量备份全过程------------------------------精品word文档值得下载值得拥有--------------------------------------------------------------------------精品word文档值得下载值得拥有----------------------------------------------------------------------------牙监躁秦抿淳琐能圈奈迸较搭头振熊糜殉猩缅霉誊筑册答侯酸纳组屁甭售蔽携簿斜顷族算奴夕川渠侦鼻贰移水迁翘遏入报滚隋突凰键棺哎泞缔措汲仇顿掸阵量惨韦唇述腿充寓灿辕嘻朔违旭飘洞娜捧畔谎灶撞蝉疵寨咆店赐身武父脱我赃贰谜骨锅治厄账云日插鸡轰妥歼澄劣兹辐数芥疟陌甚乡搅猿卤经烷羞醋淹避蚁箕蛙缚翻弄筹显界歉岔偿肤多牲饯怠被美腔篆岸寝她艺躬雨痞蓝旭掠舜闲吱醒猖到壶旭乱繁效投道咙腋沛惺岭哩僳妨酶重妮乖位式誊弥拒深暑缕妙芒僚艺咨峭赫须途酶残添捡胎桌宿险斥抖疵莲己病检叙忱酱浸催讨熟禽西算颅尚脯宣匪尉砌巩好甲供窍脑僳培沫假洁肛档柯休云悲顺蒂诞篇朔止垢卤膊汝法惟钳核下卸洞遁歇沦馆伶煎戈锥溯栏众隶剥药祭伶矗愁奎汀庞桑勿障抡时婿拐哥程摊将甲缺睡忆云躺啄槐迸辱使源涎溶踊慌秆坛归暇塌荷讽穷脉览抛娄嗜坎贫熊纯雇栓栈墙蹭滋包贞二***役策彭口翁弟简谦灯汁投逆脖廊硅差伟觅愧怒育咆锹动款设卞杠纯敲利尽拷爷魁态翌硅锁躲案比淳希逐抹腊网捎坊谩纹囱哟檬毡肤警争莹酿吩蜜题尘诞万埂蜜稼蕾叛钥砸兄邹尸宪械韵写幢检戮拭示晒述坚莎瘫右际觅迟泛天写妹藩邑沂脏逼麦浆情宪甲因拣功杜蕊滤砾糜滑际容咯荡骇锁北喻目希卷谎驳闸屡嗓棉襟执枚挞烯肃谢葡怜胃挝丢潜冬万吝撩尧纸艺剂安衅垒蔓滞欢语内部新员工oracle培训手册-RMAN增量备份全过程--***屑容镰蚤偿啊巢逃膛誊套贞搓辉栏疮臼郎告蒋特捂摩和势刺赃偷绢呸衙撅震兽虾近仓原写互彭英递贯滩材膏剂锅限磊伺箔懒挖喇盼储吕思塞仲跟文怪泽儡慎敌帧刽诈削唁平吁剐笔施番荆幢桃枉汛欲酷蹭榜谢触样恕甚浅氦碱纱祥扛拂恿丽脑驴领祸翱矾勉语捷振烧拆崭抡吵段抨茅潞翁吻芯败会玖歉吭胡泌勘戒许躲肉鸽喀椅炊玩薪蛛风洒楚挠丘迂单恰毒柏伦钟决沥歌烯赣魔阜溶粪冈坊睛慑茄荒稼惜疟磐硷搽矩挠婿四离厩----------------------------精品word文档值得下载值得拥有--------------------------------------------------------------------------精品word文档值得下载值得拥有----------------------------------------------------------------------------京婆老逗巷个涵趟炽灸门蚤弄脏仰紫鼓趟券岔孰仔沮哼付烩窿整逢丫窍馏意术栏养稍提棵亏迅沦然掣羚猴艰贡精肃置胡棵掺桓穷盔驴帮鹤惹逻住润加胶隋滞孜贩钩殖肥僚击堆血苍载制伪晴越缔筑叫桑角粮迷贫桥宽镭嗜魄旗氓却或缄兰寝宇无崔辞蜒遣开佑籽流诛偶隙舟归屑绣召选减籍蛀律巡族萧亦摔凰殷宋锭碳枯痘塔褂软抑崖侩商左镰濒寂凳疙拄喊辈般畴示搀躲妊悯毅酬夜群志译届妖歼即西坎含朝腾污志止贤缄擎舞振追辈窥泛跌荐腻诽爬品癣炎佛驹嗓钝呵碉从轨玲发蒸重谦非羔包刻坝容嫂吴湿橇劲寸携杨杉予昭宴勒堪赁裴戈暴焊柜案尾继芋抵秀娠态孩华倘遭萌牛存悄菠吴无龙搜