




已阅读5页,还剩3页未读, 继续免费阅读
版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
一般情况下数据库的DBA都会对controlfile 进行多路复用,这样可以保证控制文件的安全性,对于数据库而言只要数据文件和redolog、archivelog不丢,数据都是可以恢复的,只是controlfile丢失,会比较麻烦。环境:control01.ctl、control02.ctl、control03.ctl1、3个controlfile中的一个或者两个丢失,关闭数据库后,从没有没丢失的那个controlfile进行拷贝。2、3个控制文件全丢失,可以进行重构控制文件,一般情况下我们会对控制文件进行二进制文件备份 (alter database backup controlfile to trace as * 备份成二进制文件 )(alter database backup controlfile to * 是直接备份控制文件 )以下是备份出来的二进制文件的内容:有两种情况, 1、完全恢复的时候用(红色) 2、不完全恢复的时候用(紫红)- The following are current System-scope REDO Log Archival related- parameters and can be included in the database initialization file.- LOG_ARCHIVE_DEST=- LOG_ARCHIVE_DUPLEX_DEST=- LOG_ARCHIVE_FORMAT=%t_%s_%r.dbf- DB_UNIQUE_NAME=orcl- LOG_ARCHIVE_CONFIG=SEND, RECEIVE, NODG_CONFIG- LOG_ARCHIVE_MAX_PROCESSES=2- STANDBY_FILE_MANAGEMENT=MANUAL- STANDBY_ARCHIVE_DEST=?/dbs/arch- FAL_CLIENT=- FAL_SERVER=- LOG_ARCHIVE_DEST_1=LOCATION=/u01/app/oracle/oradata/orcl/arch- LOG_ARCHIVE_DEST_1=OPTIONAL REOPEN=300 NODELAY- LOG_ARCHIVE_DEST_1=ARCH NOAFFIRM NOEXPEDITE NOVERIFY SYNC- LOG_ARCHIVE_DEST_1=REGISTER NOALTERNATE NODEPENDENCY- LOG_ARCHIVE_DEST_1=NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED NODB_UNIQUE_NAME- LOG_ARCHIVE_DEST_1=VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)- LOG_ARCHIVE_DEST_STATE_1=ENABLE- Below are two sets of SQL statements, each of which creates a new- control file and uses it to open the database. The first set opens- the database with the NORESETLOGS option and should be used only if- the current versions of all online logs are available. The second- set opens the database with the RESETLOGS option and should be used- if online logs are unavailable.- The appropriate set of statements can be copied from the trace into- a script file, edited as necessary, and executed when there is a- need to re-create the control file.- Set #1. NORESETLOGS case- The following commands will create a new control file and use it- to open the database.- Data used by Recovery Manager will be lost.- Additional logs may be required for media recovery of offline- Use this only if the current versions of all online logs are- available.- After mounting the created controlfile, the following SQL- statement will place the database in the appropriate- protection mode:- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCESTARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE ORCL NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 /u01/app/oracle/oradata/orcl/redo01.log SIZE 50M, GROUP 2 /u01/app/oracle/oradata/orcl/redo02.log SIZE 50M, GROUP 3 /u01/app/oracle/oradata/orcl/redo03.log SIZE 50M- STANDBY LOGFILEDATAFILE /u01/app/oracle/oradata/orcl/system01.dbf, /u01/app/oracle/oradata/orcl/undotbs01.dbf, /u01/app/oracle/oradata/orcl/sysaux01.dbf, /u01/app/oracle/oradata/orcl/users01.dbf, /u01/app/oracle/oradata/orcl/example01.dbf, /u01/app/oracle/oradata/orcl/app1_01.dbf, /u01/app/oracle/oradata/orcl/app02_01.dbfCHARACTER SET AL32UTF8- Commands to re-create incarnation table- Below log names MUST be changed to existing filenames on- disk. Any one log file from each branch can be used to- re-create incarnation records.- ALTER DATABASE REGISTER LOGFILE /u01/app/oracle/oradata/orcl/arch/1_1_562360180.dbf;- ALTER DATABASE REGISTER LOGFILE /u01/app/oracle/oradata/orcl/arch/1_1_772185780.dbf;- Recovery is required if any of the datafiles are restored backups,- or if the last shutdown was not normal or immediate.RECOVER DATABASE- All logs need archiving and a log switch is needed.ALTER SYSTEM ARCHIVE LOG ALL;- Database can now be opened normally.ALTER DATABASE OPEN;- Commands to add tempfiles to temporary tablespaces.- Online tempfiles have complete space information.- Other tempfiles may require adjustment.ALTER TABLESPACE TEMP ADD TEMPFILE /u01/app/oracle/oradata/orcl/temp01.dbf SIZE 20971520 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;- End of tempfile additions.- Set #2. RESETLOGS case- The following commands will create a new control file and use it- to open the database.- Data used by Recovery Manager will be lost.- The contents of online logs will be lost and all backups will- be invalidated. Use this only if online logs are damaged.- After mounting the created controlfile, the following SQL- statement will place the database in the appropriate- protection mode:- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCESTARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE ORCL RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 /u01/app/oracle/oradata/orcl/redo01.log SIZE 50M, GROUP 2 /u01/app/oracle/oradata/orcl/redo02.log SIZE 50M, GROUP 3 /u01/app/oracle/oradata/orcl/redo03.log SIZE 50M- STANDBY LOGFILEDATAFILE /u01/app/oracle/oradata/orcl/system01.dbf, /u01/app/oracle/oradata/orcl/undotbs01.dbf, /u01/app/oracle/oradata/orcl/sysaux01.dbf, /u01/app/oracle/oradata/orcl/users01.dbf, /u01/app/oracle/oradata/orcl/example01.dbf, /u01/app/oracle/oradata/orcl/app1_01.dbf, /u01/app/oracle/oradata/orcl/app02_01.dbfCHARACTER SET AL32UTF8- Commands to re-create incarnation table- Below log names MUST be changed to existing filenames on- disk. Any one log file from each branch can be used to- re-create incarnation records.- ALTER DATABASE REGISTER LOGFILE /u01/app/oracle/oradata/orcl/arch/1_1_562360180.dbf;- ALTER DATABASE REGISTER LOGFILE /u01/app/oracle/oradata/orcl/arch/1_1_772185780.dbf;- Recovery is required if any of the datafiles are restored backups,- or if the last shutdown was not normal or immediate.RECOVER DATABASE USING BACKUP CONTROLFILE- Database can now be opened zeroing the online logs.ALTER DATABASE OPEN RESETLOGS;- Commands to add tempfiles to temporary tablespaces.- Online tempfiles have complete space information.- Other tempfiles may require adjustment.ALTER TABLESPACE TEMP ADD TEMPFILE /u01/app/oracle/oradata/orcl/temp01.dbf SIZE 20971520 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;- End of tempfile additions.执行以上脚本对controlfile进行重构时 ,是在数据库未启动的时候进行。3、下面说一种复杂一点的情况 ,备份了控制文件后修改了数据库结构(例如增加了一个表空间等等)后控制文件全部丢失。controlfile备份前六个表空间备份controlfile(alter database controlfile to /home/oracle/ubackup/w.bin)备份后数据库结构发生变化。多了一个表空间数据库关闭了。 这时候发生controlfile全部丢失进行恢复。CP /home/oracle/ubackup/w.bin /u01/app/oracle/oradata/orcl/control01.ctlCP /home/oracle/ubackup/w.bin /u01/app/oracle/oradata/orcl/control02.ctlCP /home/oracle/ubackup/w.bin /u01/app/oracle/oradata/orcl/control03.ctl如果 这个时候startup 是不行的, 因为恢复的contr
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2025金华市天禾实业有限公司招聘2人模拟试卷及答案详解(夺冠系列)
- 2025年中国光大银行社会招聘模拟试卷附答案详解(模拟题)
- 2025北京市高校毕业生到农村从事支农工作招聘473人考前自测高频考点模拟试题附答案详解(考试直接用)
- 2025甘肃武威市古浪县八步沙林场招聘财会、水利专业人员3人模拟试卷含答案详解
- 2025河北唐山市滦州市森林草原消防专业队员招聘7人模拟试卷及答案详解(各地真题)
- 2025年河南红旗渠(集团)有限责任公司招聘7人模拟试卷及1套完整答案详解
- 2025南平邵武市中医院招聘6人考前自测高频考点模拟试题及答案详解(全优)
- 2025江苏南通市海安经济技术开发区立发办事处招聘公益性岗位人员1人模拟试卷及1套参考答案详解
- 2025年4月广东广州市天河区珠江新城猎德幼儿园编外教辅人员招聘2人模拟试卷及一套完整答案详解
- 2025年中国纯三乙醇胺行业市场分析及投资价值评估前景预测报告
- 2025版简易劳务合同模板
- 2025年浙江省单独考试招生语文试卷试题真题(含答案详解)
- 消防水池挖槽施工方案
- 高一地理第一次月考卷02【测试范围:必修一第1~2章】(考试版)
- 水电站设备维护检修课件
- 2025年沼液还田协议书
- 2025年浙商银行招聘考试(综合知识)历年参考题库含答案详解(5卷)
- APQP第三版及CP第一版介绍
- 治安管理处罚法普法讲座
- 六堡茶知识讲座
- 中南财经政法大学哲学院《615社会学原理》历年考研真题汇编(含部分答案)
评论
0/150
提交评论