{"id":1233,"date":"2015-01-13T14:09:53","date_gmt":"2015-01-13T17:09:53","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=1233"},"modified":"2019-10-23T17:05:20","modified_gmt":"2019-10-23T20:05:20","slug":"continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/","title":{"rendered":"Continuando o Oracle DUPLICATE database que falhou no RECOVER dos datafiles"},"content":{"rendered":"<p>H\u00e1 um tempo, o problema que eu costumava enfrentar era a falha da etapa the recovery do script de duplicate por qualquer tipo de problema (como, por exemplo, esquecer se setar a db_recovery_area_dest_size grande o suficiente para segurar os archives que s\u00e3o trazidos) e eu acabava tendo que iniciar o comando DUPLICATE do come\u00e7o. A parte de recovery s\u00f3 traria alguns gigas, menos que 1% do total se comparado com o tamanho do backup full da parte de restore (uns 500 GBs). Portanto, rodar tudo do come\u00e7o era uma grande perda de tempo.<\/p>\n<p>Para retomar o comando de <span style=\"color: #800000;\"><strong>DUPLICATE<\/strong><\/span> do ponto de falha, comecei a dissec\u00e1-lo. Aiaxo irei mostrar um exemplo de como retomar uma duplicata de backup de fita que falhou na parte de recupera\u00e7\u00e3o.<\/p>\n<p><span style=\"color: #0000ff;\">OBS: Antes de come\u00e7ar, como dito nos coment\u00e1rios, \u00e9 importante dizer que o <strong><span style=\"color: #000000;\">DUPLICATE<\/span><\/strong> \u00e9 na maioria das vezes uma opera\u00e7\u00e3o <strong><span style=\"color: #000000;\">RESUMABLE<\/span><\/strong>, desde que reexecutado com <span style=\"color: #000000;\"><strong>A MESMA SINTAXE<\/strong> <\/span>e com o seu BD de destino de volta em <span style=\"color: #000000;\"><strong>NOMOUNT<\/strong><\/span>. Ele vai fazer o skip, na maioria dos casos, os datafiles e archivelog j\u00e1 baixados anteriormente. Esse artigo \u00e9 mais voltado para entende-lo internamente ou em casos muito particulares quando for necess\u00e1ria uma abordagem mais manual. Apenas considere esse post caso j\u00e1 tenha tentando rodar o mesmo comando e ele come\u00e7ou a baixar tudo novamente. =]<\/span><\/p>\n<p>Cen\u00e1rio:<\/p>\n<ul>\n<li>BD Origem: <strong>DBPROD<\/strong><\/li>\n<li>BD Destino: <strong>DBTEST<\/strong><\/li>\n<\/ul>\n<p>Eu criei o meu pr\u00f3prio pfile para o BD <strong>DBTEST<\/strong>, defini os par\u00e2metros e criei os diret\u00f3rios.<\/p>\n<p>Depois de iniciar o banco de dados in nomount, executei o comando:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">-- My DUPLICATE command\r\n\r\nconnect target mdoxdba\/\"xxx\"@dbprod\r\nconnect auxiliary mdoxdba\/\"xxx\"@dbtest\r\nconnect catalog rman\/\"xxx\"@rmanbkp\r\n\r\nRUN\r\n{\r\n\tSET UNTIL TIME \"to_date('2015-01-06 00:00:00','yyyy-mm-dd hh24:mi:ss')\";\r\n\tALLOCATE AUXILIARY CHANNEL T1 TYPE 'sbt_tape';\r\n\tDUPLICATE TARGET DATABASE TO 'dbtest';\r\n}<\/pre>\n<p>Note que o meu &#8220;until time&#8221; \u00e9 <strong>06\/Jan<\/strong>. O meu \u00faltimo full foi no dia <strong>03\/Jan<\/strong>. Portanto, eu tenho 3 dias de archives a serem aplicados.<\/p>\n<p>Ent\u00e3o, quando o meu script iniciou a fase de recover, abortei ele (CTRL+C) para simular uma falha:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">Recovery Manager: Release 11.1.0.7.0 - Production on Fri Jan 9 12:15:49 2015\r\n\r\nCopyright (c) 1982, 2007, Oracle.  All rights reserved.\r\n\r\nRMAN&gt;\r\nconnected to target database: DBPROD (DBID=2452006932)\r\n\r\nRMAN&gt;\r\nconnected to auxiliary database: DBTEST (not mounted)\r\n\r\nRMAN&gt;\r\nconnected to recovery catalog database\r\n\r\nRMAN&gt; 2&gt; 3&gt; 4&gt; 5&gt; 6&gt; 7&gt;\r\nexecuting command: SET until clause\r\n\r\nallocated channel: t1\r\nchannel t1: SID=554 device type=SBT_TAPE\r\nchannel t1: Data Protector A.08.10\/205\r\n\r\nStarting Duplicate Db at 09-JAN-15\r\n\r\ncontents of Memory Script:\r\n{\r\n   set until scn  13169104914343;\r\n   set newname for datafile  1 to\r\n \"\/oravl02\/oradata\/dbtest\/system01.dbf\";\r\n   set newname for datafile  2 to\r\n \"\/oravl02\/oradata\/dbtest\/sysaux01.dbf\";\r\n   set newname for datafile  3 to\r\n \"\/oravl02\/oradata\/dbtest\/undotbs01.dbf\";\r\n   set newname for datafile  4 to\r\n \"\/oravl02\/oradata\/dbtest\/users01.dbf\";\r\n   set newname for datafile  5 to\r\n \"\/oravl02\/oradata\/dbtest\/usr01.dbf\";\r\n   set newname for datafile  6 to\r\n \"\/oravl02\/oradata\/dbtest\/usr02.dbf\";\r\n   restore\r\n   clone database\r\n   ;\r\n}\r\nexecuting Memory Script\r\n\r\nexecuting command: SET until clause\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nStarting restore at 09-JAN-15\r\n\r\nchannel t1: starting datafile backup set restore\r\nchannel t1: specifying datafile(s) to restore from backup set\r\nchannel t1: restoring datafile 00001 to \/oravl02\/oradata\/dbtest\/system01.dbf\r\nchannel t1: restoring datafile 00002 to \/oravl02\/oradata\/dbtest\/sysaux01.dbf\r\nchannel t1: restoring datafile 00003 to \/oravl02\/oradata\/dbtest\/undotbs01.dbf\r\nchannel t1: restoring datafile 00004 to \/oravl02\/oradata\/dbtest\/users01.dbf\r\nchannel t1: restoring datafile 00005 to \/oravl02\/oradata\/dbtest\/usr01.dbf\r\nchannel t1: restoring datafile 00006 to \/oravl02\/oradata\/dbtest\/usr02.dbf\r\nchannel t1: reading from backup piece 1hprsdqk_1_1\r\nchannel t1: piece handle=1hprsdqk_1_1 tag=FULL_DB_INCR_ONLINE\r\nchannel t1: restored backup piece 1\r\nchannel t1: restore complete, elapsed time: 00:09:45\r\nFinished restore at 09-JAN-15\r\nsql statement: CREATE CONTROLFILE REUSE SET DATABASE \"DBTEST\" RESETLOGS ARCHIVELOG\r\n  MAXLOGFILES     16\r\n  MAXLOGMEMBERS      3\r\n  MAXDATAFILES      100\r\n  MAXINSTANCES     8\r\n  MAXLOGHISTORY      292\r\n LOGFILE\r\n  GROUP  1 ( '\/oravl02\/oradata\/dbtest\/redo01.log' ) SIZE 50 M  REUSE,\r\n  GROUP  2 ( '\/oravl02\/oradata\/dbtest\/redo02.log' ) SIZE 50 M  REUSE,\r\n  GROUP  3 ( '\/oravl02\/oradata\/dbtest\/redo03.log' ) SIZE 50 M  REUSE\r\n DATAFILE\r\n  '\/oravl02\/oradata\/dbtest\/system01.dbf'\r\n CHARACTER SET AL32UTF8\r\n\r\n\r\ncontents of Memory Script:\r\n{\r\n   switch clone datafile all;\r\n}\r\nexecuting Memory Script\r\n\r\ndatafile 2 switched to datafile copy\r\ninput datafile copy RECID=1 STAMP=868537545 file name=\/oravl02\/oradata\/dbtest\/sysaux01.dbf\r\ndatafile 3 switched to datafile copy\r\ninput datafile copy RECID=2 STAMP=868537545 file name=\/oravl02\/oradata\/dbtest\/undotbs01.dbf\r\ndatafile 4 switched to datafile copy\r\ninput datafile copy RECID=3 STAMP=868537545 file name=\/oravl02\/oradata\/dbtest\/users01.dbf\r\ndatafile 5 switched to datafile copy\r\ninput datafile copy RECID=4 STAMP=868537545 file name=\/oravl02\/oradata\/dbtest\/usr01.dbf\r\ndatafile 6 switched to datafile copy\r\ninput datafile copy RECID=5 STAMP=868537545 file name=\/oravl02\/oradata\/dbtest\/usr02.dbf\r\n\r\ncontents of Memory Script:\r\n{\r\n   set until time  \"to_date('2015-01-06 00:00:00','yyyy-mm-dd hh24:mi:ss')\";\r\n   recover\r\n   clone database\r\n    delete archivelog\r\n   ;\r\n}\r\nexecuting Memory Script\r\n\r\nexecuting command: SET until clause\r\n\r\nStarting recover at 09-JAN-15\r\n\r\nstarting media recovery\r\n\r\nchannel t1: starting archived log restore to default destination\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7304\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7305\r\nchannel t1: reading from backup piece 1jprsef0_1_1\r\n\r\nuser interrupt received\r\nOracle Error:\r\nORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below\r\nORA-01194: file 1 needs more recovery to be consistent\r\nORA-01110: data file 1: '\/oravl02\/oradata\/dbtest\/system01.dbf'\r\n\r\nreleased channel: t1\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of Duplicate Db command at 01\/09\/2015 12:26:47\r\nRMAN-03015: error occurred in stored script Memory Script\r\nRMAN-03099: job cancelled at user request\r\n\r\nRMAN&gt;<\/pre>\n<p>Aqui podemos ver que o RESTORE completou com <strong>sucesso<\/strong>. Ap\u00f3s isso, o DUPLICATE criou o controfile com apenas o datafile SYSTEM. Em seguida, ele executou um &#8220;<strong>switch datafile all<\/strong>&#8221; para adicionar o resto.<\/p>\n<p>Quando come\u00e7ou a parte de RECOVER, eu o abortei.<\/p>\n<p>Como podemos ent\u00e3o continuar daqui?<\/p>\n<p>Primeiramente, precisamos terminar o recovery. Abra novamente o <strong>rman<\/strong> conectando ao auxiliary, target e catalog servers (se presentes) e ent\u00e3o reexecute a etapa de recovery.<\/p>\n<p>Note abaixo que eu aloquei um canal auxiliar novamente e o banco <strong>DBTEST<\/strong> deve ficar em modo MOUNT.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; run\r\n2&gt; {\r\n3&gt;    allocate auxiliary channel t1 type 'SBT_TAPE';\r\n5&gt;    set until time  \"to_date('2015-01-06 00:00:00','yyyy-mm-dd hh24:mi:ss')\";\r\n6&gt;    recover\r\n7&gt;    clone database\r\n8&gt;     delete archivelog\r\n9&gt;    ;\r\n10&gt; }\r\n\r\nallocated channel: t1\r\nchannel t1: SID=552 device type=SBT_TAPE\r\nchannel t1: Data Protector A.08.10\/205\r\n\r\nexecuting command: SET until clause\r\n\r\nStarting recover at 09-JAN-15\r\nadded tempfile \/oravl04\/oradata\/dbprod\/dbprod\/temp01.dbf to tablespace TEMPORARY in control file\r\n\r\nstarting media recovery\r\n\r\nchannel t1: starting archived log restore to default destination\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7304\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7305\r\nchannel t1: reading from backup piece 1jprsef0_1_1\r\nchannel t1: piece handle=1jprsef0_1_1 tag=FULL_ARCHIVELOG_ONLINE\r\nchannel t1: restored backup piece 1\r\nchannel t1: restore complete, elapsed time: 00:03:55\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7304_bbzsz4nh_.arc thread=1 sequence=7304\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7304_bbzsz4nh_.arc RECID=2 STAMP=868538309\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7305_bbzsz4o6_.arc thread=1 sequence=7305\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7305_bbzsz4o6_.arc RECID=1 STAMP=868538308\r\nchannel t1: starting archived log restore to default destination\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7306\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7307\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7308\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7309\r\nchannel t1: reading from backup piece 1lprto0p_1_1\r\nchannel t1: piece handle=1lprto0p_1_1 tag=ARCHIVE_ONLINE\r\nchannel t1: restored backup piece 1\r\nchannel t1: restore complete, elapsed time: 00:00:55\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7306_bbzt0nlk_.arc thread=1 sequence=7306\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7306_bbzt0nlk_.arc RECID=4 STAMP=868538362\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7307_bbzt0nns_.arc thread=1 sequence=7307\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7307_bbzt0nns_.arc RECID=6 STAMP=868538362\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7308_bbzt0nn1_.arc thread=1 sequence=7308\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7308_bbzt0nn1_.arc RECID=5 STAMP=868538362\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7309_bbzt0np3_.arc thread=1 sequence=7309\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7309_bbzt0np3_.arc RECID=3 STAMP=868538362\r\nchannel t1: starting archived log restore to default destination\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7310\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7311\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7312\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7313\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7314\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7315\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7316\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7317\r\nchannel t1: reading from backup piece 1mps0cd1_1_1\r\nchannel t1: piece handle=1mps0cd1_1_1 tag=ARCHIVE_ONLINE\r\nchannel t1: restored backup piece 1\r\nchannel t1: restore complete, elapsed time: 00:00:55\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7310_bbzt2v2x_.arc thread=1 sequence=7310\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7310_bbzt2v2x_.arc RECID=9 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7311_bbzt2v3d_.arc thread=1 sequence=7311\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7311_bbzt2v3d_.arc RECID=10 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7312_bbzt2v22_.arc thread=1 sequence=7312\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7312_bbzt2v22_.arc RECID=8 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7313_bbzt2v3p_.arc thread=1 sequence=7313\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7313_bbzt2v3p_.arc RECID=11 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7314_bbzt2v42_.arc thread=1 sequence=7314\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7314_bbzt2v42_.arc RECID=12 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7315_bbzt2v4c_.arc thread=1 sequence=7315\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7315_bbzt2v4c_.arc RECID=13 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7316_bbzt2v4t_.arc thread=1 sequence=7316\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7316_bbzt2v4t_.arc RECID=14 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7317_bbzt2v55_.arc thread=1 sequence=7317\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7317_bbzt2v55_.arc RECID=7 STAMP=868538429\r\nmedia recovery complete, elapsed time: 00:00:21\r\nFinished recover at 09-JAN-15\r\nreleased channel: t1\r\n\r\nRMAN&gt;<\/pre>\n<p>Perfeito, a parte de recovery funcionou. A partir daqui, temos 2 caminhos para finalizar o duplicate: o caminho f\u00e1cil e \u00f3bvio OU o caminho do DUPLICATE (dissecado). Mostrarei ambos:<\/p>\n<h3><span style=\"color: #800000;\">1. Caminho f\u00e1cil:<\/span><\/h3>\n<p>Por fim, abra o database com resetlogs:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; alter database open resetlogs;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt;<\/pre>\n<p>Ok. Seu BD est\u00e1 pronto.<\/p>\n<h3><span style=\"color: #800000;\">2. Caminho do DUPLICATE (dissecado):<\/span><\/h3>\n<p>O comando DUPLICATE faz um monte de pa\u00e7os extras, provavelmente por que ele pode receber uma grande quantidade de combina\u00e7\u00f5es de par\u00e2metro e condi\u00e7\u00f5es, como por exemplo &#8220;skipar&#8221; alguma tablespace. Portanto, \u00e9 um modo de implementa\u00e7\u00e3o mais gen\u00e9rica para lidar com um leque maior de casos.<\/p>\n<p>Para simul\u00e1-lo, primeiro vamos deixar o BD em NOMOUNT novamente para recriar o controlfile (note que eu fiz isso usando ainda a sess\u00e3o do RMAN):<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; RUN\r\n2&gt; {\r\n3&gt;    shutdown clone immediate;\r\n4&gt;    startup clone nomount ;\r\n5&gt; }\r\n\r\ndatabase dismounted\r\nOracle instance shut down\r\n\r\nconnected to auxiliary database (not started)\r\nOracle instance started\r\n\r\nTotal System Global Area    7081771008 bytes\r\n\r\nFixed Size                     2147080 bytes\r\nVariable Size               3283610872 bytes\r\nDatabase Buffers            3791650816 bytes\r\nRedo Buffers                   4362240 bytes\r\n\r\nRMAN&gt;<\/pre>\n<p>Em seguida, ao inv\u00e9s de recriar o controlfile com todos os datafiles, o oracle vai apenas cria-lo com o datafile SYSTEM. Vamos fazer isso. (\u00c9 o mesmo comando que foi executado l\u00e1 no come\u00e7o):<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; CREATE CONTROLFILE REUSE SET DATABASE \"DBTEST\" RESETLOGS ARCHIVELOG\r\n  2    MAXLOGFILES     16\r\n  3    MAXLOGMEMBERS      3\r\n  4    MAXDATAFILES      100\r\n  5    MAXINSTANCES     8\r\n  6    MAXLOGHISTORY      292\r\n  7   LOGFILE\r\n  8    GROUP  1 ( '\/oravl02\/oradata\/dbtest\/redo01.log' ) SIZE 50 M  REUSE,\r\n  9    GROUP  2 ( '\/oravl02\/oradata\/dbtest\/redo02.log' ) SIZE 50 M  REUSE,\r\n 10    GROUP  3 ( '\/oravl02\/oradata\/dbtest\/redo03.log' ) SIZE 50 M  REUSE\r\n 11   DATAFILE\r\n 12    '\/oravl02\/oradata\/dbtest\/system01.dbf'\r\n 13   CHARACTER SET AL32UTF8;\r\n\r\nControl file created.\r\n\r\nSQL&gt;<\/pre>\n<p>Agora vamos adicionar ao controlfile os outros datafiles. Conecte novamente o RMAN ao auxiliary e target:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; run\r\n2&gt; {\r\n3&gt;    set newname for tempfile  1 to \"\/oravl02\/oradata\/dbtest\/temp01.dbf\";\r\n4&gt;    switch clone tempfile all;\r\n5&gt;    set newname for datafile 1 to \"\/oravl02\/oradata\/dbtest\/system01.dbf\";\r\n6&gt;    set newname for datafile 2 to \"\/oravl02\/oradata\/dbtest\/sysaux01.dbf\";\r\n7&gt;    set newname for datafile 3 to \"\/oravl02\/oradata\/dbtest\/undotbs01.dbf\";\r\n8&gt;    set newname for datafile 4 to \"\/oravl02\/oradata\/dbtest\/users01.dbf\";\r\n9&gt;    set newname for datafile 5 to \"\/oravl02\/oradata\/dbtest\/usr01.dbf\";\r\n10&gt;    set newname for datafile 6 to \"\/oravl02\/oradata\/dbtest\/usr02.dbf\";\r\n11&gt;    catalog clone datafilecopy \"\/oravl02\/oradata\/dbtest\/sysaux01.dbf\";\r\n12&gt;    catalog clone datafilecopy \"\/oravl02\/oradata\/dbtest\/undotbs01.dbf\";\r\n13&gt;    catalog clone datafilecopy \"\/oravl02\/oradata\/dbtest\/users01.dbf\";\r\n14&gt;    catalog clone datafilecopy \"\/oravl02\/oradata\/dbtest\/usr01.dbf\";\r\n15&gt;    catalog clone datafilecopy \"\/oravl02\/oradata\/dbtest\/usr02.dbf\";\r\n16&gt;    switch clone datafile all;\r\n17&gt; }\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nrenamed tempfile 1 to \/oravl02\/oradata\/dbtest\/temp01.dbf in control file\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\ncataloged datafile copy\r\ndatafile copy file name=\/oravl02\/oradata\/dbtest\/sysaux01.dbf RECID=1 STAMP=868554741\r\n\r\ncataloged datafile copy\r\ndatafile copy file name=\/oravl02\/oradata\/dbtest\/undotbs01.dbf RECID=2 STAMP=868554741\r\n\r\ncataloged datafile copy\r\ndatafile copy file name=\/oravl02\/oradata\/dbtest\/users01.dbf RECID=3 STAMP=868554741\r\n\r\ncataloged datafile copy\r\ndatafile copy file name=\/oravl02\/oradata\/dbtest\/usr01.dbf RECID=4 STAMP=868554742\r\n\r\ncataloged datafile copy\r\ndatafile copy file name=\/oravl02\/oradata\/dbtest\/usr02.dbf RECID=5 STAMP=868554742\r\n\r\ndatafile 2 switched to datafile copy\r\ninput datafile copy RECID=1 STAMP=868554741 file name=\/oravl02\/oradata\/dbtest\/sysaux01.dbf\r\ndatafile 3 switched to datafile copy\r\ninput datafile copy RECID=2 STAMP=868554741 file name=\/oravl02\/oradata\/dbtest\/undotbs01.dbf\r\ndatafile 4 switched to datafile copy\r\ninput datafile copy RECID=3 STAMP=868554741 file name=\/oravl02\/oradata\/dbtest\/users01.dbf\r\ndatafile 5 switched to datafile copy\r\ninput datafile copy RECID=4 STAMP=868554742 file name=\/oravl02\/oradata\/dbtest\/usr01.dbf\r\ndatafile 6 switched to datafile copy\r\ninput datafile copy RECID=5 STAMP=868554742 file name=\/oravl02\/oradata\/dbtest\/usr02.dbf\r\n\r\nRMAN&gt;<\/pre>\n<p><span style=\"color: #3366ff;\"><em><strong>OBS: Apesar de n\u00e3o estar presente no trace do DUPLICATE, eu adicionei aqui a cl\u00e1usula &#8220;set newname&#8221; para todos os datafiles. Caso contr\u00e1rio, o comando falharia. Na verdade, quando \u00e9 o RMAN executa, ele n\u00e3o necessita executar esses &#8220;sets&#8221; bloco final porque isso j\u00e1 foi feito no in\u00edcio. Como a sess\u00e3o \u00e9 o mesma, ele n\u00e3o precisa execut\u00e1-los novamente.<\/strong><\/em><\/span><\/p>\n<p>Ent\u00e3o, finalmente, abre o seu BD com resetlogs:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; run\r\n2&gt; {\r\n3&gt;    Alter clone database open resetlogs;\r\n4&gt; }\r\n\r\ndatabase opened\r\n\r\nRMAN&gt;<\/pre>\n<p>E \u00e9 isso! Por estes caminhos, n\u00e3o h\u00e1 necessidade de restaurar todos os datafiles novamente.<\/p>\n<p>Alguns sites \u00fateis que me ajudaram e onde voc\u00ea pode encontrar mais informa\u00e7\u00f5es:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.pythian.com\/blog\/rman-duplicate-in-details\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/www.pythian.com\/blog\/rman-duplicate-in-details<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?id=360962.1\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?id=360962.1<\/a><\/li>\n<li><a href=\"https:\/\/oraclefunda.wordpress.com\/2009\/02\/15\/33\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/oraclefunda.wordpress.com\/2009\/02\/15\/33\/<\/a><\/li>\n<\/ul>\n<b>Gostou? N\u00e3o deixe de comentar ou deixar um \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-1233 jlk' href='javascript:void(0)' data-task='like' data-post_id='1233' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-1233 lc'>+7<\/span><\/a><\/div><\/div> <div class='status-1233 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>H\u00e1 um tempo, o problema que eu costumava enfrentar era a falha da etapa the recovery do script de duplicate por qualquer tipo de problema (como, por exemplo, esquecer se setar a db_recovery_area_dest_size grande o suficiente para segurar os archives que s\u00e3o trazidos) e eu acabava tendo que iniciar o comando DUPLICATE do come\u00e7o. A &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/\">Continue lendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-1233","post","type-post","status-publish","format-standard","hentry","category-rman","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Continuando o Oracle DUPLICATE database que falhou no RECOVER dos datafiles - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Como continuar o Oracle DUPLICATE database que falhou no RECOVERY dos datafiles\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/01\\\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/01\\\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Continuando o Oracle DUPLICATE database que falhou no RECOVER dos datafiles\",\"datePublished\":\"2015-01-13T17:09:53+00:00\",\"dateModified\":\"2019-10-23T20:05:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/01\\\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\\\/\"},\"wordCount\":720,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"Recovery Manager (RMAN)\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/01\\\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/01\\\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/01\\\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\\\/\",\"name\":\"Continuando o Oracle DUPLICATE database que falhou no RECOVER dos datafiles - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\"},\"datePublished\":\"2015-01-13T17:09:53+00:00\",\"dateModified\":\"2019-10-23T20:05:20+00:00\",\"description\":\"Como continuar o Oracle DUPLICATE database que falhou no RECOVERY dos datafiles\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/01\\\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/01\\\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/01\\\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Continuando o Oracle DUPLICATE database que falhou no RECOVER dos datafiles\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Continuando o Oracle DUPLICATE database que falhou no RECOVER dos datafiles - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Como continuar o Oracle DUPLICATE database que falhou no RECOVERY dos datafiles","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/","twitter_misc":{"Escrito por":"DBA RJ","Est. tempo de leitura":"14 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Continuando o Oracle DUPLICATE database que falhou no RECOVER dos datafiles","datePublished":"2015-01-13T17:09:53+00:00","dateModified":"2019-10-23T20:05:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/"},"wordCount":720,"commentCount":1,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["Recovery Manager (RMAN)"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/","url":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/","name":"Continuando o Oracle DUPLICATE database que falhou no RECOVER dos datafiles - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website"},"datePublished":"2015-01-13T17:09:53+00:00","dateModified":"2019-10-23T20:05:20+00:00","description":"Como continuar o Oracle DUPLICATE database que falhou no RECOVERY dos datafiles","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/01\/continuando-o-oracle-duplicate-database-que-falhou-no-recover-dos-datafiles\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/pt-br\/"},{"@type":"ListItem","position":2,"name":"Continuando o Oracle DUPLICATE database que falhou no RECOVER dos datafiles"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website","url":"https:\/\/www.dbarj.com.br\/pt-br\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/pt-br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/1233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/comments?post=1233"}],"version-history":[{"count":2,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/1233\/revisions"}],"predecessor-version":[{"id":4323,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/1233\/revisions\/4323"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/media?parent=1233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/categories?post=1233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/tags?post=1233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}