Problems Oracle 10g (Socorro) - error ORA-0027 and ORA-00202

[Fernando Ribeiro]

Environment information:
* Oracle version: Oracle 10G Xe
* Operating system: MS Windows 2003 Server Standart

Personal, good morning!

I have a buxa of those to solve.
Here in the company has a server with Oracle 10G installed and these days the server was restarting and suddenly oracle does not start. The services are usually initiated, I interrupt Oracle and start again but when I'm going to open the web page to access Oracle will not. We interrupt Oracle and beginning through the command: Startup, however it has two errors: ORA-0027 and ORA-00202 ... I gave a researched and it looks like it is corrupted database and something of controlling.dbf.

Do you imagine what it is?

Hugs and thank you for help.

Cordially,

Fernando Ribeiro - 9634-0854

[diegolenhardt]

If it is corrupted controlling you see which of the 3 it is, and then replace the one that is invalid (corrupted) by one of the others, the 3 files are identical, play one that is good above this corrupted,
and then of Startup,

Knife with the bank downloaded,

[Fernando Ribeiro]

So the file actually is not ControlFile.dbf and yes control.dbf. Note: There is only one control.dbf and this in the directory: C: \ oracle \ oradata \ xe \ control.dbf.

Another thing:
there is the possibility of taking the database of this Oracle that is corrupted and move to another Oracle that is working (without having to pack this, that is, the way What is this now) ???

Imagine whatever.

Thanks for help.

[diegolenhardt]

Then the file is not actually controlling.dbf and yes control.dbf. Note: There is only one control.dbf and this in the directory: C: \ oracle \ oradata \ xe \ control.dbf.

No, the control file is .ctl
Control01.ctl
Control02.ctl
Control03 .ctl

look for this, unless it is different, there I am not sure now, usually has 3,

Another thing:
Is the possibility of taking the database of this Oracle that is corrupted and move to another Oracle that is working (without having to clean this, that is, the way this is now)? ?

Nor, it does not actually give it, but it will arrive in the same mistake, because it would need to take the controlling,

CAA searches for its controlling, and knife Replacement of one by the other, is simple,

unless the XE creates only one, there complicates ...

[diegolenhardt]

Now that I saw here, in the message of ORA-00200, it shows what is

Select all

ORA-00202: controlfile: ‘C:\ORACLE\ORADATA\ORACLE91\CONTROL02.CTL’

Others must be in that same principality,

exchange the corrupted by one of the others, but hold the same name,

falows

[Fernando Ribeiro]

So I did not find any file with the .ctl extension. Is this xe very different from others?
Thanks for the man help ...

Cordially,

Fernando Ribeiro - 9634-0854

[diegolenhardt]

The xe has some limitations, but in relation to the structure I do not know exactly what differences, I was seeing here it seems this control.dbf same, I do not know how to proceed to recover it there ...

= /

maybe someone there in the forum can help ..

[pauloaleo]

This is an Oracle Xe. ControlFile is not multiplexed equal to normal Oracle.

Try there:

Select all

Startup nomount; 
alter database mount; 
alter database backup controlfile to trace;

[Fernando Ribeiro]

Good morning Paulo, beleza ...
Thanks for the help, but when I type the layer (Alter Database Mount) or (Alter Database Backup ControlFile to Trace) it appears the number 2 and so ...
I have to specify the walk of a directory or enter something more ???
Thanks !!!
Cordially,

Fernando Ribeiro - 9634-0854

[diegolenhardt]

Are you putting point-and-virgulum in the end?

[pauloaleo]

The number 2 means another line

Let's

You fall at the prompt with the Oracle service enabled.

Select all

digita sqlplus "/ as sysdba" 
shutdown abort; 
startup nomount; 
alter database mount; 
alter database backup controlfile to trace;

Try there

[Fernando Ribeiro]

Good afternoon,
then, I made the commands that passed me with a point and virgulum right and even so the http of the bank does not open ...
I'll pass on to you the first procedure I did and then the Second ..
Hugs and thank you for helping me ...

Procedure - 1

Select all

C:\Documents and Settings\Administrator>sqlplus / as sysdba 
 
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 3 11:25:23 2010 
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved. 
 
 
Connected to: 
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production 
 
