Misc2
Oracle Restart: Combo OJVM-GI-DB Patch Set Update (PSU)
Oracle Restart PSU Cheat Sheet
PREP
su - grid cp /u01/orasw/patches/OPatch/12.2.0.1.16/p6880880_121010_Linux-x86-64.zip /u01/app/grid/product/12.1.0.2/grid/ cd /u01/orasw/patches unzip p<PatchFileName>.zip -- List Sub Patches cd /u01/orasw/patches/28980120 ls -l
GI PSU
su - export PATH=$PATH:/u01/app/12.1.0.2/grid/OPatch cd /u01/app/grid/product/12.1.0.2/grid/OPatch ./opatchauto apply /u01/orasw/patches/28980120/28813884 /u01/app/grid/product/12.1.0.2/grid/cfgtoollogs/opatchauto/opatchauto2019-03-29_12-56-26PM.log --> ./opatchauto rollback /u01/orasw/patches/28980120/28813884 -oh /u01/app/grid/product/12.1.0.2/grid After fixing the cause of failure Run opatchauto resume ./opatch rollback -id 28729169 ./opatch apply /u01/orasw/patches/28980115/28729169
OJVM PSU
su - export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH export PATH=$PATH:$ORACLE_HOME/OPatch cd $ORACLE_HOME/OPatch ./opatchauto apply /u01/orasw/patches/28980120/28790654 -oh $ORACLE_HOME
POST
$ORACLE_HOME/OPatch/opatch lsinventory|more crsctl status res -t -init
~~~~~~
For RMAN on Pri ORACLE_SID=oradb1;export ORACLE_SID
Notes
~~~~~~ ... For RMAN on SB ###ORACLE_SID=oradb_sb; export ORACLE_SID; printenv|grep ORA ORACLE_SID=oradb; export ORACLE_SID; printenv|grep ORA rm -rf ORADB_SB/ "Data Guard" "DUPLICATE TARGET DATABASE" "ORA-15040: diskgroup is incomplete" DUPLICATE TARGET DATABASE "ORA-15040: diskgroup is incomplete" "ORA-19504: failed to create file "+DATA"" RA-15040: diskgroup is incomplete ---- ALTER DATABASE ADD STANDBY LOGFILE thread 1 group 5 SIZE 50M; ALTER DATABASE ADD STANDBY LOGFILE thread 1 group 6 SIZE 50M; ALTER DATABASE ADD STANDBY LOGFILE thread 1 group 7 SIZE 50M; ALTER DATABASE ADD STANDBY LOGFILE thread 1 group 8 SIZE 50M; ALTER DATABASE ADD STANDBY LOGFILE thread 1 group 9 SIZE 50M; From Node 2 ALTER DATABASE ADD STANDBY LOGFILE thread 2 group 10 SIZE 50M; ALTER DATABASE ADD STANDBY LOGFILE thread 2 group 11 SIZE 50M; ALTER DATABASE ADD STANDBY LOGFILE thread 2 group 12 SIZE 50M; ALTER DATABASE ADD STANDBY LOGFILE thread 2 group 13 SIZE 50M; ALTER DATABASE ADD STANDBY LOGFILE thread 2 group 14 SIZE 50M; ORACLE_SID=oradb1; export ORACLE_SID mkdir +DATA/ORADB_SB mkdir +DATA/ORADB_SB/CONTROLFILE mkdir +DATA/ORADB_SB/DATAFILE mkdir +DATA/ORADB_SB/ONLINELOG mkdir +DATA/ORADB_SB/PARAMETERFILE mkdir +DATA/ORADB_SB/TEMPFILE mkdir +DATA/ORADB_SB/PASSWORD mkdir +FRA/ORADB_SB mkdir +FRA/ORADB_SB/ARCHIVELOG mkdir +FRA/ORADB_SB/AUTOBACKUP mkdir +FRA/ORADB_SB/CONTROLFILE mkdir +FRA/ORADB_SB/ONLINELOG OS> mkdir /u01/app/oracle/admin/oradb_sb/adump