Here original database name is ORCL which is running on the same host
and we are creating a duplicate database (DUPDB) on that same host by
utilizing the older tape backups available for that database.(auxiliary
database should be the DUPDB)
[oracle@subhen-db01 dbs]$ cat initDUPDB.ora
db_name=DUPDB
sga_target=4G
[oracle@subhen-db01 dbs]$
[oracle@subhen-db01 dbs]$ echo $ORACLE_SID
DUPDB
[oracle@subhen-db01 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 4 12:05:02 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='initDUPDB.ora'
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2235208 bytes
Variable Size 822084792 bytes
Database Buffers 3439329280 bytes
Redo Buffers 12132352 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@subhen-db01 admin]$ echo $ORACLE_SID
DUPDB
[oracle@subhen-db01 dbs]$ rman auxiliary / catalog CATALOG_SCHEMA/<password>@<catalog_DB>
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Oct 4 13:07:07 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
connected to auxiliary database: DUPDB (not mounted)
RMAN> run
{
2> 3> allocate auxiliary channel c1 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLASS=XXXXXXXX, NB_ORA_SERV=XXXXXXXX, NB_ORA_SCHED=oracle,NB_ORA_CLIENT=<db host from where backup was taken>)';
4> DUPLICATE DATABASE ORCL DBID 1343XXXX to DUPDB UNTIL TIME "TO_DATE('04/10/2013 11:48:00','DD/MM/YYYY HH24:MI:SS')" SPFILE PARAMETER_VALUE_CONVERT="ORCL","DUPDB"
5> set cluster_database="FALSE"
set DB_UNIQUE_NAME="DUPDB"
6> 7> set db_create_file_dest="+DATA"
8> set instance_number="1"
9> set local_listener="LISTENER_DUPDB"
10> set REMOTE_LISTENER=''
11> set db_file_name_convert='+DATA/ORCL','+DATA/DUPDB'
set log_file_name_convert='+DATA/ORCL','+DATA/DUPDB'
12> 13> set control_files='+DATA'
14> set db_recovery_file_dest='+DATA'
15> NOFILENAMECHECK;
16> }
allocated channel: c1
channel c1: SID=429 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)
Starting Duplicate Db at 04-OCT-13
contents of Memory Script:
{
set until scn 86339128;
restore clone spfile to '/oracle/app/database/11.2.0.3/dbhome_1/dbs/spfileDUPDB.ora';
sql clone "alter system set spfile= ''/oracle/app/database/11.2.0.3/dbhome_1/dbs/spfileDUPDB.ora''";
}
executing Memory Script
executing command: SET until clause
Starting restore at 04-OCT-13
WARNING: A restore time was estimated based on the supplied UNTIL SCN
channel c1: starting datafile backup set restore
channel c1: restoring SPFILE
output file name=/oracle/app/database/11.2.0.3/dbhome_1/dbs/spfileDUPDB.ora
channel c1: reading from backup piece 0coktav9_1_2
channel c1: piece handle=0coktav9_1_2 tag=TAG20130927T124246
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:01:35
Finished restore at 04-OCT-13
sql statement: alter system set spfile= ''/oracle/app/database/11.2.0.3/dbhome_1/dbs/spfileDUPDB.ora''
contents of Memory Script:
{
sql clone "alter system set db_name =
''DUPDB'' comment=
''duplicate'' scope=spfile";
sql clone "alter system set audit_file_dest =
''/oracle/app/admin/DUPDB/adump'' comment=
'''' scope=spfile";
sql clone "alter system set dispatchers =
''(PROTOCOL=TCP) (SERVICE=DUPDBXDB)'' comment=
'''' scope=spfile";
sql clone "alter system set cluster_database =
FALSE comment=
'''' scope=spfile";
sql clone "alter system set db_unique_name =
''DUPDB'' comment=
'''' scope=spfile";
sql clone "alter system set db_create_file_dest =
''+DATA'' comment=
'''' scope=spfile";
sql clone "alter system set instance_number =
1 comment=
'''' scope=spfile";
sql clone "alter system set local_listener =
''LISTENER_DUPDB'' comment=
'''' scope=spfile";
sql clone "alter system set REMOTE_LISTENER =
'''' comment=
'''' scope=spfile";
sql clone "alter system set db_file_name_convert =
''+DATA/ORCL'', ''+DATA/DUPDB'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''+DATA/ORCL'', ''+DATA/DUPDB'' comment=
'''' scope=spfile";
sql clone "alter system set control_files =
''+DATA'' comment=
'''' scope=spfile";
sql clone "alter system set db_recovery_file_dest =
''+DATA'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''DUPDB'' comment= ''duplicate'' scope=spfile
sql statement: alter system set audit_file_dest = ''/oracle/app/admin/DUPDB/adump'' comment= '''' scope=spfile
sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=DUPDBXDB)'' comment= '''' scope=spfile
sql statement: alter system set cluster_database = FALSE comment= '''' scope=spfile
sql statement: alter system set db_unique_name = ''DUPDB'' comment= '''' scope=spfile
sql statement: alter system set db_create_file_dest = ''+DATA'' comment= '''' scope=spfile
sql statement: alter system set instance_number = 1 comment= '''' scope=spfile
sql statement: alter system set local_listener = ''LISTENER_DUPDB'' comment= '''' scope=spfile
sql statement: alter system set REMOTE_LISTENER = '''' comment= '''' scope=spfile
sql statement: alter system set db_file_name_convert = ''+DATA/ORCL'', ''+DATA/DUPDB'' comment= '''' scope=spfile
sql statement: alter system set log_file_name_convert = ''+DATA/ORCL'', ''+DATA/DUPDB'' comment= '''' scope=spfile
sql statement: alter system set control_files = ''+DATA'' comment= '''' scope=spfile
sql statement: alter system set db_recovery_file_dest = ''+DATA'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 4175568896 bytes
Fixed Size 2234960 bytes
Variable Size 2231371184 bytes
Database Buffers 1929379840 bytes
Redo Buffers 12582912 bytes
allocated channel: c1
channel c1: SID=386 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)
contents of Memory Script:
{
set until scn 86339128;
sql clone "alter system set control_files =
''+DATA/dupdb/controlfile/current.613.827932157'' comment=
''Set by RMAN'' scope=spfile";
sql clone "alter system set db_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''DUPDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile;
alter clone database mount;
}
executing Memory Script
executing command: SET until clause
sql statement: alter system set control_files = ''+DATA/dupdb/controlfile/XXXXXXXXXX'' comment= ''Set by RMAN'' scope=spfile
sql statement: alter system set db_name = ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''DUPDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 4175568896 bytes
Fixed Size 2234960 bytes
Variable Size 2231371184 bytes
Database Buffers 1929379840 bytes
Redo Buffers 12582912 bytes
allocated channel: c1
channel c1: SID=386 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)
Starting restore at 04-OCT-13
channel c1: starting datafile backup set restore
channel c1: restoring control file
channel c1: reading from backup piece 0coktav9_1_2
channel c1: piece handle=0coktav9_1_2 tag=TAG20130927T124246
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:01:35
output file name=+DATA/dupdb/controlfile/current.613.827932157
Finished restore at 04-OCT-13
database mounted
RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
contents of Memory Script:
{
set until scn 86339128;
set newname for datafile 1 to
"+DATA";
set newname for datafile 2 to
"+DATA";
set newname for datafile 3 to
"+DATA";
set newname for datafile 4 to
"+DATA";
set newname for datafile 5 to
"+DATA";
set newname for datafile 6 to
"+DATA";
set newname for datafile 7 to
"+DATA";
set newname for datafile 8 to
"+DATA";
set newname for datafile 9 to
"+DATA";
set newname for datafile 10 to
"+DATA";
set newname for datafile 11 to
"+DATA";
set newname for datafile 12 to
"+DATA";
set newname for datafile 13 to
"+DATA";
set newname for datafile 14 to
"+DATA";
set newname for datafile 15 to
"+DATA";
set newname for datafile 16 to
"+DATA";
set newname for datafile 17 to
"+DATA";
set newname for datafile 18 to
"+DATA";
set newname for datafile 19 to
"+DATA";
set newname for datafile 20 to
"+DATA";
set newname for datafile 21 to
"+DATA";
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 04-OCT-13
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00005 to +DATA
channel c1: restoring datafile 00009 to +DATA
channel c1: restoring datafile 00014 to +DATA
channel c1: restoring datafile 00021 to +DATA
channel c1: reading from backup piece 0aoktapa_1_2
channel c1: piece handle=0aoktapa_1_2 tag=TAG20130927T124010
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:03:15
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00004 to +DATA
channel c1: restoring datafile 00013 to +DATA
channel c1: restoring datafile 00015 to +DATA
channel c1: restoring datafile 00016 to +DATA
channel c1: reading from backup piece 0koliake_1_2
channel c1: piece handle=0koliake_1_2 tag=TAG20131004T114617
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:02:45
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00003 to +DATA
channel c1: restoring datafile 00006 to +DATA
channel c1: restoring datafile 00010 to +DATA
channel c1: restoring datafile 00011 to +DATA
channel c1: reading from backup piece 0loliakg_1_2
channel c1: piece handle=0loliakg_1_2 tag=TAG20131004T114617
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 01:39:27
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00002 to +DATA
channel c1: reading from backup piece 0joliake_1_2
channel c1: piece handle=0joliake_1_2 tag=TAG20131004T114617
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:03:25
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00007 to +DATA
channel c1: restoring datafile 00017 to +DATA
channel c1: restoring datafile 00019 to +DATA
channel c1: restoring datafile 00020 to +DATA
channel c1: reading from backup piece 0noliam4_1_2
channel c1: piece handle=0noliam4_1_2 tag=TAG20131004T114617
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:01:45
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to +DATA
channel c1: restoring datafile 00008 to +DATA
channel c1: restoring datafile 00012 to +DATA
channel c1: restoring datafile 00018 to +DATA
channel c1: reading from backup piece 0molial7_1_2
channel c1: piece handle=0molial7_1_2 tag=TAG20131004T114617
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:24:46
Finished restore at 04-OCT-13
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=42 STAMP=827940402 file name=+DATA/dupdb/datafile/XXXXXXXXXX
datafile 2 switched to datafile copy
................
datafile 21 switched to datafile copy
input datafile copy RECID=62 STAMP=827940403 file name=+DATA/dupdb/datafile/XXXXXXXXXXXXXX
contents of Memory Script:
{
set until time "to_date('OCT 04 2013 11:48:00', 'MON DD YYYY HH24:MI:SS')";
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 04-OCT-13
starting media recovery
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=3
channel c1: reading from backup piece 0foliahc_1_2
channel c1: piece handle=0foliahc_1_2 tag=TAG20131004T114443
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 01:54:58
archived log file name=+DATA/dupdb/archivelog/2013_10_04/thread_1_seq_3.730.827947277 thread=1 sequence=3
channel clone_default: deleting archived log(s)
archived log file name=+DATA/dupdb/archivelog/2013_10_04/thread_1_seq_3.730.827947277 RECID=20 STAMP=827947298
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=4
channel c1: reading from backup piece 0goliahc_1_2
channel c1: piece handle=0goliahc_1_2 tag=TAG20131004T114443
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 18:27:13
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_4.730.828013663 thread=1 sequence=4
channel clone_default: deleting archived log(s)
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_4.730.828013663 RECID=21 STAMP=828013729
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=5
channel c1: reading from backup piece 0holiahc_1_2
channel c1: piece handle=0holiahc_1_2 tag=TAG20131004T114443
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:02:45
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_5.730.828013865 thread=1 sequence=5
channel clone_default: deleting archived log(s)
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_5.730.828013865 RECID=22 STAMP=828013905
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=6
channel c1: reading from backup piece 0ioliahh_1_2
channel c1: piece handle=0ioliahh_1_2 tag=TAG20131004T114443
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:02:35
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_6.730.828014051 thread=1 sequence=6
channel clone_default: deleting archived log(s)
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_6.730.828014051 RECID=23 STAMP=828014058
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=7
channel c1: reading from backup piece 0poliap9_1_2
channel c1: piece handle=0poliap9_1_2 tag=TAG20131004T114854
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:02:25
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_7.730.828014201 thread=1 sequence=7
channel clone_default: deleting archived log(s)
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_7.730.828014201 RECID=24 STAMP=828014201
media recovery complete, elapsed time: 00:00:01
Finished recover at 05-OCT-13
Oracle instance started
Total System Global Area 4175568896 bytes
Fixed Size 2234960 bytes
Variable Size 2231371184 bytes
Database Buffers 1929379840 bytes
Redo Buffers 12582912 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''DUPDB'' 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 = ''DUPDB'' 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 4175568896 bytes
Fixed Size 2234960 bytes
Variable Size 2231371184 bytes
Database Buffers 1929379840 bytes
Redo Buffers 12582912 bytes
allocated channel: c1
channel c1: SID=387 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUPDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 576
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 96
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 2 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 3 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 4 ( '+DATA', '+DATA' ) SIZE 512 M REUSE
DATAFILE
'+DATA/dupdb/datafile/system.709.827940285'
CHARACTER SET AL32UTF8
sql statement: ALTER DATABASE ADD LOGFILE
INSTANCE 'i2'
GROUP 5 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 6 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 7 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 8 ( '+DATA', '+DATA' ) SIZE 512 M REUSE
sql statement: ALTER DATABASE ADD LOGFILE
INSTANCE 'i3'
GROUP 9 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 10 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 11 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 12 ( '+DATA', '+DATA' ) SIZE 512 M REUSE
sql statement: ALTER DATABASE ADD LOGFILE
INSTANCE 'i4'
GROUP 13 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 14 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 15 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 16 ( '+DATA', '+DATA' ) SIZE 512 M REUSE
contents of Memory Script:
{
set newname for tempfile 1 to
"+DATA";
set newname for tempfile 2 to
"+DATA";
set newname for tempfile 3 to
"+DATA";
set newname for tempfile 4 to
"+DATA";
switch clone tempfile all;
catalog clone datafilecopy "+DATA/dupdb/datafile/sysaux.XXXXX",
"+DATA/dupdb/datafile/undotbs1.366.827938583",
..............
................
"+DATA/dupdb/datafile/XXXXXXXXXX.572.827932361";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to +DATA in control file
renamed tempfile 2 to +DATA in control file
renamed tempfile 3 to +DATA in control file
renamed tempfile 4 to +DATA in control file
cataloged datafile copy
datafile copy file name=+DATA/dupdb/datafile/XXXXXXXX RECID=1 STAMP=828014358
cataloged datafile copy
...........
............
cataloged datafile copy
datafile copy file name=+DATA/dupdb/datafile/XXXXXXXXXXXXX RECID=20 STAMP=828014359
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=828014358 file name=+DATA/dupdb/datafile/XXXXXXXXX
datafile 3 switched to datafile copy
............
...........
datafile 21 switched to datafile copy
input datafile copy RECID=20 STAMP=828014359 file name=+DATA/dupdb/datafile/XXXXXXXXXXXXXXXX
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 05-OCT-13
released channel: c1
RMAN>
[oracle@subhen-db01 dbs]$ cat initDUPDB.ora
db_name=DUPDB
sga_target=4G
[oracle@subhen-db01 dbs]$
[oracle@subhen-db01 dbs]$ echo $ORACLE_SID
DUPDB
[oracle@subhen-db01 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 4 12:05:02 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='initDUPDB.ora'
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2235208 bytes
Variable Size 822084792 bytes
Database Buffers 3439329280 bytes
Redo Buffers 12132352 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@subhen-db01 admin]$ echo $ORACLE_SID
DUPDB
[oracle@subhen-db01 dbs]$ rman auxiliary / catalog CATALOG_SCHEMA/<password>@<catalog_DB>
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Oct 4 13:07:07 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
connected to auxiliary database: DUPDB (not mounted)
RMAN> run
{
2> 3> allocate auxiliary channel c1 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLASS=XXXXXXXX, NB_ORA_SERV=XXXXXXXX, NB_ORA_SCHED=oracle,NB_ORA_CLIENT=<db host from where backup was taken>)';
4> DUPLICATE DATABASE ORCL DBID 1343XXXX to DUPDB UNTIL TIME "TO_DATE('04/10/2013 11:48:00','DD/MM/YYYY HH24:MI:SS')" SPFILE PARAMETER_VALUE_CONVERT="ORCL","DUPDB"
5> set cluster_database="FALSE"
set DB_UNIQUE_NAME="DUPDB"
6> 7> set db_create_file_dest="+DATA"
8> set instance_number="1"
9> set local_listener="LISTENER_DUPDB"
10> set REMOTE_LISTENER=''
11> set db_file_name_convert='+DATA/ORCL','+DATA/DUPDB'
set log_file_name_convert='+DATA/ORCL','+DATA/DUPDB'
12> 13> set control_files='+DATA'
14> set db_recovery_file_dest='+DATA'
15> NOFILENAMECHECK;
16> }
allocated channel: c1
channel c1: SID=429 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)
Starting Duplicate Db at 04-OCT-13
contents of Memory Script:
{
set until scn 86339128;
restore clone spfile to '/oracle/app/database/11.2.0.3/dbhome_1/dbs/spfileDUPDB.ora';
sql clone "alter system set spfile= ''/oracle/app/database/11.2.0.3/dbhome_1/dbs/spfileDUPDB.ora''";
}
executing Memory Script
executing command: SET until clause
Starting restore at 04-OCT-13
WARNING: A restore time was estimated based on the supplied UNTIL SCN
channel c1: starting datafile backup set restore
channel c1: restoring SPFILE
output file name=/oracle/app/database/11.2.0.3/dbhome_1/dbs/spfileDUPDB.ora
channel c1: reading from backup piece 0coktav9_1_2
channel c1: piece handle=0coktav9_1_2 tag=TAG20130927T124246
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:01:35
Finished restore at 04-OCT-13
sql statement: alter system set spfile= ''/oracle/app/database/11.2.0.3/dbhome_1/dbs/spfileDUPDB.ora''
contents of Memory Script:
{
sql clone "alter system set db_name =
''DUPDB'' comment=
''duplicate'' scope=spfile";
sql clone "alter system set audit_file_dest =
''/oracle/app/admin/DUPDB/adump'' comment=
'''' scope=spfile";
sql clone "alter system set dispatchers =
''(PROTOCOL=TCP) (SERVICE=DUPDBXDB)'' comment=
'''' scope=spfile";
sql clone "alter system set cluster_database =
FALSE comment=
'''' scope=spfile";
sql clone "alter system set db_unique_name =
''DUPDB'' comment=
'''' scope=spfile";
sql clone "alter system set db_create_file_dest =
''+DATA'' comment=
'''' scope=spfile";
sql clone "alter system set instance_number =
1 comment=
'''' scope=spfile";
sql clone "alter system set local_listener =
''LISTENER_DUPDB'' comment=
'''' scope=spfile";
sql clone "alter system set REMOTE_LISTENER =
'''' comment=
'''' scope=spfile";
sql clone "alter system set db_file_name_convert =
''+DATA/ORCL'', ''+DATA/DUPDB'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''+DATA/ORCL'', ''+DATA/DUPDB'' comment=
'''' scope=spfile";
sql clone "alter system set control_files =
''+DATA'' comment=
'''' scope=spfile";
sql clone "alter system set db_recovery_file_dest =
''+DATA'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''DUPDB'' comment= ''duplicate'' scope=spfile
sql statement: alter system set audit_file_dest = ''/oracle/app/admin/DUPDB/adump'' comment= '''' scope=spfile
sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=DUPDBXDB)'' comment= '''' scope=spfile
sql statement: alter system set cluster_database = FALSE comment= '''' scope=spfile
sql statement: alter system set db_unique_name = ''DUPDB'' comment= '''' scope=spfile
sql statement: alter system set db_create_file_dest = ''+DATA'' comment= '''' scope=spfile
sql statement: alter system set instance_number = 1 comment= '''' scope=spfile
sql statement: alter system set local_listener = ''LISTENER_DUPDB'' comment= '''' scope=spfile
sql statement: alter system set REMOTE_LISTENER = '''' comment= '''' scope=spfile
sql statement: alter system set db_file_name_convert = ''+DATA/ORCL'', ''+DATA/DUPDB'' comment= '''' scope=spfile
sql statement: alter system set log_file_name_convert = ''+DATA/ORCL'', ''+DATA/DUPDB'' comment= '''' scope=spfile
sql statement: alter system set control_files = ''+DATA'' comment= '''' scope=spfile
sql statement: alter system set db_recovery_file_dest = ''+DATA'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 4175568896 bytes
Fixed Size 2234960 bytes
Variable Size 2231371184 bytes
Database Buffers 1929379840 bytes
Redo Buffers 12582912 bytes
allocated channel: c1
channel c1: SID=386 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)
contents of Memory Script:
{
set until scn 86339128;
sql clone "alter system set control_files =
''+DATA/dupdb/controlfile/current.613.827932157'' comment=
''Set by RMAN'' scope=spfile";
sql clone "alter system set db_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''DUPDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile;
alter clone database mount;
}
executing Memory Script
executing command: SET until clause
sql statement: alter system set control_files = ''+DATA/dupdb/controlfile/XXXXXXXXXX'' comment= ''Set by RMAN'' scope=spfile
sql statement: alter system set db_name = ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''DUPDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 4175568896 bytes
Fixed Size 2234960 bytes
Variable Size 2231371184 bytes
Database Buffers 1929379840 bytes
Redo Buffers 12582912 bytes
allocated channel: c1
channel c1: SID=386 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)
Starting restore at 04-OCT-13
channel c1: starting datafile backup set restore
channel c1: restoring control file
channel c1: reading from backup piece 0coktav9_1_2
channel c1: piece handle=0coktav9_1_2 tag=TAG20130927T124246
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:01:35
output file name=+DATA/dupdb/controlfile/current.613.827932157
Finished restore at 04-OCT-13
database mounted
RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
contents of Memory Script:
{
set until scn 86339128;
set newname for datafile 1 to
"+DATA";
set newname for datafile 2 to
"+DATA";
set newname for datafile 3 to
"+DATA";
set newname for datafile 4 to
"+DATA";
set newname for datafile 5 to
"+DATA";
set newname for datafile 6 to
"+DATA";
set newname for datafile 7 to
"+DATA";
set newname for datafile 8 to
"+DATA";
set newname for datafile 9 to
"+DATA";
set newname for datafile 10 to
"+DATA";
set newname for datafile 11 to
"+DATA";
set newname for datafile 12 to
"+DATA";
set newname for datafile 13 to
"+DATA";
set newname for datafile 14 to
"+DATA";
set newname for datafile 15 to
"+DATA";
set newname for datafile 16 to
"+DATA";
set newname for datafile 17 to
"+DATA";
set newname for datafile 18 to
"+DATA";
set newname for datafile 19 to
"+DATA";
set newname for datafile 20 to
"+DATA";
set newname for datafile 21 to
"+DATA";
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 04-OCT-13
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00005 to +DATA
channel c1: restoring datafile 00009 to +DATA
channel c1: restoring datafile 00014 to +DATA
channel c1: restoring datafile 00021 to +DATA
channel c1: reading from backup piece 0aoktapa_1_2
channel c1: piece handle=0aoktapa_1_2 tag=TAG20130927T124010
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:03:15
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00004 to +DATA
channel c1: restoring datafile 00013 to +DATA
channel c1: restoring datafile 00015 to +DATA
channel c1: restoring datafile 00016 to +DATA
channel c1: reading from backup piece 0koliake_1_2
channel c1: piece handle=0koliake_1_2 tag=TAG20131004T114617
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:02:45
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00003 to +DATA
channel c1: restoring datafile 00006 to +DATA
channel c1: restoring datafile 00010 to +DATA
channel c1: restoring datafile 00011 to +DATA
channel c1: reading from backup piece 0loliakg_1_2
channel c1: piece handle=0loliakg_1_2 tag=TAG20131004T114617
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 01:39:27
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00002 to +DATA
channel c1: reading from backup piece 0joliake_1_2
channel c1: piece handle=0joliake_1_2 tag=TAG20131004T114617
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:03:25
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00007 to +DATA
channel c1: restoring datafile 00017 to +DATA
channel c1: restoring datafile 00019 to +DATA
channel c1: restoring datafile 00020 to +DATA
channel c1: reading from backup piece 0noliam4_1_2
channel c1: piece handle=0noliam4_1_2 tag=TAG20131004T114617
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:01:45
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to +DATA
channel c1: restoring datafile 00008 to +DATA
channel c1: restoring datafile 00012 to +DATA
channel c1: restoring datafile 00018 to +DATA
channel c1: reading from backup piece 0molial7_1_2
channel c1: piece handle=0molial7_1_2 tag=TAG20131004T114617
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:24:46
Finished restore at 04-OCT-13
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=42 STAMP=827940402 file name=+DATA/dupdb/datafile/XXXXXXXXXX
datafile 2 switched to datafile copy
................
datafile 21 switched to datafile copy
input datafile copy RECID=62 STAMP=827940403 file name=+DATA/dupdb/datafile/XXXXXXXXXXXXXX
contents of Memory Script:
{
set until time "to_date('OCT 04 2013 11:48:00', 'MON DD YYYY HH24:MI:SS')";
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 04-OCT-13
starting media recovery
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=3
channel c1: reading from backup piece 0foliahc_1_2
channel c1: piece handle=0foliahc_1_2 tag=TAG20131004T114443
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 01:54:58
archived log file name=+DATA/dupdb/archivelog/2013_10_04/thread_1_seq_3.730.827947277 thread=1 sequence=3
channel clone_default: deleting archived log(s)
archived log file name=+DATA/dupdb/archivelog/2013_10_04/thread_1_seq_3.730.827947277 RECID=20 STAMP=827947298
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=4
channel c1: reading from backup piece 0goliahc_1_2
channel c1: piece handle=0goliahc_1_2 tag=TAG20131004T114443
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 18:27:13
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_4.730.828013663 thread=1 sequence=4
channel clone_default: deleting archived log(s)
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_4.730.828013663 RECID=21 STAMP=828013729
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=5
channel c1: reading from backup piece 0holiahc_1_2
channel c1: piece handle=0holiahc_1_2 tag=TAG20131004T114443
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:02:45
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_5.730.828013865 thread=1 sequence=5
channel clone_default: deleting archived log(s)
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_5.730.828013865 RECID=22 STAMP=828013905
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=6
channel c1: reading from backup piece 0ioliahh_1_2
channel c1: piece handle=0ioliahh_1_2 tag=TAG20131004T114443
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:02:35
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_6.730.828014051 thread=1 sequence=6
channel clone_default: deleting archived log(s)
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_6.730.828014051 RECID=23 STAMP=828014058
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=7
channel c1: reading from backup piece 0poliap9_1_2
channel c1: piece handle=0poliap9_1_2 tag=TAG20131004T114854
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:02:25
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_7.730.828014201 thread=1 sequence=7
channel clone_default: deleting archived log(s)
archived log file name=+DATA/dupdb/archivelog/2013_10_05/thread_1_seq_7.730.828014201 RECID=24 STAMP=828014201
media recovery complete, elapsed time: 00:00:01
Finished recover at 05-OCT-13
Oracle instance started
Total System Global Area 4175568896 bytes
Fixed Size 2234960 bytes
Variable Size 2231371184 bytes
Database Buffers 1929379840 bytes
Redo Buffers 12582912 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''DUPDB'' 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 = ''DUPDB'' 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 4175568896 bytes
Fixed Size 2234960 bytes
Variable Size 2231371184 bytes
Database Buffers 1929379840 bytes
Redo Buffers 12582912 bytes
allocated channel: c1
channel c1: SID=387 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUPDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 576
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 96
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 2 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 3 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 4 ( '+DATA', '+DATA' ) SIZE 512 M REUSE
DATAFILE
'+DATA/dupdb/datafile/system.709.827940285'
CHARACTER SET AL32UTF8
sql statement: ALTER DATABASE ADD LOGFILE
INSTANCE 'i2'
GROUP 5 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 6 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 7 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 8 ( '+DATA', '+DATA' ) SIZE 512 M REUSE
sql statement: ALTER DATABASE ADD LOGFILE
INSTANCE 'i3'
GROUP 9 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 10 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 11 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 12 ( '+DATA', '+DATA' ) SIZE 512 M REUSE
sql statement: ALTER DATABASE ADD LOGFILE
INSTANCE 'i4'
GROUP 13 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 14 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 15 ( '+DATA', '+DATA' ) SIZE 512 M REUSE,
GROUP 16 ( '+DATA', '+DATA' ) SIZE 512 M REUSE
contents of Memory Script:
{
set newname for tempfile 1 to
"+DATA";
set newname for tempfile 2 to
"+DATA";
set newname for tempfile 3 to
"+DATA";
set newname for tempfile 4 to
"+DATA";
switch clone tempfile all;
catalog clone datafilecopy "+DATA/dupdb/datafile/sysaux.XXXXX",
"+DATA/dupdb/datafile/undotbs1.366.827938583",
..............
................
"+DATA/dupdb/datafile/XXXXXXXXXX.572.827932361";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to +DATA in control file
renamed tempfile 2 to +DATA in control file
renamed tempfile 3 to +DATA in control file
renamed tempfile 4 to +DATA in control file
cataloged datafile copy
datafile copy file name=+DATA/dupdb/datafile/XXXXXXXX RECID=1 STAMP=828014358
cataloged datafile copy
...........
............
cataloged datafile copy
datafile copy file name=+DATA/dupdb/datafile/XXXXXXXXXXXXX RECID=20 STAMP=828014359
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=828014358 file name=+DATA/dupdb/datafile/XXXXXXXXX
datafile 3 switched to datafile copy
............
...........
datafile 21 switched to datafile copy
input datafile copy RECID=20 STAMP=828014359 file name=+DATA/dupdb/datafile/XXXXXXXXXXXXXXXX
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 05-OCT-13
released channel: c1
RMAN>
No comments:
Post a Comment