oracle cpu是增量的,[Oracle] CPU/PSU补丁安装教程

set line 150

set pagesize 99

col action_time for a30

col action for a30

col comments for a90

col object_name for a30

col object_type for a30

col comp_name for a50

col comp_id for a20

--查看实例名

sys@ORCL>select instance_name,status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

orcl OPEN

--查看数据库版本

sys@ORCL>select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE 11.2.0.1.0 Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

--查看数据库大小

sys@ORCL>select sum(bytes)/1024/1024||'M' from dba_segments;

SUM(BYTES)/1024/1024||'M'

-----------------------------------------

68058.375M

--查看组件信息

sys@ORCL>select COMP_ID,COMP_NAME,VERSION,STATUS from DBA_REGISTRY;

COMP_ID COMP_NAME VERSION STATUS

-------------------- -------------------------------------------------- ------------------------------ ----------------------

OWB OWB 11.2.0.1.0 VALID

APEX Oracle Application Express 3.2.1.00.10 VALID

EM Oracle Enterprise Manager 11.2.0.1.0 VALID

AMD OLAP Catalog 11.2.0.1.0 VALID

SDO Spatial 11.2.0.1.0 VALID

ORDIM Oracle Multimedia 11.2.0.1.0 VALID

XDB Oracle XML Database 11.2.0.1.0 VALID

CONTEXT Oracle Text 11.2.0.1.0 VALID

EXF Oracle Expression Filter 11.2.0.1.0 VALID

RUL Oracle Rules Manager 11.2.0.1.0 VALID

OWM Oracle Workspace Manager 11.2.0.1.0 VALID

CATALOG Oracle Database Catalog Views 11.2.0.1.0 VALID

CATPROC Oracle Database Packages and Types 11.2.0.1.0 VALID

JAVAVM JServer JAVA Virtual Machine 11.2.0.1.0 VALID

XML Oracle XDK 11.2.0.1.0 VALID

CATJAVA Oracle Database Java Packages 11.2.0.1.0 VALID

APS OLAP Analytic Workspace 11.2.0.1.0 VALID

XOQ Oracle OLAP API 11.2.0.1.0 VALID

18 rows selected.

--查看补丁情况

sys@ORCL>select ACTION_TIME, ACTION, COMMENTS from sys.DBA_REGISTRY_HISTORY;

no rows selected

--查看无效对象

sys@ORCL>select count(*) from dba_objects where status<>'VALID';

COUNT(*)

----------

123

sys@ORCL> select object_name,object_type,owner,status from dba_objects where status<>'VALID';

sys@ORCL>spool off

2)备份数据库