Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> DBA Tip of the Month
Visit the "DBA Pipeline" for monthly tips, in-depth technical discussions,
free white papers,
software utilities and more. The DBA Pipeline is a free service hosted by
best-sellindg Oracle
author Michael R. Ault ("Oracle 8i Administration and Management", John
Wiley & Sons) and
sponsored by RevealNet, Inc. http://www.revealnet.com/pipeline.htm
February's Tip of the Month
Troublshooting Out of Sync File Headers and Controlfiles
In some shutdown scenarios (such as system crash) file headers and
controlfiles may get out of sync.
If you get "ORA-01207: file is more recent than controlfile - old
controlfile" type errors, you can troubleshoot
by doing the following:
Startup mount the database and execute the following commands from the svrmgrl prompt:
alter session set events 'immediate trace name controlf level 10';
alter session set events 'immediate trace name file_hdrs level 10';
alter session set events 'immediate trace name redohdr level 10';
These commands will generate a single trace file located in your
user_dump_dest
directory containing information about the control file and data/redolog
files.
In an emergency, you can use the recover clause "using backup control file"
to possibly recover from this scenario. However, make sure that you do a
full
cold backup before attempting recovery.