Clonación de una Base de Datos Oracle 11gR2 Activa usando RMAN. CLONACIÓN DE UNA BASE DE DATOS ORACLE 11gR2 ACTIVA USANDO RMAN

(1)

1

CLONACIÓN DE UNA BASE DE DATOS ORACLE

11gR2 ACTIVA USANDO RMAN

Autor

:

Luis Alberto Flores Zapata

(2)

2

Contenido

CLONACIÓN DE UNA BASE DE DATOS ORACLE 11gR2 ACTIVA USANDO RMAN ... 3

1. Objetivo ... 3

2. Información acerca de la Base de Datos Origen y Destino ... 3

3. Crear el archivo de inicialización de parámetros para la instancia Auxiliar ... 4

4. Crear un password file para la instancia Auxiliar ... 5

5. Agregar las entradas correspondientes en los archivos listener.ora y tnsnames.ora en el

servidor Auxiliar y Target ... 5

6. Iniciar la instancia Auxiliar ... 10

7. En la instancia Auxiliar con RMAN realizar la duplicación de la Base de Datos ... 11

8. Crear archivo spfile para la Base de Datos Clonada ... 23

(3)

3

CLONACIÓN DE UNA BASE DE DATOS ORACLE 11gR2 ACTIVA USANDO

RMAN

1. Objetivo

Oracle 11g introdujo la habilidad para crear Bases de Datos duplicadas directamente sin la

necesidad de un respaldo. Este es conocido como duplicación de Base de Datos activa.

Igualmente este método de duplicación tiene algunas desventajas como:

-

Impacto negativo en la performance de la Base de Datos origen.

-

Alto tráfico de red sobre la conexión entre la Base de Datos origen y destino

2. Información acerca de la Base de Datos Origen y Destino

Para el presente laboratorio se utilizó lo siguiente:

Base de Datos origen:

Database name: TST10GDB

Single instance

Version: 11.2.0.3

Hostname: bdtest_oracle.localdomain (10.4.22.103)

Filesystem: ASM

Base de Datos destino:

Database name: TEST2

Single instance

Version: 11.2.0.3

Hostname: bdtest.localdomain (10.4.22.58)

Filesystem: ASM

(4)

4 3. Crear el archivo de inicialización de parámetros para la instancia Auxiliar

[oracle@bdtest dbs]$ more initTEST2.ora

*.audit_file_dest='/oracle/admin/STDYDB/adump' *.audit_trail='db' *.compatible='11.2.0.1.0' *.db_block_size=8192 *.db_create_file_dest='+DATATESTDB2' *.db_create_online_log_dest_1='+DATATESTDB2' *.db_create_online_log_dest_2='+FRATESTDB2' *.db_domain='' *.db_name='TEST2' *.db_recovery_file_dest='+FRATESTDB2' *.db_recovery_file_dest_size=2147483648 *.diagnostic_dest='/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=TEST2XDB)'

*.local_listener='(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.22.58)(PORT = 1522)))' *.log_archive_format='TEST2_%t_%s_%r.arc' *.memory_target=314572800 *.open_cursors=300 *.processes=300 *.remote_login_passwordfile='EXCLUSIVE' *.sessions=335 *.undo_tablespace='UNDOTBS1'

(5)

5 4. Crear un password file para la instancia Auxiliar

Las passwords en los password files deben coincidir para ambos servidores

[oracle@bdtest dbs]$ orapwd file=orapwTEST2 password=tst#8mgt entries=20

5. Agregar las entradas correspondientes en los archivos listener.ora y

tnsnames.ora en el servidor Auxiliar y Target

En Servidor Auxiliar:

[grid@bdtest admin]$ more listener.ora # listener.ora Network Configuration File:

/oracle/product/11.2.0.3/grid/network/admin/listener.ora # Generated by Oracle configuration tools.

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = STDYDB) (ORACLE_HOME = /oracle/product/11.2.0.3/db_TESTDB2) (SID_NAME = STDYDB) ) (SID_DESC = (GLOBAL_DBNAME = STDYDB_DGMGRL) (ORACLE_HOME = /oracle/product/11.2.0.3/db_TESTDB2) (SID_NAME = STDYDB) ) (SID_DESC = (GLOBAL_DBNAME = TEST2) (ORACLE_HOME = /oracle/product/11.2.0.3/db_TESTDB2) (SID_NAME = TEST2) ) )

