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

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 ^_^