RMAN中什么样的数据文件才是unrecoverable的?
存在不能用重做日志进行恢复的表或索引等对象的数据文件,在RMAN中即会被列为unrecoverable。
创建一个unrecoverable的数据文件:
create table scott.dept2 tablespace users as select * from scott.dept;
alter table scott.dept2 nologging;
insert /*+ APPEND */ into scott.dept2 select * from scott.dept;
RMAN> report unrecoverable;
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------
4 full D:\DATA10G\ORCL\USERS01.DBF
REF:
1. Oracle: What is an Unrecoverable Data File?
http://www.pythian.com/news/7401/oracle-what-is-an-unrecoverable-data-file/
存在不能用重做日志进行恢复的表或索引等对象的数据文件,在RMAN中即会被列为unrecoverable。
创建一个unrecoverable的数据文件:
create table scott.dept2 tablespace users as select * from scott.dept;
alter table scott.dept2 nologging;
insert /*+ APPEND */ into scott.dept2 select * from scott.dept;
RMAN> report unrecoverable;
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------
4 full D:\DATA10G\ORCL\USERS01.DBF
REF:
1. Oracle: What is an Unrecoverable Data File?
http://www.pythian.com/news/7401/oracle-what-is-an-unrecoverable-data-file/