(6)

6

LISTENER =

(DESCRIPTION_LIST = (DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522)) )

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.22.58)(PORT = 1522)) )

)

ADR_BASE_LISTENER = /oracle

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

(7)

7 En Servidor Auxiliar:

[oracle@bdtest admin]$ more tnsnames.ora # tnsnames.ora Network Configuration File:

/oracle/product/11.2.0.3/db_TESTDB2/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

TST10GDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.22.103)(PORT = 1522))

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TST10GDB) ) ) TEST2 = (DESCRIPTION = (ADDRESS_LIST =

) (CONNECT_DATA = (SERVICE_NAME = TEST2) ) ) STDYDB = (DESCRIPTION = (ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.22.58)(PORT = 1522)) )

(8)

8

(CONNECT_DATA = (SERVICE_NAME = STDYDB) ) ) PRIMDB = (DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.22.103)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PRIMDB) ) ) LISTENER_STDYDB =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.22.58)(PORT = 1522))

LISTENER_TEST2 =

(9)

9 En Servidor Target:

[oracle@bdtest_oracle admin]$ more tnsnames.ora # tnsnames.ora Network Configuration File:

/oracle/product/11.2.0.3/db_TEST11GDB/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

TST10GDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = bdtest_oracle.localdomain)(PORT = 1522))

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TST10GDB) ) ) LISTENER_TST10GDB =

(ADDRESS = (PROTOCOL = TCP)(HOST = bdtest_oracle.localdomain)(PORT = 1522))

TEST2 =

(DESCRIPTION =

(ADDRESS_LIST =

) (CONNECT_DATA = (SERVICE_NAME = TEST2) ) ) TST10GDB_STBY = (DESCRIPTION =

(10)

10

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.22.58)(PORT = 1522)) (CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = TST10GDB_STBY) )

)

6. Iniciar la instancia Auxiliar

[oracle@bdtest ~]$ srvctl add database -d TEST2 -o /oracle/product/11.2.0.3/db_TESTDB2 [oracle@bdtest dbs]$ srvctl start database -d TEST2 -o nomount

[grid@bdtest admin]$ crsctl stat res -t

--- NAME TARGET STATE SERVER STATE_DETAILS --- Local Resources

--- ora.DATATESTDB2.dg

ONLINE ONLINE bdtest ora.FRATESTDB2.dg

ONLINE ONLINE bdtest ora.LISTENER.lsnr

ONLINE ONLINE bdtest ora.asm

ONLINE ONLINE bdtest Started ora.ons

OFFLINE OFFLINE bdtest

--- Cluster Resources

--- ora.cssd

(11)

11

1 ONLINE ONLINE bdtest ora.diskmon

1 OFFLINE OFFLINE ora.evmd

1 ONLINE ONLINE bdtest ora.stdydb.db

1 ONLINE ONLINE bdtest Open ora.test2.db

1 ONLINE INTERMEDIATE bdtest Dismounted

7. En la instancia Auxiliar con RMAN realizar la duplicación de la Base de Datos

[oracle@bdtest ~]$ rman target sys/tst#8mgt@TST10GDB auxiliary sys/tst#8mgt@TEST2

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Aug 1 16:55:59 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: TST10GDB (DBID=744104809)

connected to auxiliary database: TEST2 (not mounted) RMAN> DUPLICATE TARGET DATABASE

TO 'TEST2'

2> 3> FROM ACTIVE DATABASE;

Starting Duplicate Db at 01-AUG-2013 16:56:33

using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=19 device type=DISK contents of Memory Script:

{

sql clone "create spfile from memory"; }

executing Memory Script

sql statement: create spfile from memory contents of Memory Script:

{

shutdown clone immediate; startup clone nomount; }

executing Memory Script Oracle instance shut down

connected to auxiliary database (not started) Oracle instance started

Total System Global Area 313159680 bytes Fixed Size 2227944 bytes Variable Size 222298392 bytes

(12)

12

Database Buffers 83886080 bytes Redo Buffers 4747264 bytes contents of Memory Script:

