IT猫扑网文章教程

分类分类

rman恢复损坏的数据块

2015-06-28 00:00作者:网管联盟

  create user test identified by test default tablespace ts_test;

  grant resource,connect to test;

  create table t1 (id number,name varchar2(20));

  insert into t1 values (1,'xx');

  commit;

  rman

  connect target /;

  run {

  backup tablespace ts_test format 'c:oraclebakdb_%d%s%p%t' tag='tag_ts_test';

  }

  shutdown immediate;

  破坏ts_test.dbf文件;

  conn test/test

  select count(*)from t1;

  rman

  connect target /;

  run {

  blockrecover datafile 5 block 12 from tag='tag_ts_test';

  }

展开全部

相关文章

说两句网友评论
    我要跟贴
    取消