数据文件丢失

最新推荐文章于 2021-04-05 23:22:07 发布

congnie1720

最新推荐文章于 2021-04-05 23:22:07 发布

阅读量126

点赞数

环境：数据库无法关闭，发现数据文件对视。如果该数据文件不重要（可以删除），想要正常关闭数据库可以用参照以下：

SQL> shutdown immediate;
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/oradb/oradata/ggx/a2.dbf'
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

SQL> select * from V$tablespace;

       TS# NAME                                     INC BIG FLA ENC
---------- ---------------------------------------- --- --- --- ---
         0 SYSTEM                                   YES NO YES
         1 UNDOTBS1                                 YES NO YES
         2 SYSAUX                                   YES NO YES
         3 TEMP                                     NO NO YES
         4 USERS                                    YES NO YES
         5 GGX                                      YES NO YES
         7 A2                                       YES NO YES

7 rows selected.

SQL> drop tablespace A2;
drop tablespace A2
*
ERROR at line 1:
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/oradb/oradata/ggx/a2.dbf'
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

SQL>
SQL>
SQL> alter database datafile '/oradb/oradata/ggx/a2.dbf' offline;
alter database datafile '/oradb/oradata/ggx/a2.dbf' offline
*
ERROR at line 1:
ORA-01145: offline immediate disallowed unless media recovery enabled

SQL> alter database datafile '/oradb/oradata/ggx/a2.dbf' offline drop;

Database altered.

SQL> select * from V$tablespace;

7 rows selected.

SQL> select name,status from V$datafile;

NAME                                     STATUS
---------------------------------------- -------
/oradb/oradata/ggx/system01.dbf          SYSTEM
/oradb/oradata/ggx/undotbs01.dbf         ONLINE
/oradb/oradata/ggx/sysaux01.dbf          ONLINE
/oradb/oradata/ggx/users01.dbf           ONLINE
/oradb/oradata/ggx/ggx01.dbf             ONLINE
/oradb/oradata/ggx/a2.dbf                RECOVER

6 rows selected.

SQL> alter database datafile '/oradb/oradata/ggx/a2.dbf' offline;

Database altered.

SQL> select name,status from V$datafile;

6 rows selected.

SQL> drop tablespace a2;

Tablespace dropped.

SQL> select name,status from V$datafile;

SQL> select * from V$tablespace;

6 rows selected.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25517773/viewspace-730865/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25517773/viewspace-730865/