{

sql clone "alter system set control_files =

''+DATATESTDB2/test2/controlfile/current.256.822329809'', ''+FRATESTDB2/test2/controlfile/current.413.822329809'' comment= ''Set by RMAN'' scope=spfile";

sql clone "alter system set db_name = ''TST10GDB'' comment=

''Modified by RMAN duplicate'' scope=spfile"; sql clone "alter system set db_unique_name = ''TEST2'' comment=

''Modified by RMAN duplicate'' scope=spfile"; shutdown clone immediate;

startup clone force nomount

backup as copy current controlfile auxiliary format '+DATATESTDB2/test2/controlfile/current.265.822329809';

restore clone controlfile to '+FRATESTDB2/test2/controlfile/current.408.822329809' from '+DATATESTDB2/test2/controlfile/current.265.822329809';

sql clone "alter system set control_files =

''+DATATESTDB2/test2/controlfile/current.265.822329809'', ''+FRATESTDB2/test2/controlfile/current.408.822329809'' comment= ''Set by RMAN'' scope=spfile";

shutdown clone immediate; startup clone nomount; alter clone database mount; }

sql statement: alter system set control_files = ''+DATATESTDB2/test2/controlfile/current.256.822329809'',

''+FRATESTDB2/test2/controlfile/current.413.822329809'' comment= ''Set by RMAN'' scope=spfile sql statement: alter system set db_name = ''TST10GDB'' comment= ''Modified by RMAN

duplicate'' scope=spfile

sql statement: alter system set db_unique_name = ''TEST2'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down Oracle instance started

Total System Global Area 313159680 bytes Fixed Size 2227944 bytes Variable Size 222298392 bytes Database Buffers 83886080 bytes Redo Buffers 4747264 bytes Starting backup at 01-AUG-2013 16:56:59 allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=56 device type=DISK channel ORA_DISK_1: starting datafile copy copying current control file

output file name=/oracle/product/11.2.0.3/db_TEST11GDB/dbs/snapcf_TST10GDB.f tag=TAG20130801T165653 RECID=12 STAMP=822329814

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 Finished backup at 01-AUG-2013 16:57:02

Starting restore at 01-AUG-2013 16:57:02 allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=23 device type=DISK channel ORA_AUX_DISK_1: copied control file copy

(13)

13

Finished restore at 01-AUG-2013 16:57:04

sql statement: alter system set control_files = ''+DATATESTDB2/test2/controlfile/current.265.822329809'',

''+FRATESTDB2/test2/controlfile/current.408.822329809'' comment= ''Set by RMAN'' scope=spfile Oracle instance shut down

Total System Global Area 313159680 bytes Fixed Size 2227944 bytes Variable Size 222298392 bytes Database Buffers 83886080 bytes Redo Buffers 4747264 bytes database mounted

contents of Memory Script: {

set newname for clone datafile 1 to new; set newname for clone datafile 2 to new; set newname for clone datafile 3 to new; set newname for clone datafile 4 to new; backup as copy reuse

datafile 1 auxiliary format new datafile 2 auxiliary format new datafile 3 auxiliary format new datafile 4 auxiliary format new ;

sql 'alter system archive log current'; }

executing Memory Script executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME

Starting backup at 01-AUG-2013 16:57:22 using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001 name=+DATA/tst10gdb/datafile/system.259.817260759 output file name=+DATATESTDB2/test2/datafile/system.264.822329843 tag=TAG20130801T165715 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25

input datafile file number=00004 name=+DATA/tst10gdb/datafile/users.262.817260903 output file name=+DATATESTDB2/test2/datafile/users.262.822329867 tag=TAG20130801T165715 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25

input datafile file number=00002 name=+DATA/tst10gdb/datafile/undotbs1.260.817260819 output file name=+DATATESTDB2/test2/datafile/undotbs1.282.822329893 tag=TAG20130801T165715 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25

input datafile file number=00003 name=+DATA/tst10gdb/datafile/sysaux.261.817260851 output file name=+DATATESTDB2/test2/datafile/sysaux.283.822329919 tag=TAG20130801T165715 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25

Finished backup at 01-AUG-2013 16:59:03

sql statement: alter system archive log current contents of Memory Script:

(14)

14

{

backup as copy reuse

archivelog like "+FRA/tst10gdb/archivelog/2013_08_01/thread_1_seq_171.472.822329937" auxiliary format

"+FRATESTDB2" ;

catalog clone start with "+FRATESTDB2"; switch clone datafile all;

}

