{"id":23182,"date":"2026-03-20T08:03:55","date_gmt":"2026-03-20T14:03:55","guid":{"rendered":"https:\/\/sada.services\/?p=23182"},"modified":"2026-03-20T10:59:31","modified_gmt":"2026-03-20T16:59:31","slug":"oracle-backup-rman","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=23182","title":{"rendered":"ORACLE: BACKUP RMAN"},"content":{"rendered":"\n<ul class=\"wp-block-list\">\n<li>Se normaliza 3 copias de seguridad\n<ul class=\"wp-block-list\">\n<li>1 a la mano <\/li>\n\n\n\n<li>2 administraci\u00f3n<\/li>\n\n\n\n<li>3 fuera de la organizaci\u00f3n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Los datos se guardan en Tablespaces<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"871\" height=\"611\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-162.png\" alt=\"\" class=\"wp-image-23185\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-162.png 871w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-162-300x210.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-162-768x539.png 768w\" sizes=\"(max-width: 871px) 100vw, 871px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Los que hay que respaldar son los de usuarios no los de oracle por que se reinstala y ya<\/li>\n\n\n\n<li>en Oracle hay componentes que se llaman DATA RECOVERY\n<ul class=\"wp-block-list\">\n<li>son archivos, componentes e informaci\u00f3n que se deben configurar para que esten funcionando <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A nivel de disco instalaci\u00f3n basica\n<ul class=\"wp-block-list\">\n<li>d1 -> SO ORACLE<\/li>\n\n\n\n<li>d2->Datos de usuario<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"526\" height=\"203\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-163.png\" alt=\"\" class=\"wp-image-23186\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-163.png 526w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-163-300x116.png 300w\" sizes=\"(max-width: 526px) 100vw, 526px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Pero con data recovery otro disco pero hay que configurarlo<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"729\" height=\"288\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-165.png\" alt=\"\" class=\"wp-image-23188\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-165.png 729w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-165-300x119.png 300w\" sizes=\"(max-width: 729px) 100vw, 729px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle recomienda redondar<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"723\" height=\"353\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-167.png\" alt=\"\" class=\"wp-image-23191\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-167.png 723w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-167-300x146.png 300w\" sizes=\"(max-width: 723px) 100vw, 723px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle todo funciona en memoria las genera en memoria hasta que haga commit y luego se guardan en los Redo Logs\n<ul class=\"wp-block-list\">\n<li>INSERT<\/li>\n\n\n\n<li>CREATE<\/li>\n\n\n\n<li>INSERT<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"286\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-168-1024x286.png\" alt=\"\" class=\"wp-image-23193\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-168-1024x286.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-168-300x84.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-168-768x215.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-168.png 1176w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>En estos registros se guardan en redo logs de manera TEMPORAL contiene informaci\u00f3n como \n<ul class=\"wp-block-list\">\n<li>ID operaci\u00f3n<\/li>\n\n\n\n<li>Usuarios<\/li>\n\n\n\n<li>Fecha<\/li>\n\n\n\n<li>Sentencias<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Son temporales se gurdan como 20 minutos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"615\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-169-1024x615.png\" alt=\"\" class=\"wp-image-23194\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-169-1024x615.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-169-300x180.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-169-768x461.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-169.png 1138w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Redo log como funciona\n<ul class=\"wp-block-list\">\n<li>si hay muchas operaciones se llena el 1 y sigue con el 2<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"727\" height=\"305\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-170.png\" alt=\"\" class=\"wp-image-23195\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-170.png 727w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-170-300x126.png 300w\" sizes=\"(max-width: 727px) 100vw, 727px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y regresa al 1 pero como no se pueden perden <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"246\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-171.png\" alt=\"\" class=\"wp-image-23196\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-171.png 435w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-171-300x170.png 300w\" sizes=\"(max-width: 435px) 100vw, 435px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>hay otro componente que es una carpeta llamado FRD \/ Fast Recovery que crea una carpeta donde copia el contenido de r1 al archivo y lo guarda<\/li>\n\n\n\n<li>Y cuando ya aseguro borra el contenido del r1<\/li>\n\n\n\n<li>y permite grabar<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"332\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-172-1024x332.png\" alt=\"\" class=\"wp-image-23197\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-172-1024x332.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-172-300x97.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-172-768x249.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-172.png 1152w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>y continua el proceso<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"547\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-173-1024x547.png\" alt=\"\" class=\"wp-image-23198\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-173-1024x547.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-173-300x160.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-173-768x410.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-173.png 1172w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Data recovery\n<ul class=\"wp-block-list\">\n<li>Redo Logs: la informaci\u00f3n mas reciente<\/li>\n\n\n\n<li>FRAD: Archivelog.ARC Informaci\u00f3n archivada <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Los ARC hay que configurarlos \n<ul class=\"wp-block-list\">\n<li>en modo ArchiveLog o si no no esta haciendo data recovery<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">1. Redo log<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>forman parte de la data recovery<\/li>\n\n\n\n<li>Se organizan en grupos<\/li>\n\n\n\n<li>Oracle recomienda 3 miembros minimo<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"631\" height=\"450\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-174.png\" alt=\"\" class=\"wp-image-23199\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-174.png 631w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-174-300x214.png 300w\" sizes=\"(max-width: 631px) 100vw, 631px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>y cada uno en disco distinto<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"813\" height=\"447\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-175.png\" alt=\"\" class=\"wp-image-23200\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-175.png 813w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-175-300x165.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-175-768x422.png 768w\" sizes=\"(max-width: 813px) 100vw, 813px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Se guardan las operaciones en binario<\/li>\n\n\n\n<li>Multiplexado se graban en paralelo<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"385\" height=\"460\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-176.png\" alt=\"\" class=\"wp-image-23201\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-176.png 385w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-176-251x300.png 251w\" sizes=\"(max-width: 385px) 100vw, 385px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Si la BD no encuentra los redo logs la BD se cae<\/li>\n\n\n\n<li>Por estos se recomienda minimo 3<\/li>\n\n\n\n<li>Descargar la vm con oracle <a href=\"https:\/\/www.talleresoracle.com\/vm\">https:\/\/www.talleresoracle.com\/vm<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.youtube.com\/@TalleresOracleONLINE\/videos\">https:\/\/www.youtube.com\/@TalleresOracleONLINE\/videos<\/a><\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>U: SYSTEM\nP: oracle<\/code><\/pre>\n\n\n\n<div data-wp-interactive=\"core\/file\" class=\"wp-block-file\"><object data-wp-bind--hidden=\"!state.hasPdfPreview\" hidden class=\"wp-block-file__embed\" data=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/TEMA06-REDOLOGFILE.pdf\" type=\"application\/pdf\" style=\"width:100%;height:600px\" aria-label=\"Incrustado de TEMA06-REDOLOGFILE.\"><\/object><a id=\"wp-block-file--media-412618e6-7e26-45d8-ab6a-ebee8c7f63a3\" href=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/TEMA06-REDOLOGFILE.pdf\">TEMA06-REDOLOGFILE<\/a><a href=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/TEMA06-REDOLOGFILE.pdf\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-412618e6-7e26-45d8-ab6a-ebee8c7f63a3\">Descarga<\/a><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Consultar los archivos<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>----------------------------------------------------\n-- 1. Listar los archivos REDO LOG\n----------------------------------------------------\nSELECT * FROM V$LOGFILE<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Asi podemos ver los miembros<\/li>\n\n\n\n<li>Vemos los discos<\/li>\n\n\n\n<li>SO Oracle<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"874\" height=\"464\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-178.png\" alt=\"\" class=\"wp-image-23205\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-178.png 874w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-178-300x159.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-178-768x408.png 768w\" sizes=\"(max-width: 874px) 100vw, 874px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>podemos ver que los grupos estan en los mismos discos \/u01<\/li>\n\n\n\n<li>Se se da\u00f1a perdemos so y datos<\/li>\n\n\n\n<li>Y le damos la carga de lso redo logs el disco se puede saturar<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"785\" height=\"559\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-179.png\" alt=\"\" class=\"wp-image-23206\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-179.png 785w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-179-300x214.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-179-768x547.png 768w\" sizes=\"(max-width: 785px) 100vw, 785px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>La otra vista nos muestra un estado de cada grupo<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>----------------------------------------------------\n-- 2. Mostrando el estado de los Grupos Redo\n----------------------------------------------------\nSELECT * FROM V$LOG<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Redo log graba en el primer grupo y luego pasa al siguiente <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"360\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-180-1024x360.png\" alt=\"\" class=\"wp-image-23207\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-180-1024x360.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-180-300x105.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-180-768x270.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-180.png 1101w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Current es el grupo activo<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>podemos cambiar el el logfile<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"356\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-181-1024x356.png\" alt=\"\" class=\"wp-image-23208\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-181-1024x356.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-181-300x104.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-181-768x267.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-181.png 1060w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Aplicamos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1025\" height=\"366\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-182.png\" alt=\"\" class=\"wp-image-23209\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-182.png 1025w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-182-300x107.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-182-768x274.png 768w\" sizes=\"(max-width: 1025px) 100vw, 1025px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cuando se llena pasa al 1 y se asume que se paso al archivado<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"324\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-183-1024x324.png\" alt=\"\" class=\"wp-image-23210\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-183-1024x324.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-183-300x95.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-183-768x243.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-183.png 1027w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Problema todo esta en el mismo disco<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"732\" height=\"266\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-184.png\" alt=\"\" class=\"wp-image-23211\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-184.png 732w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-184-300x109.png 300w\" sizes=\"(max-width: 732px) 100vw, 732px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Para moverlos<\/li>\n\n\n\n<li>Creamos unas carpetas para redo<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"487\" height=\"157\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-185.png\" alt=\"\" class=\"wp-image-23212\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-185.png 487w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-185-300x97.png 300w\" sizes=\"(max-width: 487px) 100vw, 487px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Agregamos miembro a  grupo1<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>----------------------------------------------------\n-- 3. Agregar un miembro adicional a cada Grupo\n----------------------------------------------------\nALTER DATABASE ADD LOGFILE MEMBER\n'\/u02\/redo\/redo_m1_g1.log'\nTO GROUP 1;\nALTER DATABASE ADD LOGFILE MEMBER\n'\/u03\/redo\/redo_m1_g2.log'\nTO GROUP 2;\nALTER DATABASE ADD LOGFILE MEMBER\n'\/u04\/redo\/redo_m1_g3.log'\nTO GROUP 3;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"979\" height=\"174\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-188.png\" alt=\"\" class=\"wp-image-23216\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-188.png 979w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-188-300x53.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-188-768x136.png 768w\" sizes=\"(max-width: 979px) 100vw, 979px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Consultamos y ya tenemos 5 miembros<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"655\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-189.png\" alt=\"\" class=\"wp-image-23217\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-189.png 940w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-189-300x209.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-189-768x535.png 768w\" sizes=\"(max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Hay que eliminar entonces los otros para que el disco no tenga sobre carga<\/li>\n\n\n\n<li>Primero hay que sincromizar cambiando el switch para que se sincornicen ejecutamos esto varias veces<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"425\" height=\"75\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-192.png\" alt=\"\" class=\"wp-image-23220\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-192.png 425w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-192-300x53.png 300w\" sizes=\"(max-width: 425px) 100vw, 425px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>No podemo elimoinar el mimebro si el fg1 esta activo<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"122\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-190-1024x122.png\" alt=\"\" class=\"wp-image-23218\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-190-1024x122.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-190-300x36.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-190-768x92.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-190.png 1032w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>----------------------------------------------------\n-- 5. Eliminar un miembro de un Grupo\n----------------------------------------------------\nALTER DATABASE DROP LOGFILE MEMBER '\/u04\/redo\/redo_m1_g3. log';<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"438\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-193-1024x438.png\" alt=\"\" class=\"wp-image-23221\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-193-1024x438.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-193-300x128.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-193-768x328.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-193.png 1404w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Resultado<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"902\" height=\"528\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-194.png\" alt=\"\" class=\"wp-image-23222\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-194.png 902w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-194-300x176.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-194-768x450.png 768w\" sizes=\"(max-width: 902px) 100vw, 902px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Esto cuando es en filesystem (menos de 10000 usuarios) se maneja asi<\/li>\n\n\n\n<li>Cuando son mas usarios se usa asm que es una licencia especial que maneja esto<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Zona FRA<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Es la carpera de arcivelog donde esta?<\/li>\n<\/ul>\n\n\n\n<div data-wp-interactive=\"core\/file\" class=\"wp-block-file\"><object data-wp-bind--hidden=\"!state.hasPdfPreview\" hidden class=\"wp-block-file__embed\" data=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/TEMA07-FASTRECOVERYAREA.pdf\" type=\"application\/pdf\" style=\"width:100%;height:600px\" aria-label=\"Incrustado de TEMA07-FASTRECOVERYAREA.\"><\/object><a id=\"wp-block-file--media-c98971c6-5894-4ba4-8cfc-fb83832476b1\" href=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/TEMA07-FASTRECOVERYAREA.pdf\">TEMA07-FASTRECOVERYAREA<\/a><a href=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/TEMA07-FASTRECOVERYAREA.pdf\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-c98971c6-5894-4ba4-8cfc-fb83832476b1\">Descarga<\/a><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Donde esta<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>--------------------------------------------------------\n-- 3. Configure la zona FRA para ubicarla en \u201c\/u03\/fra\u201d\n--------------------------------------------------------\nUbicaci\u00f3n actual\nSELECT VALUE FROM V$PARAMETER WHERE NAME = 'db_recovery_file_dest';<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Esto nos dice que cantidad de sesiones tenemos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"394\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-195-1024x394.png\" alt=\"\" class=\"wp-image-23224\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-195-1024x394.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-195-300x116.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-195-768x296.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-195-1536x592.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-195.png 1558w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Esto nos dice donde esta la zona FRA<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"243\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-196-1024x243.png\" alt=\"\" class=\"wp-image-23225\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-196-1024x243.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-196-300x71.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-196-768x182.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-196.png 1525w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>vamos hacer que se llenen los redo logs<\/li>\n\n\n\n<li>para que se graben en los FRA se graban aqui y crea una carpeta por dia<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"405\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-197-1024x405.png\" alt=\"\" class=\"wp-image-23226\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-197-1024x405.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-197-300x119.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-197-768x303.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-197.png 1496w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Crear datos<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE ARTICULOS ( id integer , NOMBRE VARCHAR(50) );\nBEGIN\nFOR i IN 1..200000 LOOP\nINSERT INTO ARTICULOS VALUES ( I, 'ART_' || I );\nCOMMIT;\nEND LOOP;\nDBMS_OUTPUT.PUT_LINE ('FINALIZADO');\nEND;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"763\" height=\"349\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-198.png\" alt=\"\" class=\"wp-image-23227\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-198.png 763w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-198-300x137.png 300w\" sizes=\"(max-width: 763px) 100vw, 763px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>y si vamos a la carpeta vemos que no se crearon si no que regresa a g1 o sea no esta en modo Archivado no se esta generando data recovery<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"449\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-200-1024x449.png\" alt=\"\" class=\"wp-image-23229\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-200-1024x449.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-200-300x132.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-200-768x337.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-200.png 1469w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Si entgramos a RMAN y tratamos de hacer backup no sirve por que no esta en modo NOARCHIVELOG<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"982\" height=\"496\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-201.png\" alt=\"\" class=\"wp-image-23230\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-201.png 982w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-201-300x152.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-201-768x388.png 768w\" sizes=\"(max-width: 982px) 100vw, 982px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Configurar modo archivado<\/li>\n\n\n\n<li>Coinsultar modo<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>----------------------------------------------------\n-- 1. Consultar el MODO archivado de la BD\n----------------------------------------------------\nSELECT LOG_MODE FROM V$DATABASE;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"692\" height=\"483\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-202.png\" alt=\"\" class=\"wp-image-23231\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-202.png 692w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-202-300x209.png 300w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Para activarlo modo archivo<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>----------------------------------------------------\n-- 2. Configurar la BD en Modo Archivado\n----------------------------------------------------\nCMD> SQLPLUS \/ AS SYSDBA\nSQL> SHUTDOWN IMMEDIATE\nSQL> STARTUP MOUNT\nSQL> ALTER DATABASE ARCHIVELOG;\nSQL> ALTER DATABASE OPEN;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Una vez levantado con archive <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"929\" height=\"628\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-203.png\" alt=\"\" class=\"wp-image-23232\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-203.png 929w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-203-300x203.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-203-768x519.png 768w\" sizes=\"(max-width: 929px) 100vw, 929px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Creamos carpeta para almacenar la zona FRA<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"508\" height=\"84\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-204.png\" alt=\"\" class=\"wp-image-23233\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-204.png 508w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-204-300x50.png 300w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>--------------------------------------------------------\n-- 3. Configure la zona FRA para ubicarla en \u201c\/u03\/fra\u201d\n--------------------------------------------------------\nUbicaci\u00f3n actual\nSELECT VALUE FROM V$PARAMETER WHERE NAME = 'db_recovery_file_dest';\nUbicaci\u00f3n nueva ( \/u02\/fra )\n$ mkdir \/u03\/fra\nALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '\/u03\/fra' SCOPE = BOTH;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SCOPE = BOTH; grabelo en memoria para que lo haga inmediato y guardelo en la tabla<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"455\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-205-1024x455.png\" alt=\"\" class=\"wp-image-23234\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-205-1024x455.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-205-300x133.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-205-768x341.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-205.png 1054w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vamos la carpeta<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"572\" height=\"228\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-206.png\" alt=\"\" class=\"wp-image-23235\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-206.png 572w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-206-300x120.png 300w\" sizes=\"(max-width: 572px) 100vw, 572px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Corremos el proceso<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1020\" height=\"374\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-207.png\" alt=\"\" class=\"wp-image-23236\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-207.png 1020w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-207-300x110.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-207-768x282.png 768w\" sizes=\"(max-width: 1020px) 100vw, 1020px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>los crea<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"152\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-208.png\" alt=\"\" class=\"wp-image-23237\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-208.png 471w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-208-300x97.png 300w\" sizes=\"(max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"205\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-209.png\" alt=\"\" class=\"wp-image-23238\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-209.png 816w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-209-300x75.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-209-768x193.png 768w\" sizes=\"(max-width: 816px) 100vw, 816px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"697\" height=\"181\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-210.png\" alt=\"\" class=\"wp-image-23239\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-210.png 697w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-210-300x78.png 300w\" sizes=\"(max-width: 697px) 100vw, 697px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Contiene las operaciones<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"539\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-211-1024x539.png\" alt=\"\" class=\"wp-image-23240\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-211-1024x539.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-211-300x158.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-211-768x404.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-211.png 1149w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Si se corrempe un arc podemos recuperar hasta este punto<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"716\" height=\"183\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-212.png\" alt=\"\" class=\"wp-image-23241\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-212.png 716w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-212-300x77.png 300w\" sizes=\"(max-width: 716px) 100vw, 716px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Podemos hacer un script de linux para que respalde en la nube<\/li>\n\n\n\n<li>o podemos hacer una oracle dataguard que es una copia en la nube<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"911\" height=\"151\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-213.png\" alt=\"\" class=\"wp-image-23242\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-213.png 911w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-213-300x50.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-213-768x127.png 768w\" sizes=\"(max-width: 911px) 100vw, 911px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">3. BACKUP: Recovery Manager RMAN<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle crea una carpeta donde todos los dias se crea una back de lo historial esto dentro de la zona FRA<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"531\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-214-1024x531.png\" alt=\"\" class=\"wp-image-23244\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-214-1024x531.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-214-300x156.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-214-768x398.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-214.png 1199w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Permite hacer\n<ul class=\"wp-block-list\">\n<li>backup<\/li>\n\n\n\n<li>Restore<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Como ingresamos<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>rman target<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"374\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-215.png\" alt=\"\" class=\"wp-image-23245\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-215.png 750w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-215-300x150.png 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>No se le da el nombre el se encarga<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"693\" height=\"466\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-216.png\" alt=\"\" class=\"wp-image-23246\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-216.png 693w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-216-300x202.png 300w\" sizes=\"(max-width: 693px) 100vw, 693px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>ingresamos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"809\" height=\"183\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-217.png\" alt=\"\" class=\"wp-image-23247\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-217.png 809w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-217-300x68.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-217-768x174.png 768w\" sizes=\"(max-width: 809px) 100vw, 809px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>backup (se guarda en la zona FRA)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"414\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-218-1024x414.png\" alt=\"\" class=\"wp-image-23248\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-218-1024x414.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-218-300x121.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-218-768x310.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-218.png 1109w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Solo contiene los datafiles no redo logs ni archivelog<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"354\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-219-1024x354.png\" alt=\"\" class=\"wp-image-23249\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-219-1024x354.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-219-300x104.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-219-768x266.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-219.png 1168w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Se crean<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"243\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-220-1024x243.png\" alt=\"\" class=\"wp-image-23250\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-220-1024x243.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-220-300x71.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-220-768x183.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-220.png 1300w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>El tiene un catalogo de los bck que tiene y el se encarga de restaurar<\/li>\n\n\n\n<li>Que se debe guardar para poder restaurar<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"536\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-221-1024x536.png\" alt=\"\" class=\"wp-image-23251\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-221-1024x536.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-221-300x157.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-221-768x402.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-221.png 1067w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>vamos a botar la bd<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"418\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-222-1024x418.png\" alt=\"\" class=\"wp-image-23252\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-222-1024x418.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-222-300x122.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-222-768x313.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-222.png 1130w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div data-wp-interactive=\"core\/file\" class=\"wp-block-file\"><object data-wp-bind--hidden=\"!state.hasPdfPreview\" hidden class=\"wp-block-file__embed\" data=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/TEMA09-RESTORE-TBSBD.pdf\" type=\"application\/pdf\" style=\"width:100%;height:600px\" aria-label=\"Incrustado de TEMA09-RESTORE-TBS+BD.\"><\/object><a id=\"wp-block-file--media-3eb31eca-977d-4800-9fa0-88665cb2a93b\" href=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/TEMA09-RESTORE-TBSBD.pdf\">TEMA09-RESTORE-TBS+BD<\/a><a href=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/TEMA09-RESTORE-TBSBD.pdf\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-3eb31eca-977d-4800-9fa0-88665cb2a93b\">Descarga<\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">CASO1: Recovery<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Creamos nuevo TB<\/li>\n\n\n\n<li>Creamos carpeta<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"649\" height=\"192\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-223.png\" alt=\"\" class=\"wp-image-23254\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-223.png 649w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-223-300x89.png 300w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>Caso 1 : PERDIDA DE TABLESPACE Y RESTAURACION EN LA MISMA UBICACION\nSe trata de un TABLESPACE que fue da\u00f1ado y se requiere restaurarlo en la misma ubicaci\u00f3n.\n-- 1. CREANDO ESCENARIO:\nCREATE TABLESPACE TBS_DATA\nDATAFILE '\/u02\/datos\/data01.dbf' SIZE 10M;\n\nCREATE TABLE CURSO ( NOMBRE CHAR(50)) TABLESPACE TBS_DATA;\n\nINSERT INTO CURSO VALUES ('ORACLE');\nINSERT INTO CURSO VALUES ('SQL');\n\nCOMMIT;\n\nSELECT * FROM CURSO;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahorita estos datos estan en memoria redolog o ARC<\/li>\n\n\n\n<li>el tB se crea pero no tiene los datos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"192\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-224.png\" alt=\"\" class=\"wp-image-23255\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-224.png 680w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-224-300x85.png 300w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Borramos el data file<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"682\" height=\"119\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-226.png\" alt=\"\" class=\"wp-image-23257\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-226.png 682w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-226-300x52.png 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Consultamos y si estan los datos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"812\" height=\"663\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-227.png\" alt=\"\" class=\"wp-image-23258\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-227.png 812w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-227-300x245.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-227-768x627.png 768w\" sizes=\"(max-width: 812px) 100vw, 812px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle va seguir trabajando hasta que se corra un proceso interno que se de cuenta que no hay un datafile<\/li>\n\n\n\n<li>Podemos forzar a que guarde a disco baja todo lo de menoria a disco<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"430\" height=\"109\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-228.png\" alt=\"\" class=\"wp-image-23259\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-228.png 430w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-228-300x76.png 300w\" sizes=\"(max-width: 430px) 100vw, 430px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"339\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-229-1024x339.png\" alt=\"\" class=\"wp-image-23260\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-229-1024x339.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-229-300x99.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-229-768x255.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-229.png 1240w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Solucion<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>Para iniciar proceso de restauraci\u00f3n , debemos llevar a la base de datos en el modo MOUNT\nCon el RMAN:\nRMAN> STARTUP MOUNT;\nRMAN> RESTORE TABLESPACE TBS_DATA;\nRMAN> RECOVER TABLESPACE TBS_DATA;\nRMAN> ALTER DATABASE OPEN;\nComprobando restauraci\u00f3n:\nSQL> SELECT * FROM CURSO;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Hay 2 acrhivos importantes al iniciar la BD\n<ul class=\"wp-block-list\">\n<li>Control file: tiene informaci\u00f3n de todos los procesos, backup, etc<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Proceso\n<ul class=\"wp-block-list\">\n<li>RESTORE TABLESPACE TBS_DATA;\n<ul class=\"wp-block-list\">\n<li>Tiene el ultimo bak de esto -> no existe<\/li>\n\n\n\n<li>Existe en el redo log y ARC RECOVER TABLESPACE TBS_DATA;<\/li>\n\n\n\n<li>y luego abrimos ALTER DATABASE OPEN;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ingresamos BD con error no iniciada<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"231\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-230-1024x231.png\" alt=\"\" class=\"wp-image-23261\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-230-1024x231.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-230-300x68.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-230-768x173.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-230.png 1255w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Montamos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"751\" height=\"384\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-231.png\" alt=\"\" class=\"wp-image-23262\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-231.png 751w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-231-300x153.png 300w\" sizes=\"(max-width: 751px) 100vw, 751px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Restaurar TB\n<ul class=\"wp-block-list\">\n<li>crea el tb del back (si existe)<\/li>\n\n\n\n<li>Si no lo crea limpio<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"360\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-232-1024x360.png\" alt=\"\" class=\"wp-image-23263\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-232-1024x360.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-232-300x105.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-232-768x270.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-232.png 1041w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Complementar redo log y ARC<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"756\" height=\"357\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-233.png\" alt=\"\" class=\"wp-image-23264\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-233.png 756w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-233-300x142.png 300w\" sizes=\"(max-width: 756px) 100vw, 756px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>iniciamos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"693\" height=\"203\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-234.png\" alt=\"\" class=\"wp-image-23265\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-234.png 693w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-234-300x88.png 300w\" sizes=\"(max-width: 693px) 100vw, 693px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Comprobamos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"654\" height=\"407\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-235.png\" alt=\"\" class=\"wp-image-23266\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-235.png 654w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-235-300x187.png 300w\" sizes=\"(max-width: 654px) 100vw, 654px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Caso2: con asesor<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Herramienta Asessor de recuperaci\u00f3n del rman<\/li>\n\n\n\n<li>Consultamos los data files<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"263\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-236-1024x263.png\" alt=\"\" class=\"wp-image-23268\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-236-1024x263.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-236-300x77.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-236-768x197.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-236.png 1404w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Borramos varios archivos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"845\" height=\"112\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-237.png\" alt=\"\" class=\"wp-image-23269\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-237.png 845w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-237-300x40.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-237-768x102.png 768w\" sizes=\"(max-width: 845px) 100vw, 845px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"205\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-238-1024x205.png\" alt=\"\" class=\"wp-image-23270\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-238-1024x205.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-238-300x60.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-238-768x154.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-238.png 1254w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>checkpoint<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"365\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-239-1024x365.png\" alt=\"\" class=\"wp-image-23271\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-239-1024x365.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-239-300x107.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-239-768x274.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-239.png 1086w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>la BD no sirve y se trata de levantar<\/li>\n\n\n\n<li>Esto indica que sp file esta b ien<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"568\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-240-1024x568.png\" alt=\"\" class=\"wp-image-23272\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-240-1024x568.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-240-300x166.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-240-768x426.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-240.png 1035w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Esto indica que el controlfile esta bien<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"463\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-241-1024x463.png\" alt=\"\" class=\"wp-image-23273\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-241-1024x463.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-241-300x136.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-241-768x347.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-241.png 1036w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Esto ques un datfile<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"476\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-242-1024x476.png\" alt=\"\" class=\"wp-image-23274\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-242-1024x476.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-242-300x139.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-242-768x357.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-242.png 1207w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Entramos a traget<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"274\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-243-1024x274.png\" alt=\"\" class=\"wp-image-23275\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-243-1024x274.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-243-300x80.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-243-768x206.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-243.png 1161w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Mountamos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"711\" height=\"371\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-244.png\" alt=\"\" class=\"wp-image-23276\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-244.png 711w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-244-300x157.png 300w\" sizes=\"(max-width: 711px) 100vw, 711px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Listamos arcvhivos<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>list failure;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"348\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-245-1024x348.png\" alt=\"\" class=\"wp-image-23277\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-245-1024x348.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-245-300x102.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-245-768x261.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-245.png 1378w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>pedir mas detalles<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>list failure 102 detail;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"462\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-246-1024x462.png\" alt=\"\" class=\"wp-image-23278\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-246-1024x462.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-246-300x135.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-246-768x346.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-246.png 1351w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>list failure 142 detail;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"302\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-247-1024x302.png\" alt=\"\" class=\"wp-image-23279\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-247-1024x302.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-247-300x89.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-247-768x227.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-247.png 1344w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Asesorar en fallas<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Asesorame<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>advise failure 142;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"528\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-248-1024x528.png\" alt=\"\" class=\"wp-image-23280\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-248-1024x528.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-248-300x155.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-248-768x396.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-248.png 1334w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"219\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-249-1024x219.png\" alt=\"\" class=\"wp-image-23281\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-249-1024x219.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-249-300x64.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-249-768x164.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-249.png 1082w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>vamos a la carpeta<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"227\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-250-1024x227.png\" alt=\"\" class=\"wp-image-23282\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-250-1024x227.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-250-300x67.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-250-768x170.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-250.png 1123w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>o muestramelo en pantalla<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>repair failure preview;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"537\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-251-1024x537.png\" alt=\"\" class=\"wp-image-23283\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-251-1024x537.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-251-300x157.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-251-768x403.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-251.png 1098w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y si quiere que lo aplique<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"202\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-252-1024x202.png\" alt=\"\" class=\"wp-image-23284\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-252-1024x202.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-252-300x59.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-252-768x152.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-252.png 1138w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>caso 2 102<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"512\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-253-1024x512.png\" alt=\"\" class=\"wp-image-23285\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-253-1024x512.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-253-300x150.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-253-768x384.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-253.png 1350w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"253\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-254-1024x253.png\" alt=\"\" class=\"wp-image-23286\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-254-1024x253.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-254-300x74.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-254-768x190.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-254.png 1086w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"578\" height=\"67\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-255.png\" alt=\"\" class=\"wp-image-23287\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-255.png 578w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-255-300x35.png 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"199\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-256.png\" alt=\"\" class=\"wp-image-23288\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-256.png 714w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-256-300x84.png 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"415\" height=\"70\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-257.png\" alt=\"\" class=\"wp-image-23289\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-257.png 415w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-257-300x51.png 300w\" sizes=\"(max-width: 415px) 100vw, 415px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"87\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-258.png\" alt=\"\" class=\"wp-image-23290\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-258.png 969w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-258-300x27.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-258-768x69.png 768w\" sizes=\"(max-width: 969px) 100vw, 969px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>quiere abriri la BD<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"953\" height=\"124\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-259.png\" alt=\"\" class=\"wp-image-23291\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-259.png 953w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-259-300x39.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-259-768x100.png 768w\" sizes=\"(max-width: 953px) 100vw, 953px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Datos restaurados<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"561\" height=\"513\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-260.png\" alt=\"\" class=\"wp-image-23292\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-260.png 561w, https:\/\/sada.services\/wp-content\/uploads\/2026\/03\/image-260-300x274.png 300w\" sizes=\"(max-width: 561px) 100vw, 561px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>1. Redo log Zona FRA 3. BACKUP: Recovery Manager RMAN CASO1: Recovery Caso2: con asesor Asesorar en fallas vamos a la carpeta<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-23182","post","type-post","status-publish","format-standard","hentry","category-sin-categoria"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/23182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=23182"}],"version-history":[{"count":9,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/23182\/revisions"}],"predecessor-version":[{"id":23293,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/23182\/revisions\/23293"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}