very urgent

[cravi]

ERROR:

ORA-00201:CONTROL FILE VERSION INCOMPATIBLE WITH ORACLE VERSION
ORA-00202: CONTROL FILE: 'D:\ORANT\DATABASE\TGGG\CTL1TGGG.ORA'

DATABSE IS NOT FUNCTIONING.WHAT SHOULD I DO?

PLEASE COME BACK WITH SOME SOLUTION.

THANKS
RAVI

[Kishore]

Create new control file and start the database with that. You should be ok.

alter database backup controlfile to trace;

[cravi]

THE COMMAND ALTER DATABASE BACKUP CONTROLFILE TO TRACE IS not working either at sys or at system.The same error is popping up when i am using this command.

Any solution please.

Ravi

[ramk_vv]

Hi,

The available options which come to my mind are :

a) If you are having an old copy of the trace file created
by the 'alter database backup controlfile to trace' command
you can manually edit it, make changes if any, like if you
have added any datafiles or redolog files after the backup file
is created and then execute the script,with the database
in nomount state.Generally, the 'alter database...' command is executed as a part of a good backup good strategy.So even
if you have an old file you can use it.

b) Manually create a txt file containing the 'create controlfile' command with its full syntax and execute it.This is possible assuming you have the complete list of your datafiles, redologfiles etc. (Pls. refer the docm. for the syntax).

c) In a worst case, you may use a backup controlfile, do a dummy incomplete recovery and open the database with resetlogs.

Take care.

HTH.