export ORACLE_SID=orcl
rman targer /
>backup full database plus archivelog;
升級
./runInstall 安裝升級包
sqlplus / as sysdba
>startup upgrade
>@$ORACLE_HOME/rdbms/admin/catupgrd.sql
>shutdown immediate
>startup
>@$ORACLE_HOME/rdbms/admin/utlrp.sql
>select * from utl_recomp_errors; ----------> 無選定行說明無錯(cuò)誤
檢查
>select name from v$database ------->確認(rèn)ORACLE_SID正確,為oral
>show user ------->確認(rèn)當(dāng)前使用者為SYS
>select tablespace_name,bytes from dba_data_files ------>確認(rèn)表空間大小
>@$ORACLE_HOME/rdbms/admin/catalog.sql
>shutdown immediate
>startup