t0nsha's Blog

差异增量备份(Differential incremental backup)：备份自最近一次小于或等于level  n备份以来的修改。累积增量备份(Cumulative incremental backup)：备份自最近一次小于level  n备份以来的修改。在rman增量备份中，有差异增量和累积增量的概念    1、概念    差异增量：是备份上级及同级备份以来所有变化的数据块，差异增量是默认

RMAN中什么样的数据文件才是unrecoverable的？存在不能用重做日志进行恢复的表或索引等对象的数据文件，在RMAN中即会被列为unrecoverable。创建一个unrecoverable的数据文件：create table scott.dept2 tablespace users as select * from scott.dept;alter table scott.dept2 n

Problem Description:-----------------------While duplicate database whenever I try to connect to auxiliary instance from the target database it returns me with error ORA-12528.SQL> host rman target /

DBID stands for database identifier. Which is a unique identifier for each oracle database running.we can get the DBID from the v$database view.sql>select DBID from v$database; DBID---------- 396

丢失控制文件后，用脚本重建控制文件，打开数据库时可不必指定RESETLOGS选项，不会产生新的incarnation，但是会丢失原来控制文件中信息，如RMAN配置与备份记录、incarnation表。Well last week I had a few posts about controlfile recovery; one about recovering without a backup a

Target DB / RMAN Client: 11.2.0.1.01. 当CONFIGURE CONTROLFILE AUTOBACKUP OFF;时，仅备份数据文件1（system01.dbf）时会自动备份控制文件；2. 当CONFIGURE CONTROLFILE AUTOBACKUP ON;时，备份任意文件（数据文件/归档日志）都会自动备份控制文件。RMAN> show all;RMAN

版本：SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionPL/SQL

版本:SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionPL/SQL