控制文件丢失解决方法

控制文件丢失解决方式：1 alter database backup controlfile to trace;2 在trace文件中粘贴出这一段vi /home/oracle/control.sqlCREATE CONTROLFILE REUSE DATABASE "ORA11GR2" NORESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 '/u01/app/oracle/oradata/ORA11GR2/redo01.log' SIZE 50M BLOCKSIZE 512,GROUP 2 '/u01/app/oracle/oradata/ORA11GR2/redo02.log' SIZE 50M BLOCKSIZE 512,GROUP 3 '/u01/app/oracle/oradata/ORA11GR2/redo03.log' SIZE 50M BLOCKSIZE 512-- STANDBY LOGFILEDATAFILE '/u01/app/oracle/oradata/ORA11GR2/system01.dbf','/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf','/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf','/u01/app/oracle/oradata/ORA11GR2/users01.dbf','/u01/app/oracle/oradata/ORA11GR2/example01.dbf'CHARACTER SET WE8MSWIN1252;3 shutdown immediate4 [oracle@wdd58 ORA11GR2]$ mv control01.ctl control01.ctl.bak[oracle@wdd58 ORA11GR2]$ mv control02.ctl control02.ctl.bak5 startup nomount@/home/oracle/control.sqlSQL> select status from v$instance; STATUS------------MOUNTED6 alter database open;7 select name from v$tempfile;发现没有临时表空间对应的文件8 alter tablespace temp add tempfile '/u01/app/oracle/oradata/ORA11GR2/temp01.dbf' reuse;9 select name from v$tempfile;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!