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