{"id":2258,"date":"2021-03-23T21:19:49","date_gmt":"2021-03-23T20:19:49","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=2258"},"modified":"2021-04-16T19:33:56","modified_gmt":"2021-04-16T17:33:56","slug":"comandos-basicos-del-rac-ii","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/comandos-basicos-del-rac-ii\/","title":{"rendered":"Comandos basicos del RAC II a\u00f1adir bases de datos"},"content":{"rendered":"

Hoy vamos a seguir con la serie de entradas de comandos basicos de administracion de RAC.
\nHoy vamos a centrarnos en a\u00f1adir bases de datos y mover los recursos del cluster <\/p>\n

A\u00f1adir una base de datos <\/h1>\n

Para anadir una base de datos esta tendra que tener en el init.ora los parametros
\n<\/p>\n

  • CLUSTER_DATABASE=TRUE\n
  • CLUSTER_DATABASE_INSTANCES=2\n
  • TEST1.INSTANCE_NUMBER=1\n
  • TEST2.INSTANCE_NUMBER=2\n
  • TEST1.THREAD=1\n
  • TEST2.THREAD=2\n
  • TEST1.UNDO_TABLESPACE=’UNDOTBS1′\n
  • TEST2.UNDO_TABLESPACE=’UNDOTBS2′\n<\/ul>\n

    or supuesto,deberemos de contar con tantos grupos de UNDO y threads de REDO como nodos vayamos a tener.
    \nUna vez tenemos esto, la registraremos en el crs con los comandos <\/p>\n

    \r\nsrvctl add database  -db TEST-instance IBTEST1 -spfile +DATA\/TEST\/spfileTEST.ora -diskgroup \"DATA,FRA,REDO1,REDO2\"-oraclehome $ORACLE_HOME\r\nsrvctl add instance -d TEST-i TEST1 -n rac1.pamplona.name\r\nsrvctl start database -db TEST\r\nsrvctl add instance -d TEST-i TEST2 -n rac2.pamplona.name\r\nsrvctl start  instance -db IBTES -i IBTEST2 \r\n<\/pre>\n
    Mas entradas para dummies sobre RAC:
    \nComandos basicos en Orace RAC<\/a>
    \n    Comandos basicos del RAC II<\/a>
    \n    Eliminar un nodo del rac<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
    Hoy vamos a seguir con la serie de entradas de comandos basicos de administracion de RAC. Hoy vamos a centrarnos en a\u00f1adir bases de datos y mover los recursos del cluster A\u00f1adir una base de datos Para anadir una base … Sigue leyendo →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[567,921,975,9,49],"tags":[137,252,213],"class_list":["post-2258","post","type-post","status-publish","format-standard","hentry","category-12c-en","category-18c","category-19c","category-dummie","category-rac","tag-crsctl","tag-rac","tag-srvctl"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=2258"}],"version-history":[{"count":7,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2258\/revisions"}],"predecessor-version":[{"id":2267,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2258\/revisions\/2267"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=2258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=2258"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=2258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}