O RMAN possui a capacidade de resumir um DUPLICATE com falha reaproveitando os datafiles que já foram restaurados ou copiados para o destino, bastando apenas reiniciar a instância auxiliar em NOMOUNT e reexecutar o script RMAN com a mesma síntaxe utilizada na tentativa com falha.
Para conseguir isso, o RMAN usa a feature RESTORE OPTIMIZATION, onde o datafile não é restaurado se o mesmo já existir no destino com um SCN inferior ao que o RMAN irá usar para realizar o restore. Note que o recurso é empregado em operações de restore convencional, em duplicate a partir de um backup e em duplicate a partir de um banco de dados ativo (na prática, o RMAN gera um backup na origem e faz restore no destino).
Demonstração
Iniciando um ACTIVE DUPLICATE e inrreompendo o processo propositalmente após restaurar os primeiros datafiles:
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Oct 26 15:23:50 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: DB19C (DBID=2209240791)
connected to auxiliary database: ORCL (not mounted)
RMAN> duplicate target database to orcl from active database nofilenamecheck;
Starting Duplicate Db at 26-OCT-21
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=153 device type=DISK
current log archived
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 1073738608 bytes
Fixed Size 9143152 bytes
Variable Size 276824064 bytes
Database Buffers 780140544 bytes
Redo Buffers 7630848 bytes
duplicating Online logs to Oracle Managed File (OMF) location
duplicating Datafiles to Oracle Managed File (OMF) location
contents of Memory Script:
{
sql clone "alter system set control_files =
''+DATA/ORCL/CONTROLFILE/current.292.1086967493'', ''+RECO/ORCL/CONTROLFILE/current.263.1086967493'' comment=
''Set by RMAN'' scope=spfile";
sql clone "alter system set db_name =
''DB19C'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''orcl'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone from service 'db19c_lab01' primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set control_files = ''+DATA/ORCL/CONTROLFILE/current.292.1086967493'', ''+RECO/ORCL/CONTROLFILE/current.263.1086967493'' comment= ''Set by RMAN'' scope=spfile
sql statement: alter system set db_name = ''DB19C'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''orcl'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 1073738608 bytes
Fixed Size 9143152 bytes
Variable Size 276824064 bytes
Database Buffers 780140544 bytes
Redo Buffers 7630848 bytes
Starting restore at 26-OCT-21
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
output file name=+DATA/ORCL/CONTROLFILE/current.292.1086967493
output file name=+RECO/ORCL/CONTROLFILE/current.263.1086967493
Finished restore at 26-OCT-21
database mounted
contents of Memory Script:
{
set newname for clone datafile 1 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
set newname for clone datafile 7 to new;
set newname for clone datafile 8 to new;
set newname for clone datafile 9 to new;
set newname for clone datafile 10 to new;
set newname for clone datafile 11 to new;
set newname for clone datafile 12 to new;
set newname for clone datafile 13 to new;
set newname for clone datafile 14 to new;
set newname for clone datafile 15 to new;
set newname for clone datafile 16 to new;
set newname for clone datafile 17 to new;
set newname for clone datafile 21 to new;
set newname for clone datafile 22 to new;
set newname for clone datafile 24 to new;
restore
from nonsparse from service
'db19c_lab01' clone database
;
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
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 26-OCT-21
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to +DATA
^C
user interrupt received
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/26/2021 15:25:53
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03099: job cancelled at user request
RMAN>
Os datafiles 1 e 3 foram copiados com sucesso.
Observe o seguinte trecho do script, onde o RMAN irá gerar novos nomes para todos os datafiles:
contents of Memory Script:
{
set newname for clone datafile 1 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
set newname for clone datafile 7 to new;
set newname for clone datafile 8 to new;
set newname for clone datafile 9 to new;
set newname for clone datafile 10 to new;
set newname for clone datafile 11 to new;
set newname for clone datafile 12 to new;
set newname for clone datafile 13 to new;
set newname for clone datafile 14 to new;
set newname for clone datafile 15 to new;
set newname for clone datafile 16 to new;
set newname for clone datafile 17 to new;
set newname for clone datafile 21 to new;
set newname for clone datafile 22 to new;
set newname for clone datafile 24 to new;
restore
from nonsparse from service
'db19c_lab01' clone database
;
sql 'alter system archive log current';
}
Note que para todos os datafiles, foi utilizada a opção “to new”, onde o Oracle irá gerar novos nomes para os datafiles (OMF neste exemplo).
Durante o duplicate, para atender a feature de “Resume Failed Duplicate”, o RMAN cria um arquivo de controle no servidor da instância auxiliar, abaixo de $ORACLE_HOME/dbs, no padrão “_rm_dup_<DBNAME>_<SID>.dat”.
Veja abaixo o exemplo gerado neste teste, com o banco chamado ORCL:
[oracle@lab02 dbs]$ ls -l $ORACLE_HOME/dbs/*dup*
-rw-r--r-- 1 oracle asmadmin 1088 Oct 26 15:25 /u01/app/oracle/product/19.0.0.0/db_1/dbs/_rm_dup_ORCL_orcl.dat
Dando um cat no arquivo, vemos a relação de datafiles que o RMAN completou a cópia:
[oracle@lab02 dbs]$ cat $ORACLE_HOME/dbs/_rm_dup_ORCL_orcl.dat +DATA/ORCL/DATAFILE/system.300.1086967547+DATA/ORCL/DATAFILE/sysaux.296.1086967549
Agora vamos reiniciar o duplicate, primeiro colocando a instância auxiliar em NOMOUNT novamente:
SQL> shutdown immediate; ORA-01109: database not open
[oracle@lab02 dbs]$ rm -f spfileorcl.ora
SQL> startup nomount; ORACLE instance started. Total System Global Area 1073738608 bytes Fixed Size 9143152 bytes Variable Size 276824064 bytes Database Buffers 780140544 bytes Redo Buffers 7630848 bytes
Reexecutando o DUPLICATE no RMAN:
RMAN> duplicate target database to orcl from active database nofilenamecheck;
Starting Duplicate Db at 26-OCT-21
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=153 device type=DISK
current log archived
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 1073738608 bytes
Fixed Size 9143152 bytes
Variable Size 276824064 bytes
Database Buffers 780140544 bytes
Redo Buffers 7630848 bytes
duplicating Online logs to Oracle Managed File (OMF) location
duplicating Datafiles to Oracle Managed File (OMF) location
contents of Memory Script:
{
sql clone "alter system set control_files =
''+DATA/ORCL/CONTROLFILE/current.294.1086967973'', ''+RECO/ORCL/CONTROLFILE/current.265.1086967973'' comment=
''Set by RMAN'' scope=spfile";
sql clone "alter system set db_name =
''DB19C'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''orcl'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone from service 'db19c_lab01' primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set control_files = ''+DATA/ORCL/CONTROLFILE/current.294.1086967973'', ''+RECO/ORCL/CONTROLFILE/current.265.1086967973'' comment= ''Set by RMAN'' scope=spfile
sql statement: alter system set db_name = ''DB19C'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''orcl'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 1073738608 bytes
Fixed Size 9143152 bytes
Variable Size 276824064 bytes
Database Buffers 780140544 bytes
Redo Buffers 7630848 bytes
Starting restore at 26-OCT-21
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DATA/ORCL/CONTROLFILE/current.294.1086967973
output file name=+RECO/ORCL/CONTROLFILE/current.265.1086967973
Finished restore at 26-OCT-21
database mounted
Using previous duplicated file +DATA/ORCL/DATAFILE/system.300.1086967547 for datafile 1 with checkpoint SCN of 15278282
Using previous duplicated file +DATA/ORCL/DATAFILE/sysaux.296.1086967549 for datafile 3 with checkpoint SCN of 15278288
contents of Memory Script:
{
set newname for datafile 1 to
"+DATA/ORCL/DATAFILE/system.300.1086967547";
set newname for datafile 3 to
"+DATA/ORCL/DATAFILE/sysaux.296.1086967549";
set newname for clone datafile 4 to new;
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
set newname for clone datafile 7 to new;
set newname for clone datafile 8 to new;
set newname for clone datafile 9 to new;
set newname for clone datafile 10 to new;
set newname for clone datafile 11 to new;
set newname for clone datafile 12 to new;
set newname for clone datafile 13 to new;
set newname for clone datafile 14 to new;
set newname for clone datafile 15 to new;
set newname for clone datafile 16 to new;
set newname for clone datafile 17 to new;
set newname for clone datafile 21 to new;
set newname for clone datafile 22 to new;
set newname for clone datafile 24 to new;
restore
from nonsparse from service
'db19c_lab01' clone datafile
4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 21, 22, 24 ;
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
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 26-OCT-21
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00006 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00008 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00009 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00010 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00011 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00012 to +DATA
^C
user interrupt received
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/26/2021 15:33:59
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03099: job cancelled at user request
RMAN>
Após copiar mais alguns datafiles, interrompi o processo novamente. Note que o RMAN já indicou que vai reutilizar os dois datafiles:
Using previous duplicated file +DATA/ORCL/DATAFILE/system.300.1086967547 for datafile 1 with checkpoint SCN of 15278282
Using previous duplicated file +DATA/ORCL/DATAFILE/sysaux.296.1086967549 for datafile 3 with checkpoint SCN of 15278288
Agora observe o conteúdo do script onde o RMAN define os novos nomes para os datafiles:
contents of Memory Script:
{
set newname for datafile 1 to
"+DATA/ORCL/DATAFILE/system.300.1086967547";
set newname for datafile 3 to
"+DATA/ORCL/DATAFILE/sysaux.296.1086967549";
set newname for clone datafile 4 to new;
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
set newname for clone datafile 7 to new;
set newname for clone datafile 8 to new;
set newname for clone datafile 9 to new;
set newname for clone datafile 10 to new;
set newname for clone datafile 11 to new;
set newname for clone datafile 12 to new;
set newname for clone datafile 13 to new;
set newname for clone datafile 14 to new;
set newname for clone datafile 15 to new;
set newname for clone datafile 16 to new;
set newname for clone datafile 17 to new;
set newname for clone datafile 21 to new;
set newname for clone datafile 22 to new;
set newname for clone datafile 24 to new;
restore
from nonsparse from service
'db19c_lab01' clone datafile
4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 21, 22, 24 ;
sql 'alter system archive log current';
}
Para os datafiles 1 e 3 que haviam sido copiados com sucesso na primeira tentativa, o RMAN usou a opção “to <file_name>” ao invés de “to new” no comando “set newname for clone datafile”. O caminho do datafile utilizado no comando é o mesmo caminho no qual o datafile foi restaurado anteriormente, dessa forma não é gerado um novo nome OMF, e se o RMAN encontrar o datafile no disco, o mesmo não será copiado novamente.
Por fim, executei o DUPLICATE novamente (após colocar a instância auxiliar em NOMOUNT) e deixei o procedimento concluir:
RMAN> duplicate target database to orcl from active database nofilenamecheck;
Starting Duplicate Db at 26-OCT-21
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=152 device type=DISK
current log archived
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 1073738608 bytes
Fixed Size 9143152 bytes
Variable Size 276824064 bytes
Database Buffers 780140544 bytes
Redo Buffers 7630848 bytes
duplicating Online logs to Oracle Managed File (OMF) location
duplicating Datafiles to Oracle Managed File (OMF) location
contents of Memory Script:
{
sql clone "alter system set control_files =
''+DATA/ORCL/CONTROLFILE/current.266.1086969051'', ''+RECO/ORCL/CONTROLFILE/current.256.1086969051'' comment=
''Set by RMAN'' scope=spfile";
sql clone "alter system set db_name =
''DB19C'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''orcl'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone from service 'db19c_lab01' primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set control_files = ''+DATA/ORCL/CONTROLFILE/current.266.1086969051'', ''+RECO/ORCL/CONTROLFILE/current.256.1086969051'' comment= ''Set by RMAN'' scope=spfile
sql statement: alter system set db_name = ''DB19C'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''orcl'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 1073738608 bytes
Fixed Size 9143152 bytes
Variable Size 276824064 bytes
Database Buffers 780140544 bytes
Redo Buffers 7630848 bytes
Starting restore at 26-OCT-21
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DATA/ORCL/CONTROLFILE/current.266.1086969051
output file name=+RECO/ORCL/CONTROLFILE/current.256.1086969051
Finished restore at 26-OCT-21
database mounted
Using previous duplicated file +DATA/ORCL/DATAFILE/system.300.1086967547 for datafile 1 with checkpoint SCN of 15278282
Using previous duplicated file +DATA/ORCL/DATAFILE/sysaux.296.1086967549 for datafile 3 with checkpoint SCN of 15278288
Using previous duplicated file +DATA/ORCL/DATAFILE/undotbs1.306.1086968027 for datafile 4 with checkpoint SCN of 15279564
Using previous duplicated file +DATA/ORCL/DATAFILE/users.304.1086968033 for datafile 7 with checkpoint SCN of 15279574
Using previous duplicated file +DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/system.291.1086968035 for datafile 9 with checkpoint SCN of 15279581
Using previous duplicated file +DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/sysaux.298.1086968037 for datafile 10 with checkpoint SCN of 15279583
Using previous duplicated file +DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/undotbs1.297.1086968037 for datafile 11 with checkpoint SCN of 15279586
contents of Memory Script:
{
set newname for datafile 1 to
"+DATA/ORCL/DATAFILE/system.300.1086967547";
set newname for datafile 3 to
"+DATA/ORCL/DATAFILE/sysaux.296.1086967549";
set newname for datafile 4 to
"+DATA/ORCL/DATAFILE/undotbs1.306.1086968027";
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
set newname for datafile 7 to
"+DATA/ORCL/DATAFILE/users.304.1086968033";
set newname for clone datafile 8 to new;
set newname for datafile 9 to
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/system.291.1086968035";
set newname for datafile 10 to
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/sysaux.298.1086968037";
set newname for datafile 11 to
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/undotbs1.297.1086968037";
set newname for clone datafile 12 to new;
set newname for clone datafile 13 to new;
set newname for clone datafile 14 to new;
set newname for clone datafile 15 to new;
set newname for clone datafile 16 to new;
set newname for clone datafile 17 to new;
set newname for clone datafile 21 to new;
set newname for clone datafile 22 to new;
set newname for clone datafile 24 to new;
restore
from nonsparse from service
'db19c_lab01' clone datafile
5, 6, 8, 12, 13, 14, 15, 16, 17, 21, 22, 24 ;
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
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 26-OCT-21
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00006 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00008 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00012 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00013 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00014 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00015 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00016 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00017 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00021 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00022 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00024 to +DATA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 26-OCT-21
sql statement: alter system archive log current
current log archived
contents of Memory Script:
{
restore clone force from service 'db19c_lab01'
archivelog from scn 15278282;
catalog clone datafilecopy "+DATA/ORCL/DATAFILE/system.300.1086967547",
"+DATA/ORCL/DATAFILE/sysaux.296.1086967549",
"+DATA/ORCL/DATAFILE/undotbs1.306.1086968027",
"+DATA/ORCL/DATAFILE/users.304.1086968033",
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/system.291.1086968035",
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/sysaux.298.1086968037",
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/undotbs1.297.1086968037";
switch clone datafile 1 to datafilecopy
"+DATA/ORCL/DATAFILE/system.300.1086967547";
switch clone datafile 3 to datafilecopy
"+DATA/ORCL/DATAFILE/sysaux.296.1086967549";
switch clone datafile 4 to datafilecopy
"+DATA/ORCL/DATAFILE/undotbs1.306.1086968027";
switch clone datafile 7 to datafilecopy
"+DATA/ORCL/DATAFILE/users.304.1086968033";
switch clone datafile 9 to datafilecopy
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/system.291.1086968035";
switch clone datafile 10 to datafilecopy
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/sysaux.298.1086968037";
switch clone datafile 11 to datafilecopy
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/undotbs1.297.1086968037";
switch clone datafile all;
}
executing Memory Script
Starting restore at 26-OCT-21
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=80
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=81
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=82
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=83
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service db19c_lab01
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=84
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 26-OCT-21
cataloged datafile copy
datafile copy file name=+DATA/ORCL/DATAFILE/system.300.1086967547 RECID=16 STAMP=1086969139
cataloged datafile copy
datafile copy file name=+DATA/ORCL/DATAFILE/sysaux.296.1086967549 RECID=17 STAMP=1086969139
cataloged datafile copy
datafile copy file name=+DATA/ORCL/DATAFILE/undotbs1.306.1086968027 RECID=18 STAMP=1086969139
cataloged datafile copy
datafile copy file name=+DATA/ORCL/DATAFILE/users.304.1086968033 RECID=19 STAMP=1086969139
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/system.291.1086968035 RECID=20 STAMP=1086969139
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/sysaux.298.1086968037 RECID=21 STAMP=1086969139
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/undotbs1.297.1086968037 RECID=22 STAMP=1086969139
datafile 1 switched to datafile copy
input datafile copy RECID=16 STAMP=1086969139 file name=+DATA/ORCL/DATAFILE/system.300.1086967547
datafile 3 switched to datafile copy
input datafile copy RECID=17 STAMP=1086969139 file name=+DATA/ORCL/DATAFILE/sysaux.296.1086967549
datafile 4 switched to datafile copy
input datafile copy RECID=18 STAMP=1086969139 file name=+DATA/ORCL/DATAFILE/undotbs1.306.1086968027
datafile 7 switched to datafile copy
input datafile copy RECID=19 STAMP=1086969139 file name=+DATA/ORCL/DATAFILE/users.304.1086968033
datafile 9 switched to datafile copy
input datafile copy RECID=20 STAMP=1086969139 file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/system.291.1086968035
datafile 10 switched to datafile copy
input datafile copy RECID=21 STAMP=1086969139 file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/sysaux.298.1086968037
datafile 11 switched to datafile copy
input datafile copy RECID=22 STAMP=1086969139 file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/undotbs1.297.1086968037
datafile 5 switched to datafile copy
input datafile copy RECID=23 STAMP=1086969140 file name=+DATA/ORCL/CA1E291660451E23E0530E01A8C00D35/DATAFILE/system.265.1086969107
datafile 6 switched to datafile copy
input datafile copy RECID=24 STAMP=1086969141 file name=+DATA/ORCL/CA1E291660451E23E0530E01A8C00D35/DATAFILE/sysaux.264.1086969107
datafile 8 switched to datafile copy
input datafile copy RECID=25 STAMP=1086969141 file name=+DATA/ORCL/CA1E291660451E23E0530E01A8C00D35/DATAFILE/undotbs1.263.1086969109
datafile 12 switched to datafile copy
input datafile copy RECID=26 STAMP=1086969141 file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/users.262.1086969109
datafile 13 switched to datafile copy
input datafile copy RECID=27 STAMP=1086969141 file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/system.260.1086969111
datafile 14 switched to datafile copy
input datafile copy RECID=28 STAMP=1086969141 file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/sysaux.286.1086969111
datafile 15 switched to datafile copy
input datafile copy RECID=29 STAMP=1086969141 file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/undotbs1.259.1086969115
datafile 16 switched to datafile copy
input datafile copy RECID=30 STAMP=1086969141 file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/example.258.1086969121
datafile 17 switched to datafile copy
input datafile copy RECID=31 STAMP=1086969141 file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/users.287.1086969123
datafile 21 switched to datafile copy
input datafile copy RECID=32 STAMP=1086969141 file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/soe.257.1086969125
datafile 22 switched to datafile copy
input datafile copy RECID=33 STAMP=1086969141 file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/example.333.1086969131
datafile 24 switched to datafile copy
input datafile copy RECID=34 STAMP=1086969141 file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/hr_data.334.1086969133
contents of Memory Script:
{
set until scn 15283006;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 26-OCT-21
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 80 is already on disk as file +RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_80.257.1086969135
archived log for thread 1 with sequence 81 is already on disk as file +RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_81.258.1086969135
archived log for thread 1 with sequence 82 is already on disk as file +RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_82.271.1086969137
archived log for thread 1 with sequence 83 is already on disk as file +RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_83.280.1086969137
archived log for thread 1 with sequence 84 is already on disk as file +RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_84.282.1086969139
archived log file name=+RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_80.257.1086969135 thread=1 sequence=80
archived log file name=+RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_81.258.1086969135 thread=1 sequence=81
archived log file name=+RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_82.271.1086969137 thread=1 sequence=82
archived log file name=+RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_83.280.1086969137 thread=1 sequence=83
archived log file name=+RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_84.282.1086969139 thread=1 sequence=84
media recovery complete, elapsed time: 00:00:01
Finished recover at 26-OCT-21
contents of Memory Script:
{
delete clone force archivelog all;
}
executing Memory Script
released channel: ORA_AUX_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=281 device type=DISK
deleted archived log
archived log file name=+RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_80.257.1086969135 RECID=1 STAMP=1086969134
deleted archived log
archived log file name=+RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_81.258.1086969135 RECID=2 STAMP=1086969135
deleted archived log
archived log file name=+RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_82.271.1086969137 RECID=3 STAMP=1086969136
deleted archived log
archived log file name=+RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_83.280.1086969137 RECID=4 STAMP=1086969137
deleted archived log
archived log file name=+RECO/ORCL/ARCHIVELOG/2021_10_26/thread_1_seq_84.282.1086969139 RECID=5 STAMP=1086969138
Deleted 5 objects
Oracle instance started
Total System Global Area 1073738608 bytes
Fixed Size 9143152 bytes
Variable Size 276824064 bytes
Database Buffers 780140544 bytes
Redo Buffers 7630848 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''ORCL'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
}
executing Memory Script
sql statement: alter system set db_name = ''ORCL'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance started
Total System Global Area 1073738608 bytes
Fixed Size 9143152 bytes
Variable Size 276824064 bytes
Database Buffers 780140544 bytes
Redo Buffers 7630848 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCL" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 SIZE 300 M ,
GROUP 2 SIZE 300 M ,
GROUP 3 SIZE 300 M ,
GROUP 4 SIZE 300 M
DATAFILE
'+DATA/ORCL/DATAFILE/system.300.1086967547',
'+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/system.291.1086968035',
'+DATA/ORCL/CA1E291660451E23E0530E01A8C00D35/DATAFILE/system.265.1086969107',
'+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/system.260.1086969111'
CHARACTER SET WE8MSWIN1252
contents of Memory Script:
{
set newname for clone tempfile 1 to new;
set newname for clone tempfile 2 to new;
set newname for clone tempfile 3 to new;
set newname for clone tempfile 4 to new;
switch clone tempfile all;
catalog clone datafilecopy "+DATA/ORCL/DATAFILE/sysaux.296.1086967549",
"+DATA/ORCL/DATAFILE/undotbs1.306.1086968027",
"+DATA/ORCL/CA1E291660451E23E0530E01A8C00D35/DATAFILE/sysaux.264.1086969107",
"+DATA/ORCL/DATAFILE/users.304.1086968033",
"+DATA/ORCL/CA1E291660451E23E0530E01A8C00D35/DATAFILE/undotbs1.263.1086969109",
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/sysaux.298.1086968037",
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/undotbs1.297.1086968037",
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/users.262.1086969109",
"+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/sysaux.286.1086969111",
"+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/undotbs1.259.1086969115",
"+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/example.258.1086969121",
"+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/users.287.1086969123",
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/soe.257.1086969125",
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/example.333.1086969131",
"+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/hr_data.334.1086969133";
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/ORCL/DATAFILE/sysaux.296.1086967549 RECID=1 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/DATAFILE/undotbs1.306.1086968027 RECID=2 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA1E291660451E23E0530E01A8C00D35/DATAFILE/sysaux.264.1086969107 RECID=3 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/DATAFILE/users.304.1086968033 RECID=4 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA1E291660451E23E0530E01A8C00D35/DATAFILE/undotbs1.263.1086969109 RECID=5 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/sysaux.298.1086968037 RECID=6 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/undotbs1.297.1086968037 RECID=7 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/users.262.1086969109 RECID=8 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/sysaux.286.1086969111 RECID=9 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/undotbs1.259.1086969115 RECID=10 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/example.258.1086969121 RECID=11 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/users.287.1086969123 RECID=12 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/soe.257.1086969125 RECID=13 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/example.333.1086969131 RECID=14 STAMP=1086969176
cataloged datafile copy
datafile copy file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/hr_data.334.1086969133 RECID=15 STAMP=1086969176
datafile 6 switched to datafile copy
input datafile copy RECID=3 STAMP=1086969176 file name=+DATA/ORCL/CA1E291660451E23E0530E01A8C00D35/DATAFILE/sysaux.264.1086969107
datafile 8 switched to datafile copy
input datafile copy RECID=5 STAMP=1086969176 file name=+DATA/ORCL/CA1E291660451E23E0530E01A8C00D35/DATAFILE/undotbs1.263.1086969109
datafile 12 switched to datafile copy
input datafile copy RECID=8 STAMP=1086969176 file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/users.262.1086969109
datafile 14 switched to datafile copy
input datafile copy RECID=9 STAMP=1086969176 file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/sysaux.286.1086969111
datafile 15 switched to datafile copy
input datafile copy RECID=10 STAMP=1086969176 file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/undotbs1.259.1086969115
datafile 16 switched to datafile copy
input datafile copy RECID=11 STAMP=1086969176 file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/example.258.1086969121
datafile 17 switched to datafile copy
input datafile copy RECID=12 STAMP=1086969176 file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/users.287.1086969123
datafile 21 switched to datafile copy
input datafile copy RECID=13 STAMP=1086969176 file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/soe.257.1086969125
datafile 22 switched to datafile copy
input datafile copy RECID=14 STAMP=1086969176 file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/example.333.1086969131
datafile 24 switched to datafile copy
input datafile copy RECID=15 STAMP=1086969176 file name=+DATA/ORCL/CA2E22F26E402DE4E0530E01A8C0031F/DATAFILE/hr_data.334.1086969133
datafile 3 switched to datafile copy
input datafile copy RECID=16 STAMP=1086969177 file name=+DATA/ORCL/DATAFILE/sysaux.296.1086967549
datafile 4 switched to datafile copy
input datafile copy RECID=17 STAMP=1086969177 file name=+DATA/ORCL/DATAFILE/undotbs1.306.1086968027
datafile 7 switched to datafile copy
input datafile copy RECID=18 STAMP=1086969177 file name=+DATA/ORCL/DATAFILE/users.304.1086968033
datafile 10 switched to datafile copy
input datafile copy RECID=19 STAMP=1086969177 file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/sysaux.298.1086968037
datafile 11 switched to datafile copy
input datafile copy RECID=20 STAMP=1086969177 file name=+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/undotbs1.297.1086968037
Reenabling controlfile options for auxiliary database
Executing: alter database add supplemental log data
Executing: alter database force logging
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
contents of Memory Script:
{
sql clone "alter pluggable database all open";
}
executing Memory Script
sql statement: alter pluggable database all open
Cannot remove created server parameter file
Finished Duplicate Db at 26-OCT-21
Datafiles sendo reaproveitados:
Using previous duplicated file +DATA/ORCL/DATAFILE/system.300.1086967547 for datafile 1 with checkpoint SCN of 15278282
Using previous duplicated file +DATA/ORCL/DATAFILE/sysaux.296.1086967549 for datafile 3 with checkpoint SCN of 15278288
Using previous duplicated file +DATA/ORCL/DATAFILE/undotbs1.306.1086968027 for datafile 4 with checkpoint SCN of 15279564
Using previous duplicated file +DATA/ORCL/DATAFILE/users.304.1086968033 for datafile 7 with checkpoint SCN of 15279574
Using previous duplicated file +DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/system.291.1086968035 for datafile 9 with checkpoint SCN of 15279581
Using previous duplicated file +DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/sysaux.298.1086968037 for datafile 10 with checkpoint SCN of 15279583
Using previous duplicated file +DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/undotbs1.297.1086968037 for datafile 11 with checkpoint SCN of 15279586
Observe que no trecho onde o RMAN gera novos nomes para os datafiles, os outros datafiles copiados na segunda tentativa também já tem os caminhos definidos explicitamente:
contents of Memory Script:
{
set newname for datafile 1 to
"+DATA/ORCL/DATAFILE/system.300.1086967547";
set newname for datafile 3 to
"+DATA/ORCL/DATAFILE/sysaux.296.1086967549";
set newname for datafile 4 to
"+DATA/ORCL/DATAFILE/undotbs1.306.1086968027";
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
set newname for datafile 7 to
"+DATA/ORCL/DATAFILE/users.304.1086968033";
set newname for clone datafile 8 to new;
set newname for datafile 9 to
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/system.291.1086968035";
set newname for datafile 10 to
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/sysaux.298.1086968037";
set newname for datafile 11 to
"+DATA/ORCL/CA1E48B93E75259DE0530E01A8C0FF1C/DATAFILE/undotbs1.297.1086968037";
set newname for clone datafile 12 to new;
set newname for clone datafile 13 to new;
set newname for clone datafile 14 to new;
set newname for clone datafile 15 to new;
set newname for clone datafile 16 to new;
set newname for clone datafile 17 to new;
set newname for clone datafile 21 to new;
set newname for clone datafile 22 to new;
set newname for clone datafile 24 to new;
restore
from nonsparse from service
'db19c_lab01' clone datafile
5, 6, 8, 12, 13, 14, 15, 16, 17, 21, 22, 24 ;
sql 'alter system archive log current';
}
Referência:
25.8 Restarting DUPLICATE After a Failure