根据控制文件的信息恢复数据文件 - 数据库编程

控制文件里的信息恢复数据文件

SQL> select * from v$dbfile;

FILE# NAME

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

4 /u01/tiger/oradata/orcl2/users01.dbf

3 /u01/tiger/oradata/orcl2/sysaux01.dbf

2 /u01/tiger/oradata/orcl2/undotbs01.dbf

1 /u01/tiger/oradata/orcl2/system01.dbf

5 /u01/tiger/oradata/orcl2/ind_tbs01.dbf

SQL> create tablespace tiger datafile'/u01/tiger/oradata/orcl2/tiger01.dbf' size 10m;

Tablespace created.

创建一张表

SQL> create table t1 tablespace tiger asselect * from emp;

切换一次日志使其记录到日志中

SQL> alter system switch logfile;

System altered.

SQL> !cp /etc/passwd/u01/tiger/oradata/orcl2/tiger01.dbf

SQL> select * from t1;

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO

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

7369 SMITH CLERK 7902 17-DEC-80 800 20

7566 JONES MANAGER 7839 02-APR-81 2975 20

7788 SCOTT ANALYST 7566 19-APR-87 3000 20

7876 ADAMS CLERK 7788 23-MAY-87 1100 20

7902 FORD ANALYST 7566 03-DEC-81 3000 20

7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30

7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30

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 2452 10

7839 KING PRESIDENT 17-NOV-81 5002 10

7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30

7900 JAMES CLERK 7698 03-DEC-81 950 30

7934 MILLER CLERK 7782 23-JAN-82 1302 10

14 rows selected.

SQL> alter system switch logfile;