Solutions to Oracle ORA-01110 errors

Database use: Oracle ORA-01110 error Solution
On the database server, create a user test and run the drop user test cascade command to delete the user, the user's data file/opt/oracle/oradata/test/testdata is also deleted. dbf. When you log on to the database, you can start the instance, but cannot open the database, the system error: ORA-01157: cannot identify/lock data file 10-see DBWR trace file ORA-01110: data file 10: '/opt/oracle/oradata/test/testdata. dbf'
The following reference CSDN forum to give a solution: http://topic.csdn.net/u/20090209/16/cdf830ad-72fb-44e5-92b3-690779e10d9a.html
There is a premise for recovery: 1. Delete the data file without backing up. Www.2cto. com2. is a data file created after the database is changed to ARCHIVELOG mode. The solution is to re-create a data file and then recover it, provided that the log file is still in progress. 1. startup mount 2. alter database create datafile '/opt/oracle/oradata/test/testdata. dbf'; 3. set autorecovery on; 4. recover datafile '/opt/oracle/oradata/test/testdata. dbf'; 5. alter database datafile '/opt/oracle/oradata/test/testdata. dbf'online; 6. alter database open;
Author: wangliya110