控制文件丢失的恢复.doc

一般情况下数据库的DBA都会对controlfile 进行多路复用，这样可以保证控制文件的安全性，对于数据库而言只要数据文件和redolog、archivelog不丢，数据都是可以恢复的，只是controlfile丢失，会比较麻烦。 环境：control01.ctl、control02.ctl、control03.ctl 1、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