SEMINARIO DE INVESTIGACION OPM3

INTRODUCCION

La investigación tiene como fin determinar el grado de madurez en las organizaciones en cuanto a la gerencia de proyectos y de esta forma poder contar con una herramienta software que permita evaluar la situación actual y con ello generar unas recomendaciones y un plan de acción de acuerdo al modelo OPM3 (Project Management Maturity Model) propuesto por el PMI en 2003 El estudio de madurez en gerencia de proyectos aplicando el modelo OPM3 permite a cada organización, determinar si los proyectos están siendo bien manejados y si cumplen las expectativas en cuanto alcance, tiempo, costo, calidad, seguridad. La investigación brinda herramientas de estudio que permiten que cada organización aumente la madurez en el manejo de proyectos y entrega un plan de acción con recomendaciones.


PLANTEAMIENTO DEL PROBLEMA

Las empresas para ser siempre competitivas deben ser agiles y responder de manera efectiva a nuevos cambios y oportunidades del mercado, para esto las organizaciones utilizan los proyectos como mecanismos por los cuales realizan cambios a sus servicios, productos y procesos, de esta forma la gestión de proyectos en cada organización permite evaluar responsablemente la madurez en el manejo de proyectos y entrega un plan de acción con recomendaciones las cuales permitan a las organizaciones ser más eficientes en la gestión de proyectos.

MARCO TEORICO

El primer factor por el cual fracasan los proyectos a nivel mundial se puede considerar la falta de fijar un alcance claro o meta la cual debe ser (medible, especifica, tangible y alcanzable), en Colombia un factor determinante que también afecta el éxito de un proyecto es la corrupción, algunas veces priman más los intereses propios cuanto se va a recibir de comisión, que si en realidad el proyecto se desarrollara efectivamente como se espera. Las organizaciones son más o menos maduras si tienen la capacidad de desarrollar actividades o procesos que entreguen productos y servicios de manera dinámica y eficiente, de esta forma se alcanzan objetivos y metas, estas competencias o debilidades deben ser conocidas por todos en la organización de manera homogénea y transparente, las cuales deben ser aprovechadas de manera rigurosa, medidas y mejoradas continuamente con el fin de ser mejores siempre.

Con base a experiencias y análisis cualitativos en el entorno, se observa que no siempre los proyectos en las organizaciones son exitosos en general, si bien algunos son exitosos en general no es constante y normalmente estos tienen desviaciones en tiempo, costo, calidad, seguridad, esto permite concluir que hay oportunidad para poder aumentar la eficiencia en la gestión de proyectos y de esta forma mejorar los costos y tiempos de ejecución, claro está sin perder calidad y seguridad, es ahí donde un estudio de madurez organizacional en gerencia de proyectos como lo plantea al modelo OPM3 (Project Management Maturity Model), permite aportar variables y recomendaciones de mejora.

No hace mucho tiempo, los proyectos se administraban con métodos y técnicas informales basadas en los gráficos de Gantt, PERT, método de ruta crítica. Estos modelos son la base metodológica utilizada por los gerentes de proyectos. En el 2006 se formó el PMI, Instituto de Gerencia de Proyectos, bajo el argumento que cualquier proyecto, sin importar la clase que sea, usa las mismas bases metodológicas y herramientas. Es el PMI quien dicta los estándares en esa materia actualmente. En la investigación realizada no se encontraron estudios que permitan conocer el nivel de madurez de las empresas colombianas en la gestión de proyectos y la tasa de éxito de estos de esta forma se hace importante la adopción por muchas organizaciones

El modelo OPM3 el cual ofrece una metodología que permite inicialmente el conocimiento, la evaluación y mejora, dimensiones que brindan la capacidad de evaluar a través de métodos de medición, la madurez organizacional en la aplicación de la gestión organizacional de proyectos del PMI, permitiendo de esta forma mediante una metodología desarrollar la capacidad para entregar proyectos exitosos, colaborando con el logro de los objetivos y las metas de la organización. Dado que OPM3 es un modelo guía y un estándar, este sólo describe las mejores prácticas orientadas a la gestión organizacional de proyectos. Es importante mencionar que OPM no indica cómo se debe implementar. Las mejores prácticas que se mencionan en el estándar OPM3 aplican a las categorías tanto de Dominio como de habilitador organizacional estos son procesos o actividades orientadas a estandarizar, medir, controlar o mejorar continuamente los grupos de procesos de los dominios de la gestión organizacional de proyectos.

La hipótesis planteada en esta investigación es: Existe una evaluación de la madurez que se tiene en cada organización referente a la gestión de proyectos y el éxito de los mismos. Para dar inicio a la investigación se hace necesario realizar entrevistas esto con el fin de poder realizar recomendaciones a la organización. Se debe considerar que no todas las organizaciones son iguales para que puedan realizar un mejoramiento continuo.

En conclusión, cada organización debería realizar la evaluación de madurez para poder tener un mejor panorama del manejo de proyectos. En muchos casos las organizaciones no conocen el modelo OPM3 o no le dan la importancia que se debe. Al dar a conocer este modelo, las organizaciones obtienen además del nivel de madurez en el que se encuentran, obtienen recomendaciones para poder llegar al nivel de madurez esperado.

Modelo de Negocio

Plan de Negocio

Descripción del Negocio   

Uno de los cuatro tipos principales de información que se incluye en un plan de negocios es una descripción de la empresa. La descripción de la actividad se centra en sus operaciones básicas, los tipos de productos o servicios ofrecidos. La descripción tiene que ser concisa y lo suficientemente amplia como para que el lector comprenda los elementos básicos de la empresa.

Empresa especializada en productos y servicios relacionados con internet, software, dispositivos electrónicos y otras tecnologías. El principal producto  es el motor de búsqueda  el cual sirve  de ayuda de contenido y publicidad para lugares como Centros comerciales Tiendas Hoteles, Restaurantes.

Este servicio se caracteriza por ofrecer a establecimientos,  enlaces publicidad y anunciantes mediante dispositivos electrónicos y smartphones

Comercialización del Negocio

Un programa planificado de marketing es un elemento importante de un plan de negocios completo. La sección de marketing del plan de negocios debe centrarse en  actividades de promoción en lugares como centros comerciales tiendas y hoteles.

El plan de marketing se debe centrar en impulsaar la descarga de la aplicacion para las diferentes dispositivos moviles durante el primer año de funcionamiento. El programa de marketing debe identificar los tipos de negocios a los cuales se les hara promoción y publicidad en redes sociales.

Finanzas del Negocio

Un componente clave de un plan de negocios es el presupuesto y otra información financiera. El presupuesto es la columna vertebral de cualquier plan de negocios. El presupuesto debe incluir una proyección razonable de los ingresos y gastos durante un período de tiempo que se extiende hasta tres años desde la fecha en que se creó el plan de negocios. Además, el elemento financiero incluye una explicación total de la inversión de capital necesaria para establecer el negocio en primer lugar.

Gestión de la Empresa

Una pieza de información importante en un plan de negocios es una visión general de la gestión de la empresa. La parte de gestión de un plan de negocio se centra en el personal clave el cual inicialmente se centra en las impulsadoras para la descarga de aplicacion movil.

Es importante contar con un partner para el desarollo y personalizacion de la aplicacion movil.

Componentes del Plan de Negocio 

Fabricante

El desarrollo de la aplicacion movil estara a cargo por parte de una empresa de desarrollo de software Para dispositivos moviles, el modelo prevee que la aplicacison sea descargada gratuitamente.Proposición de oferta o de valor

