ORACLE全备份和0级增量备份的区别
比较官方的说法
Full
A backup of a datafile that includes every allocated block in the file being backed up. A full backup of a datafile can be an image copy, in which case every data block is backed up. It can also be stored in a backup set, in which case datafile blocks not in use may be skipped, according to rules in Oracle Database Backup and Recovery Reference.
A full backup cannot be part of an incremental backup strategy; that is, it cannot be the parent for a subsequent incremental backup.
Incremental
An incremental backup is either a level 0 backup, which includes every block in the file except blocks compressed out because they have never been used, or a level 1 backup, which includes only those blocks that have been changed since the parent backup was taken.
A level 0 incremental backup is physically identical to a full backup. The only difference is that the level 0 backup is recorded as an incremental backup in the RMAN repository, so it can be used as the parent for a level 1 backup.
网上搜到的只言片语
The only difference between a level 0 backup and a full backup is that a full backup is never included in an incremental strategy. If no level 0 backup exists when you run a level 1 or higher backup, RMAN makes a level 0 backup automatically to serve as the base.
增量备份0级与全备份都是全备份,但是增量备份0级使用rman备份的话就只备份了used block,而全备份备份了used and unused block
总结一下,二者有两个地方不同
1
全备份不能被用作1级增量备份的基础
2
使用rman备份的时候,全备份备份了used and unused block,0级使用rman备份的话就只备份了used block
相关文档:
oracle表空间操作详解
1
2
3作者: 来源: 更新日期:2006-01-04
5
6
7建立表空间
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
《福布斯》网站近日发表文章称,如果甲骨文74亿美元收购Sun的计划由于欧盟的阻挠而以失败告终,这并不会给甲骨文带来太大损失,但却会令Sun遭受重创。
甲骨文收购Sun的交易仍未获得欧盟委员会的批准。
欧盟反垄断监管部门担心,甲骨文收购Sun将对Sun的开源数据库业务MySQL造成不利影响。甲骨文面对欧盟的疑虑并不愿做出让 ......
在JAVA中的SQL 语句的编写方面,没有使用ORACLE 绑定变量,很大程度上降低了数据库的性能,表现在两个方面:
1、SQL语句硬分析(Hard Parse)太多,严重消耗CPU资源,延长了SQL语句总的执行时间
SQL语句的执行过程分几个步骤:语法检查、分析、执行、返回结果。其中分析又分为硬分析(Hard Parse)和软分析(Soft Pars ......
最近要做搜索,所以学起Oracle全文索引来了。
参考文章:http://www.eygle.com/archives/2005/06/ecieoaoracleeia.html
如何使用Oracle全文检索功能?
作者:eygle
出处:http://www.eygle.com/blog
日期:June 11, 2005
浏览次数:
890
本文链接:http://www.eygle.com/archives/2005/06/ecieoaoracleeia.html
本文简要 ......