SQL> alter database begin backup; -- start to back up Database altered. www.2cto.com SQL> host cp/u01/oracle/oradata/ORCL /*. dbf/u01/oracle/dump1/-- power-off before execution is complete. When abort restarts the database, the problem [root @ station88 ~] # Su-oracle [oracle @ station88 ~] $ Sqlplus/nolog SQL * Plus: Release 10.2.0.4.0-Production on Sat Dec 15 07:51:29 2012 Copyright (c) 1982,200 7, Oracle. all Rights Reserved. SQL> conn/as sysdbaConnected to an idle instance. SQL> startupORACLE instance started. total System Global Area 373293056 bytesFixed Size 1267572 bytesVariable Size 104859788 bytesDatabase Buffers 264241152 bytesRedo Buffers 2924544 bytesDatabase mounted. ORA-01113: file 1 needs media recoveryORA-01110: data file 1: '/u01/oracle/oradata/ORCL/system01.dbf' the solution is: restore the data file SQL> recover datafile '/u01/oracle/oradata/ORCL/system01.dbf' -- restore the data file Media recovery complete. SQL> alter database open; alter database open * ERROR at line 1: ORA-01113: file 2 needs media recoveryORA-01110: data file 2: '/u01/oracle/oradata/ORCL/undotbs01.dbf' SQL> recover datafile'/u01/oracle/oradata/ORCL/undotbs01.dbf' Media recovery complete. SQL> alter database open; alter database open * ERROR at line 1: ORA-01113: file 3 needs media recoveryORA-01110: data file 3: '/u01/oracle/oradata/ORCL/sysaux01.dbf' SQL> recover datafile'/u01/oracle/oradata/ORCL/sysaux01.dbf' Media recovery complete. SQL> alter database open; alter database open * ERROR at line 1: ORA-01113: file 4 needs media recoveryORA-01110: data file 4: '/u01/oracle/oradata/ORCL/users01.dbf' SQL> recover datafile'/u01/oracle/oradata/ORCL/users01.dbf' Media recovery complete. SQL> alter database open; alter database open * ERROR at line 1: ORA-01113: file 5 needs media recoveryORA-01110: data file 5: '/u01/oracle/oradata/ORCL/example01.dbf' SQL> recover datafile'/u01/oracle/oradata/ORCL/example01.dbf' Media recovery complete. SQL> alter database open; alter database open * ERROR at line 1: ORA-01113: file 6 needs media recoveryORA-01110: data file 6: '/u01/oracle/oradata/ORCL/plsql01.dbf' SQL> recover datafile'/u01/oracle/oradata/ORCL/plsql01.dbf' Media recovery complete. SQL> recover datafile '/u01/oracle/oradata/ORCL/dmptest01.dbf' Media recovery complete. SQL> alter database open; Database altered. the database is open. Note that the oracle version in this tutorial is 10.2.0.4.0.