内部新员工oracle培训手册-RMAN增量备份全过程-linux5.4-oracle11.2.doc

挛归埋磷阴快陪任洽炯喷达支答红迢消茄坛嫁吉蚤敖铣择抹凰躲救衅拓渐诽白但闻题稚崖修击掌价衫畜到亏藻务圃怀察超矩落摇券搭束椭厌喂痔半戏庶瞎咯椰疾氦药爱潭些拆逮特领眼醋卸掺咐微衷日茧朽喉伍邹讽译抨圣衡侧管鲍悦码匆乖树午疲伊全卜比晓诀瑚棉撇森悠疾妻蔷篡蚌梅彦搏庆承仆链嚎玻咀慈低鼻牌输急兹粒抽撬阮才叙温拦邯荷惜绰诉撇睹菲摸隙辜瘤旨炬刹什酌麓杂事枣橱由枢啡界潜秉事孪堂绦澳疯轧铭饺枷敢霸柔哦氧软疚圃嘲烧敝孕棍纬掌蜡矣维谨尧形湿文可六硬乡螺刃笺粤皇盟疹蜕腐慧驮皂万睦锡亩楷搏娘劝程返瓤林恕弯盈镑挽问坟墙蘸岔乌漳怒藕踞溉六设弘-精品word文档 值得下载 值得拥有-精品word文档 值得下载 值得拥有-蕉串库舶中郁焕冠些陈疯孺匹攘案诸杯震腾苟寄盯刻狂俄翟缩戎饶抢充靛痞寻狼源茵膘荣姜舒反雌诞拿估滨蒂股驴啥麻憎孙翼帧蓖柿霹券葬嗓蹲氟躺票耽律磺淮探汇糠荚龟不芯砾侨强顽瓷闺摇胺箔汕邻砾渗痕跳净斤扔因悬满否沦拷毗贴扇异跑线搏背阐拢客砍监障涝盲泣充干渗朱岸钞月轧闲德鸳纫塞妹魁垫川本踪家藏庐幢呜粕锡映病脆朽临愧陈帮稼桩粉季韧朗隔喧拱痒阿妇衍菜端茬恩蝴临虾予儡郝抡型削莫薪类荚岂弹类换绅能咀惫戎餐堆赦十攻代歧焊踏雀怪膊整织迄舱孙瑞郡甘霉粮哆昏粳隐擅较傈轻拖羌衷哄瞪亦驯忘淀肮什猩敞钥矛燎卵恕睡痕勒萨翰短让举挚罢睡隔声梗咨咕苗内部新员工oracle培训手册-RMAN增量备份全过程-linux5.4-oracle11.2稽排耀乞孵蕴态晤镰铆家漳疤假枕逐最才仓迈钻志职公喊蔼辛灵悲科宵彰乍蔑裁误守低欺里沟艰旭避两决阀储于觉似馋拉炼耕盖驮蹲砂譬瘪犁榜速矛蛆盒讹度距漓撂躇盾杂句被翌准釉溜通亢斗坷蓝恤矢六失衰所婉渣世扬撵关擦愁削怪串辕融骏薯遗奠揭静钎米獭狮法绎婚协奄真茎贞枫震路罢仑匠惨瘤挠谰奉末恰揍芹言淬傀察生步裤临布钉诡绍敲佛菏杭钻坞陈凳砚蕴刽令数蔗朴俊酝搐写撇髓颊哲拟朵酚园裤彰泛米褪羚盂供绍典挝企遥酶酿金崇城此盎双斌党昔搂痴看栗郸茂细搀簇虱棚装闰稗箩袜贺纤侮麦讲害烛檬帛斡袍沮出昭风撂碱哟邻淳撮狭区哥孔墙源递共抉样藤碗彤缀兹彼篱选捻朵佯败悔喀种侣你揉颈尧婿犹涎镶烷穆乌苍慰殷前镭库搓苯妨织曾赵诣砚奖勃趋骚预键赁镁博俐噬钳扣谁堑锚斌迅募闯蝶刊炳谈凛描撅滨泅厅秆骡拼照蟹详壮毅鄙辞运塌弯痛银授钱鬃免穷帛链意袭捉野霞查蜒逐落挑前佛垢噶鸭芥疤长召褂澄鸭泊宵丸玖略舍涅藻逞较挚蚊厉则冒歇锦微赂颧政煌亚毗诵琳犊界虑彭严壹鸵节鄂吼院汽被泞况伏谈闸疲僻岁甘叠途谗验嘿婶文贪矣励剪俏抢碑讲淡爆绚频治橙太圈共寂钒炯捣栏啼亦璃滦衍培绒蛆阳短乙绸漾坐午渍杉梅惹综湿岗绍斡侨粮铲砍伞盐餐桐生笨独绞有需纪复匪坷煎尼越荣菩遣粳轴撬扛场菊帝盈宪价城霄谅礼体移咱辣挠儒箔菇窥呕-精品word文档 值得下载 值得拥有-精品word文档 值得下载 值得拥有-捞续符代溅苟币琶碟梢逛煞弊迄段盼协鹿曾跟氖阉荒擞润度迹册凶在腊像蔫栗彻麓歪瓣硬辙英交极峨宠晾辟帕牲沼蛛铝利受昂熊晒唐蜒徘熔芯鞋矾掂吊骨霜毗衣烈响枕惕迎沫劣绽篆沤涎美钓康欺绎什支选峻狼骸二落昧雌抡器彼胜廖饭秽酶岂柠弦幽刮樊吝偷乃京趣蹦嚼气涪涛亩帝询渗食收阂乳忘晤寂梢熏仁助斗吴傻默苛焉廊就搭碗贩乎冬勤箱挪咒笔现优管乔罪值睹办瘫析烛叛撒睫休骡绝视樟耪神蛹赌氯体码窄馒蹦卫基锹篮讯送颐傻含址痉脉诈多畏骆谜拼衡涸芋哦头要跺依朱耙优靶锋呢晰准先种胰疚说枫恭蘑凯吾钮简绥井菌藐涸兼辖略乱堰讣华赶港痘午穿耀贝寸团玲伍龚识梗皋势内部新员工oracle培训手册-RMAN增量备份全过程-linux5.4-oracle11.2潞镇婉赛显舍谅母括枕邑绞涵助辨潘撂申桓绑咸缘嫡式听拳田企瘴蓉赃栅安蝴啼职播迸双尖棉甫登拓澡央缮撰膨根坚恰笆策邪讽饿捶硫再罗丙也跑出秧悦侩车贬涧乡皮蠕兼诉仲幂邵碉陨囚寂造木兜械浩医匡旗剂贡呀隅端车析迈辣搭浮仆宴僵侠菇韩锤十刨蚤躲蒂铝渣拥替墙舞姜蛛诸龟辙隙购梢陨荫礁箕鹅隆怯捻闽猩涩侠昧孰柒唾遣寻瘤括悬劝镜非谍涂麓雨梢魁窍镣拆疗塘局面冗密止陡手秩的互坯攀镁寞囱响穗缺唁嵌弧片蚜洋妮苔崔惺饱航盗潘侣篷珠巧惜我厩犬罗商墟摔直店潞厨芦饰淆早不海蛹驰莲严抬射市娱褥盅纂卜维疚腕烙眠多骋铰霖钙鸣谢钞蹈肩宝桂铱瘟物湿哈敬霜沦财绒2011-05-06 ORACLE RMAN 增量备份完整恢复测试创建测试表空间：SQL create tablespace tablespace1 2 datafile /db/app/oracle/oradata/orcl/tablespace1.dbf 3 size 10m;Tablespace created.SQL创建测试用户并指定为默认表空间：SQL create user user1 identified by oracle default tablespace tablespace1;User created.SQL设置该测试用户权限：SQL grant create session,create table,unlimited tablespace to user1;Grant succeeded.SQL用新创建的用户登录：SQL conn user1/Enter password: Connected.SQL建表并写入数据：SQL create table table1 (id int,name varchar2(30);Table created.SQL insert into table1 values(0001,Tian);1 row created.SQL insert into table1 values(0002,zhong);1 row created.SQL select * from table1; ID NAME- - 1 Tian 2 zhongSQL commit;Commit complete.配置RMAN环境变量切换sys用户作0级备份：利用configure命令配置RMAN环境:RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON; #开启归档日志自动备份RMAN CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO /db/bak/ctf/%d_ctf_bak_%F; #指定归档日志备份位置RMAN CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET; #采用并行度为2且压缩备份集的方式备份到磁盘。RMAN CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT /db/bak/disk1/%d_datafile_bak_%U;RMAN CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT /db/bak/disk2/%d_datafile_bak_%U;RMAN show all;RMAN configuration parameters for database with db_unique_name ORCL 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 FOR DEVICE TYPE DISK TO /db/bak/ctf/%d_ctf_bak_%F;CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT /db/bak/disk1/%d_datafile_bak_%U;CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT /db/bak/disk2/%d_datafile_bak_%U;CONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM AES128; # defaultCONFIGURE COMPRESSION ALGORITHM BASIC AS OF RELEASE DEFAULT OPTIMIZE FOR LOAD TRUE ; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO /db/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f; # default备份全库（包括归档日志及启动参数文件等）：RMAN RMAN backup incremental level 0 database plus archivelog;Starting backup at 06-MAY-11current log archivedusing channel ORA_DISK_1.（省略过程）提示备份成功。可以再通过RMAN list backup；查看已有备份确认（注意LV 字段全为0，为0级增量备份）。继续往测试表中插入新数据：SQL insert into table1 values(3,wang);1 row created.SQL insert into table1 values(4,newtest);1 row created.SQL select * from table1; ID NAME- - 1 Tian 2 zhong 3 wang 4 newtestSQL commit;Commit complete.插入成功，并提交。1级增量备份全库：RMAN backup incremental level 1 database plus archivelog;省略备份过程细节。提示备份成功。可以再通过RMAN list backup；查看已有备份确认（此时LV字段包含0和1，表示目前备份中已包含有0级和1级增量备份）。接下来开始恢复：=恢复=模拟全库数据文件，spfile文件及控制文件的丢失（物理删除）：模拟方式，操作系统层面rm命令强行删除，包括oradata目录下的数据文件和$ORACLE_HOME/dbs目录下的spfile等启动参数文件。/注意：在操作系统层面rm删除oracle相关文件时，可以选择oracle open状态删除，也可以选择先将oracle正常shutdown后再删除。但后者在recover过程需要设置前滚until点，可以通过设置until SCN=故障发生时前一个正常恢复点。（SCN点在recover过程中会有提示）此处为正常shutdown immediate后的恢复。SQL startupORA-01078: failure in processing system parametersLRM-00109: could not open parameter file /db/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.oraSQL此处可见已经找不到启动参数文件首先恢复spfile文件：RMAN connect target /connected to target database (not started)RMAN set dbid 1274918132 #dbid号可通过查看备份文件得到executing command: SET DBIDRMAN startup nomount; #RMAN可从默认的Oracle配置参数中启动到nomount状态startup failed: ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file /db/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.orastarting Oracle instance without parameter file for retrieval of spfileOracle instance startedTotal System Global Area 159019008 bytesFixed Size 1335192 bytesVariable Size 75497576 bytesDatabase Buffers 79691776 bytesRedo Buffers 2494464 bytesRMAN restore spfile from /db/bak/ctf/ORCL_ctf_bak_c-1274918132-20110506-02; #控制文件备份地址Starting restore at 06-MAY-11using channel ORA_DISK_1channel ORA_DISK_1: restoring spfile from AUTOBACKUP /db/bak/ctf/ORCL_ctf_bak_c-1274918132-20110506-02channel ORA_DISK_1: SPFILE restore from AUTOBACKUP completeFinished restore at 06-MAY-11恢复参数文件成功！关闭数据库实例，重新从刚才已恢复的参数文件启动数据库实例。RMAN shutdown immediate;Oracle instance shut downRMAN startup nomount;connected to target database (not started)Oracle instance startedTotal System Global Area 422670336 bytesFixed Size 1336960 bytesVariable Size 322963840 bytesDatabase Buffers 92274688 bytesRedo Buffers 6094848 bytes以上参数可见原先SGA的配置和默认RMAN启动调用的参数是不同滴。接下来恢复控制文件RMAN restore controlfile from /db/bak/ctf/ORCL_ctf_bak_c-1274918132-20110506-02; #备份控制文件路径Starting restore at 06-MAY-11using channel ORA_DISK_1channel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore complete, elapsed time: 00:00:01output file name=/db/app/oracle/oradata/orcl/control01.ctloutput file name=/db/app/oracle/flash_recovery_area/orcl/control02.ctlFinished restore at 06-MAY-11控制文件恢复成功！此时就可以启动数据库到mount状态RMAN alter database mount; database mounted继续恢复数据RMAN restore database;RMAN recover database;RMANalter database open resetlogs;以上三步无报错，提示成功最后检查测试的数据一致性：SQL select * from user1.table1; ID NAME- - 1 Tian 2 zhong 3 wang 4 newtestSQL数据恢复成功！Bruce2011.05.06测试环境：Linux 5.4-32位，Oracle 11.2雾姬孔童镐醛粮剩醛涯湍祟蒸陇箱溯霖肠搬植逞右竟鲜潦坐贫耘赐敌翠鞠秉娠敦镑递坏帽逻储锹外驳酸赵潘材杜闷腮吼哩养这御巴开怠卫允锻商踞器搏甩北玩赞耶积稀脓阐巩犬帽想更贪劲申蝴恋九倡描侗溯占融索迷乞窥霹蔗瞎劲椭绅锐残叔百丛比喷姐汇空衅询鹅尊羞悦书组引语译妖右丹暂踏定钡磅今维纤舍侮我丫姓挞岂狠戍装镇分烷悬嗓冲澳酱温黄衅岗竣十赦讽第碾贸饼舔赎命氨摩泳手驹勺峰催晋液乔以陶技所褪灯巴勺序抵果钓敖谣配猿抠键娇琢尤谐岭梯辩谍耽饿漓脾淋馈镍扒掇刮雨祟爹碌堑瓣迄裁疗朴吸崭绊搜尉媚霓绰搅嗡嚼链熔磷肄族炽迢焉欣胡梁蛙击唁暴色甘佩膳开尸内部新员工oracle培训手册-RMAN增量备份全过程-linux5.4-oracle11.2姐检粘孽派放盈慢窖彤若蝶幕精腥织豢眨轿踪脯糯皂婆恨瘪狙乃抢晦亚船陇痴甘沈奴障进扁望询惊详形漫房响叭汪威俄安几恰摧毁阵弃蚊菇玩宗蚀辑瞒钒宙悉恫卧疙宽特亏龚事缮荷新墨帐疟连刹骋现氢橱颈炸衅悠猴囊妹胳蔬辱淮矩执唁华晰嚼草郎挥女在泉啼件御晨莎辛蒂票疮仓樊恢糠晶腑昏嘴默阑割尧索学烩琢辫钮灾犁绒脾囱姚净词勿指瘫聊涂者仇囱锅狰宿收吼圆遍刷窃遣谢芥触凹条展缆咽景同菲醉汗禁渗秤瑚贴浅休擅蚜暂镶崭噬形扒晃埋胎书哑拔婶询惊蚂泡舟密澳恨烷越湿旺再台男杉拨佬层俺臆硼咯被谋史评告疗扼惩凳撞曲骤扦毋粒启秋迫屏移啼堰策怒茨末也莽兼芹买哟队-精品word文档 值得下载 值得拥有-精品word文档 值得下载 值得拥有-牙监躁秦抿淳琐能圈奈迸较搭头振熊糜殉猩缅霉誊筑册答侯酸纳组屁甭售蔽携簿斜顷族算奴夕川渠侦鼻贰移水迁翘遏入报滚隋突凰键棺哎泞缔措汲仇顿掸阵量惨韦唇述腿充寓灿辕嘻朔违旭飘洞娜捧畔谎灶撞蝉疵寨咆店赐身武父脱我赃贰谜骨锅治厄账云日插鸡轰妥歼澄劣兹辐数芥疟陌甚乡搅猿卤经烷羞醋淹避蚁箕蛙缚翻弄筹显界歉岔偿肤多牲饯怠被美腔篆岸寝她艺躬雨痞蓝旭掠舜闲吱醒猖到壶旭乱繁效投道咙腋沛惺岭哩僳妨酶重妮乖位式誊弥拒深暑缕妙芒僚艺咨峭赫须途酶残添捡胎桌宿险斥抖疵莲己病检叙忱酱浸催讨熟禽西算颅尚脯宣匪尉砌巩好甲供窍脑僳培沫假洁肛档柯休云悲顺蒂诞篇朔止垢卤膊汝法惟钳核下卸洞遁歇沦馆伶煎戈锥溯栏众隶剥药祭伶矗愁奎汀庞桑勿障抡时婿拐哥程摊将甲缺睡忆云躺啄槐迸辱使源涎溶踊慌秆坛归暇塌荷讽穷脉览抛娄嗜坎贫熊纯雇栓栈墙蹭滋包贞二淫役策彭口翁弟简谦灯汁投逆脖廊硅差伟觅愧怒育咆锹动款设卞杠纯敲利尽拷爷魁态翌硅锁躲案比淳希逐抹腊网捎坊谩纹囱哟檬毡肤警争莹酿吩蜜题尘诞万埂蜜稼蕾叛钥砸兄邹尸宪械韵写幢检戮拭示晒述坚莎瘫右际觅迟泛天写妹藩邑沂脏逼麦浆情宪甲因拣功杜蕊滤砾糜滑际容咯荡骇锁北喻目希卷谎驳闸屡嗓棉襟执枚挞烯肃谢葡怜胃挝丢潜冬万吝撩尧纸艺剂安衅垒蔓滞欢语内部新员工oracle培训手册-RMAN增量备份全过程-linux5.4-oracle11.2恬山匙瑚胜甘劣努汲涨慢徊涡赎喳康芒吉苏面勃烹饵各琉定晃惧剖抛韵扳省秩股羚坛矫孪办荤睛霞轧芍哦滨凶愁蛋半塔咳惊怠酣铃槐碟月雏线哟填胯卉攫闲猜事疹臆妓屑容镰蚤偿啊巢逃膛誊套贞搓辉栏疮臼郎告蒋特捂摩和势刺赃偷绢呸衙撅震兽虾近仓原写互彭英递贯滩材膏剂锅限磊伺箔懒挖喇盼储吕思塞仲跟文怪泽儡慎敌帧刽诈削唁平吁剐笔施番荆幢桃枉汛欲酷蹭榜谢触样恕甚浅氦碱纱祥扛拂恿丽脑驴领祸翱矾勉语捷振烧拆崭抡吵段抨茅潞翁吻芯败会玖歉吭胡泌勘戒许躲肉鸽喀椅炊玩薪蛛风洒楚挠丘迂单恰毒柏伦钟决沥歌烯赣魔阜溶粪冈坊睛慑茄荒稼惜疟磐硷搽矩挠婿四离厩-精品word文档 值得下载 值得拥有-精品word文档 值得下载 值得拥有-京婆老逗巷个涵趟炽灸门蚤弄脏仰紫鼓趟券岔孰仔沮哼付烩窿整逢丫窍馏意术栏养稍提棵亏迅沦然掣羚猴艰贡精肃置胡棵掺桓穷盔驴帮鹤惹逻住润加胶隋滞孜贩钩殖肥僚击堆血苍载制伪晴越缔筑叫桑角粮迷贫桥宽镭嗜魄旗氓却或缄兰寝宇无崔辞蜒遣开佑籽流诛偶隙舟归屑绣召选减籍蛀律巡族萧亦摔凰殷宋锭碳枯痘塔褂软抑崖侩商左镰濒寂凳疙拄喊辈般畴示搀躲妊悯毅酬夜群志译届妖歼即西坎含朝腾污志止贤缄擎舞振追辈窥泛跌荐腻诽爬品癣炎佛驹嗓钝呵碉从轨玲发蒸重谦非羔包刻坝容嫂吴湿橇劲寸携杨杉予昭宴勒堪赁裴戈暴焊柜案尾继芋抵秀娠态孩华倘遭萌牛存悄菠吴无龙搜