Oracle 基础知识：标准版的功能列表和 Incremental backup and recovery

由于Oracle数据库软件，可以自由的下载试用，所以很少有人会注意到企业版和标准版的不同。

在我的职业生涯中，曾经有限的次数，使用过专业版本的数据库。

有朋友问：

Oracle 的备份机制，增量备份需要额外购买什么组件包吗？

为什么我们要求公司管理员（并非专业DBA，兼职公司所有硬件维护授权的管理员）进行增量备份，对方说当前的oracle没有购买增量备份的服务，不能建立增量备份只能全库备份。

其实这的确是有限制的，以下输出来自 Oracle 标准版软件，通过 v$option 可以看到数据库中的选项列表，注意其中的： Incremental backup and recovery 选项，其值是 False。

如果使用标准版软件，的确是不能使用这个功能的。

SQL> select * from v$option order by value;

PARAMETER                                                        VALUE
---------------------------------------------------------------- -----
Partitioning                                                     FALSE
Real Application Clusters                                        FALSE
Advanced replication                                             FALSE
Parallel backup and recovery                                     FALSE
Incremental backup and recovery                                  FALSE
Bit-mapped indexes                                               FALSE
Parallel execution                                               FALSE
Point-in-time tablespace recovery                                FALSE
Fine-grained access control                                      FALSE
Spatial                                                          FALSE
Database resource manager                                        FALSE

PARAMETER                                                        VALUE
---------------------------------------------------------------- -----
Materialized view warehouse refresh                              FALSE
Materialized view rewrite                                        FALSE
Managed Standby                                                  FALSE
Coalesce Index                                                   FALSE
Online Index Build                                               FALSE
Plan Stability                                                   FALSE
Function-based indexes                                           FALSE
Enterprise User Security                                         FALSE
Application Role                                                 FALSE
Fine-grained Auditing                                            FALSE
Block Media Recovery                                             FALSE

PARAMETER                                                        VALUE
---------------------------------------------------------------- -----
Java                                                             FALSE
Duplexed backups                                                 FALSE
Sample Scan                                                      FALSE
Fast-Start Fault Recovery                                        FALSE
Transparent Application Failover                                 FALSE
Export transportable tablespaces                                 FALSE
Visual Information Retrieval                                     FALSE
Objects                                                          TRUE
Connection multiplexing                                          TRUE
Connection pooling                                               TRUE
Proxy authentication/authorization                               TRUE

PARAMETER                                                        VALUE
---------------------------------------------------------------- -----
OLAP Window Functions                                            TRUE
Parallel load                                                    TRUE
Instead-of triggers                                              TRUE
Database queuing                                                 TRUE

37 rows selected.

这个记录来自 Oracle 9i版本，如果版本信息没有 Enterprise 字样，就说明是标准版：

[oracle@st ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.0.1.0.0 - Production on Mon Jul 24 10:40:25 2006

(c) Copyright 2001 Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Release 9.0.1.0.0 - Production
JServer Release 9.0.1.0.0 - Production

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Release 9.0.1.0.0 - Production
PL/SQL Release 9.0.1.0.0 - Production
CORE    9.0.1.0.0       Production
TNS for Linux: Version 9.0.1.0.0 - Production
NLSRTL Version 9.0.1.0.0 - Production

看一下Oracle的标准版支持的选件,为True的还真不多:

SQL> set linesize 120
SQL> col value for a5
SQL> select * from v$option where value='TRUE';

PARAMETER                                                        VALUE
---------------------------------------------------------------- -----
Objects                                                          TRUE
Connection multiplexing                                          TRUE
Connection pooling                                               TRUE
Proxy authentication/authorization                               TRUE
OLAP Window Functions                                            TRUE
Parallel load                                                    TRUE
Instead-of triggers                                              TRUE
Database queuing                                                 TRUE

8 rows selected.

更高一级的版权许可信息，可以从下文中获得： https://www.modb.pro/doc/679