SQL> shutdown immediate 
ORA-01109: database not open 
 
 
Database dismounted. 
ORACLE instance shut down. 
SQL> startup nomount 
ORACLE instance started. 
 
Total System Global Area  251658240 bytes 
Fixed Size                  1286820 bytes 
Variable Size              83889500 bytes 
Database Buffers          163577856 bytes 
Redo Buffers                2904064 bytes 
SQL> alter database mount; 
 
Database altered. 
 
SQL> alter database backup controlfile to trace; 
 
Database altered. 
 
SQL> shutdown immediate 
ORA-01109: database not open 
 
 
Database dismounted. 
ORACLE instance shut down. 
SQL> startup 
ORACLE instance started. 
 
Total System Global Area  251658240 bytes 
Fixed Size                  1286820 bytes 
Variable Size              83889500 bytes 
Database Buffers          163577856 bytes 
Redo Buffers                2904064 bytes 
Database mounted. 
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open 
 
 
SQL>

procedure - 2

Select all

Microsoft Windows [Version 5.2.3790] 
(C) Copyright 1985-2003 Microsoft Corp. 
 
C:\Documents and Settings\Administrator>sqlplus "/as sysdba" 
 
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 3 13:51:17 2010 
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved. 
 
 
Connected to: 
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production 
 
SQL> shutdown abort; 
ORACLE instance shut down. 
SQL> startup nomount; 
ORACLE instance started. 
 
Total System Global Area  251658240 bytes 
Fixed Size                  1286820 bytes 
Variable Size              83889500 bytes 
Database Buffers          163577856 bytes 
Redo Buffers                2904064 bytes 
SQL> alter database mount; 
 
Database altered. 
 
SQL> alter database backup controlfile to trace; 
 
Database altered. 
 
SQL>

That's it ...
Thank you all ...
You are beasts ...

Cordially,

Fernando Ribeiro - 9634-0854

[diegolenhardt]

Try

Select all

startup nomount; 
alter database mount;  
alter database open resetlogs;

Now that you restored ControlFile, =]

[Fernando Ribeiro]

Take a look at the procedure I did now ...

Select all

SQL> shutdown immediate 
ORA-01109: database not open 
 
 
Database dismounted. 
ORACLE instance shut down. 
SQL> startup nomount 
ORACLE instance started. 
 
Total System Global Area  251658240 bytes 
Fixed Size                  1286820 bytes 
Variable Size              83889500 bytes 
Database Buffers          163577856 bytes 
Redo Buffers                2904064 bytes 
SQL> alter database mount; 
 
Database altered. 
 
SQL> alter database resetlogs; 
alter database resetlogs 
                       * 
ERROR at line 1: 
ORA-02231: missing or invalid option to ALTER DATABASE 
 
 
SQL>

Thanks.

Cordially,

Fernando Ribeiro - 9634-0854

[diegolenhardt]

This:

Select all

alter database OPEN resetlogs;

[Fernando Ribeiro]

Take a look:

Select all

SQL> alter database OPEN resetlogs; 
alter database OPEN resetlogs 
* 
ERROR at line 1: 
ORA-01113: file 1 needs media recovery 
ORA-01110: data file 1: 'C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF' 
 
SQL> 

Thank you very much ...

Cordially,

Fernando Ribeiro - 9634 -0854

[diegolenhardt]

http://eduardolegatti.blogspot.com/2008 ... ption.html
I think that's exactly what's happening to you.

Maybe or Paul has another idea, but at the beginning with this altered parameter you can climb the bank to make an export and restore later,
falows

[pauloaleo]

No more alter Database Open resetlogs that you will lose the bank.

does this:

Select all

sqlplus "/ as sysdba" 
startup mount; 
alter database backup controlfile to trace; 
show parameters dump

The Oracle Dump Directorio will appear

post here.

[Fernando Ribeiro]

See:

Select all

CREATE CONTROLFILE REUSE DATABASE "XE" NORESETLOGS  NOARCHIVELOG 
    MAXLOGFILES 16 
    MAXLOGMEMBERS 3 
    MAXDATAFILES 100 
    MAXINSTANCES 8 
    MAXLOGHISTORY 292 
