控制文件与数据文件头信息怎样设置？
首先备份控制文件，打开数据库，增进检查点: [oracle@jumper eygle]$ cp control01。ctl control01。ctl。bak[oracle@jumper eygle]$ sqlplus "/ as sysdba"SQL*Plus: Release 9。 2。0。4。0 - Production on Fri Aug 11 10:46:05 2006Copyright (c) 1982, 2002, Oracle Corporation。
All rights reserved。 Connected to an idle instance。SQL> st...全部
首先备份控制文件，打开数据库，增进检查点: [oracle@jumper eygle]$ cp control01。ctl control01。ctl。bak[oracle@jumper eygle]$ sqlplus "/ as sysdba"SQL*Plus: Release 9。
2。0。4。0 - Production on Fri Aug 11 10:46:05 2006Copyright (c) 1982, 2002, Oracle Corporation。
All rights reserved。
Connected to an idle instance。SQL> startupORACLE instance started。Total System Global Area
139531744 bytesFixed Size
452064 bytesVariable Size
121634816 bytesDatabase Buffers
16777216 bytesRedo Buffers
667648 bytesDatabase mounted。
Database opened。SQL> alter system checkpoint;System altered。SQL> shutdown immediate;Database closed。
Database dismounted。ORACLE instance shut down。SQL> exitDisconnected from Oracle9i Enterprise Edition Release 9。
2。0。4。0 - ProductionWith the Partitioning optionJServer Release 9。2。0。4。0 - Production
然后恢复旧的控制文件，mount数据库，转储数据文件头:[oracle@jumper eygle]$ mv control01。
ctl control01。ctl。n[oracle@jumper eygle]$ mv control01。ctl。bak control01。ctl [oracle@jumper eygle]$ sqlplus "/ as sysdba"SQL*Plus: Release 9。
2。0。4。0 - Production on Fri Aug 11 10:46:50 2006Copyright (c) 1982, 2002, Oracle Corporation。
All rights reserved。
Connected to an idle instance。SQL> startup mount;ORACLE instance started。Total System Global Area
139531744 bytesFixed Size
452064 bytesVariable Size
121634816 bytesDatabase Buffers
16777216 bytesRedo Buffers
667648 bytesDatabase mounted。
SQL> alter session set events 'immediate trace name file_hdrs level 10';Session altered。SQL> !。收起
