Oracle ¿ØÖÆÎļþ

Ò». Oracle ¿ØÖÆÎļþÖ÷Òª°üº¬ÈçÏÂÌõÄ¿
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECORDS
BACKUP DATAFILE RECORDS
BACKUP LOG RECORDS
DATAFILE COPY RECORDS
BACKUP DATAFILE CORRUPTION RECORDS
DATAFILE COPY CORRUPTION RECORDS
DELETION RECORDS
PROXY COPY RECORDS
INCARNATION RECORDS
¶þ.¿ÉÒÔͨ¹ýdump¿´µ½ ¿ØÖÆÎļþÄÚ
·½·¨1.Ö±½Ódump controlfile£ºalter system set events 'immediate trace name controlf level 10'
·½·¨2.  alter database backup controlfile to trace
     ²é¿´UDMPĿ¼ÏµÄ<SID>_ora_<PID>.trcÎļþ
·½·¨3.alter database backup controlfile to ÎļþÃû
    ²éѯ¸ÃÎļþ
SQL>select name from v$controlfile     
SQL>show parameter user_dump_dest
ÔÚÖ¸¶¨µÄĿ¼Ï»áÕÒµ½¸Õ²úÉúµÄtrcÎļþ£¬Í¨¹ýÈÕÆÚ¿ÉÒÔ¿´³öÄǸöÊǸղúÉúµÄ¡£
Èý. ¿ØÖÆÎļþµÄÖؽ¨£ºCREATE CONTROLFILE SET/reuse DATABASE SID RESETLOGS/NOresetlogs NOARCHIVELOG/archivelong
ORA-00205: error in identifying control file, check alert log for more info
µ±Èý¸ö¿ØÖÆÎļþ¶¼ÒÑË𻵣¬ÓÖûÓпØÖÆÎļþµÄ±¸·Ý£¬ÎÒÃÇÖ»ÄܲÉÈ¡Öؽ¨¿ØÖÆÎļþµÄ×ö·¨¡£
SQL> startup nomount
ORACLE instance started.
Total System Global Area  268435456 bytes
Fixed Size                  1266968 bytes
Variable Size              88083176 bytes
Database Buffers          176160768 bytes
Redo Buffers                2924544 bytes
SQL> create controlfile reuse database woody noresetlogs archivelog
  2  LOGFILE
  3  GROUP 1 '/u01/app/oracle/oradata/woody/redo01.lo