ORA-01157 and ORA-01110 problems at Oracle Database startup

Source: Internet
Author: User

An error with ORA-01157 and ORA-01110 reported at Oracle startup today

SQL> startup mount;

SQL> alter database open;

RA-01157: unable to identify/lock data files 10-see DBWR trace files ORA-01110: Data Files 10: 'd: \ ORACLE \ ORADATA \ ORCL \ USERS02.DBF'

The solution is as follows:

1. startup mount

2. alter database open

ORA-01157: cannot identify/lock data file 10-see DBWR trace file

ORA-01110: data file 12: '/oradata/orcldata/sacproduce02.dbf'

3. cd/oradata

4. cd orcldata

The error message is that read/write operations cannot be performed, haha. The reason is found. The attached hard disk cannot be read or written. To open the database, you can only perform offline operations on the file.

5. archive log list

Archive Mode

Alter database datafile '/oradata/orcldata/sacproduce02.dbf' offline

Non-archive Mode

Alter database datafile '/oradata/orcldata/sacproduce02.dbf' offline drop

6. At this point, the database can be open. However, there is still the required data in the file. The next step is to mount the hard disk, online data file, and open database.

Alter database datafile '/oradata/orcldata/sacproduce02.dbf' online;

ORA-01113: file 12 needs media recovery

ORA-01110: data file 12: '/oradata/orcldata/sacproduce02.dbf'

Recover datafile '/oradata/orcldata/sacproduce02.dbf'

Alter database datafile '/oradata/orcldata/sacproduce02.dbf' online;

Alter database open;

OK, problem solving ^_^

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.