Starting backup at 01-AUG-2013 16:59:04 using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log copy

input archived log thread=1 sequence=171 RECID=78 STAMP=822329937

output file name=+FRATESTDB2/test2/archivelog/2013_08_01/thread_1_seq_171.406.822329945 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01 Finished backup at 01-AUG-2013 16:59:05

searching for all files that match the pattern +FRATESTDB2 List of Files Unknown to the Database

=====================================

File Name: +fratestdb2/TEST2/ARCHIVELOG/2013_08_01/thread_1_seq_171.406.822329945 File Name: +fratestdb2/TEST2/CONTROLFILE/Current.413.822329809

File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_165.366.822290443 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_166.367.822302347 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_167.368.822302349 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_168.369.822302359 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_169.370.822302359 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_170.371.822302363 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_171.372.822302415 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_172.373.822302891 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_173.374.822303867 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_174.375.822303871 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_175.376.822304049 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_176.377.822304051 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_177.378.822304309 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_178.379.822305065 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_179.380.822305169 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_180.381.822305175 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_181.382.822305181 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_182.383.822305183 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_183.384.822305187 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_184.385.822305501 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_185.386.822305825 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_186.387.822306107 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_187.388.822306109 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_188.389.822306161 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_189.390.822306521 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_190.391.822306671 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_191.392.822306673 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_192.393.822306679 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_193.394.822306681 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_194.395.822306685 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_195.396.82230696 9 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_196.397.822307031 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_197.398.822307033 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_198.399.822307067 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_199.400.822307237 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_200.401.822307239 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_201.402.822307249 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_202.403.822307251 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_203.404.822307253 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_204.405.822307597 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_148.349.822186917 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_149.350.822221589

(15)

15

File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_150.351.822221593 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_151.352.822221635 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_152.353.822249135 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_153.354.822249791 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_154.355.822249795 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_155.356.822249801 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_156.357.822249803 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_157.358.822249805 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_158.359.822250115 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_159.360.822250265 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_160.361.822250289 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_161.362.822250815 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_162.363.822250819 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_163.364.822250863 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_164.365.822251105 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_63.331.822128571 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_64.330.822128571 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_65.329.822129567 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_66.328.822129575 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_67.327.822129585 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_68.326.822131661 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_69.325.822132161 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_70.324.822132165 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_71.323.822132171 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_72.322.822132171 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_73.321.822132177 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_74.320.822132273 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_75.319.822132555 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_76.318.822132557 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_77.317.822132607 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_78.316.822138791 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_79.315.822139599 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_80.314.822139601 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_81.313.822139607 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_82.312.822139607 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_83.311.822139613 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_84.310.822139971 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_85.309.822140341 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_86.308.822140361 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_87.307.822140809 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_88.306.822140813 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_89.305.822140877 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_90.304.822149103 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_91.303.822149183 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_92.302.822149187 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_93.301.822149193 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_94.300.822149195 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_95.299.822149197 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_96.298.822149247 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_97.297.822150175 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_98.296.822150195 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_99.295.822150905 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_100.294.822150905 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_101.293.822150951 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_102.292.822151913 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_103.291.822152003 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_104.290.822152005 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_105.289.822152011 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_106.288.822152013 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_107.287.822152017 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_108.286.822152375 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_109.285.822152827 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_110.284.822152847 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_111.283.822153503 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_112.282.822153505 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_113.281.822153545 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_114.280.822155107

(16)

16

File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_115.279.822155451 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_116.278.822155453 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_117.277.822155459 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_118.276.822155459 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_119.275.822155463 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_120.274.822155779 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_121.257.822156483 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_122.258.822156505 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_123.259.822156609 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_124.256.822156661 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_125.263.822157733 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_126.261.822157733 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_127.260.822158163 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_128.262.822158277 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_129.267.822158281 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_130.268.822158287 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_131.271.822158287 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_132.273.822158291 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_133.266.822158617 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_134.265.822159005 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_135.336.822159183 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_136.337.822159499 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_137.338.822159503 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_138.339.822159543 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_139.340.822160627 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_140.341.822161909 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_141.342.822161913 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_142.343.822161919 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_143.344.822161919 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_144.345.822161923 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_145.346.822162255 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_146.347.822162883 File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_147.348.822162903 File Name: +fratestdb2/STDYDB/ONLINELOG/group_1.272.822074535

