分类分类
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';
}
相关文章