当前位置：首页 -> 基础 -> 数据库编程

RMAN备份与恢复之可脱机数据文件丢失(二)

2014-11-24 08:11:55 · 作者: · 浏览: 12
标签: RMAN 备份 恢复 脱机 数据 文件 丢失
1088247 12-DEC-13 /u01/oracle/oradata/justdb/system01.dbf 2 Full 1088247 12-DEC-13 /u01/oracle/oradata/justdb/sysaux01.dbf 3 Full 1088247 12-DEC-13 /u01/oracle/oradata/justdb/undotbs01.dbf 4 Full 1088247 12-DEC-13 /u01/oracle/oradata/justdb/users01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 15 Full 9.36M DISK 00:00:01 12-DEC-13 BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20131212T095816 Piece Name: /u01/oracle/fast_recovery_area/JUSTDB/backupset/2013_12_12/o1_mf_ncsnf_TAG20131212T095816_9bl62lw2_.bkp SPFILE Included: Modification time: 12-DEC-13 SPFILE db_unique_name: JUSTDB Control File Included: Ckp SCN: 1088267 Ckp time: 12-DEC-13 SQL> CONN SCOTT/tiger; Connected. SQL> SELECT * FROM tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- BONUS TABLE DEPT TABLE EMP TABLE SALGRADE TABLE

Step2，SQL Plus中删除USERS表空间，模拟USERS表空间丢失

SQL> HO mv /u01/oracle/oradata/justdb/users01.dbf /opt/learn/

Step 3，scott用户查看数据失败

SQL> CONN SCOTT/tiger;
Connected.
SQL> DESC dept;
ERROR:
ORA-01116: error in opening database file 4
ORA-01110: data file 4: '/u01/oracle/oradata/justdb/users01.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Step4，SQL Plus中使第4号数据文件离线

SQL> CONN / AS SYSDBA;
Connected.
SQL> ALTER DATABASE DATAFILE 4 OFFLINE;

Database altered.

Step5，RMAN中还原4号数据文件

RMAN> RESTORE DATAFILE 4;

Starting restore at 12-DEC-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to /u01/oracle/oradata/justdb/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/oracle/fast_recovery_area/JUSTDB/backupset/2013_12_12/o1_mf_nnndf_TAG20131212T095816_9bl61rrn_.bkp
channel ORA_DISK_1: piece handle=/u01/oracle/fast_recovery_area/JUSTDB/backupset/2013_12_12/o1_mf_nnndf_TAG20131212T095816_9bl61rrn_.bkp tag=TAG20131212T095816
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 12-DEC-13

Step6，RMAN中恢复4号文件

RMAN> RECOVER DATAFILE 4;

Starting recover at 12-DEC-13
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 12-DEC-13

Step7，SQL Plus中使4号数据文件在线

SQL> ALTER DATABASE DATAFILE 4 ONLINE;

Database altered.

Step8，SQL Plus中查看数据

SQL> CONN SCOTT/tiger;
Connected.
SQL> DESC dept;
Name             Null     Type
 ----------------------------------------- -------- ----------------------------
 DEPTNO            NOT NULL NUMBER(2)
 DNAME                VARCHAR2(14)
 LOC                VARCHAR2(13)

SQL> SELECT * FROM dept;

    DEPTNO DNAME    LOC
---------- -------------- -------------
  10 ACCOUNTING   NEW YORK
  20 RESEARCH   DALLAS
  30 SALES    CHICAGO
  40 OPERATIONS   BOSTON

四 相关文章

RMAN备份与恢复之控制文件丢失

  我的邮箱：wgbno27@gmail.com
  新浪微博：@jutdb         
  微信公众平台：JustOracle（微信号：justoracle）
  数据库技术交流群：336882565（加群时验证 From CSDN XXX）
  All is well
  2014年1月15日
  By Larry Wen


katoon Sina CSDN
@Wentasy 博文仅供参考，欢迎大家来访。如有错误之处，希望批评指正。原创博文如需转载请注明出处，谢谢 :