【赵渝强老师】第一个Oracle的手工备份和恢复

create tablespace mytbs datafile '/home/oracle/mytbs01.dbf' size 50M;
alter user scott quota unlimited on mytbs;
create table scott.test1 tablespace mytbs as select ename,sal from scott.emp;
create table scott.test2 tablespace mytbs as select * from scott.dept;

alter tablespace mytbs begin backup;
host cp /home/oracle/mytbs01.dbf /home/oracle/backup/demo1/mytbs01.dbf
alter tablespace mytbs end backup;

删除数据文件，模拟数据丢失
rm -rf /home/oracle/mytbs01.dbf

打开数据库：startup

出现以下错误：
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/home/oracle/mytbs01.dbf'

查询错误信息：
SQL> select FILE#,ERROR from V$RECOVER_FILE;
     FILE# ERROR
---------- ---------------------------------------------------
	 5 FILE NOT FOUND

查看当前数据库的状态：
SQL> select OPEN_MODE from v$database;
OPEN_MODE
--------------------
MOUNTED

转储数据文件：将备份拷贝回原来的位置
cp /home/oracle/backup/demo1/mytbs01.dbf /home/oracle/mytbs01.dbf

恢复：
recover datafile 8; 

打开数据库：
alter database open;