LOGFILE 
  GROUP 1 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_5PMF7SXS_.LOG'  SIZE 50M, 
  GROUP 2 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_5PMF7TRW_.LOG'  SIZE 50M, 
  GROUP 3 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_3_5PMF7VM1_.LOG'  SIZE 100M 
-- STANDBY LOGFILE 
DATAFILE 
  'C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF', 
  'C:\ORACLEXE\ORADATA\XE\UNDO.DBF', 
  'C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF', 
  'C:\ORACLEXE\ORADATA\XE\USERS.DBF' 
CHARACTER SET US7ASCII 
;

[Fernando Ribeiro]

Error:

Select all

Wed Feb 03 16:36:21 2010 
Errors in file c:\oraclexe\app\oracle\admin\xe\udump\xe_ora_1972.trc: 
ORA-00600: internal error code, arguments: [2662], [0], [68431731], [0], [68438001], [8388617], [], [] 
 
Wed Feb 03 16:36:23 2010 
Errors in file c:\oraclexe\app\oracle\admin\xe\udump\xe_ora_1972.trc: 
ORA-00600: internal error code, arguments: [2662], [0], [68431731], [0], [68438001], [8388617], [], [] 
 
Wed Feb 03 16:36:23 2010 
Error 600 happened during db open, shutting down database 
USER: terminating instance due to error 600 
Wed Feb 03 16:36:24 2010 
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_pmon_640.trc: 
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [] 
 
Wed Feb 03 16:36:24 2010 
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_reco_1576.trc: 
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [] 
 
Wed Feb 03 16:36:24 2010 
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_smon_1924.trc: 
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [] 
 
Wed Feb 03 16:36:24 2010 
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_ckpt_1732.trc: 
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [] 
 
Wed Feb 03 16:36:24 2010 
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_psp0_1728.trc: 
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [] 
 
Wed Feb 03 16:36:24 2010 
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_632.trc: 
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [] 
 
Wed Feb 03 16:36:24 2010 
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_mman_652.trc: 
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [] 
 
Wed Feb 03 16:36:24 2010 
Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_dbw0_364.trc: 
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [] 
 
Instance terminated by USER, pid = 1972 
ORA-1092 signalled during: alter database open...

[pauloaleo]

Select all

_allow_resetlogs_corruption = true 
_allow_read_only_corruption = true 
_no_recovery_through_resetlogs=TRUE

These parameters have to be placed in the Bank init.

Diluma, help there, where the Bank's init is.

[diegolenhardt]

In this link you have exactly what you need to do, http://eduardolegatti.blogspot.com/2008 ... ption.html
as já had passed,

in case he starts nomount, created the pfile and set up with pfile = c : \ pfile

It will work too,

[Fernando Ribeiro]

Good afternoon people.
I would like to thank everyone who helped me in solving the problem in Oracle 10g, thank Diego and especially to Paul, who accompanied me step by step in the resolution of the problem ... [[99]) Well, I will Post the step by step of the commands that Paul aided me ...

Select all

SQL>   GROUP 2 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_ 
5PMF7TRW_.LOG' 
SP2-0734: unknown command beginning "GROUP 2 'C..." - rest of line ignored. 
SQL> 
SQL> SIZE 50M, 
SP2-0042: unknown command "SIZE 50M," - rest of line ignored. 
SQL>   GROUP 3 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_3_ 
5PMF7VM1_.LOG' 
SP2-0734: unknown command beginning "GROUP 3 'C..." - rest of line ignored. 
SP2-0044: For a list of known commands enter HELP 
and to leave enter EXIT. 
SQL> 
SQL> SIZE 100M 
SP2-0042: unknown command "SIZE 100M" - rest of line ignored. 
SQL> -- STANDBY LOGFILE 
SQL> DATAFILE 
SP2-0042: unknown command "DATAFILE" - rest of line ignored. 
SQL>   'C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF', 
SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored. 
SQL>   'C:\ORACLEXE\ORADATA\XE\UNDO.DBF', 
SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored. 
SQL>   'C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF', 
SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored. 
SP2-0044: For a list of known commands enter HELP 
and to leave enter EXIT. 
SQL>   'C:\ORACLEXE\ORADATA\XE\USERS.DBF' 
SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored. 
SQL> CHARACTER SET US7ASCII 
SP2-0734: unknown command beginning "CHARACTER ..." - rest of line ignored. 
SQL> ; 
  1  CREATE CONTROLFILE REUSE DATABASE "XE" NORESETLOGS  NOARCHIVELOG 
  2      MAXLOGFILES 16 
  3      MAXLOGMEMBERS 3 
  4      MAXDATAFILES 100 
  5      MAXINSTANCES 8 
  6      MAXLOGHISTORY 292 
  7  LOGFILE 
  8*   GROUP 1 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_ 
