Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "how to solve the ORA-01113,ORA-01110 error of Oracle". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. Restart the database: analyze and resolve problems:

C:\ Documents and Settings\ Jacken > sqlplus / nolog

SQL > conn sys/123456 as sysdba

SQL > shutdown immediate

The database has been closed.

The database has been uninstalled.

The ORACLE routine has been closed.

SQL > startup

Total System Global Area 293601280 bytes

Fixed Size 1248600 bytes

Variable Size 100663976 bytes

Database Buffers 184549376 bytes

Redo Buffers 7139328 bytes

The database is loaded.

An error occurred on line 1:

ORA-01113: file 1 requires media recovery

ORA-01110: data file 1:'G:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ MYDB\ SYSTEM01.DBF'

The execution of startup failed to start, and an error occurred with ORA-01113,ORA-01110. That's easy. Recover the files.

two。 Restore file media

SQL > shutdown immediate

SQL > recover datafile'G:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ MYDB\ SYSTEM01.DBF'

Complete the media recovery.

SQL > alter database open

SQL > startup

This is the end of the content of "how to solve the ORA-01113,ORA-01110 error of Oracle". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.