===========================================================
控制文件包含哪些基本内容
===========================================================
作者: tolywang(http://tolywang.itpub.net)
发表于:2008.06.30 11:40
分类: Oracle数据库管理
出处：http://tolywang.itpub.net/post/48/465268
---------------------------------------------------------------
发表于:2008.06.30 11:40
分类: Oracle数据库管理
出处：http://tolywang.itpub.net/post/48/465268
---------------------------------------------------------------
控制文件主要包含如下条目，可以通过dump控制文件内容看到
alter session set events 'immediate trace name controlf level 10 ;
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