La propuesta de valor

La solución o propuesta de valor para el consumidor o persona que descargue la aplicacion es contar con informacion en linea detallada de un lugar o establecimiento comercial, la cual sirva para un usuario como guia,

Segmento del mercado objetivo

El mercado objetivo son establecimientos comerciales en donde se pueda informar y realizar pautas publicitarias para ofrecer los diferentes productos. Al existir diferentes tipos de negocio y mercados que utilizan productos iguales o similares, se puede aumentar la  ganancia mediante publicidad.

Canal de distribución o de movimiento

Al permitir hacer llegar el producto al mercado objetivo, mediante la descarga gratuita de la aplicacion de distribución. Esto establece los medios por los cuales el usuario se relaciona con cada establecimiento comercial

Relación del consumidor

La forma en que estableces las relaciones con diferentes segmentos de clientes es la relación de consumo. Para el proyecto se define cómo a partir del contenido que se descarga de la aplicación móvil se gana confianza al ofrecer productos y servicios a los usuarios y de esta forma se gana el reconocimiento de la marca que para el caso nuestro es el nombre de la aplicación.

Configuración de valor o de recursos

La manera de utilizar las actividades, el personal y los recursos necesarios para producir el producto son tu valor y la configuración de recursos o la cadena de valor. Esta configuración es la base de tus estructuras de costos e ingresos.

Competencia subyacente

Los conocimientos básicos, habilidades, capacidades y conocimientos necesarios para producir tu producto son de tu competencia. Inicialmente, descansa en el propietario-innovador y en el equipo que lo rodea para llevar el producto al mercado.

Compañeros de la red o de afiliación

La red de socios representa acuerdos entre tu empresa y otras empresas necesarias para producir y comercializar tu producto. Incluyen proveedores de materiales y piezas, puntos de venta, transportistas, agencias de publicidad y medios de comunicación. Comercializar el valor de tu producto depende de tu colaboración.

Estructuras de costo

Los gastos necesarios para fabricar un producto o servicio es la estructura de costos. Esto incluye los costos fijos como arrendamientos o pagos de la hipoteca y los costos variables, como investigación y desarrollo, comercialización, transporte y nómina. La proporción de costes fijos a costes variables representa la estructura de costos.

Vía de ingresos

Las formas que una empresa hace ingresos son tus fuentes de ingresos. De manera más frecuente se trata de ingresos por ventas. Sin embargo, puede hacer referencia a la mercancía vendida y devoluciones de valor añadido de los consumidores, socios o terceros como marketing viral o social no solicitado.

Específico

Los objetivos estratégicos de un plan de negocios proporcionan los detalles específicos acerca de cuáles son las expectativas de una empresa para cumplir sus metas identificadas.

Los objetivos tienen que ser específicos. Esto significa que tienen que indicar exactamente cuáles son las expectativas. "Perder peso" no es un objetivo específico. "Perder 12 libras (5,44 Kg)" lo es. Aunque los objetivos proporcionan una dirección general para una organización o grupo de planificación, "incrementar las ventas" o "vencerle a la competencia", los objetivos proporcionan una imagen clara de cómo lucirá el éxito final.

Medible

Los objetivos medibles proporcionan la habilidad para que los equipos de planificación, al final de un ciclo de planificación, miren atrás y determinen si los objetivos se cumplieron o no. Tener simplemente un número específico como parte del objetivo no asegura lo que será medible. Por ejemplo: "Incrementar la satisfacción de los empleados por un 10 por ciento" puede parecer medible, pero esta declaración no da una indicación de lo que es la satisfacción y puede haber un desacuerdo sobre qué es la satisfacción o cómo es el éxito. En su lugar, un objetivo medible puede apuntar a preguntas específicas en una encuesta anual sobre satisfacción realizada a los empleados que el liderazgo de la empresa ha elegido para representar el nivel de satisfacción general. El objetivo, por lo tanto, puede decir: "Incrementar la puntuación en preguntas 1,7 y 10 de la encuesta anual a los empleados por el 10 por ciento como una indicación de un aumento en la satisfacción".

Procesable

La "A" en el acrónimo en inglés SMART puede referirse a "factible" o "procesable". Ya que "factible" está cercanamente relacionado a "realista", procesable proporciona una perspectiva ligeramente diferente. Procesable significa que el objetivo tiene que representar un resultado que la empresa o grupo de planificación sea capaz de tomar acción para lograr. "Reducir los impactos económicos en las ventas" puede no ser procesable porque la empresa no puede impactar los impactos económicos.

Realista

Los objetivos realistas son aquellos que la empresa o grupo de planificación tienen la habilidad de cumplir. Aunque está bien que los objetivos sean desafiantes, tienen que reflejar resultados que estén dentro del alcance de la organización, dado sus recursos actuales o disponibles en el momento, su dinero y personal.

Duración determinada

Los objetivos de duración determinada tienen una fecha final clara. "Perder 10 libras (4,53 Kg)", por ejemplo, no indica cuándo se perderán esas 10 libras. Puede ser el siguiente mes, el siguiente año o dentro de diez años. Todos los objetivos tienen que indicar claramente el marco de tiempo que abarcan para proporcionar un punto en el cual el grupo de planificación pueda determinar si el objetivo se logró o no.

Converting a Database on the Source Host

Converting a Database on the Source Host

RMAN> CONVERT DATABASE
2>   NEW DATABASE 'newdb'
3>   TRANSPORT SCRIPT '/tmp/convertdb/transportscript.sql'
4>   TO PLATFORM 'Microsoft Windows IA (32-bit)'
5>   DB_FILE_NAME_CONVERT '/disk1/oracle/dbs' '/tmp/convertdb';
 
Starting convert at 25-NOV-06
using channel ORA_DISK_1
 
External table SH.SALES_TRANSACTIONS_EXT found in the database
 
Directory SYS.DATA_PUMP_DIR found in the database
Directory SYS.MEDIA_DIR found in the database
Directory SYS.DATA_FILE_DIR found in the database
Directory SYS.LOG_FILE_DIR found in the database
 
BFILE PM.PRINT_MEDIA found in the database
 
User SYS with SYSDBA and SYSOPER privilege found in password file
User OPER with SYSDBA privilege found in password file
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00001 name=/disk1/oracle/dbs/tbs_01.f
converted datafile=/tmp/convertdb/tbs_01.f
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00002 name=/disk1/oracle/dbs/tbs_ax1.f
converted datafile=/tmp/convertdb/tbs_ax1.f
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03
.
.
.
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00016 name=/disk1/oracle/dbs/tbs_52.f
converted datafile=/tmp/convertdb/tbs_52.f
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
Run SQL script /tmp/convertdb/transportscript.sql on the destination platform 
  to create database
Edit init.ora file init_00gb3vfv_1_0.ora. This PFILE will be used to 
  create the database on the destination platform
To recompile all PL/SQL modules, run utlirp.sql and utlrp.sql on 
  the destination platform
To change the internal database identifier, use DBNEWID Utility
Finished backup at 25-NOV-06

VER ACTIVIDAD DML

SELECT TABLE_NAME,INSERTS,UPDATES,DELETES
FROM USER_TAB_MODIFICATIONS
WHERE TABLE_NAME='TABLA'

It is possible to manually flush this data by calling the procedure DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO if you want to get up-to-date information at query time (internally the monitoring data is flushed before all statistics collection operations). You can then see which tables have stale statistics by querying the STALE_STATS column in the USER_TAB_STATISTICS view

PRUEBA RESTORE ORACLE 11G

