Oracle Rman Full Recovery case (i) database most datafile lost

Case 1: Database most datafile lost (recover db, must be under mount)

1) test environment

07:21:12 sql> Conn Scott/tiger

Connected.

07:21:16 sql>

07:21:16 sql> SELECT * from tab;

Tname Tabtype Clusterid

------------------------------ ------- ----------

DEPT TABLE

EMP TABLE

BONUS TABLE

Salgrade TABLE

SYS_TEMP_FBT TABLE

TEST TABLE

EMP1 TABLE

7 rows selected.

07:21:20 sql> SELECT * from test;

EMPNO ename JOB MGR hiredate SAL COMM DEPTNO

---------- ---------- --------- ---------- --------- ---------- ---------- ----------

7369 SMITH Clerk 7902 17-dec-80 800 20

7499 ALLEN salesman 7698 20-feb-81 1600 300 30

7369 SMITH Clerk 7902 17-dec-80 800 20

7499 ALLEN salesman 7698 20-feb-81 1600 300 30

7521 WARD salesman 7698 22-feb-81 1250 500 30

7566 JONES MANAGER 7839 02-apr-81 2975 20

7654 MARTIN salesman 7698 28-sep-81 1250 1400 30

7698 BLAKE MANAGER 7839 01-may-81 2850 30

7782 CLARK MANAGER 7839 09-jun-81 2450 10

7788 SCOTT ANALYST 7566 19-apr-87 3000 20

7839 KING PRESIDENT 17-nov-81 5000 10

7844 TURNER salesman 7698 08-sep-81 1500 0 30

7876 ADAMS Clerk 7788 23-may-87 1100 20

7900 JAMES Clerk 7698 03-dec-81 950 30