ORA 01113 and ORA 01110

[Marcio Souza]

Good morning,
of anything my bank did not want to open, I went to check and I have the following messages of error: ora 01113 and ora 01110, detail the bank is in narchivelog and tb mode has no backup, it's a test base What is production mirror, but even mesmo as a form of learning would like to know if it is still possible to recover this base? The most complete error message:

Select all

ORA-01113 = o arquivo 1 precisa de recuperação de midia 
ORA-01110 = 1 do arquivo de dados: 'D:\ORACLE\ORADATA\DBSIGA\SYSTEM01.DBF'

[gilbertoca]

Second documentation, this usually occurs when a manual backup is completed or when making a manual backup the instance falls.

Select all

 
oracle@oasibm:~> oerr ORA 01113 
01113, 00000, "file %s needs media recovery" 
// *Cause:  An attempt was made to online or open a database with a file that 
//         is in need of media recovery. 
// *Action: First apply media recovery to the file. 
oracle@oasibm:~>  

Suggestion is to mount the seat and run the backup end:

Select all

 
ALTER DATABASE END BACKUP 

or recovery:

Select all

 
# Mount the database 
 
SQL> STARTUP MOUNT 
 
# Recover the database as normal. For example, enter: 
 
SQL> RECOVER DATABASE 

If not, I regret lost the Tablespace System loses the bank. Well I hope I'm correct in this statement!
Someone with more oracle time can help me in this?

Gilberto