1.script to duplicate database using newname instead of db_file_name_convert, cvrman is the target database and crman is the auxiliary database
run
{
allocate channel c1 device type disk connect 'sys/sys123@cvrman';
allocate channel c2 device type disk connect 'sys/sys123@cvrman';
allocate channel c3 device type disk connect 'sys/sys123@cvrman';
allocate auxiliary channel aux1 device type disk;
allocate auxiliary channel aux2 device type disk;
allocate auxiliary channel aux3 device type disk;
set newname for datafile 1 to '+DATA/crman/datafile/system.dbf';
set newname for datafile 2 to '+DATA/crman/datafile/sysaux.dbf';
set newname for datafile 3 to '+DATA/crman/datafile/undotbs1.dbf';
set newname for datafile 4 to '+DATA/crman/datafile/users.dbf';
set newname for datafile 5 to '+DATA/crman/datafile/example.dbf';
duplicate target database to crman
from active database
spfile
parameter_value_convert='/u01/app/orcl/oracle/admin/cvrman/adump','/u01/app/orcl/oracle/admin/crman/adump'
set audit_file_dest='/u01/app/orcl/oracle/admin/crman/adump'
set dispatchers='(PROTOCOL=TCP) (SERVICE=crmanXDB)'
set control_files='+DATA','+DATA'
set log_file_name_convert='+DATA/cvrman/','+DATA/crman/';
release channel c1;
release channel c2;
release channel c3;
release channel aux1;
release channel aux2;
release channel aux3;
}
2.Create dedicated listener configuration for the auxiliary database and start the listener in the node2
3.Create net service name entry in the tnsnames.ora entry for the auxiliary database and the target database in the nodes
4.Create password file for the auxiliary database using orapwd utility
5.Use rman utility to duplicate the target database.
rman target="sys/sys123@cvrman" auxiliary="sys/sys123@crman"
Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jun 7 10:12:18 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: CVRMAN (DBID=659771233)
connected to auxiliary database: CRMAN (not mounted)
RMAN> @ rman_duplicate_1.cmd
RMAN> run
2> {
3> allocate channel c1 device type disk connect *;
4> allocate channel c2 device type disk connect *;
5> allocate channel c3 device type disk connect *;
6> allocate auxiliary channel aux1 device type disk;
7> allocate auxiliary channel aux2 device type disk;
8> allocate auxiliary channel aux3 device type disk;
9> set newname for datafile 1 to '+DATA/crman/datafile/system.dbf';
10> set newname for datafile 2 to '+DATA/crman/datafile/sysaux.dbf';
11> set newname for datafile 3 to '+DATA/crman/datafile/undotbs1.dbf';
12> set newname for datafile 4 to '+DATA/crman/datafile/users.dbf';
13> set newname for datafile 5 to '+DATA/crman/datafile/example.dbf';
14> duplicate target database to crman
15> from active database
16> spfile
17> parameter_value_convert='/u01/app/orcl/oracle/admin/cvrman/adump','/u01/app/orcl/oracle/admin/crman/adump'
18> set audit_file_dest='/u01/app/orcl/oracle/admin/crman/adump'
19> set dispatchers='(PROTOCOL=TCP) (SERVICE=crmanXDB)'
20> set control_files='+DATA','+DATA'
21> set log_file_name_convert='+DATA/cvrman/','+DATA/crman/';
22> release channel c1;
23> release channel c2;
24> release channel c3;
25> release channel aux1;
26> release channel aux2;
27> release channel aux3;
28> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=58 device type=DISK
allocated channel: c2
channel c2: SID=65 device type=DISK
allocated channel: c3
channel c3: SID=61 device type=DISK
allocated channel: aux1
channel aux1: SID=27 device type=DISK
allocated channel: aux2
channel aux2: SID=28 device type=DISK
allocated channel: aux3
channel aux3: SID=29 device type=DISK
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting Duplicate Db at 07-JUN-14
contents of Memory Script:
{
backup as copy reuse
targetfile '+DATA/cvrman/spfilecvrman.ora' auxiliary format
'/u01/app/orcl/oracle/product/11.2.0.3/db_1/dbs/spfilecrman.ora' ;
sql clone "alter system set spfile= ''/u01/app/orcl/oracle/product/11.2.0.3/db_1/dbs/spfilecrman.ora''";
}
executing Memory Script
Starting backup at 07-JUN-14
Finished backup at 07-JUN-14
sql statement: alter system set spfile= ''/u01/app/orcl/oracle/product/11.2.0.3/db_1/dbs/spfilecrman.ora''
contents of Memory Script:
{
sql clone "alter system set db_name =
''CRMAN'' comment=
''duplicate'' scope=spfile";
sql clone "alter system set audit_file_dest =
''/u01/app/orcl/oracle/admin/crman/adump'' comment=
'''' scope=spfile";
sql clone "alter system set dispatchers =
''(PROTOCOL=TCP) (SERVICE=crmanXDB)'' comment=
'''' scope=spfile";
sql clone "alter system set control_files =
''+DATA'', ''+DATA'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''+DATA/cvrman/'', ''+DATA/crman/'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''CRMAN'' comment= ''duplicate'' scope=spfile
sql statement: alter system set audit_file_dest = ''/u01/app/orcl/oracle/admin/crman/adump'' comment= '''' scope=spfile
sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=crmanXDB)'' comment= '''' scope=spfile
sql statement: alter system set control_files = ''+DATA'', ''+DATA'' comment= '''' scope=spfile
sql statement: alter system set log_file_name_convert = ''+DATA/cvrman/'', ''+DATA/crman/'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 275578880 bytes
Fixed Size 2227584 bytes
Variable Size 113246848 bytes
Database Buffers 155189248 bytes
Redo Buffers 4915200 bytes
allocated channel: aux1
channel aux1: SID=25 device type=DISK
allocated channel: aux2
channel aux2: SID=26 device type=DISK
allocated channel: aux3
channel aux3: SID=32 device type=DISK
contents of Memory Script:
{
sql clone "alter system set control_files =
''+DATA/crman/controlfile/current.419.849608059'', ''+DATA/crman/controlfile/current.420.849608059'' comment=
''Set by RMAN'' scope=spfile";
sql clone "alter system set db_name =
''CVRMAN'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''CRMAN'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format '+DATA/crman/controlfile/current.421.849608059';
restore clone controlfile to '+DATA/crman/controlfile/current.422.849608065' from
'+DATA/crman/controlfile/current.421.849608059';
sql clone "alter system set control_files =
''+DATA/crman/controlfile/current.421.849608059'', ''+DATA/crman/controlfile/current.422.849608065'' comment=
''Set by RMAN'' scope=spfile";
shutdown clone immediate;
startup clone nomount;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set control_files = ''+DATA/crman/controlfile/current.419.849608059'', ''+DATA/crman/controlfile/current.420.849608059'' comment= ''Set by RMAN'' scope=spfile
sql statement: alter system set db_name = ''CVRMAN'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''CRMAN'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 275578880 bytes
Fixed Size 2227584 bytes
Variable Size 117441152 bytes
Database Buffers 150994944 bytes
Redo Buffers 4915200 bytes
allocated channel: aux1
channel aux1: SID=30 device type=DISK
allocated channel: aux2
channel aux2: SID=31 device type=DISK
allocated channel: aux3
channel aux3: SID=32 device type=DISK
Starting backup at 07-JUN-14
channel c1: starting datafile copy
copying current control file
output file name=/u01/app/orcl/oracle/product/11.2.0.3/db_1/dbs/snapcf_cvrman.f tag=TAG20140607T101508 RECID=2 STAMP=849608114
channel c1: datafile copy complete, elapsed time: 00:00:26
Finished backup at 07-JUN-14
Starting restore at 07-JUN-14
channel aux2: skipped, AUTOBACKUP already found
channel aux3: skipped, AUTOBACKUP already found
channel aux1: copied control file copy
Finished restore at 07-JUN-14
sql statement: alter system set control_files = ''+DATA/crman/controlfile/current.421.849608059'', ''+DATA/crman/controlfile/current.422.849608065'' comment= ''Set by RMAN'' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 275578880 bytes
Fixed Size 2227584 bytes
Variable Size 117441152 bytes
Database Buffers 150994944 bytes
Redo Buffers 4915200 bytes
allocated channel: aux1
channel aux1: SID=30 device type=DISK
allocated channel: aux2
channel aux2: SID=31 device type=DISK
allocated channel: aux3
channel aux3: SID=32 device type=DISK
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
"+DATA/crman/datafile/system.dbf";
set newname for datafile 2 to
"+DATA/crman/datafile/sysaux.dbf";
set newname for datafile 3 to
"+DATA/crman/datafile/undotbs1.dbf";
set newname for datafile 4 to
"+DATA/crman/datafile/users.dbf";
set newname for datafile 5 to
"+DATA/crman/datafile/example.dbf";
backup as copy reuse
datafile 1 auxiliary format
"+DATA/crman/datafile/system.dbf" datafile
2 auxiliary format
"+DATA/crman/datafile/sysaux.dbf" datafile
3 auxiliary format
"+DATA/crman/datafile/undotbs1.dbf" datafile
4 auxiliary format
"+DATA/crman/datafile/users.dbf" datafile
5 auxiliary format
"+DATA/crman/datafile/example.dbf" ;
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
executing command: SET NEWNAME
Starting backup at 07-JUN-14
channel c1: starting datafile copy
input datafile file number=00001 name=+DATA/cvrman/datafile/system.304.849559339
channel c2: starting datafile copy
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.286.849559341
channel c3: starting datafile copy
input datafile file number=00005 name=+DATA/cvrman/datafile/example.314.849560251
output file name=+DATA/crman/datafile/example.dbf tag=TAG20140607T101737
channel c3: datafile copy complete, elapsed time: 00:02:47
channel c3: starting datafile copy
input datafile file number=00003 name=+DATA/cvrman/datafile/undotbs1.270.849559341
output file name=+DATA/crman/datafile/undotbs1.dbf tag=TAG20140607T101737
channel c3: datafile copy complete, elapsed time: 00:00:45
channel c3: starting datafile copy
input datafile file number=00004 name=+DATA/cvrman/datafile/users.391.849559341
output file name=+DATA/crman/datafile/sysaux.dbf tag=TAG20140607T101737
channel c2: datafile copy complete, elapsed time: 00:03:53
output file name=+DATA/crman/datafile/users.dbf tag=TAG20140607T101737
channel c3: datafile copy complete, elapsed time: 00:00:16
output file name=+DATA/crman/datafile/system.dbf tag=TAG20140607T101737
channel c1: datafile copy complete, elapsed time: 00:04:23
Finished backup at 07-JUN-14
sql statement: alter system archive log current
contents of Memory Script:
{
backup as copy reuse
archivelog like "+DATA/cvrman/archivelog/2014_06_07/thread_1_seq_11.428.849608543" auxiliary format
"+DATA" ;
catalog clone start with "+DATA";
switch clone datafile all;
}
executing Memory Script
Starting backup at 07-JUN-14
channel c1: starting archived log copy
input archived log thread=1 sequence=11 RECID=6 STAMP=849608554
output file name=+DATA/crman/archivelog/2014_06_07/thread_1_seq_11.429.849608555 RECID=0 STAMP=0
channel c1: archived log copy complete, elapsed time: 00:00:08
Finished backup at 07-JUN-14
searching for all files that match the pattern +DATA
List of Files Unknown to the Database
=====================================
File Name: +data/CRMAN/ARCHIVELOG/2014_06_07/thread_1_seq_11.429.849608555
File Name: +data/CRMAN/DATAFILE/SYSTEM.423.849608261
File Name: +data/CRMAN/DATAFILE/SYSAUX.424.849608261
File Name: +data/CRMAN/DATAFILE/EXAMPLE.425.849608261
File Name: +data/CRMAN/DATAFILE/UNDOTBS1.426.849608431
File Name: +data/CRMAN/DATAFILE/USERS.427.849608483
File Name: +data/CRMAN/CONTROLFILE/Current.419.849608059
File Name: +data/CRMAN/CONTROLFILE/Current.420.849608059
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_1_seq_1.296.849521463
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_1.316.849554593
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_2.315.849554609
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_1_seq_1.295.849554635
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_3.294.849554637
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_15.305.849557523
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_1.282.849557803
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_2.272.849557825
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_1_seq_1.281.849557839
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_3.271.849557839
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_1_seq_10.382.849454287
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_2_seq_1.405.849458541
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_1_seq_1.406.849458731
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_1_seq_2.407.849458739
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_2_seq_2.408.849470619
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_1_seq_3.409.849470619
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_1_seq_4.410.849470625
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_1_seq_5.411.849471755
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_2_seq_1.301.849479899
File Name: +data/ORCLDP/CONTROLFILE/Current.393.849556947
File Name: +data/ORCLDP/CONTROLFILE/Current.291.849556947
File Name: +data/CVRMAN/spfilecvrman.ora
File Name: +data/CVRMAN/ARCHIVELOG/2014_06_07/thread_1_seq_11.428.849608543
File Name: +data/CVRMAN/CONTROLFILE/Current.395.849559905
File Name: +data/CVRMAN/CONTROLFILE/Current.394.849559907
File Name: +data/ORCL/spfileorcl.ora
File Name: +data/ORCL/PARAMETERFILE/spfile.288.849286189
File Name: +data/ORCL/TEMPFILE/TEMP1.287.849285863
File Name: +data/ORCL/TEMPFILE/TEMP.336.849374879
File Name: +data/ORCL/ONLINELOG/group_5.274.849293875
File Name: +data/ORCL/ONLINELOG/group_5.273.849293881
File Name: +data/ORCL/ONLINELOG/group_6.276.849293885
File Name: +data/ORCL/ONLINELOG/group_6.275.849293895
File Name: +data/ORCL/ONLINELOG/group_7.279.849293899
File Name: +data/ORCL/ONLINELOG/group_7.280.849293901
File Name: +data/ORCL/ONLINELOG/group_8.277.849293907
File Name: +data/ORCL/ONLINELOG/group_8.278.849293911
File Name: +data/ORCL/ONLINELOG/group_1.327.849374779
File Name: +data/ORCL/ONLINELOG/group_1.326.849374783
File Name: +data/ORCL/ONLINELOG/group_2.338.849374787
File Name: +data/ORCL/ONLINELOG/group_2.337.849374791
File Name: +data/ORCL/ONLINELOG/group_3.341.849378271
File Name: +data/ORCL/ONLINELOG/group_3.342.849378289
File Name: +data/ORCL/ONLINELOG/group_4.343.849378293
File Name: +data/ORCL/ONLINELOG/group_4.344.849378297
File Name: +data/ORCL/AUTOBACKUP/2014_06_04/s_849350745.319.849350751
File Name: +data/ORCL/AUTOBACKUP/2014_06_04/s_849352699.325.849352705
File Name: +data/ORCL/AUTOBACKUP/2014_06_04/s_849395529.358.849395571
File Name: +data/ORCL/AUTOBACKUP/2014_06_05/s_849476538.308.849476545
File Name: +data/ORCL/DATAFILE/SYSAUX.261.849281819
File Name: +data/ORCL/DATAFILE/UNDOTBS2.259.849281819
File Name: +data/ORCL/DATAFILE/SYSTEM.258.849281819
File Name: +data/ORCL/DATAFILE/UNDOTBS1.263.849281819
File Name: +data/ORCL/DATAFILE/USERS.264.849281819
File Name: +data/ORCL/DATAFILE/SYSTEM.320.849352297
File Name: +data/ORCL/DATAFILE/SYSAUX.321.849352297
File Name: +data/ORCL/DATAFILE/UNDOTBS1.322.849352297
File Name: +data/ORCL/DATAFILE/UNDOTBS2.323.849352299
File Name: +data/ORCL/DATAFILE/USERS.324.849352307
File Name: +data/ORCL/DATAFILE/SYSTEM.332.849374461
File Name: +data/ORCL/DATAFILE/SYSAUX.333.849374463
File Name: +data/ORCL/DATAFILE/UNDOTBS1.334.849374463
File Name: +data/ORCL/DATAFILE/USERS.329.849374463
File Name: +data/ORCL/DATAFILE/EXAMPLE.339.849374929
File Name: +data/ORCL/DATAFILE/UNDOTBS2.340.849376549
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_5.300.849521037
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_16.298.849521039
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_17.297.849521047
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_18.365.849531131
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_6.366.849531131
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_7.400.849531135
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_8.399.849531135
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_19.398.849531137
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_9.396.849551245
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_20.397.849551249
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_21.307.849551279
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_10.376.849553059
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_11.387.849553081
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_12.388.849553089
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_22.370.849553093
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_13.389.849553095
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_23.390.849553277
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_24.306.849553307
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_14.299.849553311
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_25.292.849553311
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_15.317.849557491
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_1.359.849426809
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_2.360.849426835
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_3.361.849426841
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_4.362.849426847
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_5.363.849426853
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_6.364.849426881
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_7.372.849427379
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_8.375.849428749
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_9.386.849437475
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_10.383.849454285
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_11.404.849474777
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_2_seq_1.385.849474777
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_12.371.849476019
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_2_seq_2.403.849476023
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_2_seq_3.267.849476517
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_13.312.849476517
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_14.293.849478385
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_15.311.849478399
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_2_seq_4.310.849478407
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_5.335.849361403
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_6.331.849363367
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_2_seq_1.345.849378359
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_2_seq_2.346.849379157
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_8.347.849379157
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_9.351.849379621
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_10.353.849389643
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_7.354.849395259
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_6.355.849395261
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_2_seq_14.356.849395265
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_2_seq_13.357.849395273
File Name: +data/ORCL/ARCHIVELOG/2014_06_03/thread_1_seq_54.260.849281315
File Name: +data/ORCL/ARCHIVELOG/2014_06_03/thread_1_seq_55.262.849281391
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.367.849476091
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.374.849476101
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.373.849476103
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.381.849476105
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.402.849476109
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.401.849476111
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.369.849476133
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.368.849476135
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.378.849476137
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.377.849476141
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.379.849476143
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.384.849476149
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.380.849476165
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.412.849476165
File Name: +data/ORCL/BACKUPSET/2014_06_05/nnndf0_FULL_BACKUP_DB_0.413.849476193
File Name: +data/ORCL/BACKUPSET/2014_06_05/nnndf0_FULL_BACKUP_DB_0.414.849476211
File Name: +data/ORCL/BACKUPSET/2014_06_05/nnndf0_FULL_BACKUP_DB_0.415.849476219
File Name: +data/ORCL/BACKUPSET/2014_06_05/nnndf0_FULL_BACKUP_DB_0.416.849476229
File Name: +data/ORCL/BACKUPSET/2014_06_05/nnndf0_FULL_BACKUP_DB_0.417.849476231
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.266.849476529
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.309.849476533
File Name: +data/ORCL/BACKUPSET/2014_06_04/annnf0_TAG20140604T183923_0.348.849379165
File Name: +data/ORCL/BACKUPSET/2014_06_04/nnndf0_TAG20140604T183942_0.349.849379185
File Name: +data/ORCL/BACKUPSET/2014_06_04/ncsnf0_TAG20140604T183942_0.350.849379581
File Name: +data/ORCL/BACKUPSET/2014_06_04/annnf0_TAG20140604T184705_0.352.849379641
File Name: +data/ORCL/BACKUPSET/2014_06_03/nnsnf0_FULL_BKP_COPY_0.257.849275563
File Name: +data/ORCL/CONTROLFILE/Backup.256.849275563
File Name: +data/ORCL/CONTROLFILE/Current.330.849374769
File Name: +data/ORCL/CONTROLFILE/Current.328.849374771
File Name: +data/cluster10/OCRFILE/REGISTRY.255.849273351
File Name: +data/cluster10/ASMPARAMETERFILE/REGISTRY.253.849270757
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: +data/CRMAN/ARCHIVELOG/2014_06_07/thread_1_seq_11.429.849608555
File Name: +data/CRMAN/DATAFILE/SYSTEM.423.849608261
File Name: +data/CRMAN/DATAFILE/SYSAUX.424.849608261
File Name: +data/CRMAN/DATAFILE/EXAMPLE.425.849608261
File Name: +data/CRMAN/DATAFILE/UNDOTBS1.426.849608431
File Name: +data/CRMAN/DATAFILE/USERS.427.849608483
File Name: +data/CVRMAN/ARCHIVELOG/2014_06_07/thread_1_seq_11.428.849608543
List of Files Which Where Not Cataloged
=======================================
File Name: +data/CRMAN/CONTROLFILE/Current.419.849608059
RMAN-07517: Reason: The file header is corrupted
File Name: +data/CRMAN/CONTROLFILE/Current.420.849608059
RMAN-07517: Reason: The file header is corrupted
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_1_seq_1.296.849521463
RMAN-07518: Reason: Foreign database file DBID: 3004886097 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_1.316.849554593
RMAN-07518: Reason: Foreign database file DBID: 3004960799 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_2.315.849554609
RMAN-07518: Reason: Foreign database file DBID: 3004960799 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_1_seq_1.295.849554635
RMAN-07518: Reason: Foreign database file DBID: 3004960799 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_3.294.849554637
RMAN-07518: Reason: Foreign database file DBID: 3004960799 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_15.305.849557523
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_1.282.849557803
RMAN-07518: Reason: Foreign database file DBID: 3004964025 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_2.272.849557825
RMAN-07518: Reason: Foreign database file DBID: 3004964025 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_1_seq_1.281.849557839
RMAN-07518: Reason: Foreign database file DBID: 3004964025 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_06/thread_2_seq_3.271.849557839
RMAN-07518: Reason: Foreign database file DBID: 3004964025 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_1_seq_10.382.849454287
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_2_seq_1.405.849458541
RMAN-07518: Reason: Foreign database file DBID: 3004860673 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_1_seq_1.406.849458731
RMAN-07518: Reason: Foreign database file DBID: 3004860673 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_1_seq_2.407.849458739
RMAN-07518: Reason: Foreign database file DBID: 3004860673 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_2_seq_2.408.849470619
RMAN-07518: Reason: Foreign database file DBID: 3004860673 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_1_seq_3.409.849470619
RMAN-07518: Reason: Foreign database file DBID: 3004860673 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_1_seq_4.410.849470625
RMAN-07518: Reason: Foreign database file DBID: 3004860673 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_1_seq_5.411.849471755
RMAN-07518: Reason: Foreign database file DBID: 3004860673 Database Name: ORCLDP
File Name: +data/ORCLDP/ARCHIVELOG/2014_06_05/thread_2_seq_1.301.849479899
RMAN-07518: Reason: Foreign database file DBID: 3004886097 Database Name: ORCLDP
File Name: +data/ORCLDP/CONTROLFILE/Current.393.849556947
RMAN-07517: Reason: The file header is corrupted
File Name: +data/ORCLDP/CONTROLFILE/Current.291.849556947
RMAN-07517: Reason: The file header is corrupted
File Name: +data/CVRMAN/spfilecvrman.ora
RMAN-07518: Reason: Foreign database file DBID: 0 Database Name:
File Name: +data/CVRMAN/CONTROLFILE/Current.395.849559905
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/CVRMAN/CONTROLFILE/Current.394.849559907
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/spfileorcl.ora
RMAN-07518: Reason: Foreign database file DBID: 0 Database Name:
File Name: +data/ORCL/PARAMETERFILE/spfile.288.849286189
RMAN-07518: Reason: Foreign database file DBID: 0 Database Name:
File Name: +data/ORCL/TEMPFILE/TEMP1.287.849285863
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/TEMPFILE/TEMP.336.849374879
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_5.274.849293875
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_5.273.849293881
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_6.276.849293885
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_6.275.849293895
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_7.279.849293899
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_7.280.849293901
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_8.277.849293907
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_8.278.849293911
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_1.327.849374779
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_1.326.849374783
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_2.338.849374787
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_2.337.849374791
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_3.341.849378271
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_3.342.849378289
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_4.343.849378293
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ONLINELOG/group_4.344.849378297
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/AUTOBACKUP/2014_06_04/s_849350745.319.849350751
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/AUTOBACKUP/2014_06_04/s_849352699.325.849352705
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/AUTOBACKUP/2014_06_04/s_849395529.358.849395571
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/AUTOBACKUP/2014_06_05/s_849476538.308.849476545
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/DATAFILE/SYSAUX.261.849281819
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/UNDOTBS2.259.849281819
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/SYSTEM.258.849281819
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/UNDOTBS1.263.849281819
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/USERS.264.849281819
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/SYSTEM.320.849352297
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/SYSAUX.321.849352297
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/UNDOTBS1.322.849352297
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/UNDOTBS2.323.849352299
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/USERS.324.849352307
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/SYSTEM.332.849374461
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/SYSAUX.333.849374463
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/UNDOTBS1.334.849374463
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/USERS.329.849374463
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/EXAMPLE.339.849374929
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/DATAFILE/UNDOTBS2.340.849376549
RMAN-07519: Reason: Error while cataloging. See alert.log.
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_5.300.849521037
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_16.298.849521039
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_17.297.849521047
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_18.365.849531131
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_6.366.849531131
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_7.400.849531135
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_8.399.849531135
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_19.398.849531137
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_9.396.849551245
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_20.397.849551249
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_21.307.849551279
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_10.376.849553059
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_11.387.849553081
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_12.388.849553089
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_22.370.849553093
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_13.389.849553095
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_23.390.849553277
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_24.306.849553307
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_14.299.849553311
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_1_seq_25.292.849553311
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_06/thread_2_seq_15.317.849557491
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_1.359.849426809
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_2.360.849426835
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_3.361.849426841
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_4.362.849426847
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_5.363.849426853
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_6.364.849426881
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_7.372.849427379
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_8.375.849428749
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_9.386.849437475
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_10.383.849454285
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_11.404.849474777
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_2_seq_1.385.849474777
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_12.371.849476019
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_2_seq_2.403.849476023
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_2_seq_3.267.849476517
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_13.312.849476517
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_14.293.849478385
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_1_seq_15.311.849478399
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_05/thread_2_seq_4.310.849478407
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_5.335.849361403
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_6.331.849363367
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_2_seq_1.345.849378359
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_2_seq_2.346.849379157
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_8.347.849379157
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_9.351.849379621
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_10.353.849389643
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_7.354.849395259
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_1_seq_6.355.849395261
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_2_seq_14.356.849395265
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_04/thread_2_seq_13.357.849395273
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_03/thread_1_seq_54.260.849281315
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/ARCHIVELOG/2014_06_03/thread_1_seq_55.262.849281391
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.367.849476091
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.374.849476101
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.373.849476103
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.381.849476105
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.402.849476109
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.401.849476111
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.369.849476133
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.368.849476135
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.378.849476137
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.377.849476141
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.379.849476143
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.384.849476149
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.380.849476165
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.412.849476165
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/nnndf0_FULL_BACKUP_DB_0.413.849476193
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/nnndf0_FULL_BACKUP_DB_0.414.849476211
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/nnndf0_FULL_BACKUP_DB_0.415.849476219
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/nnndf0_FULL_BACKUP_DB_0.416.849476229
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/nnndf0_FULL_BACKUP_DB_0.417.849476231
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.266.849476529
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_05/annnf0_FULL_BACKUP_ARCHIVE_0.309.849476533
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_04/annnf0_TAG20140604T183923_0.348.849379165
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_04/nnndf0_TAG20140604T183942_0.349.849379185
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_04/ncsnf0_TAG20140604T183942_0.350.849379581
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_04/annnf0_TAG20140604T184705_0.352.849379641
RMAN-07518: Reason: Foreign database file DBID: 1377155504 Database Name: ORCL
File Name: +data/ORCL/BACKUPSET/2014_06_03/nnsnf0_FULL_BKP_COPY_0.257.849275563
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/CONTROLFILE/Backup.256.849275563
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/CONTROLFILE/Current.330.849374769
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/ORCL/CONTROLFILE/Current.328.849374771
RMAN-07518: Reason: Foreign database file DBID: 1374849049 Database Name: ORCL
File Name: +data/cluster10/OCRFILE/REGISTRY.255.849273351
RMAN-07517: Reason: The file header is corrupted
File Name: +data/cluster10/ASMPARAMETERFILE/REGISTRY.253.849270757
RMAN-07518: Reason: Foreign database file DBID: 0 Database Name:
datafile 1 switched to datafile copy
input datafile copy RECID=7 STAMP=849608649 file name=+DATA/crman/datafile/system.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=8 STAMP=849608649 file name=+DATA/crman/datafile/sysaux.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=9 STAMP=849608650 file name=+DATA/crman/datafile/undotbs1.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=10 STAMP=849608650 file name=+DATA/crman/datafile/users.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=11 STAMP=849608651 file name=+DATA/crman/datafile/example.dbf
contents of Memory Script:
{
set until scn 1084551;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 07-JUN-14
starting media recovery
archived log for thread 1 with sequence 11 is already on disk as file +DATA/crman/archivelog/2014_06_07/thread_1_seq_11.429.849608555
archived log file name=+DATA/crman/archivelog/2014_06_07/thread_1_seq_11.429.849608555 thread=1 sequence=11
media recovery complete, elapsed time: 00:00:03
Finished recover at 07-JUN-14
Oracle instance started
Total System Global Area 275578880 bytes
Fixed Size 2227584 bytes
Variable Size 121635456 bytes
Database Buffers 146800640 bytes
Redo Buffers 4915200 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''CRMAN'' 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;
}
executing Memory Script
sql statement: alter system set db_name = ''CRMAN'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 275578880 bytes
Fixed Size 2227584 bytes
Variable Size 121635456 bytes
Database Buffers 146800640 bytes
Redo Buffers 4915200 bytes
allocated channel: aux1
channel aux1: SID=29 device type=DISK
allocated channel: aux2
channel aux2: SID=30 device type=DISK
allocated channel: aux3
channel aux3: SID=31 device type=DISK
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CRMAN" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '+data', '+data' ) SIZE 50 M REUSE,
GROUP 2 ( '+data', '+data' ) SIZE 50 M REUSE,
GROUP 3 ( '+data', '+data' ) SIZE 50 M REUSE
DATAFILE
'+DATA/crman/datafile/system.dbf'
CHARACTER SET WE8MSWIN1252
contents of Memory Script:
{
set newname for clone tempfile 1 to new;
switch clone tempfile all;
catalog clone datafilecopy "+DATA/crman/datafile/sysaux.dbf",
"+DATA/crman/datafile/undotbs1.dbf",
"+DATA/crman/datafile/users.dbf",
"+DATA/crman/datafile/example.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to +data in control file
cataloged datafile copy
datafile copy file name=+DATA/crman/datafile/sysaux.dbf RECID=1 STAMP=849608791
cataloged datafile copy
datafile copy file name=+DATA/crman/datafile/undotbs1.dbf RECID=2 STAMP=849608791
cataloged datafile copy
datafile copy file name=+DATA/crman/datafile/users.dbf RECID=3 STAMP=849608807
cataloged datafile copy
datafile copy file name=+DATA/crman/datafile/example.dbf RECID=4 STAMP=849608813
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=849608791 file name=+DATA/crman/datafile/sysaux.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=849608791 file name=+DATA/crman/datafile/undotbs1.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=849608807 file name=+DATA/crman/datafile/users.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=849608813 file name=+DATA/crman/datafile/example.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 07-JUN-14
released channel: c1
released channel: c2
released channel: c3
released channel: aux1
released channel: aux2
released channel: aux3
RMAN>
RMAN> **end-of-file**
RMAN>
exit
No comments:
Post a Comment