dba:oracle:howtos:convert_database_into_resource
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
dba:oracle:convert_database_into_resource [2022/02/11 11:12] – ↷ Page moved from oracle:convert_database_into_resource to dba:oracle:convert_database_into_resource dodger | dba:oracle:howtos:convert_database_into_resource [2023/01/31 08:24] – removed - external edit (Unknown date) 127.0.0.1 | ||
---|---|---|---|
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