重建控制文件.docx

范例一Oracle提供两种方式备份控制文件:1.生成可以重建控制文件的脚本2.备份二进制的控制文件如何获得可以重建控制文件的脚本.在mount状态下获得trc文件[sql]?view plaincopysql?alter?database?backup?controlfile?to?trace?as?/home/oracle/crontol_trace.trc;???[sql]?view plaincopy[oracle@hbgf?oracle]$??more?/home/oracle/crontol_trace.trc??--?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=uniguard??--??--?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_10=LOCATION=USE_DB_RECOVERY_FILE_DEST??--?LOG_ARCHIVE_DEST_10=OPTIONAL?REOPEN=300?NODELAY??--?LOG_ARCHIVE_DEST_10=ARCH?NOAFFIRM?NOEXPEDITE?NOVERIFY?SYNC??--?LOG_ARCHIVE_DEST_10=REGISTER?NOALTERNATE?NODEPENDENCY??--?LOG_ARCHIVE_DEST_10=NOMAX_FAILURE?NOQUOTA_SIZE?NOQUOTA_USED?NODB_UNIQUE_NAME??--?LOG_ARCHIVE_DEST_10=VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)??--?LOG_ARCHIVE_DEST_STATE_10=ENABLEp--??--?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?ve