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>