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
相关文档：
《福布斯》网站近日发表文章称，如果甲骨文74亿美元收购Sun的计划由于欧盟的阻挠而以失败告终，这并不会给甲骨文带来太大损失，但却会令Sun遭受重创。
甲骨文收购Sun的交易仍未获得欧盟委员会的批准。
欧盟反垄断监管部门担心，甲骨文收购Sun将对Sun的开源数据库业务MySQL造成不利影响。甲骨文面对欧盟的疑虑并不愿做出让 ......
上篇介绍了静默安装数据库软件，下面介绍静默创建数据库的方法。
1. 用DBCA根据种子数据库创建一个模板
（种子数据库就是源数据库，如果没有源数据库，可以用DBCA创建一个新的模版或编辑原有的模版）
2. 将Oracle DB安装盘里面response目录下的dbca.rsp拷贝到本机上
3. 修改dbca.rsp文件，将模板名和DB名添加进去
GDB ......
SQL中的单记录函数
1.ASCII
返回与指定的字符对应的十进制数;
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2.CHR
给出整数,返回对应的� ......
作者:杨大友,余川 测试员:王健
开发工具:Oracle Jdeveloper 10131
软硬件环境:
操作系统linux redhat 3.0 数据库为Oracle 10G 10.0.2
应用服务器为SOA Application Server 10131
开发语言:java
关于体系结构,说多了也让人觉得晕.我直接示例一个做法,至于理解,就慢慢看书吧!
步骤:
1.
创 ......
