问题:某数据库SYSTEM表空间由2个数据文件组成,分别为system01.dbf和system02.dbf。因操作失误,从磁盘上将system02.dbf误删除了。致使数据库启动过程中报错。如下所示:
SQL>startup
ORACLE instance started.
Total System Global Area 536870912 bytes
Fixed Size 2097624 bytes
Variable Size 150998568 bytes
Database Buffers 377487360 bytes
Redo Buffers 6287360 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/oradata/orcl/system02.dbf'
处理过程 :
1、在MOUNT状态下,创建同名的数据文件。
SQL> alter database create datafile '/oradata/orcl/system02.dbf';
Database altered.
2、恢复数据文件,当提示指定日志文件时,输入“AUTO”。
SQL> recover datafile '/oradata/orcl/system02.dbf';
ORA-00279: change 847492 generated at 12/27/2013 08:33:31 needed for thread 1