Fecha del backup: 05-NOV-2014 21:33:45
=~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2014.11.21 10:58:28 =~=~=~=~=~=~=~=~=~=~=~=
date
Fri Nov 21 10:58:41 COT 2014
[oracle@bddesarrollo ~]$
[oracle@bddesarrollo ~]$
[oracle@bddesarrollo ~]$
[oracle@bddesarrollo ~]$ cd /u02/backup/rman/prueba_restauracion
[oracle@bddesarrollo prueba_restauracion]$ ls -lrt
total 11264448
-rwxrwxrwx 1 oracle oinstall   14590464 Nov 21 10:51 archivelog_FONPETP_2spmskhp_1_1_20141105.bak
-rwxrwxrwx 1 oracle oinstall   21856256 Nov 21 10:51 controlfile_c-2150325182-20141105-00.bak
-rwxrwxrwx 1 oracle oinstall 5798445056 Nov 21 10:53 full_FONPETP_2opmsj5l_1_1_20141105.bak
-rwxrwxrwx 1 oracle oinstall 5576212480 Nov 21 10:55 full_FONPETP_2ppmsj5l_1_1_20141105.bak
-rwxrwxrwx 1 oracle oinstall  123649465 Nov 21 10:55 full_asdbp_110514.dmp.gz
-rwxrwxrwx 1 oracle oinstall      28048 Nov 21 10:55 full_asdbp_110514.log.gz
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 11:01:28 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> SYS@fonpetd> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ asmcmd
ASMCMD> cd +DG_DATA
ASMCMD> ls -lrt
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'
Type  Redund  Striped  Time             Sys  Name
                                        Y    ASDBD/
                                        Y    ASM/
                                        Y    DB_UNKNOWN/
                                        Y    FONPETP/
                                        N    fonpetd/
ASMCMD> cd fonpetd/
ASMCMD> ls -lrt
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'
Type           Redund  Striped  Time             Sys  Name
                                                 Y    CONTROLFILE/
                                                 N    DATAFILE/
                                                 Y    ONLINELOG/
                                                 N    TEMPFILE/
                                                 N    spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> rm CONTROLFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 10.
ORA-15032: not all alterations performed
ORA-15173: entry 'CONTROLFILE' does not exist in directory 'fonpetd' (DBD ERROR: OCIStmtExecute)
ASMCMD> rm DATAFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> rn ONLINELOG/
        commands:
        --------
        md_backup, md_restore
        lsattr, setattr
        cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
        mkdir, pwd, rm, rmalias
        chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
        offline, online, rebal, remap, umount
        dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
        spmove, spset, startup
        chtmpl, lstmpl, mktmpl, rmtmpl
        chgrp, chmod, chown, groups, grpmod, lsgrp, lspwusr, lsusr
        mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr
        volcreate, voldelete, voldisable, volenable, volinfo
        volresize, volset, volstat
