误删system04.dbf 报：ORA-01…

最新推荐文章于 2024-11-03 17:31:22 发布

原创最新推荐文章于 2024-11-03 17:31:22 发布 · 612 阅读

0 ·

CC 4.0 BY-SA版权

Oracle 专栏收录该内容

70 篇文章

订阅专栏

本文记录了一次在Oracle Database 11g中进行系统表空间数据文件恢复的过程。数据库运行在非归档模式下，通过SQL命令成功添加了一个新的数据文件，并在文件被移动后进行了数据文件的创建和恢复操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

DB:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

OS:
Oracle Linux 5.7

非归档模式：
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 625
Current log sequence 627

SQL> alter tablespace system add datafile '/u01/oracle/oradata/yoon/system04.dbf' size 100m;

Tablespace altered.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/oracle/oradata/yoon/system01.dbf
/u01/oracle/oradata/yoon/sysaux01.dbf
/u01/oracle/oradata/yoon/undotbs01.dbf
/u01/oracle/oradata/yoon/users01.dbf
/u01/oracle/oradata/yoon/vpro.dbf
/u01/oracle/oradata/yoon/yoon01.dbf
/u01/oracle/oradata/yoon/svrmg1_oid.dbf
/u01/oracle/oradata/yoon/system02.dbf
/u01/oracle/oradata/yoon/system03.dbf
/u01/oracle/oradata/yoon/system04.dbf

[oracle@yoon yoon]$ mv system04.dbf system04.dbf.bak

SQL> shutdown immediate
ORA-03113: end-of-file on communication channel
Process ID: 9775
Session ID: 1 Serial number: 5

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@yoon ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 27 00:05:02 2013

Connected to an idle instance.

SQL>

SQL> startup
ORACLE instance started.

Total System Global Area 3340451840 bytes
Fixed Size 2232960 bytes
Variable Size 2499808640 bytes
Database Buffers 822083584 bytes
Redo Buffers 16326656 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: '/u01/oracle/oradata/yoon/system04.dbf'

SQL> startup mount
ORACLE instance started.

Total System Global Area 3340451840 bytes
Fixed Size 2232960 bytes
Variable Size 2499808640 bytes
Database Buffers 822083584 bytes
Redo Buffers 16326656 bytes
Database mounted.

SQL> alter database create datafile '/u01/oracle/oradata/yoon/system04.dbf';

Database altered.

SQL> recover datafile '/u01/oracle/oradata/yoon/system04.dbf';
Media recovery complete.

SQL> alter database open;

Database altered.