5PMF7SXS_.LOG' 
SQL> exit 
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Produ 
ction 
 
C:\Documents and Settings\Administrator>sqlplus "/as sysdba" 
 
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 3 16:32:43 2010 
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved. 
 
 
Connected to: 
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production 
 
SQL> ? 
SP2-0171: HELP system not available. 
SQL> ! 
SP2-0042: unknown command "!" - rest of line ignored. 
SQL> CREATE CONTROLFILE REUSE DATABASE "XE" NORESETLOGS  NOARCHIVELOG 
  2  MAXLOGFILES 16 
  3  MAXLOGMEMBERS 3 
  4  MAXDATAFILES 100 
  5  MAXINSTANCES 8 
  6  MAXLOGHISTORY 292 
  7  LOGFILE 
  8  GROUP 1 
  9  'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_5PMF7SXS_. 
LOG'SIZE 50M, 
 10  GROUP 2 
 11  'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_5PMF7TRW_. 
LOG'SIZE 50M, 
 12  GROUP 3 
 13  'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_3_5PMF7VM1_. 
LOG' SIZE 100M 
 14  -- STANDBY LOGFILE 
 15  DATAFILE 
 16  'C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF', 
 17  'C:\ORACLEXE\ORADATA\XE\UNDO.DBF', 
 18  'C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF', 
 19  'C:\ORACLEXE\ORADATA\XE\USERS.DBF' 
 20  CHARACTER SET US7ASCII; 
 
Control file created. 
 
SQL> select status from v$instance; 
 
STATUS 
------------ 
MOUNTED 
 
SQL> recovery database; 
SP2-0734: unknown command beginning "recovery d..." - rest of line ignored. 
SQL> recover database; 
Media recovery complete. 
SQL> alter database open; 
alter database open 
* 
ERROR at line 1: 
ORA-03113: end-of-file on communication channel 
 
 
SQL> shutdown abort; 
ORA-24324: service handle not initialized 
ORA-01041: internal error. hostdef extension doesn't exist 
SQL> exit 
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Produ 
ction 
 
C:\Documents and Settings\Administrator>set Oracle_sid=XE 
 
C:\Documents and Settings\Administrator>sqlplus "/as sysdba" 
 
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 3 16:54:10 2010 
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved. 
 
Connected to an idle instance. 
 
SQL> startup mount; 
ORACLE instance started. 
 
Total System Global Area  251658240 bytes 
Fixed Size                  1286820 bytes 
Variable Size              83889500 bytes 
Database Buffers          163577856 bytes 
Redo Buffers                2904064 bytes 
Database mounted. 
SQL> recover database; 
Media recovery complete. 
SQL> alter database open; 
 
Database altered. 
 
SQL> select status v$database; 
select status v$database 
                       * 
ERROR at line 1: 
ORA-00923: FROM keyword not found where expected 
 
 
SQL> select status v$instance; 
select status v$instance 
                       * 
ERROR at line 1: 
ORA-03113: end-of-file on communication channel 
 
 
SQL> exit 
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Produ 
ction 
 
C:\Documents and Settings\Administrator>sqlplus "/as sysdba" 
 
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 3 16:57:20 2010 
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved. 
 
Connected to an idle instance. 
 
SQL> exit 
Disconnected 
 
C:\Documents and Settings\Administrator>sqlplus "/as sysdba" 
 
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 3 16:58:57 2010 
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved. 
 
Connected to an idle instance. 
 
SQL> shutdown immediate 
ORA-01034: ORACLE not available 
ORA-27101: shared memory realm does not exist 
SQL> startup 
ORACLE instance started. 
 
