一、检查当前数据库版本及系统信息
[oracle@db01 ~]$ lsb_release -a
LSB Version: :core-4.0-amd64:core-4.0-ia32:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-ia32:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-ia32:printing-4.0-noarch
Distributor ID: RedHatEnterpriseServer
Description: Red Hat Enterprise Linux Server release 5.8 (Tikanga)
Release: 5.8
Codename: Tikanga
[oracle@db01 ~]$ uname -a
Linux db01 2.6.18-308.el5 #1 SMP Fri Jan 27 17:17:51 EST 2012 x86_64 x86_64 x86_64 GNU/Li
[oracle@db01 DBData]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
53G 26G 24G 52% /
/dev/sda1 99M 13M 82M 14% /boot
tmpfs 4.0G 1.1G 3.0G 26% /dev/shm
SQL> select * from v$version;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 0
PL/SQL Release 12.1.0.1.0 - Production 0
CORE 12.1.0.1.0 Production 0
TNS for Linux: Version 12.1.0.1.0 - Production 0
NLSRTL Version 12.1.0.1.0 - Production 0
SQL> col comp_name format a40
SQL> col version format a13
SQL> col control format a8
SQL> col status format a15
SQL> set line 300
SQL> set pagesize 800
SQL> select comp_name,version,control,status from dba_server_registry;
COMP_NAME VERSION CONTROL STATUS
---------------------------------------- ------------- -------- ---------------
Oracle Database Vault 12.1.0.1.0 SYS VALID
Oracle Application Express 4.2.0.00.27 SYS VALID
Oracle Label Security 12.1.0.1.0 SYS VALID
Spatial 12.1.0.1.0 SYS VALID
Oracle Multimedia 12.1.0.1.0 SYS VALID
Oracle Text 12.1.0.1.0 SYS VALID
Oracle Workspace Manager 12.1.0.1.0 SYS VALID
Oracle XML Database 12.1.0.1.0 SYS VALID
Oracle Database Catalog Views 12.1.0.1.0 SYS VALID
Oracle Database Packages and Types 12.1.0.1.0 SYS VALID
JServer JAVA Virtual Machine 12.1.0.1.0 SYS VALID
Oracle XDK 12.1.0.1.0 SYS VALID
Oracle Database Java Packages 12.1.0.1.0 SYS VALID
OLAP Analytic Workspace 12.1.0.1.0 SYS VALID
Oracle OLAP API 12.1.0.1.0 SYS VALID
Oracle Real Application Clusters 12.1.0.1.0 SYS OPTION OFF
16 rows selected.
?
二、删除EM
[oracle@db01 ~]$ emctl stop dbconsole
SQL> @$ORACLE_HOME/rdbms/admin/emremove.sql
old 69: IF (upper('&LOGGING') = 'VERBOSE')
new 69: IF (upper('VERBOSE') = 'VERBOSE')
PL/SQL procedure successfully completed.
[oracle@db01 ~]$ rm –rf $ORACLE_HOME/$HOSTNAME
[oracle@db01 ~]$ rm –rf $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_*
三、备份数据库
RMAN> backup database plus archivelog delete input format '/DBBackup/Phycal/full_%U.bak'; Starting backup at 02-DEC-14 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=48 RECID=1 STAMP=865232107 input archived log thread=1 sequence=49 RECID=2 STAMP=865232108 input archived log thread=1 sequence=50 RECID=3 STAMP=865232110 input archived log thread=1 sequence=51 RECID=4 STAMP=865232124 input archived log thread=1 sequence=52 RECID=5 STAMP=865232126 input archived log thread=1 sequence=53 RECID=6 STAMP=865232129 input archived log thread=1 sequence=54 RECID=7 STAMP=865232130 input archived log thread=1 sequence=55 RECID=8 STAMP=865232199 i