控制檔案包含哪些基本內容

tolywang發表於2008-06-30

控制檔案主要包含如下條目,可以透過dump控制檔案內容看到

alter session set events 'immediate trace name controlf level 10 ;


DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS

[@more@]

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

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-1006307/,如需轉載,請註明出處,否則將追究法律責任。

相關文章