Total System Global Area  251658240 bytes 
Fixed Size                  1286820 bytes 
Variable Size              83889500 bytes 
Database Buffers          163577856 bytes 
Redo Buffers                2904064 bytes 
Database mounted. 
Database opened. 
SQL> select status from v$instance; 
 
STATUS 
------------ 
OPEN 
 
SQL> select open_mode from v$database; 
 
OPEN_MODE 
---------- 
READ WRITE 
 
SQL> select * from v$logfile; 
 
    GROUP# STATUS  TYPE 
---------- ------- ------- 
MEMBER 
-------------------------------------------------------------------------------- 
 
IS_ 
--- 
         3         ONLINE 
C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_3_5PMF7VM1_.LOG 
YES 
 
         2 STALE   ONLINE 
C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_5PMF7TRW_.LOG 
YES 
 
    GROUP# STATUS  TYPE 
---------- ------- ------- 
MEMBER 
-------------------------------------------------------------------------------- 
 
IS_ 
--- 
 
         1 STALE   ONLINE 
C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_5PMF7SXS_.LOG 
YES 
 
 
SQL> select * from v$recover_file; 
 
     FILE# ONLINE  ONLINE_ 
---------- ------- ------- 
ERROR                                                                CHANGE# 
----------------------------------------------------------------- ---------- 
TIME 
--------- 
         5 OFFLINE OFFLINE 
FILE MISSING                                                               0 
 
 
         6 OFFLINE OFFLINE 
FILE MISSING                                                               0 
 
 
     FILE# ONLINE  ONLINE_ 
---------- ------- ------- 
ERROR                                                                CHANGE# 
----------------------------------------------------------------- ---------- 
TIME 
--------- 
 
 
SQL> select status from v$datafile_reader; 
select status from v$datafile_reader 
                   * 
ERROR at line 1: 
ORA-00942: table or view does not exist 
 
 
SQL> select status from v$datafile_header; 
 
STATUS 
------- 
ONLINE 
ONLINE 
ONLINE 
ONLINE 
OFFLINE 
OFFLINE 
 
6 rows selected. 
 
SQL> select file# from v$datafile_header; 
 
     FILE# 
---------- 
         1 
         2 
         3 
         4 
         5 
         6 
 
6 rows selected. 
 
SQL> select file# from v$recover_file; 
 
     FILE# 
---------- 
         5 
         6 
 
SQL> recover datafile 5; 
ORA-00283: recovery session canceled due to errors 
ORA-01111: name for data file 5 is unknown - rename to correct file 
ORA-01110: data file 5: 
'C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\MISSING00005' 
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file 
ORA-01111: name for data file 5 is unknown - rename to correct file 
ORA-01110: data file 5: 
'C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\MISSING00005' 
 
 
SQL>

We recover a lot, but still have some lost tables ... But it is better something than nothing right ???
If anyone knows how to recover these other lost tables ... please ...
Hugs and thank you all ...

[diegolenhardt]

Good is not the intention to criticize but

If you have important information in a database, always back up,

a simple EXP or EXPDP command would have in the maximum 1 hour recovered all,

= [

[Fernando Ribeiro]

Would it have a quick and simple way to make the backup ???
Do you know how ???

Hugs and thank you !!!

Cordially,

Fernando Ribeiro - 9634-0854

[diegolenhardt]

Select all

exp usuario/senha file=C:\banco.dmp log=C:\logExp.log statistics=none owner=USUARIO

or yet, if you have several schemas,

use the User SYSTEM to connect, and where has Owner = User
Change to:

Select all

FULL=Y

ai will backup all the bank's schemas,

then you can make a .bat file with this, and schedule a Windows task To back up every day,

[pedroedu]

Select all

shutdown immediate 
startup nomount

recreates the controlling with the trace or just replaces it for another good, porque for sure the extension clt is hidden by windows, then you give a recover database until cancel using backup controlling, will ask the archives if you have in archive log ai type auto, if you do not apply and do not open and it is very important this bank, get a way to access remote I give a way to open it without charging you ... just make a backup of it before to start moving in recovery (this would be the first providency to be taken before attempting to recover a BD with problem, because sometimes the attempt to recover the dictionary and the head of the data files and control)