dba:oracle:howtos:convert_database_into_resource
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
dba:oracle:howtos:convert_database_into_resource [2023/01/31 08:24] – removed - external edit (Unknown date) 127.0.0.1 | dba:oracle:howtos:convert_database_into_resource [2023/01/31 08:24] (current) – ↷ Page moved from dba:oracle:convert_database_into_resource to dba:oracle:howtos:convert_database_into_resource dodger | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== [HOWTO] Converting a Database into a clusterware resource ====== | ||
+ | ====== Descripción ====== | ||
+ | Como convertir una bbdd en un recurso del clusterware de oracle para poder pivotarla de nodo en un entorno activo-pasivo. | ||
+ | |||
+ | ====== Howto ====== | ||
+ | * Tomo la variable ORACLESID como nombre de la base de datos. | ||
+ | * Exportamos y CONSERVAMOS la configuración actual de la bbdd: | ||
+ | < | ||
+ | crsctl status resource ora.${ORACLESID,, | ||
+ | cp -pfv crsctl_${ORACLESID,, | ||
+ | </ | ||
+ | * Paramos la BBDD | ||
+ | * Eliminamos la configuración actual: | ||
+ | < | ||
+ | srvctl remove database -d ${ORACLESID,, | ||
+ | </ | ||
+ | * Editar el fichero de recursos: | ||
+ | < | ||
+ | * Y dejar los siguientes parámetros de configuración: | ||
+ | < | ||
+ | NAME | ||
+ | TYPE | ||
+ | ACL | ||
+ | ACTION_SCRIPT | ||
+ | ACTION_FAILURE_TEMPLATE | ||
+ | ACTIVE_PLACEMENT | ||
+ | AUTO_START | ||
+ | CARDINALITY | ||
+ | CHECK_INTERVAL | ||
+ | DEGREE | ||
+ | DESCRIPTION | ||
+ | ENABLED | ||
+ | HOSTING_MEMBERS | ||
+ | LOAD | ||
+ | NOT_RESTARTING_TEMPLATE | ||
+ | OFFLINE_CHECK_INTERVAL | ||
+ | PLACEMENT | ||
+ | PROFILE_CHANGE_TEMPLATE | ||
+ | RESTART_ATTEMPTS | ||
+ | SCRIPT_TIMEOUT | ||
+ | START_DEPENDENCIES | ||
+ | START_TIMEOUT | ||
+ | STATE_CHANGE_TEMPLATE | ||
+ | STOP_DEPENDENCIES | ||
+ | STOP_TIMEOUT | ||
+ | UPTIME_THRESHOLD | ||
+ | </ | ||
+ | * Cambiar las variables: | ||
+ | < | ||
+ | ACTION_SCRIPT=/ | ||
+ | HOSTING_MEMBERS=node1 node2 | ||
+ | </ | ||
+ | * Donde ACTION_SCRIPT es un script más abajo documentado y los " | ||
+ | * Y añadimos el recurso: | ||
+ | < | ||
+ | |||
+ | ===== Script de Acción ===== | ||
+ | < | ||
+ | |||
+ | <code bash> | ||
+ | #!/bin/bash | ||
+ | |||
+ | # Environment variables | ||
+ | export ORA_SID=" | ||
+ | export ORA_USER=" | ||
+ | |||
+ | export CRS_HOME="/ | ||
+ | export CRS_HOME_SCRIPT=${CRS_HOME}/ | ||
+ | |||
+ | export EXITCODE=0 | ||
+ | |||
+ | export PATH="/ | ||
+ | export DB_HOME=/ | ||
+ | . / | ||
+ | |||
+ | |||
+ | |||
+ | # Database start, stop, check, clean | ||
+ | |||
+ | # DB STOP | ||
+ | stop() { | ||
+ | echo " | ||
+ | sqlplus /nolog <<EOF | ||
+ | connect / as sysdba | ||
+ | shutdown immediate | ||
+ | EOF | ||
+ | EXITCODE=$? | ||
+ | } | ||
+ | |||
+ | |||
+ | # DB Startup | ||
+ | start() { | ||
+ | echo " | ||
+ | sqlplus /nolog <<EOF | ||
+ | connect / as sysdba | ||
+ | startup | ||
+ | EOF | ||
+ | EXITCODE=$? | ||
+ | } | ||
+ | |||
+ | # DB Check | ||
+ | check() { | ||
+ | local PMONPROCCESS=" | ||
+ | if [[ " | ||
+ | then | ||
+ | EXITCODE=0 | ||
+ | else | ||
+ | EXITCODE=1 | ||
+ | fi | ||
+ | } | ||
+ | |||
+ | # Clean = SHUTDOWN ABORT | ||
+ | clean() { | ||
+ | echo " | ||
+ | sqlplus /nolog <<EOF | ||
+ | connect / as sysdba | ||
+ | shutdown abort | ||
+ | EOF | ||
+ | EXITCODE=$? | ||
+ | } | ||
+ | |||
+ | case " | ||
+ | start) | ||
+ | start | ||
+ | ;; | ||
+ | stop) | ||
+ | stop | ||
+ | ;; | ||
+ | check) | ||
+ | check | ||
+ | ;; | ||
+ | clean) | ||
+ | clean | ||
+ | ;; | ||
+ | *) | ||
+ | echo " | ||
+ | EXITCODE=1 | ||
+ | ;; | ||
+ | esac | ||
+ | |||
+ | exit $EXITCODE | ||
+ | </ | ||
+ | Variables a tener en cuenta: | ||
+ | ^ Variable ^ Descripción ^ | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' |
dba/oracle/howtos/convert_database_into_resource.txt · Last modified: 2023/01/31 08:24 by dodger