File Name: +fratestdb2/STDYDB/ONLINELOG/group_2.264.822074537 File Name: +fratestdb2/STDYDB/ONLINELOG/group_3.335.822074539 File Name: +fratestdb2/STDYDB/ONLINELOG/group_4.334.822074541 File Name: +fratestdb2/STDYDB/ONLINELOG/group_5.333.822074543 File Name: +fratestdb2/STDYDB/ONLINELOG/group_6.332.822074545 File Name: +fratestdb2/STDYDB/CONTROLFILE/Current.270.822074465 File Name: +fratestdb2/STDYDB/CONTROLFILE/Current.269.822074465 cataloging files...

cataloging done

List of Cataloged Files =======================

File Name: +fratestdb2/TEST2/ARCHIVELOG/2013_08_01/thread_1_seq_171.406.822329945 List of Files Which Where Not Cataloged

=======================================

File Name: +fratestdb2/TEST2/CONTROLFILE/Current.413.822329809 RMAN-07517: Reason: The file header is corrupted

File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_165.366.822290443 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_166.367.822302347 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_167.368.822302349 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_168.369.822302359 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_169.370.822302359 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_170.371.822302363 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_171.372.822302415 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_172.373.822302891

(17)

17

RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_173.374.822303867 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_174.375.822303871 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_175.376.822 304049 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_176.377.822304051 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_177.378.822304309 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_178.379.822305065 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_179.380.822305169 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_180.381.822305175 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_181.382.822305181 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_182.383.822305183 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_183.384.822305187 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_184.385.822305501 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_185.386.822305825 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_186.387.822306107 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_187.388.822306109 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_188.389.822306161 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_189.390.822306521 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_190.391.822306671 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_191.392.822306673 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_192.393.822306679 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_193.394.822306681 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_194.395.822306685 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_195.396.822306969 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_196.397.822307031 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_197.398.822307033 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_198.399.822307067 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_199.400.822307237 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_200.401.822307239 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_201.402.822307249 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_202.403.822307251 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_203.404.822307253 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_08_01/thread_1_seq_204.405.822307597 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_148.349.822186917 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB

(18)

18

File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_149.350.822221589 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_150.351.822221593 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_151.352.822221635 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_152.353.822249135 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_153.354.822249791 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_154.355.822249795 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_155.356.822249801 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_156.357.822249803 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_157.358.822249805 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_158.359.822250115 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_159.360.822250265 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_160.361.822250289 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_161.362.822250815 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_162.363.822250819 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_163.364.822250863 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_31/thread_1_seq_164.365.822251105 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_63.331.822128571 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_64.330.822128571 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_65.329.822129567 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_66.328.822129575 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_67.327.822129585 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_68.326.822131661 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_69.325.822132161 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_70.324.822132165 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_71.323.822132171 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_72.322.822132171 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_73.321.822132177 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_74.320.822132273 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_75.319.822132555 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_76.318.822132557 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_77.317.822132607 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_78.316.822138791 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_79.315.822139599 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_80.314.822139601

(19)

19

RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_81.313.822139607 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_82.312.822139607 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_83.311.822139613 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_84.310.822139971 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_85.309.822140341 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_86.308.822140361 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_87.307.822140809 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_88.306.822140813 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_89.305.822140877 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_90.304.822149103 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_91.303.822149183 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_92.302.822149187 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_93.301.822149193 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_94.300.822149195 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_95.299.822149197 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_96.298.822149247 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_97.297.822150175 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_98.296.822150195 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_99.295.822150905 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_100.294.822150905 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_101.293.822150951 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_102.292.822151913 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_103.291.822152003 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_104.290.822152005 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_105.289.822152011 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_106.288.822152013 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_107.287.822152017 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_108.286.822152375 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_109.285.822152827 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_110.284.822152847 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_111.283.822153503 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_112.282.822153505 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_113.281.822153545 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB

(20)

20

