使用Rman进行不完全恢复

原创 eygle 2005-04-05

414

1.模拟数据损失


$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Apr 5 09:26:04 2005
Copyright (c) 1982, 2004, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SYS AS SYSDBA on 05-APR-05 >create table t as select * from dba_objects;
Table created.
SYS AS SYSDBA on 05-APR-05 >alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
Session altered.

记录一下时间(具体的生产环境，可能需要你估计一个恢复时间或者通过Logminer来分析日志得到故障时间)


SYS AS SYSDBA on 2005-04-05 09:26:48 >select sysdate from dual;
SYSDATE
-------------------
2005-04-05 09:26:55
SYS AS SYSDBA on 2005-04-05 09:26:55 >select count(*) from t;
  COUNT(*)
----------
      9478

drop table模拟一次事故(当然也可以选择闪回这张表，本例为了说明不完全恢复)


SYS AS SYSDBA on 2005-04-05 09:27:05 >drop table t;
Table dropped.
SYS AS SYSDBA on 2005-04-05 09:27:19 >exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

使用Rman进行不完全恢复

评论