实验:针对表空间users
PS:本次实验模拟USERS表空间数据文件损坏或者该磁盘硬件损毁
run {
allocate channel ch1 device type disk;
backup incremental level 0 tablespace users format '/u01/backup/users_0_%T_%U';
release channel ch1;
}
create table t20(id number) tablespace users;
insert into t20 values(100);
insert into t20 values(200);
commit;
sys切换日志,产生归档日志文件
alter system switch logfile;
run {
allocate channel ch1 device type disk;
backup incremental level 1 tablespace users format '/u01/backup/users_1_%T_%U';
release channel ch1;
}
insert into t20 values(300);
insert into t20 values(400);
commit;
sys切换日志,产生归档日志文件
alter system switch logfile;
run {
allocate channel ch1 device type disk;
backup incremental level 2 tablespace users format '/u01/backup/users_2_%T_%U';
release channel ch1;
}
insert into t20 values(500);
insert into t20 values(600);
commit;
RMAN> report schema ; 找出表空间下的数据文件
Or
select * from dba_data_files ;
将users 表空间 offline
SQL>alter tablespace users offline ;
将数据文件删除
[oracle@rhel7 Backup]$ mv /u01/oracle/oradata/ORCL/datafile/o1_mf_users_gqdkd0d3_.dbf /u01/oracle/oradata/ORCL/datafile/o1_mf_users_gqdkd0d3_.dbf.bak
run {
allocate channel ch1 device type disk;
set newname for datafile 7 to '/u01/oradata/orcl/users01.dbf';
restore datafile 7;
switch datafile 7 ;
recover datafile 7;
alter database datafile 7 online;
release channel ch1;
}
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
赞2
添加新评论0 条评论