File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_114.280.822155107 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_115.279.822155451 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_116.278.822155453 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_117.277.822155459 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_118.276.822155459 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_119.275.822155463 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_120.274.822155779 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_121.257.822156483 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_122.258.822156505 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_123.259.822156609 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_124.256.822156661 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_125.263.822157733 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_126.261.822157733 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_127.260.822158163 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_128.262.822158277 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_129.267.822158281 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_130.268.822158287 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_131.271.822158287 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_132.273.822158291 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_133.266.822158617 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_134.265.822159005 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_135.33 6.822159183 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_136.337.822159499 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_137.338.822159503 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_138.339.822159543 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_139.340.822160627 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_140.341.822161909 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_141.342.822161913 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_142.343.822161919 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_143.344.822161919 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_144.345.822161923 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_145.346.822162255 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_146.347.822162883 RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ARCHIVELOG/2013_07_30/thread_1_seq_147.348.822162903

(21)

21

RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/ONLINELOG/group_1.272.822074535

RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB File Name: +fratestdb2/STDYDB/CONTROLFILE/Current.270.822074465

RMAN-07517: Reason: The file header is corrupted

File Name: +fratestdb2/STDYDB/CONTROLFILE/Current.269.822074465

RMAN-07518: Reason: Foreign database file DBID: 496325052 Database Name: PRIMDB datafile 1 switched to datafile copy

input datafile copy RECID=12 STAMP=822329947 file name=+DATATESTDB2/test2/datafile/system.264.822329843 datafile 2 switched to datafile copy

input datafile copy RECID=13 STAMP=822329947 file name=+DATATESTDB2/test2/datafile/undotbs1.282.822329893 datafile 3 switched to datafile copy

input datafile copy RECID=14 STAMP=822329947 file name=+DATATESTDB2/test2/datafile/sysaux.283.822329919 datafile 4 switched to datafile copy

input datafile copy RECID=15 STAMP=822329947 file name=+DATATESTDB2/test2/datafile/users.262.822329867 contents of Memory Script:

{ set until scn 5783666; recover clone database delete archivelog ; }

executing command: SET until clause Starting recover at 01-AUG-2013 16:59:08 allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=27 device type=DISK starting media recovery

archived log for thread 1 with sequence 171 is already on disk as file +FRATESTDB2/test2/archivelog/2013_08_01/thread_1_seq_171.406.822329945

archived log file name=+FRATESTDB2/test2/archivelog/2013_08_01/thread_1_seq_171.406.822329945 thread=1 sequence=171

media recovery complete, elapsed time: 00:00:00 Finished recover at 01-AUG-2013 16:59:09 Oracle instance started

Total System Global Area 313159680 bytes Fixed Size 2227944 bytes Variable Size 226492696 bytes Database Buffers 79691776 bytes Redo Buffers 4747264 bytes contents of Memory Script:

{

(22)

22

''TEST2'' comment=

''Reset to original value by RMAN'' scope=spfile";

sql clone "alter system reset db_unique_name scope=spfile"; shutdown clone immediate;

startup clone nomount; }

sql statement: alter system set db_name = ''TEST2'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset db_unique_name scope=spfile Oracle instance shut down

Total System Global Area 313159680 bytes Fixed Size 2227944 bytes Variable Size 226492696 bytes Database Buffers 79691776 bytes Redo Buffers 4747264 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TEST2" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 SIZE 50 M , GROUP 2 SIZE 50 M , GROUP 3 SIZE 50 M DATAFILE '+DATATESTDB2/test2/datafile/system.264.822329843' CHARACTER SET AL32UTF8

set newname for clone tempfile 1 to new; switch clone tempfile all;

catalog clone datafilecopy "+DATATESTDB2/test2/datafile/undotbs1.282.822329893", "+DATATESTDB2/test2/datafile/sysaux.283.822329919",

"+DATATESTDB2/test2/datafile/users.262.822329867"; switch clone datafile all;

}

executing Memory Script executing command: SET NEWNAME

renamed tempfile 1 to +DATATESTDB2 in control file cataloged datafile copy

datafile copy file name=+DATATESTDB2/test2/datafile/undotbs1.282.822329893 RECID=1 STAMP=822329966

cataloged datafile copy

datafile copy file name=+DATATESTDB2/test2/datafile/sysaux.283.822329919 RECID=2 STAMP=822329966

cataloged datafile copy

datafile copy file name=+DATATESTDB2/test2/datafile/users.262.822329867 RECID=3 STAMP=822329966

datafile 2 switched to datafile copy

input datafile copy RECID=1 STAMP=822329966 file name=+DATATESTDB2/test2/datafile/undotbs1.282.822329893

(23)

