Shulou(Shulou.com)06/01 Report--

If you delete the data file test.dbf of test in a tablespace by mistake, then the next time you restart the database, the database cannot be opened (open).

Always reporting errors: SQL > alter database open

Alter database open*

ERROR at line 1:

ORA-01157: cannot identify/lock data file 6-see DBWRtrace file

ORA-01110: data file 6 frexample U01 apprenticeship oracleapactyoradataUniplicateorclappact.dbf'

Solution:

1. Create a new test.dbf file in the path / u01/app/oracle/oradata/orcl/

2. Log in to the database startup force; with sqlplus / as sysdba, but there will be an error at this time. It doesn't matter.

3. Execute:

SQL > alter database datafile'/u01/app/oracle/oradata/orcl/test.dbf' offline drop

Database altered.

4. Then execute:

SQL > startupforce

ORACLE instance started.

Total System Global Area 1570009088 bytes

Fixed Size 2253584 bytes

Variable Size 973081840 bytes

Database Buffers 587202560 bytes

Redo Buffers 7471104 bytes

Database mounted.

Database opened.

5. After the above steps, the database is open.

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.