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

ORA-01116: error in opening database file 89

ORA-01110: data file 89: '/templv/osm/OSM_TABP_00.dbf'

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 3

If the table space data file is not important, delete it directly:

First of all, change the table space file to offline!

SQL>alter database datafile '/templv/osm/OSM_TABP_00.dbf' offline drop;

Every file must be offline before it can be deleted.

Now use:

drop tablespace osm_tabp_0 including contents

That's OK!

If you need to recover, refer to the following steps

The solution is to recreate a data file and recover it, but only if the log file is still there.

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;

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.