1.- Se respaldan a nivel de +ASM las
siguientes LUNs:
ASMCMD> lsdsk
Path
/dev/c0t60060E80166C340000016C34000000B6d0s6
/dev/c0t60060E80166C340000016C34000000B7d0s6
/dev/c0t60060E80166C340000016C34000000B8d0s6
/dev/c0t60060E80166C340000016C3400000127d0s6
srvctl stop ASM -f
srvctl start ASM
2.-Respaldo filesystem: /APPDBA02
NOTA: En el momento de comenzar la
actividad se bajan los DIKGROUP del +ASM, para realizar el split (se corta la réplica
de las LUNs), esto mantiene en un estado consistente los discos, por una
eventual corrupción o perdida de datos por causa de la actividad, con esto se
obtiene una vuelta atrás.
2.
BACKUP OFFLINE RMAN:
MUFLON:
$HOME/dba/RMAN/bin/RMAN_bkp_db.sh
-s muflon -v 11gR2 -m offline -e >>
$HOME/dba/RMAN/log/cron_bkpdb_muflon_offline.log 2>&1
Tiempo de respaldo 10:00
min.
PECARI:
$HOME/dba/RMAN/bin/RMAN_bkp_db.sh
-s pecari -v 11 -m offline -e >>
$HOME/dba/RMAN/log/cron_bkpdb_pecari_offline.log 2>&1
Tiempo de respaldo
15:00 min.
3.
Instalación software 11.2.0.4 /APPDBA02/app/oracle/product/11204
/APPDBA01/app/oracle/soft11204
Despues de instalar
el software movemos el script $ORACLE_HOME/rdbms/admin/utlu112i.sql hacia el
directorio temporal.
cd
$ORACLE_HOME/rdbms/admin/
pangue.oracle(muflon)>cp utlu112i.sql /tmp
4.
Corremos el script diagnóstico de Upgrade (dbupgdiag.sql):
Si encontramos objetos descompilados en la
salida del diagnóstico:
$
cd $ORACLE_HOME/rdbms/admin
$ sqlplus "/ as sysdba"
SQL> @utlrp.sql
PRE UPGRADE
STEPS
================
5.
Copiamos el init o spfile al nuevo home.
cp /APPDBA02/app/oracle/product/11.2/dbs/initchita.ora
/APPDBA02/app/oracle/product/11204/dbs
Cambiamos el parámetro compatible a 11.2.0.4
Borramos los parámetros deprecados para esta
versión.
SQL> alter system set
job_queue_processes=0 scope=both;
SQL> EXECUTE
dbms_stats.gather_dictionary_stats;
SELECT * FROM v$recover_file;
Shutdown the database.
$ sqlplus "/as sysdba"
SQL> shutdown immediate;
UPGRADE STEPS
================
6.
Pasos Upgrade Manual
6.1 cd $ORACLE_HOME/rdbms/admin
sqlplus
" / as sysdba "
SQL> spool /tmp/upgrade_chita.log
SQL> startup upgrade
SQL> set echo on
SQL> @catupgrd.sql;
SQL> spool off
SQL> Shutdown immediate
6.2 Check
catupgrd.sql spool file for errors.
6.3 Restart the
database in normal mode.
6.4 SQL>
@$ORACLE_HOME/rdbms/admin/catuppst.sql;
6.5 SQL>
@$ORACLE_HOME/rdbms/admin/utlrp.sql;
6.6 Run
dbupgdiag.sql script (See note: 556610.1)
and verify that all the components in dba_registry are valid and there are no
invalid objects in dba_objects.
7.
POST UPGRADE STEPS
===================
8.
Upgrade TIME_ZONE 4 a 14 DST
8.1 SQL> SELECT version FROM v$timezone_file;
VERSION
----------
4
8.2 SQL > SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;
8.3 exec DBMS_DST.BEGIN_PREPARE(14);
8.4 Truncate all the DST affected tables:
SQL> TRUNCATE TABLE SYS.DST$TRIGGER_TABLE;
Table truncated.
SQL> TRUNCATE TABLE sys.dst$affected_tables;
Table truncated.
SQL> TRUNCATE TABLE sys.dst$error_table;
Table truncated.
8.5 SQL> BEGIN
DBMS_DST.FIND_AFFECTED_TABLES
(affected_tables => ‘sys.dst$affected_tables’,
log_errors => TRUE,
log_errors_table => ‘sys.dst$error_table’);
END;
/
SQL>
SELECT * FROM sys.dst$affected_tables;
SQL>
EXEC DBMS_DST.END_PREPARE;
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade
ORACLE instance started.
8.6 Execute the DST upgrade.
SQL> EXEC
DBMS_DST.BEGIN_UPGRADE(14);
PL/SQL procedure
successfully completed.
8.7 Startup the
database in NORMAL mode.
SQL> shut
immediate;.
SQL> startup
SQL> SELECT version FROM v$timezone_file;
VERSION
———-
14
9.
PSU APPLY STEPS
===================
APPLY PSU DB_HOME:
pangue.oracle(muflon)>ORACLE_HOME/OPatch/ocm/bin/emocmrsp
-no_banner -output /tmp/ocm_muflon.rsp
Provide
your email address to be informed of security issues, install and
initiate
Oracle Configuration Manager. Easier for you if you use your My
Oracle
Support Email address/User Name.
Visit
http://www.oracle.com/support/policies.html for details.
Email
address/User Name:
You
have not provided an email address for notification of security issues.
Do you
wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
The OCM
configuration response file (/tmp/ocm_chita.rsp) was successfully created.
export
SOFT_HOME=/APPDBA01/app/oracle/soft11204
cd $SOFT_HOME
pangue.oracle(muflon)>ORACLE_HOME/OPatch/opatch
prereq CheckConflictAgainstOHWithDetail -ph ./
unzip p21352635_112040_<platform>.zip
cd $SOFT_HOME/21352635
/APPDBA02/app/oracle/product/11204/OPatch/opatch apply
The
catbundle.sql execution is reflected
in the dba_registry_history view by a row associated with bundle series PSU.
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
APPLY PSU GI_HOME:
export
SOFT_HOME=/APPDBA01/app/oracle/soft11204
cd $SOFT_HOME
/APPDBA02/app/oracle/product/grid/11.2/OPatch/opatch
auto /APPDBA01/app/oracle/soft11204/21523375 -ocmrf /tmp/rsp_asm.rsp
No hay comentarios.:
Publicar un comentario