轻松掌握无文件备份、拥有所有归档的恢复 （2）

E:\Oracle\oradata\eygle>sqlplus "sys/oracle as sysdba"

SQL*Plus: Release 9.2.0.5.0 - Production on 星期三 10月 13 22:41:48 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

已连接到空闲例程。

SQL> startup
ORACLE 例程已经启动。

Total System Global Area   47259136 bytes
Fixed Size                   454144 bytes
Variable Size              29360128 bytes
Database Buffers           16777216 bytes
Redo Buffers                 667648 bytes
数据库装载完毕。
ORA-01157: 无法标识/锁定数据文件 4 - 请参阅 DBWR 跟踪文件
ORA-01110: 数据文件 4: 'E:\ORACLE\ORADATA\EYGLE\TEST01.DBF'


SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
E:\ORACLE\ORADATA\EYGLE\SYSTEM01.DBF
E:\ORACLE\ORADATA\EYGLE\UNDOTBS01.DBF
E:\ORACLE\ORADATA\EYGLE\EYGLE01.DBF
E:\ORACLE\ORADATA\EYGLE\TEST01.DBF

SQL> alter database create datafile 'E:\ORACLE\ORADATA\EYGLE\TEST01.DBF';

数据库已更改。

SQL> recover datafile 'E:\ORACLE\ORADATA\EYGLE\TEST01.DBF';
完成介质恢复。
SQL> alter database open;

数据库已更改。

SQL> host
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.

E:\Oracle\oradata\eygle>ls -l
total 1105221
-rwxrwxrwa   1 Administrators  SYSTEM          1613824 Oct 13 23:42 CONTROL01.CTL
-rwxrwxrwa   1 Administrators  SYSTEM          1613824 Oct 13 23:42 CONTROL02.CTL
-rwxrwxrwa   1 Administrators  SYSTEM          1613824 Oct 13 23:42 CONTROL03.CTL
-rwxrwxrwa   1 Administrators  SYSTEM          10493952 Oct 13 23:44 EYGLE01.DBF
-rwxrwxrwa   1 Administrators  SYSTEM          10486272 Oct 13 23:44 REDO01.LOG
-rwxrwxrwa   1 Administrators  SYSTEM          10486272 Oct 13 23:44 REDO02.LOG
-rwxrwxrwa   1 Administrators  SYSTEM          10486272 Oct 13 23:44 REDO03.LOG
-rwxrwxrwa   1 Administrators  SYSTEM          262152192 Oct 13 23:44 SYSTEM01.DBF
-rwxrwxrwa   1 Administrators  SYSTEM          41951232 Jul  3 17:50 TEMP01.DBF
-rwxrwxrwa   1 Administrators  SYSTEM          5251072 Oct 13 23:44 TEST01.DBF
-rwxrwxrwa   1 Administrators  SYSTEM          209723392 Oct 13 23:44 UNDOTBS01.DBF
drwxrwxrwx   1 gqgai           None                  0 Oct 13 23:41 bak
-rwxrwxrwa   1 gqgai           None                811 Oct 13 23:10 sqlnet.log

E:\Oracle\oradata\eygle>ls -l TEST01.DBF
-rwxrwxrwa   1 Administrators  SYSTEM          5251072 Oct 13 23:44 TEST01.DBF

E:\Oracle\oradata\eygle>