ASMCMD> ^[[A    rm ONLINELOG/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo01a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo02a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo03a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo08b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo08a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo09a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo09b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo10a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo10b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo11a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo11b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo12b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'ONLINELOG' does not exist in directory 'fonpetd' (DBD ERROR: OCIStmtExecute)
ASMCMD> ls -l
Type           Redund  Striped  Time             Sys  Name
                                                 N    DATAFILE/
                                                 N    TEMPFILE/
                                                 N    spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> rm    pwd
+DG_DATA/fonpetd
ASMCMD> rm DATAFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD-8002: entry '*' does not exist in directory '+DG_DATA/fonpetd/DATAFILE/'
ASMCMD> rm TEMPFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 25.
ORA-15032: not all alterations performed
ORA-15173: entry 'temp01.dbf' does not exist in directory 'TEMPFILE' (DBD ERROR: OCIStmtExecute)
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> ls TEMPFILE/
ASMCMD> ls DATAFILE/
ASMCMD> ls -l
Type           Redund  Striped  Time             Sys  Name
                                                 N    DATAFILE/
                                                 N    TEMPFILE/
                                                 N    spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> exit
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [+ASM] ? fonpetd
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 11:05:29 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.
SYS@fonpetd> alter system set db_name='FONPETP' scope=spfile;                                                start  up nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
SYS@fonpetd> alter system set db_name='FONPETP' scope=spfile;
System altered.
SYS@fonpetd> alter system set db_file_name_convert='+DG_DATA/fonpetp','+DG_DATA/fonpetd' scope=spfile;
System altered.
SYS@fonpetd> alter system set log_file_name_convert='+DG_DATA/fonpetp','+DG_DATA/fonpetd' scope=spfile;
System altered.
SYS@fonpetd> shu immeiate    diate;
ORA-01507: database not mounted

ORACLE instance shut down.
SYS@fonpetd> startup nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
SYS@fonpetd> SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary /. oraenvnv
ORACLE_SID = [fonpetd] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:08:28 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpett backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:08:35
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:08:35
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in  /u02/backup/rman/prueba_restauracion/
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:08:43
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:08:43
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in  /u02/backup/rman/prueba_restauracion/
RMAN>
RMAN>
RMAN> exit

Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:08:46 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:08:48
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:08:48
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in  /u02/backup/rman/prueba_restauracion/
RMAN> restore controlfile from 'controlfile_c-2150325182-20141105-00.bak                                        /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
Starting restore at 21/11/2014 11:10:17
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/21/2014 11:10:17
RMAN-06171: not connected to target database
RMAN> exit

Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary / oraenv
ORACLE_SID = [fonpetd] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$  oraenvrman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:10:33 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN>
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary / oraenv
ORACLE_SID = [fonpetd] ? ^C
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$ ps -efa | grep smon
oracle    3435     1  0 Sep23 ?        00:00:59 asm_smon_+ASM
oracle    3629     1  0 Sep23 ?        00:03:20 ora_smon_asdbd
oracle   27198     1  0 11:08 ?        00:00:00 ora_smon_fonpetd
oracle   27310 25482  0 11:11 pts/0    00:00:00 grep smon
[oracle@bddesarrollo prueba_restauracion]$ ps -efa | grep smon oraenvps -efa | grep smon oraenvrman auxiliary / oraenvrman auxiliary / oraenvrman auxiliary / oraenvrman auxiliary / oraenvps -efa | grep smonps -efa | grep smon oraenvrman auxiliary / oraenvrman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:12:03 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:12:31
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:12:31
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in  /u02/backup/rman/prueba_restauracion/
RMAN> s catalog start with '/u02/backup/rman/prueba_restauracion/';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 11/21/2014 11:13:26
RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted
RMAN> restore controlfile from /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "/"
RMAN> restore controlfile from 0 '/u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
Starting restore at 21/11/2014 11:13:51
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/21/2014 11:13:51
RMAN-06171: not connected to target database
RMAN> exit

Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ connrman auxiliary /target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:13:59 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: FONPETP (not mounted)
RMAN> restore controlfile from '/u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
Starting restore at 21/11/2014 11:14:05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=199 device type=DISK
channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/21/2014 11:14:06
ORA-19870: error while restoring backup piece /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak
ORA-19504: failed to create file "+DG_DATA/fonpetd/controlfile/control01.ctl"
ORA-17502: ksfdcre:4 Failed to create file +DG_DATA/fonpetd/controlfile/control01.ctl
ORA-15173: entry 'controlfile' does not exist in directory 'fonpetd'
RMAN> exit

Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ asmcmd
ASMCMD> cd +DG_DATA/fonpetd/controlfile
ASMCMD-8002: entry 'controlfile' does not exist in directory '+DG_DATA/fonpetd/'
ASMCMD> mkdir +DG_DATA/fonpetd/controlfile
ASMCMD> cd +DG_DATA/fonpetd/
ASMCMD> l -l   s -l
Type           Redund  Striped  Time             Sys  Name
                                                 N    DATAFILE/
                                                 N    TEMPFILE/
                                                 N    controlfile/
                                                 N    spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> mkdir ONLINELOG
ASMCMD> exit
[oracle@bddesarrollo prueba_restauracion]$ asmcmd. oraenvrman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:16:24 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-12001: could not open channel default
RMAN-10008: could not create channel context
RMAN-10002: ORACLE error: ORA-15021: parameter "remote_dependencies_mode" is not valid in asm instance
RMAN-10006: error running SQL statement: alter session set remote_dependencies_mode = signature
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [+ASM] ? fonpetd
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ . oraenvrman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:16:31 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: FONPETP (not mounted)
RMAN>
RMAN> xit   exit

Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman target /. oraenvrman target /asmcmd. oraenvrman target /auxiliary
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:16:55 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:16:56
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:16:56
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in  /u02/backup/rman/prueba_restauracion/
RMAN> catalog start with -/u02/backup/rman/prueba_restauracion/                                      - '/u02/backup/rman/prueba_restauracion/';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 11/21/2014 11:17:50
RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:18:55
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:18:55
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in  /u02/backup/rman/prueba_restauracion/
RMAN> exit

Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:18:57 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:18:58
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:18:58
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in  /u02/backup/rman/prueba_restauracion/
RMAN> run
2> {
3> DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location /u02/backup/rman/prueba_restauracion/';                                       '/u02/backup/rman/prueba_restauracion/';
4> }
Starting Duplicate Db at 21/11/2014 11:19:51
contents of Memory Script:
{
   sql clone "alter system set  db_name =
 ''FONPETP'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile from  '/u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
   alter clone database mount;
}
executing Memory Script
sql statement: alter system set  db_name =  ''FONPETP'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area    1402982400 bytes
Fixed Size                     2228304 bytes
Variable Size               1073745840 bytes
Database Buffers             318767104 bytes
Redo Buffers                   8241152 bytes
Starting restore at 21/11/2014 11:20:00
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=393 device type=DISK
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
output file name=+DG_DATA/fonpetd/controlfile/control01.ctl
output file name=+DG_FRA/fonpetd/controlfile/control02.ctl
Finished restore at 21/11/2014 11:20:07
database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=393 device type=DISK
contents of Memory Script:
{
   set until scn  110586010;
   set newname for datafile  1 to
 "+DG_DATA/fonpetd/datafile/system01.dbf";
   set newname for datafile  2 to
 "+DG_DATA/fonpetd/datafile/sysaux01.dbf";
   set newname for datafile  3 to
 "+DG_DATA/fonpetd/datafile/undotbs101.dbf";
   set newname for datafile  4 to
 "+DG_DATA/fonpetd/datafile/users01.dbf";
   set newname for datafile  5 to
 "+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf";
   set newname for datafile  6 to
 "+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf";
   set newname for datafile  7 to
 "+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf";
   set newname for datafile  8 to
 "+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf";
   set newname for datafile  9 to
 "+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf";
   set newname for datafile  10 to
 "+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf";
   set newname for datafile  11 to
 "+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf";
   set newname for datafile  12 to
 "+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf";
   set newname for datafile  13 to
 "+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf";
   set newname for datafile  14 to
 "+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf";
   set newname for datafile  15 to
 "+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf";
   restore
   clone database
   ;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 21/11/2014 11:20:13
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to +DG_DATA/fonpetd/datafile/system01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00005 to +DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00007 to +DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf
channel ORA_AUX_DISK_1: restoring datafile 00008 to +DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf
channel ORA_AUX_DISK_1: restoring datafile 00010 to +DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00011 to +DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00012 to +DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00015 to +DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak
channel ORA_AUX_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak tag=TAG20141105T211012
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:13:55
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00002 to +DG_DATA/fonpetd/datafile/sysaux01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to +DG_DATA/fonpetd/datafile/undotbs101.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to +DG_DATA/fonpetd/datafile/users01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00006 to +DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf
channel ORA_AUX_DISK_1: restoring datafile 00009 to +DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf
channel ORA_AUX_DISK_1: restoring datafile 00013 to +DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf
channel ORA_AUX_DISK_1: restoring datafile 00014 to +DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak
channel ORA_AUX_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak tag=TAG20141105T211012
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:14:45
Finished restore at 21/11/2014 11:48:55
contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=16 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=17 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=18 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/undotbs101.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=19 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=20 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=21 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=22 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=23 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=24 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=25 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=26 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=27 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=28 STAMP=864215336 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=29 STAMP=864215336 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=30 STAMP=864215336 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf
contents of Memory Script:
{
   set until scn  110586010;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script
executing command: SET until clause
Starting recover at 21/11/2014 11:48:57
using channel ORA_AUX_DISK_1
starting media recovery
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=8884
channel ORA_AUX_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
channel ORA_AUX_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak tag=TAG20141105T213317
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+DG_FRA/fonpetp/archivelog/2014_11_21/thread_1_seq_8884.859.864215339 thread=1 sequence=8884
channel clone_default: deleting archived log(s)
archived log file name=+DG_FRA/fonpetp/archivelog/2014_11_21/thread_1_seq_8884.859.864215339 RECID=1 STAMP=864215338
media recovery complete, elapsed time: 00:00:03
Finished recover at 21/11/2014 11:49:02
Oracle instance started
Total System Global Area    1402982400 bytes
Fixed Size                     2228304 bytes
Variable Size               1073745840 bytes
Database Buffers             318767104 bytes
Redo Buffers                   8241152 bytes
contents of Memory Script:
{
   sql clone "alter system set  db_name =
 ''FONPETD'' comment=
 ''Reset to original value by RMAN'' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script
sql statement: alter system set  db_name =  ''FONPETD'' comment= ''Reset to original value by RMAN'' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area    1402982400 bytes
Fixed Size                     2228304 bytes
Variable Size               1073745840 bytes
Database Buffers             318767104 bytes
Redo Buffers                   8241152 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "FONPETD" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY     2920
 LOGFILE
  GROUP   1 ( '+DG_DATA/fonpetd/onlinelog/redo01a.rdo', '+DG_FRA/fonpetp/onlinelog/redo01b.rdo' ) SIZE 50 M  REUSE,
  GROUP   2 ( '+DG_DATA/fonpetd/onlinelog/redo02a.rdo', '+DG_FRA/fonpetp/onlinelog/redo02b.rdo' ) SIZE 50 M  REUSE,
  GROUP   3 ( '+DG_DATA/fonpetd/onlinelog/redo03a.rdo', '+DG_FRA/fonpetp/onlinelog/redo03b.rdo' ) SIZE 50 M  REUSE,
  GROUP   8 ( '+DG_DATA/fonpetd/onlinelog/redo08b.rdo', '+DG_DATA/fonpetd/onlinelog/redo08a.rdo' ) SIZE 50 M  REUSE,
  GROUP   9 ( '+DG_DATA/fonpetd/onlinelog/redo09a.rdo', '+DG_DATA/fonpetd/onlinelog/redo09b.rdo' ) SIZE 50 M  REUSE,
  GROUP  10 ( '+DG_DATA/fonpetd/onlinelog/redo10a.rdo', '+DG_DATA/fonpetd/onlinelog/redo10b.rdo' ) SIZE 50 M  REUSE,
  GROUP  11 ( '+DG_DATA/fonpetd/onlinelog/redo11a.rdo', '+DG_DATA/fonpetd/onlinelog/redo11b.rdo' ) SIZE 50 M  REUSE,
  GROUP  12 ( '+DG_DATA/fonpetd/onlinelog/redo12b.rdo', '+DG_DATA/fonpetd/onlinelog/redo12a.rdo' ) SIZE 50 M  REUSE
 DATAFILE
  '+DG_DATA/fonpetd/datafile/system01.dbf'
 CHARACTER SET WE8ISO8859P1

contents of Memory Script:
{
   set newname for tempfile  1 to
 "+DG_DATA/fonpetd/tempfile/temp01.dbf";
   switch clone tempfile all;
   catalog clone datafilecopy  "+DG_DATA/fonpetd/datafile/sysaux01.dbf",
 "+DG_DATA/fonpetd/datafile/undotbs101.dbf",
 "+DG_DATA/fonpetd/datafile/users01.dbf",
 "+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf",
 "+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf",
 "+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf",
 "+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf",
 "+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf",
 "+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf",
 "+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf",
 "+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf",
 "+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf",
 "+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf",
 "+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf";
   switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to +DG_DATA/fonpetd/tempfile/temp01.dbf in control file
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/sysaux01.dbf RECID=1 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/undotbs101.dbf RECID=2 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/users01.dbf RECID=3 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf RECID=4 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf RECID=5 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf RECID=6 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf RECID=7 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf RECID=8 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf RECID=9 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf RECID=10 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf RECID=11 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf RECID=12 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf RECID=13 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf RECID=14 STAMP=864215362
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/undotbs101.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf
Reenabling controlfile options for auxiliary database
Executing: alter database force logging
contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 21/11/2014 11:50:00
RMAN> exit

Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ sqlplus dabba_fopnpet as sgsysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 11:50:16 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> select count(1) from dba_segments;
  COUNT(1)
----------
      6314
SYS@fonpetd> select name,     , open_mode, dbid from v$database;
NAME  OPEN_MODE     DBID
--------- -------------------- ----------
FONPETD   READ WRITE       1247845184
SYS@fonpetd> col name format a50
SYS@fonpetd> set lines 1000 pages 10000
SYS@fonpetd> seect   lect name, bytes s, status from v$datafile;
NAMEBYTES STATUS
-------------------------------------------------- ---------- -------
+DG_DATA/fonpetd/datafile/system01.dbf   1461714944 SYSTEM
+DG_DATA/fonpetd/datafile/sysaux01.dbf   2006974464 ONLINE
+DG_DATA/fonpetd/datafile/undotbs101.dbf   1073741824 ONLINE
+DG_DATA/fonpetd/datafile/users01.dbf    196608000 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.db 5309988864 ONLINE
f
+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf    594214912 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf   3463774208 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg 2621440000 ONLINE
0.dbf
+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf    104857600 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf   9154789376 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.db 5146411008 ONLINE
f
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf   3145728000 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf   1073741824 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf   3.4318E+10 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf    7130316800 ONLINE
15 rows selected.
SYS@fonpetd> col name format a50 6
SYS@fonpetd> /
NAME      BYTES STATUS
-------------------------------------------------------- ---------- -------
+DG_DATA/fonpetd/datafile/system01.dbf 1461714944 SYSTEM
+DG_DATA/fonpetd/datafile/sysaux01.dbf 2006974464 ONLINE
+DG_DATA/fonpetd/datafile/undotbs101.dbf 1073741824 ONLINE
+DG_DATA/fonpetd/datafile/users01.dbf  196608000 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf 5309988864 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf  594214912 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf 3463774208 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf  2621440000 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf  104857600 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf 9154789376 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf 5146411008 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf 3145728000 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf 1073741824 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf 3.4318E+10 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf  7130316800 ONLINE
15 rows selected.
SYS@fonpetd>   selec     select member, status from v$logfile;
MEMBER  STATUS
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------
+DG_DATA/fonpetd/onlinelog/redo12b.rdo
+DG_DATA/fonpetd/onlinelog/redo12a.rdo
+DG_DATA/fonpetd/onlinelog/redo11a.rdo
+DG_DATA/fonpetd/onlinelog/redo11b.rdo
+DG_DATA/fonpetd/onlinelog/redo10a.rdo
+DG_DATA/fonpetd/onlinelog/redo10b.rdo
+DG_DATA/fonpetd/onlinelog/redo09a.rdo
+DG_DATA/fonpetd/onlinelog/redo09b.rdo
+DG_DATA/fonpetd/onlinelog/redo08b.rdo
+DG_DATA/fonpetd/onlinelog/redo08a.rdo
+DG_DATA/fonpetd/onlinelog/redo03a.rdo
+DG_FRA/fonpetp/onlinelog/redo03b.rdo
+DG_DATA/fonpetd/onlinelog/redo02a.rdo
+DG_FRA/fonpetp/onlinelog/redo02b.rdo
+DG_DATA/fonpetd/onlinelog/redo01a.rdo
+DG_FRA/fonpetp/onlinelog/redo01b.rdo
16 rows selected.
SYS@fonpetd> ^[[6~      
SYS@fonpetd>
SYS@fonpetd> shw p   pw p    pw pa     ow parameter recovery
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest     string +DG_FRA
db_recovery_file_dest_size     big integer 70G
recovery_parallelism     integer 0
SYS@fonpetd> show    show para  meter unique
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name     string FONPETD
SYS@fonpetd> show parameter db_name
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name      string FONPETD
SYS@fonpetd> spw   show parameter instance_name
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name     string fonpetd
SYS@fonpetd> exit    show     
SYS@fonpetd>
SYS@fonpetd>
SYS@fonpetd> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> xi  exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ asmcmd
ASMCMD> rm    cd +DG_DATA/fonpet   petd
ASMCMD> ls l -l
Type           Redund  Striped  Time             Sys  Name
                                                 N    DATAFILE/
                                                 N    ONLINELOG/
                                                 N    TEMPFILE/
                                                 N    controlfile/
                                                 N    spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD> rm DATAFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> rm ONLINELOG/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo01a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo02a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo03a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo08b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo08a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo09a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo09b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo10a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo10b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo11a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo11b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo12b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo12a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
ASMCMD> rm TEMPFILE/
ORA-15032: not all alterations performed
ORA-15178: directory 'TEMPFILE' is not empty; cannot drop this directory (DBD ERROR: OCIStmtExecute)
ASMCMD>  rm controlfile/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> rm TEMPFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 11.
ORA-15032: not all alterations performed
ORA-15173: entry 'temp01.dbf' does not exist in directory 'TEMPFILE' (DBD ERROR: OCIStmtExecute)
ASMCMD> ls -l
Type           Redund  Striped  Time             Sys  Name
                                                 N    DATAFILE/
                                                 N    ONLINELOG/
                                                 N    TEMPFILE/
                                                 N    controlfile/
                                                 N    spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD> ls -l DATAFILE/
ASMCMD> ls -l ONLINELOG/
ASMCMD> ls -l TEMPFILE/
ASMCMD> ls -l controlfile/
ASMCMD> rm  dir        controlfile/
ASMCMD> M mkdir CONTROLFILE                 rm DATAFILE/
ASMCMD> rm ONLINELOG/
ASMCMD> rm TEMPFILE/
ASMCMD> ls -l
Type           Redund  Striped  Time             Sys  Name
                                                 N    spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD> mkdir DATAFILE/
ASMCMD> mkdir ONLINELOG/
ASMCMD> mkdir TEMPFILE/
ASMCMD> mkdir CONTOLFIL       N   CONTROLFILE
ASMCMD> LS -L     ls-lrt     -lrt
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'
Type           Redund  Striped  Time             Sys  Name
                                                 N    CONTROLFILE/
                                                 N    DATAFILE/
                                                 N    ONLINELOG/
                                                 N    TEMPFILE/
                                                 N    spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD> exit
[oracle@bddesarrollo prueba_restauracion]$ sqlplus da_ / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 12:00:14 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@+ASM>
SYS@+ASM> startup nomount;
ORA-01031: insufficient privileges
SYS@+ASM> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [+ASM] ? fonpetd
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ . oraenvsqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 12:00:45 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.
SYS@fonpetd>
SYS@fonpetd> startup nomout  unt
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
SYS@fonpetd> show parameer  ter dba_  _name
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name      string FONPETD
SYS@fonpetd> show parm ameter uniqie    ique
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name     string FONPETD
SYS@fonpetd> show parameter instance
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count     integer
cluster_database_instances     integer 1
instance_groups      string
instance_name     string fonpetd
instance_number      integer 0
instance_type     string RDBMS
open_links_per_instance      integer 4
parallel_instance_group      string
parallel_server_instances     integer 1
SYS@fonpetd> alter system st   et db_name=FONPETP scope=spfile;
System altered.
SYS@fonpetd> show parameter convert
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert     string +DG_DATA/fonpetp, +DG_DATA/fon
 petd
log_file_name_convert     string +DG_DATA/fonpetp, +DG_DATA/fon
 petd
SYS@fonpetd> shu i     alter system st   et db_file_name_convert='+DG_DATA/fonpetp, +DG_DATA/fonpetd' sc cope=spfile;
alter system set db_file_name_convert='+DG_DATA/fonpetp, +DG_DATA/fonpetd' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-01678: parameter db_file_name_convert must be pairs of pattern and
replacement strings

SYS@fonpetd> alter system set db_file_name_convert='+DG_DATA/fonpetp','+DG_DATA/fonpetd' scope=spfile;
System altered.
SYS@fonpetd> alter system set log_file_name_convert='+DG_DATA/fonpetp0,  ','+DG_DATA/fonpetd' scope=spfile;
System altered.
SYS@fonpetd> s shu mmediate        immediate, ;
ORA-01507: database not mounted

ORACLE instance shut down.
SYS@fonpetd> startup nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
SYS@fonpetd> exi   ext
SP2-0042: unknown command "ext" - rest of line ignored.
SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
[oracle@bddesarrollo prueba_restauracion]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 12:05:11 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: FONPETP (not mounted)
RMAN> restore controlfile from /u02/backup/rman/prueba_restauracion                                    '/u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
Starting restore at 21/11/2014 12:05:38
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=393 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DG_DATA/fonpetd/controlfile/control01.ctl
output file name=+DG_FRA/fonpetd/controlfile/control02.ctl
Finished restore at 21/11/2014 12:05:39
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> crosscheck backup;
Starting implicit crosscheck backup at 21/11/2014 12:06:08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
Crosschecked 10 objects
Finished implicit crosscheck backup at 21/11/2014 12:06:10
Starting implicit crosscheck copy at 21/11/2014 12:06:10
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 21/11/2014 12:06:10
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2jpmpuph_1_1_20141104.bak RECID=2034 STAMP=862780213
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2ipmpuph_1_1_20141104.bak RECID=2035 STAMP=862780209
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2lpmq03u_1_1_20141104.bak RECID=2037 STAMP=862781567
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/controlfile_c-2150325182-20141104-00.bak RECID=2039 STAMP=862781604
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2ppmsj5l_1_1_20141105.bak RECID=2040 STAMP=862866617
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2opmsj5l_1_1_20141105.bak RECID=2041 STAMP=862866614
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2qpmskgv_1_1_20141105.bak RECID=2042 STAMP=862867999
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2rpmskh0_1_1_20141105.bak RECID=2043 STAMP=862868000
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2spmskhp_1_1_20141105.bak RECID=2044 STAMP=862868025
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/controlfile_FONPETP_2tpmski1_1_1_20141105.bak RECID=2045 STAMP=862868034
Crosschecked 10 objects
RMAN-08591: WARNING: invalid archived log deletion policy
RMAN> cro   crosscheck archivel  l ogg  ll  all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
specification does not match any archived log in the repository
RMAN> cro   delete expired backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
2034    2031    1   1   EXPIRED     DISK        /u03/backups/rman/fonpetp/full_FONPETP_2jpmpuph_1_1_20141104.bak
2035    2032    1   1   EXPIRED     DISK        /u03/backups/rman/fonpetp/full_FONPETP_2ipmpuph_1_1_20141104.bak
2037    2034    1   1   EXPIRED     DISK        /u03/backups/rman/fonpetp/archivelog_FONPETP_2lpmq03u_1_1_20141104.bak
2039    2036    1   1   EXPIRED     DISK        /u03/backups/rman/fonpetp/controlfile_c-2150325182-20141104-00.bak
2040    2037    1   1   EXPIRED     DISK        /u03/backups/rman/fonpetp/full_FONPETP_2ppmsj5l_1_1_20141105.bak
2041    2038    1   1   EXPIRED     DISK        /u03/backups/rman/fonpetp/full_FONPETP_2opmsj5l_1_1_20141105.bak
2042    2039    1   1   EXPIRED     DISK        /u03/backups/rman/fonpetp/archivelog_FONPETP_2qpmskgv_1_1_20141105.bak
2043    2040    1   1   EXPIRED     DISK        /u03/backups/rman/fonpetp/archivelog_FONPETP_2rpmskh0_1_1_20141105.bak
2044    2041    1   1   EXPIRED     DISK        /u03/backups/rman/fonpetp/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
2045    2042    1   1   EXPIRED     DISK        /u03/backups/rman/fonpetp/controlfile_FONPETP_2tpmski1_1_1_20141105.bak
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2jpmpuph_1_1_20141104.bak RECID=2034 STAMP=862780213
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2ipmpuph_1_1_20141104.bak RECID=2035 STAMP=862780209
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2lpmq03u_1_1_20141104.bak RECID=2037 STAMP=862781567
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/controlfile_c-2150325182-20141104-00.bak RECID=2039 STAMP=862781604
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2ppmsj5l_1_1_20141105.bak RECID=2040 STAMP=862866617
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2opmsj5l_1_1_20141105.bak RECID=2041 STAMP=862866614
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2qpmskgv_1_1_20141105.bak RECID=2042 STAMP=862867999
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2rpmskh0_1_1_20141105.bak RECID=2043 STAMP=862868000
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2spmskhp_1_1_20141105.bak RECID=2044 STAMP=862868025
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/controlfile_FONPETP_2tpmski1_1_1_20141105.bak RECID=2045 STAMP=862868034
Deleted 10 EXPIRED objects
RMAN-08591: WARNING: invalid archived log deletion policy
RMAN> delete expired ARCHIVELOG ALL;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
specification does not match any archived log in the repository
RMAN> restore        
RMAN> catalog da  start i with '/u02/backup/rman/prueba_restauracion';
searching for all files that match the pattern /u02/backup/rman/prueba_restauracion
List of Files Unknown to the Database
=====================================
File Name: /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak
File Name: /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_asdbp_110514.dmp.gz
File Name: /u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_asdbp_110514.log.gz
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak
File Name: /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak
List of Files Which Where Not Cataloged
=======================================
File Name: /u02/backup/rman/prueba_restauracion/full_asdbp_110514.dmp.gz
  RMAN-07517: Reason: The file header is corrupted
File Name: /u02/backup/rman/prueba_restauracion/full_asdbp_110514.log.gz
  RMAN-07517: Reason: The file header is corrupted
RMAN> restore database;
Starting restore at 21/11/2014 12:08:27
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DG_DATA/fonpetp/datafile/system01.dbf
channel ORA_DISK_1: restoring datafile 00005 to +DG_DATA/fonpetp/datafile/indic_fonpet_movim_01.dbf
channel ORA_DISK_1: restoring datafile 00007 to +DG_DATA/fonpetp/datafile/indic_fonpet_movim.dbf
channel ORA_DISK_1: restoring datafile 00008 to +DG_DATA/fonpetp/datafile/indic_fonpet_movim_reorg0.dbf
channel ORA_DISK_1: restoring datafile 00010 to +DG_DATA/fonpetp/datafile/ts_fonpet_movim_01.dbf
channel ORA_DISK_1: restoring datafile 00011 to +DG_DATA/fonpetp/datafile/indic_fonpet_movim_02.dbf
channel ORA_DISK_1: restoring datafile 00012 to +DG_DATA/fonpetp/datafile/ts_fonpet_movim_02.dbf
channel ORA_DISK_1: restoring datafile 00015 to +DG_DATA/fonpetp/datafile/ts_fonpet_movim_2.dbf
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak
channel ORA_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak tag=TAG20141105T211012
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:14:06
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to +DG_DATA/fonpetp/datafile/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to +DG_DATA/fonpetp/datafile/undotbs101.dbf
channel ORA_DISK_1: restoring datafile 00004 to +DG_DATA/fonpetp/datafile/users01.dbf
channel ORA_DISK_1: restoring datafile 00006 to +DG_DATA/fonpetp/datafile/indic_fonpet_param.dbf
channel ORA_DISK_1: restoring datafile 00009 to +DG_DATA/fonpetp/datafile/ts_fonpet_param.dbf
channel ORA_DISK_1: restoring datafile 00013 to +DG_DATA/fonpetp/datafile/ts_fonpet_rep.dbf
channel ORA_DISK_1: restoring datafile 00014 to +DG_DATA/fonpetp/datafile/ts_fonpet_movim.dbf
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak
channel ORA_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak tag=TAG20141105T211012
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:14:55
Finished restore at 21/11/2014 12:37:28
RMAN>
RMAN> exit

Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ aexport rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 12:53:47 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: FONPETP (DBID=2150325182, not open)
RMAN> LIST BACKU   UP OF ARCHIVELOG ALL<
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "<"
RMAN> LIST BACKUP OF ARCHIVELOG ALL< < ;
using target database control file instead of recovery catalog
List of Backup Sets
===================

BS Key  Size       Device Type Elapsed Time Completion Time   
------- ---------- ----------- ------------ -------------------
2043    13.91M     DISK        00:00:00     05/11/2014 21:33:45
        BP Key: 2046   Status: AVAILABLE  Compressed: NO  Tag: TAG20141105T213317
        Piece Name: /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
  List of Archived Logs in backup set 2043
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    8884    110575832  05/11/2014 20:00:09 110586010  05/11/2014 21:33:15
RMAN> restoe  o     recover         list backup of controlfile<
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "<"
RMAN>  list backup of controlfileñ ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, controlfile, database, datafile, foreign, spfile, tablespace"
RMAN-01008: the bad identifier was: controlfile
RMAN-01007: at line 1 column 17 file: standard input
RMAN> lit   l list backup of controlfile;
specification does not match any backup in the repository
RMAN> recover database until logseq 8884;  5. ;
Starting recover at 21/11/2014 12:55:15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=580 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/21/2014 12:55:16
ORA-19698: +DG_FRA/fonpetp/onlinelog/redo01b.rdo is from different database: id=1247845184, db_name=FONPETD
RMAN> re  exit

Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysbasdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 12:57:04 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> show parameer  ter db_bame
SYS@fonpetd> show parameter db_name
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name      string FONPETP
SYS@fonpetd> alter system se  set db_name=' 'FONPETP' scope=spfi             D' scope=spfie  ile;
alter system set db_name='FONPETD' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-32016: parameter "db_name" cannot be updated in SPFILE

SYS@fonpetd> shu immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> startup nomount pfile;       ;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
SYS@fonpetd> alter system set db_name='FONPETD' scope=spfile
  2  ;
System altered.
SYS@fonpetd> al  alter       shu immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
ORA-01103: database name 'FONPETP' in control file is not 'FONPETD'

SYS@fonpetd> show parameter lo  convert
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert     string +DG_DATA/fonpetp, +DG_DATA/fon
 petd
log_file_name_convert     string +DG_DATA/fonpetp, +DG_DATA/fon
 petd
SYS@fonpetd> alter     alter sye  ession  =       ystem set db_name=FONPETD P scope? =sf pfile;
System altered.
SYS@fonpetd> shu immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
[oracle@bddesarrollo prueba_restauracion]$  .oa oraenv}
ORACLE_SID = [fonpetd] ? *AS   +as  ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ cd +DG_FRA/fonpetp/onlinelog/redo01b.rdo
-bash: cd: +DG_FRA/fonpetp/onlinelog/: No such file or directory
[oracle@bddesarrollo prueba_restauracion]$ ls -lasmcmd
ASMCMD> cd +DG_FRA/fonpetp/onlinelog/
ASMCMD> ls -lr
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'
Type       Redund  Striped  Time             Sys  Name
                                             N    redo03b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_3.707.864215385
                                             N    redo02b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_2.706.864215383
                                             N    redo01b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_1.705.864215383
ASMCMD> rm    ls l-  -l
Type       Redund  Striped  Time             Sys  Name
                                             N    redo01b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_1.705.864215383
                                             N    redo02b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_2.706.864215383
                                             N    redo03b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_3.707.864215385
ASMCMD> rm redo*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> exit
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [+ASM] ? fonped   petd
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 13:01:35 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database (not started)
RMAN> alter database mount;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 11/21/2014 13:01:42
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
RMAN> startup mount;
Oracle instance started
database mounted
Total System Global Area    1402982400 bytes
Fixed Size                     2228304 bytes
Variable Size               1073745840 bytes
Database Buffers             318767104 bytes
Redo Buffers                   8241152 bytes
RMAN> list backup of archivelog all;

List of Backup Sets
===================

BS Key  Size       Device Type Elapsed Time Completion Time   
------- ---------- ----------- ------------ -------------------
2043    13.91M     DISK        00:00:00     05/11/2014 21:33:45
        BP Key: 2046   Status: AVAILABLE  Compressed: NO  Tag: TAG20141105T213317
        Piece Name: /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
  List of Archived Logs in backup set 2043
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    8884    110575832  05/11/2014 20:00:09 110586010  05/11/2014 21:33:15
RMAN> recover database until logeq 8884 5;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "scn, sequence, time"
RMAN-01008: the bad identifier was: logeq
RMAN-01007: at line 1 column 24 file: standard input
RMAN> recover database until logseq 8885;
Starting recover at 21/11/2014 13:02:37
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=8 device type=DISK
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=8884
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
channel ORA_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak tag=TAG20141105T213317
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+DG_FRA/fonpetp/archivelog/2014_11_21/thread_1_seq_8884.707.864219759 thread=1 sequence=8884
channel default: deleting archived log(s)
archived log file name=+DG_FRA/fonpetp/archivelog/2014_11_21/thread_1_seq_8884.707.864219759 RECID=27540 STAMP=864219759
media recovery complete, elapsed time: 00:00:03
Finished recover at 21/11/2014 13:02:43
RMAN> alter database open resetlogs;
database opened
RMAN> exit

Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman target /. oraenvrman target /sqlplus / as ssdbaysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:05:37 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> select name, dbid, statos    s us                          
SYS@fonpetd>
SYS@fonpetd> ^[[A^[[A        exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdbarman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 13:06:01 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: FONPETP (DBID=2150325182)
RMAN> sql 'select name, dbid  , open_mode rom v     from v$database';
using target database control file instead of recovery catalog
sql statement: select name, dbid, open_mode from v$database
RMAN> exit

Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman target /sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:06:40 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> select name, dbid, open_mode from v$database;
NAMEDBID OPEN_MODE
--------- ---------- --------------------
FONPETP   2150325182 READ WRITE
SYS@fonpetd> altr syste set    m set               shu   shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
Database mounted.
SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ dbnewid
-bash: dbnewid: command not found
[oracle@bddesarrollo prueba_restauracion]$ dbnewidnid
DBNEWID: Release 11.2.0.3.0 - Production on Fri Nov 21 13:07:56 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Keyword     Description                    (Default)
----------------------------------------------------
TARGET      Username/Password              (NONE)
DBNAME      New database name              (NONE)
LOGFILE     Output Log                     (NONE)
REVERT      Revert failed change           NO
SETNAME     Set a new database name only   NO
APPEND      Append to output log           NO
HELP        Displays these messages        NO
[oracle@bddesarrollo prueba_restauracion]$ nid TARGET=7/ as sysda DBNAME=FONPED
DBNEWID: Release 11.2.0.3.0 - Production on Fri Nov 21 13:08:15 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to database FONPETP (DBID=2150325182)
Connected to server version 11.2.0
Control Files in database:
    +DG_DATA/fonpetd/controlfile/control01.ctl
    +DG_FRA/fonpetd/controlfile/control02.ctl
Change database ID and database name FONPETP to FONPED? (Y/[N]) => y Y
Proceeding with operation
Changing database ID from 2150325182 to 2659586623
Changing database name from FONPETP to FONPED
    Control File +DG_DATA/fonpetd/controlfile/control01.ctl - modified
    Control File +DG_FRA/fonpetd/controlfile/control02.ctl - modified
    Datafile +DG_DATA/fonpetp/datafile/system01.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/sysaux01.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/undotbs101.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/users01.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_01.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_param.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_reorg0.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_param.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_01.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_02.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_02.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_rep.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_2.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/tempfile/temp01.db - dbid changed, wrote new name
    Control File +DG_DATA/fonpetd/controlfile/control01.ctl - dbid changed, wrote new name
    Control File +DG_FRA/fonpetd/controlfile/control02.ctl - dbid changed, wrote new name
    Instance shut down
Database name changed to FONPED.
Modify parameter file and generate a new password file before restarting.
Database ID for database FONPED changed to 2659586623.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
[oracle@bddesarrollo prueba_restauracion]$ nid TARGET=/ DBNAME=FONPEDnid TARGET=/ DBNAME=FONPEDtDDTD
DBNEWID: Release 11.2.0.3.0 - Production on Fri Nov 21 13:09:09 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

NID-00106: LOGIN to target database failed with Oracle error:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0

Change of database name failed during validation - database is intact.
DBNEWID - Completed with validation errors.
[oracle@bddesarrollo prueba_restauracion]$ .sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:09:18 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
ORA-01103: database name 'FONPED' in control file is not 'FONPETP'

SYS@fonpetd> show parameter dba_name
SYS@fonpetd> show mara   p  parameter db_name
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name      string FONPETP
SYS@fonpetd> shw     show parameter              ^[[A    alter       exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
[oracle@bddesarrollo prueba_restauracion]$ rmarrman rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 13:10:46 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: FONPETP (not mounted)
RMAN> list incart nation of database;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 11/21/2014 13:10:51
ORA-01507: database not mounted
RMAN> alter       exit

Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ salter system setrman target /sqlplus / as sysdbanid TARGET=/ DBNAME=FONPETDsqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:11:07 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> altersytem set            system set dbn _name=^[[5~       'FONPED. '
  2 
SYS@fonpetd> shu abort;
ORACLE instance shut down.
SYS@fonpetd> start     startuu p nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
SYS@fonpetd> alter system set db_name='FONPED'
  2  scope=spfile;
System altered.
SYS@fonpetd> shu abort;
ORACLE instance shut down.
SYS@fonpetd> startup nomoun      mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
Database mounted.
SYS@fonpetd> alter database open resetlogs;
Database altered.
SYS@fonpetd> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
Database mounted.
SYS@fonpetd> alter       exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdbarman target /sqlplus / as sysdbanid TARGET=/ DBNAME=FONPETD
DBNEWID: Release 11.2.0.3.0 - Production on Fri Nov 21 13:14:32 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to database FONPED (DBID=2659586623)
Connected to server version 11.2.0
Control Files in database:
    +DG_DATA/fonpetd/controlfile/control01.ctl
    +DG_FRA/fonpetd/controlfile/control02.ctl
Change database ID and database name FONPED to FONPETD? (Y/[N]) => y
Proceeding with operation
Changing database ID from 2659586623 to 1247841337
Changing database name from FONPED to FONPETD
    Control File +DG_DATA/fonpetd/controlfile/control01.ctl - modified
    Control File +DG_FRA/fonpetd/controlfile/control02.ctl - modified
    Datafile +DG_DATA/fonpetp/datafile/system01.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/sysaux01.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/undotbs101.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/users01.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_01.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_param.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_reorg0.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_param.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_01.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_02.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_02.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_rep.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_2.db - dbid changed, wrote new name
    Datafile +DG_DATA/fonpetp/tempfile/temp01.db - dbid changed, wrote new name
    Control File +DG_DATA/fonpetd/controlfile/control01.ctl - dbid changed, wrote new name
    Control File +DG_FRA/fonpetd/controlfile/control02.ctl - dbid changed, wrote new name
    Instance shut down
Database name changed to FONPETD.
Modify parameter file and generate a new password file before restarting.
Database ID for database FONPETD changed to 1247841337.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
[oracle@bddesarrollo prueba_restauracion]$ orapwd file?=$ORACLE_HOME /NETnet/u01/app/oracle/product/11.2.0/dbhome_1/network/dbs/pwdf/orapwfonpetd passwoforce=Y password?0=Nuevuevo123 entries?=43
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:15:46 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.
SYS@fonpetd> startup nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
SYS@fonpetd> alter       show parameter db_bame    name
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name      string FONPED
SYS@fonpetd> alter syte set                alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01103: database name 'FONPETD' in control file is not 'FONPED'

SYS@fonpetd> a alter syste se   mt    set db_name=FON   'FONPETD' soc  cope? =spfile;
System altered.
SYS@fonpetd> shu   s shu a i¿       shu abort;
ORACLE instance shut down.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size    2228304 bytes
Variable Size 1073745840 bytes
Database Buffers  318767104 bytes
Redo Buffers    8241152 bytes
Database mounted.
SYS@fonpetd> alter database open s resetlogs;
Database altered.
SYS@fonpetd>