23

datafile 3 switched to datafile copy

input datafile copy RECID=2 STAMP=822329966 file name=+DATATESTDB2/test2/datafile/sysaux.283.822329919 datafile 4 switched to datafile copy

input datafile copy RECID=3 STAMP=822329966 file name=+DATATESTDB2/test2/datafile/users.262.822329867 Reenabling controlfile options for auxiliary database Executing: alter database force logging

Alter clone database open resetlogs; }

executing Memory Script database opened

Finished Duplicate Db at 01-AUG-2013 16:59:41 RMAN>

8. Crear archivo spfile para la Base de Datos Clonada

-

Revisamos los control files de la Base de Datos Clonada:

[oracle@bdtest db_TESTDB2]$ sqlplus " / as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 1 17:07:31 2013

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> select name from v$controlfile;

NAME

---

(24)

24

+FRATESTDB2/test2/controlfile/current.408.822329809

Añadimos los control files al archivo initTEST2.ora:

[oracle@bdtest dbs]$ more initTEST2.ora *.audit_file_dest='/oracle/admin/STDYDB/adump' *.audit_trail='db' *.compatible='11.2.0.1.0' *.db_block_size=8192 *.control_files='+DATATESTDB2/test2/controlfile/current.265.822329809','+FRATESTDB2/test2 /controlfile/current.408.822329809' *.db_create_file_dest='+DATATESTDB2' *.db_create_online_log_dest_1='+DATATESTDB2' *.db_create_online_log_dest_2='+FRATESTDB2' *.db_domain='' *.db_name='TEST2' *.db_recovery_file_dest='+FRATESTDB2' *.db_recovery_file_dest_size=2147483648 *.diagnostic_dest='/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=TEST2XDB)'

*.local_listener='(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.22.58)(PORT = 1522)))' *.log_archive_format='TEST2_%t_%s_%r.arc' *.memory_target=314572800 *.open_cursors=300 *.processes=300 *.remote_login_passwordfile='EXCLUSIVE' *.sessions=335 *.undo_tablespace='UNDOTBS1'

(25)

25 Procedemos a crear el spfile en el ASM:

[oracle@bdtest dbs]$ sqlplus " / as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 1 17:11:33 2013

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options

SQL> create spfile='+DATATESTDB2' from

pfile='/oracle/product/11.2.0.3/db_TESTDB2/dbs/initTEST2.ora';

File created.

ASMCMD> pwd +DATATESTDB2/TEST2

ASMCMD> mkalias +DATATESTDB2/TEST2/PARAMETERFILE/spfile.259.822330831 spfileTEST2.ora ASMCMD> ls -l

Type Redund Striped Time Sys Name

Y CONTROLFILE/ Y DATAFILE/ Y ONLINELOG/ Y PARAMETERFILE/ Y TEMPFILE/ N spfileTEST2.ora => +DATATESTDB2/TEST2/PARAMETERFILE/spfile.259.822330831

(26)

26 En archivo initTEST2.ora ingresamos la ruta del SPFILE creado:

[oracle@bdtest dbs]$ pwd

/oracle/product/11.2.0.3/db_TESTDB2/dbs [oracle@bdtest dbs]$ more initTEST2.ora SPFILE='+DATATESTDB2/TEST2/spfileTEST2.ora'

Bajamos y subimos la Base de Datos clonada:

[oracle@bdtest dbs]$ srvctl stop database -d TEST2 [oracle@bdtest dbs]$ srvctl start database -d TEST2 [grid@bdtest admin]$ crsctl stat res -t

--- NAME TARGET STATE SERVER STATE_DETAILS --- Local Resources

--- ora.DATATESTDB2.dg

ONLINE ONLINE bdtest ora.FRATESTDB2.dg

ONLINE ONLINE bdtest ora.LISTENER.lsnr

ONLINE ONLINE bdtest ora.asm

ONLINE ONLINE bdtest Started ora.ons

OFFLINE OFFLINE bdtest

--- Cluster Resources

--- ora.cssd

(27)

27

1 ONLINE ONLINE bdtest ora.diskmon

1 OFFLINE OFFLINE ora.evmd

1 ONLINE ONLINE bdtest ora.stdydb.db

1 ONLINE ONLINE bdtest Open

ora.test2.db

1 ONLINE ONLINE bdtest Open