Hoje \u00e9 dia de destruir e reconstruir. Vamos simular a perda de um datafile “non-system” (ou seja, que n\u00e3o abriga os metadados do database), em um ambiente em noarchivelog mode. Reconhecendo o ambiente:<\/p>\n\n\n
\n[oracle@oel8 ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Fri Jul 23 20:37:44 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: RMANDB (DBID=3825250984)\n \nRMAN> SELECT NAME,LOG_MODE,OPEN_MODE FROM V$DATABASE;\n \nusing target database control file instead of recovery catalog\nNAME LOG_MODE OPEN_MODE\n--------- ------------ --------------------\nRMANDB NOARCHIVELOG READ WRITE\n \nRMAN> REPORT SCHEMA;\n \nReport of database schema for database with db_unique_name RMANDB\n \nList of Permanent Datafiles\n===========================\nFile Size(MB) Tablespace RB segs Datafile Name\n---- -------- -------------------- ------- ------------------------\n1 880 SYSTEM YES \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n2 120 TS_HIPO_CATALOG NO \/oracle\/dados\/RMANDB\/datafile\/ts_hipo_catalog.dbf\n3 730 SYSAUX NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n4 305 UNDOTBS1 YES \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n5 200 TS_CORTEX_CATALOG NO \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n7 16 USERS NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \nList of Temporary Files\n=======================\nFile Size(MB) Tablespace Maxsize(MB) Tempfile Name\n---- -------- -------------------- ----------- --------------------\n1 69 TEMP 32767 \/oracle\/dados\/RMANDB\/datafile\/o1_mf_temp_h8nyvt1f_.tmp\n<\/pre><\/div>\n\n\nRealizando um backup full do banco (como o mesmo est\u00e1 em noarchivelog mode, \u00e9 necess\u00e1rio mont\u00e1-lo para realizar o processo):<\/p>\n\n\n
\nRMAN> SHUTDOWN IMMEDIATE;\n \ndatabase closed\ndatabase dismounted\nOracle instance shut down\n \nRMAN> STARTUP MOUNT;\n \nconnected to target database (not started)\nOracle instance started\ndatabase mounted\n \nTotal System Global Area 1610612016 bytes\n \nFixed Size 8658224 bytes\nVariable Size 520093696 bytes\nDatabase Buffers 1073741824 bytes\nRedo Buffers 8118272 bytes\n<\/pre><\/div>\n\n\nRMAN> BACKUP DATABASE;\n \nStarting backup at 2021-07-23:20:39:14\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=34 device type=DISK\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\ninput datafile file number=00002 name=\/oracle\/dados\/RMANDB\/datafile\/ts_hipo_catalog.dbf\ninput datafile file number=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-07-23:20:39:15\nchannel ORA_DISK_1: finished piece 1 at 2021-07-23:20:40:40\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T203914_jhpns3d7_.bkp tag=TAG20210723T203914 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:25\nFinished backup at 2021-07-23:20:40:40\n \nStarting Control File and SPFILE Autobackup at 2021-07-23:20:40:40\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_07_23\/o1_mf_s_1078691912_jhpnvs16_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-07-23:20:40:43\n<\/pre><\/div>\n\n\nPara explorarmos algumas situa\u00e7\u00f5es que ocorrer\u00e3o, ap\u00f3s o backup Full vamos criar uma tabela e popul\u00e1-la com 1 registro:<\/p>\n\n\n
\nRMAN> ALTER DATABASE OPEN;\n \nStatement processed\n \nRMAN> SELECT USERNAME,DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME='BSS';\n \n \n \nUSERNAME\n--------------------------------------------------------------------------------\nDEFAULT_TABLESPACE\n------------------------------\n \nBSS\nUSERS\n \n \nRMAN> CREATE TABLE BSS.ASWAN (DESCRICAO VARCHAR2(50));\n \nStatement processed\n \nRMAN> INSERT INTO BSS.ASWAN (DESCRICAO) VALUES ('AAAAAAAAA');\n \nStatement processed\n \nRMAN> COMMIT;\n \nStatement processed\n \nRMAN> SELECT * FROM BSS.ASWAN;\n \nDESCRICAO\n--------------------------------------------------\nAAAAAAAAA\n<\/pre><\/div>\n\n\nVamos remover o datafile da tablespace USERS:<\/p>\n\n\n
\nRMAN> host "rm \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf";\n \nhost command complete\n<\/pre><\/div>\n\n\nObservando o alert.log do nosso banco, \u00e9 poss\u00edvel notar que ainda n\u00e3o foi identificado a anomalia:<\/p>\n\n\n
\n2021-07-23T20:41:05.705506-03:00\ndb_recovery_file_dest_size of 5120 MB is 29.37% used. This is a\nuser-specified limit on the amount of space that will be used by this\ndatabase for recovery-related files, and does not reflect the amount of\nspace available in the underlying filesystem or ASM diskgroup.\n2021-07-23T20:41:53.461859-03:00\nTABLE AUDSYS.AUD$UNIFIED: ADDED INTERVAL PARTITION SYS_P686 (85) VALUES LESS THAN (TIMESTAMP' 2021-08-01 00:00:00')\n<\/pre><\/div>\n\n\nPodemos executar o comando VALIDATE DATABASE no RMAN para que o Oracle reconhe\u00e7a o problema:<\/p>\n\n\n
\nRMAN> VALIDATE DATABASE;\n \nStarting validate at 2021-07-23:20:43:21\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=103 device type=DISK\nRMAN-06169: could not read file header for datafile 7 error reason 5\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of validate command at 07\/23\/2021 20:43:22\nRMAN-06056: could not access datafile 7\n<\/pre><\/div>\n\n\nAlert:<\/p>\n\n\n
\n2021-07-23T20:43:22.166904-03:00\nErrors in file \/oracle\/18.0.0\/base\/diag\/rdbms\/rmandb\/RMANDB\/trace\/RMANDB_mz00_3727.trc:\nORA-01110: data file 7: '\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf'\nORA-01565: error in identifying file '\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf'\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 7\nChecker run found 1 new persistent data failures\n<\/pre><\/div>\n\n\nComo os outros datafiles est\u00e3o preservados, pensamos na possibilidade de restaurar e recuperar apenas o datafile 7. Como os vetores de altera\u00e7\u00e3o ainda est\u00e3o contidos nos Online Redo Logs do ambiente, \u00e9 poss\u00edvel recuperar este datafile de modo com que o banco abra sem necessidade de resetlogs. Este cen\u00e1rio depende muito mais do ambiente do que voc\u00ea. Caso esses vetores n\u00e3o estivessem mais no ORL, o resultado seria diferente. \u00c9 como a rea\u00e7\u00e3o de um paciente quando recebe transfus\u00e3o de sangue do doador. Depende mais do seu organismo do que do m\u00e9dico.<\/p>\n\n\n
\n[oracle@oel8 trace]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Fri Jul 23 20:44:41 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.13.0.0.0\n \nSQL> SHU IMMEDIATE;\nORA-01116: error in opening database file 7\nORA-01110: data file 7: '\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf'\nORA-27041: unable to open file\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 3\n<\/pre><\/div>\n\n\nRMAN> SHUTDOWN ABORT;\n \nusing target database control file instead of recovery catalog\nOracle instance shut down\n \nRMAN> STARTUP MOUNT;\n \nconnected to target database (not started)\nOracle instance started\ndatabase mounted\n \nTotal System Global Area 1610612016 bytes\n \nFixed Size 8658224 bytes\nVariable Size 520093696 bytes\nDatabase Buffers 1073741824 bytes\nRedo Buffers 8118272 bytes\n \nRMAN> RESTORE DATAFILE 7;\n \nStarting restore at 2021-07-23:20:45:28\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=34 device type=DISK\n \nchannel ORA_DISK_1: starting datafile backup set restore\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\nchannel ORA_DISK_1: restoring datafile 00007 to \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_DISK_1: reading from backup piece \/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T203914_jhpns3d7_.bkp\nchannel ORA_DISK_1: piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T203914_jhpns3d7_.bkp tag=TAG20210723T203914\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\nFinished restore at 2021-07-23:20:45:29\n \nRMAN> RECOVER DATAFILE 7;\n \nStarting recover at 2021-07-23:20:45:34\nusing channel ORA_DISK_1\n \nstarting media recovery\nmedia recovery complete, elapsed time: 00:00:01\n \nFinished recover at 2021-07-23:20:45:35\n \nRMAN> ALTER DATABASE OPEN;\n \nStatement processed\n<\/pre><\/div>\n\n\nRealizando o VALIDATE DATABASE:<\/p>\n\n\n
\nRMAN> VALIDATE DATABASE;\n \nStarting validate at 2021-07-23:20:46:02\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting validation of datafile\nchannel ORA_DISK_1: specifying datafile(s) for validation\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\ninput datafile file number=00002 name=\/oracle\/dados\/RMANDB\/datafile\/ts_hipo_catalog.dbf\ninput datafile file number=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpo4rgv_.dbf\nchannel ORA_DISK_1: validation complete, elapsed time: 00:00:15\nList of Datafiles\n=================\nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n1 OK 0 17832 112643 3284859\n File Name: \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 74841\n Index 0 13649\n Other 0 6318\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n2 OK 0 14609 15360 2733896\n File Name: \/oracle\/dados\/RMANDB\/datafile\/ts_hipo_catalog.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 150\n Index 0 98\n Other 0 503\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n3 OK 0 22386 93444 3284301\n File Name: \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 14138\n Index 0 13992\n Other 0 42924\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n4 OK 0 513 39040 3284861\n File Name: \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 0\n Index 0 0\n Other 0 38527\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n5 OK 0 24697 25600 2790924\n File Name: \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 175\n Index 0 135\n Other 0 593\n \nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n7 OK 0 120 2101 3083633\n File Name: \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpo4rgv_.dbf\n Block Type Blocks Failing Blocks Processed\n ---------- -------------- ----------------\n Data 0 1420\n Index 0 19\n Other 0 521\n \nchannel ORA_DISK_1: starting validation of datafile\nchannel ORA_DISK_1: specifying datafile(s) for validation\nincluding current control file for validation\nincluding current SPFILE in backup set\nchannel ORA_DISK_1: validation complete, elapsed time: 00:00:01\nList of Control File and SPFILE\n===============================\nFile Type Status Blocks Failing Blocks Examined\n------------ ------ -------------- ---------------\nSPFILE OK 0 2\nControl File OK 0 722\nFinished validate at 2021-07-23:20:46:18\n<\/pre><\/div>\n\n\nNossa tabela de teste ap\u00f3s o backup foi recuperada:<\/p>\n\n\n
\nRMAN> SELECT * FROM BSS.ASWAN;\n\nDESCRICAO\n--------------------------------------------------\nAAAAAAAAA\n<\/pre><\/div>\n\n\nAgora vamos simular uma situa\u00e7\u00e3o interessante que testei 2 vezes, para ter certeza que era o comportamento do Oracle. Vamos dropar nossa tabela de teste, remover os backups existentes, e fazer o processo completo:<\/p>\n\n\n
\nRMAN> DROP TABLE BSS.ASWAN;\n \nStatement processed\n \nRMAN> DELETE BACKUPSET;\n \nusing channel ORA_DISK_1\n \nList of Backup Pieces\nBP Key BS Key Pc# Cp# Status Device Type Piece Name\n------- ------- --- --- ----------- ----------- ----------\n376 347 1 1 AVAILABLE DISK \/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T203914_jhpns3d7_.bkp\n377 348 1 1 AVAILABLE DISK \/oracle\/fra\/RMANDB\/autobackup\/2021_07_23\/o1_mf_s_1078691912_jhpnvs16_.bkp\n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T203914_jhpns3d7_.bkp RECID=376 STAMP=1078691955\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_07_23\/o1_mf_s_1078691912_jhpnvs16_.bkp RECID=377 STAMP=1078692040\nDeleted 2 objects\n<\/pre><\/div>\n\n\nGerando novo backup FULL:<\/p>\n\n\n
\nRMAN> SHUTDOWN IMMEDIATE;\n \ndatabase closed\ndatabase dismounted\nOracle instance shut down\n \nRMAN> STARTUP MOUNT;\n \nconnected to target database (not started)\nOracle instance started\ndatabase mounted\n \nTotal System Global Area 1610612016 bytes\n \nFixed Size 8658224 bytes\nVariable Size 520093696 bytes\nDatabase Buffers 1073741824 bytes\nRedo Buffers 8118272 bytes\n \nRMAN> BACKUP DATABASE;\n \nStarting backup at 2021-07-23:20:49:19\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=34 device type=DISK\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\ninput datafile file number=00002 name=\/oracle\/dados\/RMANDB\/datafile\/ts_hipo_catalog.dbf\ninput datafile file number=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpo4rgv_.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-07-23:20:49:19\nchannel ORA_DISK_1: finished piece 1 at 2021-07-23:20:49:44\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T204919_jhpoczkd_.bkp tag=TAG20210723T204919 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:25\nFinished backup at 2021-07-23:20:49:44\n \nStarting Control File and SPFILE Autobackup at 2021-07-23:20:49:44\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_07_23\/o1_mf_s_1078692524_jhpodrt9_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-07-23:20:49:45\n<\/pre><\/div>\n\n\nCriando tabela ap\u00f3s o backup:<\/p>\n\n\n
\nRMAN> ALTER DATABASE OPEN;\n \nStatement processed\n \nRMAN> CREATE TABLE BSS.ASWAN (DESCRICAO VARCHAR2(50));\n \nStatement processed\n \nRMAN> INSERT INTO BSS.ASWAN (DESCRICAO) VALUES ('AAAAAAAAA');\n \nStatement processed\n \nRMAN> COMMIT;\n \nStatement processed\n \nRMAN> SELECT * FROM BSS.ASWAN;\n \nDESCRICAO\n--------------------------------------------------\nAAAAAAAAA\n<\/pre><\/div>\n\n\nDeletando novamente o datafile da tablespace USERS:<\/p>\n\n\n
\nRMAN> REPORT SCHEMA;\n \nReport of database schema for database with db_unique_name RMANDB\n \nList of Permanent Datafiles\n===========================\nFile Size(MB) Tablespace RB segs Datafile Name\n---- -------- -------------------- ------- ------------------------\n1 880 SYSTEM YES \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n2 120 TS_HIPO_CATALOG NO \/oracle\/dados\/RMANDB\/datafile\/ts_hipo_catalog.dbf\n3 730 SYSAUX NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n4 305 UNDOTBS1 YES \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n5 200 TS_CORTEX_CATALOG NO \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n7 16 USERS NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpo4rgv_.dbf\n \nList of Temporary Files\n=======================\nFile Size(MB) Tablespace Maxsize(MB) Tempfile Name\n---- -------- -------------------- ----------- --------------------\n1 69 TEMP 32767 \/oracle\/dados\/RMANDB\/datafile\/o1_mf_temp_h8nyvt1f_.tmp\n \nRMAN> host 'rm \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpo4rgv_.dbf';\n \nhost command complete\n<\/pre><\/div>\n\n\nIdentificando o problema:<\/p>\n\n\n
\nRMAN> VALIDATE DATABASE;\n \nStarting validate at 2021-07-23:20:51:18\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting validation of datafile\nchannel ORA_DISK_1: specifying datafile(s) for validation\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\ninput datafile file number=00002 name=\/oracle\/dados\/RMANDB\/datafile\/ts_hipo_catalog.dbf\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03009: failure of validate command on ORA_DISK_1 channel at 07\/23\/2021 20:51:18\nORA-01122: database file 7 failed verification check\nORA-01110: data file 7: '\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpo4rgv_.dbf'\nORA-01565: error in identifying file '\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpo4rgv_.dbf'\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 7\n<\/pre><\/div>\n\n\nAgora vamos executar o comando de SWITCH LOGFILE algumas vezes, de modo que esse roteamento mande nossos vetores de altera\u00e7\u00e3o (que poderiam ser usados no recover) para o espa\u00e7o. Como temos 3 grupos de ORL, ao tentar executar o \u00faltimo SWITCH, a inst\u00e2ncia do Oracle c\u00e1i. E isso permite a recupera\u00e7\u00e3o do datafile:<\/p>\n\n\n
\nRMAN> SELECT DISTINCT(GROUP#) FROM V$LOG;\n \n GROUP#\n----------\n 1\n 2\n 3\n \nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nStatement processed\n \nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nStatement processed\n \nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-00601: fatal error in recovery manager\nRMAN-03004: fatal error during execution of command\nORA-01092: ORACLE instance terminated. Disconnection forced\nRMAN-03002: failure of sql statement command at 07\/23\/2021 20:52:22\nORA-03113: end-of-file on communication channel\nProcess ID: 5171\nSession ID: 1 Serial number: 18594\n<\/pre><\/div>\n\n\nTentando realizar a recupera\u00e7\u00e3o apenas do datafile 7:<\/p>\n\n\n
\n[oracle@oel8 trace]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Fri Jul 23 20:52:51 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database (not started)\n \nRMAN> STARTUP MOUNT;\n \nOracle instance started\ndatabase mounted\n \nTotal System Global Area 1610612016 bytes\n \nFixed Size 8658224 bytes\nVariable Size 520093696 bytes\nDatabase Buffers 1073741824 bytes\nRedo Buffers 8118272 bytes\n \nRMAN> RESTORE DATAFILE 7;\n \nStarting restore at 2021-07-23:20:53:13\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=34 device type=DISK\n \nchannel ORA_DISK_1: starting datafile backup set restore\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\nchannel ORA_DISK_1: restoring datafile 00007 to \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpo4rgv_.dbf\nchannel ORA_DISK_1: reading from backup piece \/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T204919_jhpoczkd_.bkp\nchannel ORA_DISK_1: piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T204919_jhpoczkd_.bkp tag=TAG20210723T204919\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\nFinished restore at 2021-07-23:20:53:15\n \nRMAN> RECOVER DATAFILE 7;\n \nStarting recover at 2021-07-23:20:53:21\nusing channel ORA_DISK_1\n \nstarting media recovery\nmedia recovery complete, elapsed time: 00:00:00\n \nFinished recover at 2021-07-23:20:53:22\n \nRMAN> ALTER DATABASE OPEN;\n \nStatement processed\n<\/pre><\/div>\n\n\nNossa tabela est\u00e1 salva:<\/p>\n\n\n
\nRMAN> SELECT * FROM BSS.ASWAN;\n\nDESCRICAO\n--------------------------------------------------\nAAAAAAAAA\n<\/pre><\/div>\n\n\nSendo assim, vou fazer o mesmo processo (dropar tabela, remover backup, criar tabela, criar backup), mas o Switch vou executar antes de remover o datafile. Assim garantimos que n\u00e3o teremos os vetores de altera\u00e7\u00e3o dispon\u00edveis para o nosso paciente.<\/p>\n\n\n
\nRMAN> DROP TABLE BSS.ASWAN;\n \nStatement processed\n \nRMAN> DELETE BACKUPSET;\n \nusing channel ORA_DISK_1\n \nList of Backup Pieces\nBP Key BS Key Pc# Cp# Status Device Type Piece Name\n------- ------- --- --- ----------- ----------- ----------\n378 349 1 1 AVAILABLE DISK \/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T204919_jhpoczkd_.bkp\n379 350 1 1 AVAILABLE DISK \/oracle\/fra\/RMANDB\/autobackup\/2021_07_23\/o1_mf_s_1078692524_jhpodrt9_.bkp\n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T204919_jhpoczkd_.bkp RECID=378 STAMP=1078692559\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_07_23\/o1_mf_s_1078692524_jhpodrt9_.bkp RECID=379 STAMP=1078692584\nDeleted 2 objects\n \n \nRMAN> BACKUP DATABASE;\n \nStarting backup at 2021-07-23:20:54:42\nusing channel ORA_DISK_1\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of backup command at 07\/23\/2021 20:54:42\nRMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode\n \nRMAN> SHUTDOWN IMMEDIATE;\n \ndatabase closed\ndatabase dismounted\nOracle instance shut down\n \nRMAN> STARTUP MOUNT;\n \nconnected to target database (not started)\nOracle instance started\ndatabase mounted\n \nTotal System Global Area 1610612016 bytes\n \nFixed Size 8658224 bytes\nVariable Size 520093696 bytes\nDatabase Buffers 1073741824 bytes\nRedo Buffers 8118272 bytes\n \nRMAN> BACKUP DATABASE;\n \nStarting backup at 2021-07-23:20:55:35\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=34 device type=DISK\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\ninput datafile file number=00002 name=\/oracle\/dados\/RMANDB\/datafile\/ts_hipo_catalog.dbf\ninput datafile file number=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpombgk_.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-07-23:20:55:36\nchannel ORA_DISK_1: finished piece 1 at 2021-07-23:20:56:01\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T205535_jhpoqr62_.bkp tag=TAG20210723T205535 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:25\nFinished backup at 2021-07-23:20:56:01\n \nStarting Control File and SPFILE Autobackup at 2021-07-23:20:56:01\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_07_23\/o1_mf_s_1078692900_jhporkmj_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-07-23:20:56:02\n \nRMAN> CREATE TABLE BSS.ASWAN (DESCRICAO VARCHAR2(50));\n \nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of sql statement command at 07\/23\/2021 20:56:05\nORA-01109: database not open\n \nRMAN> ALTER DATABASE OPEN;\n \nStatement processed\n \nRMAN> CREATE TABLE BSS.ASWAN (DESCRICAO VARCHAR2(50));\n \nStatement processed\n \nRMAN> INSERT INTO BSS.ASWAN (DESCRICAO) VALUES ('AAAAAAAAA');\n \nStatement processed\n \nRMAN> COMMIT;\n \nStatement processed\n \nRMAN> SELECT * FROM BSS.ASWAN;\n \nDESCRICAO\n--------------------------------------------------\nAAAAAAAAA\n \nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nStatement processed\n \nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nStatement processed\n \nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nStatement processed\n \nRMAN> ALTER SYSTEM SWITCH LOGFILE;\n \nStatement processed\n<\/pre><\/div>\n\n\nDeletando datafile:<\/p>\n\n\n
\nRMAN> REPORT SCHEMA;\n \nReport of database schema for database with db_unique_name RMANDB\n \nList of Permanent Datafiles\n===========================\nFile Size(MB) Tablespace RB segs Datafile Name\n---- -------- -------------------- ------- ------------------------\n1 880 SYSTEM YES \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n2 120 TS_HIPO_CATALOG NO \/oracle\/dados\/RMANDB\/datafile\/ts_hipo_catalog.dbf\n3 730 SYSAUX NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n4 305 UNDOTBS1 YES \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n5 200 TS_CORTEX_CATALOG NO \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n7 16 USERS NO \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpombgk_.dbf\n \nList of Temporary Files\n=======================\nFile Size(MB) Tablespace Maxsize(MB) Tempfile Name\n---- -------- -------------------- ----------- --------------------\n1 69 TEMP 32767 \/oracle\/dados\/RMANDB\/datafile\/o1_mf_temp_h8nyvt1f_.tmp\n \nRMAN> host 'rm \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpombgk_.dbf';\n \nhost command complete\n \nRMAN> VALIDATE DATABASE;\n \nStarting validate at 2021-07-23:20:57:32\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting validation of datafile\nchannel ORA_DISK_1: specifying datafile(s) for validation\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\ninput datafile file number=00002 name=\/oracle\/dados\/RMANDB\/datafile\/ts_hipo_catalog.dbf\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03009: failure of validate command on ORA_DISK_1 channel at 07\/23\/2021 20:57:33\nORA-01122: database file 7 failed verification check\nORA-01110: data file 7: '\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpombgk_.dbf'\nORA-01565: error in identifying file '\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpombgk_.dbf'\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 7\n<\/pre><\/div>\n\n\nTentando recuperar apenas o datafile 7, vimos que o mesmo precisaria de mais vetores de altera\u00e7\u00e3o para concluir o recover. Assim a abertura do banco n\u00e3o \u00e9 poss\u00edvel.<\/p>\n\n\n
\nRMAN> SHUTDOWN IMMEDIATE;\n \nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of shutdown command at 07\/23\/2021 20:58:12\nORA-03113: end-of-file on communication channel\n \nRMAN> exit\n \n \nRecovery Manager complete.\n[oracle@oel8 trace]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Fri Jul 23 20:58:15 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database (not started)\n \nRMAN> STARTUP MOUNT;\n \nOracle instance started\ndatabase mounted\n \nTotal System Global Area 1610612016 bytes\n \nFixed Size 8658224 bytes\nVariable Size 520093696 bytes\nDatabase Buffers 1073741824 bytes\nRedo Buffers 8118272 bytes\n \nRMAN> RESTORE DATAFILE 7;\n \nStarting restore at 2021-07-23:20:59:04\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=34 device type=DISK\n \nchannel ORA_DISK_1: starting datafile backup set restore\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\nchannel ORA_DISK_1: restoring datafile 00007 to \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpombgk_.dbf\nchannel ORA_DISK_1: reading from backup piece \/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T205535_jhpoqr62_.bkp\nchannel ORA_DISK_1: piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T205535_jhpoqr62_.bkp tag=TAG20210723T205535\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\nFinished restore at 2021-07-23:20:59:06\n \nRMAN> RECOVER DATAFILE 7;\n \nStarting recover at 2021-07-23:20:59:13\nusing channel ORA_DISK_1\n \nstarting media recovery\n \narchived log for thread 1 with sequence 123 is already on disk as file \/oracle\/dados\/RMANDB\/onlinelog\/o1_mf_3_h8nyv1ok_.log\narchived log for thread 1 with sequence 124 is already on disk as file \/oracle\/dados\/RMANDB\/onlinelog\/o1_mf_1_h8nytyh4_.log\narchived log for thread 1 with sequence 125 is already on disk as file \/oracle\/dados\/RMANDB\/onlinelog\/o1_mf_2_h8nytykj_.log\nRMAN-08187: warning: media recovery until SCN 3489796 complete\nFinished recover at 2021-07-23:20:59:14\n \nRMAN> ALTER DATABASE OPEN;\n \nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of sql statement command at 07\/23\/2021 20:59:33\nORA-01113: file 7 needs media recovery\nORA-01110: data file 7: '\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpoy9bs_.dbf'\n<\/pre><\/div>\n\n\nNessas circunst\u00e2ncias, como n\u00e3o h\u00e1 archived logs (pois o banco est\u00e1 em NOARCHIVELOG mode) e como n\u00e3o h\u00e1 mais os vetores nos Online Redo Logs (pois a quantidade de Switches foi maior que a quantidade de grupos do ambientes), a \u00fanica sa\u00edda \u00e9 restaurar o banco de dados TODO, utilizando o backup FULL realizado, e abr\u00ed-lo com o Resetlogs:<\/p>\n\n\n
\nRMAN> RESTORE DATABASE;\n \nStarting restore at 2021-07-23:21:03:01\nusing channel ORA_DISK_1\n \nskipping datafile 7; already restored to file \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_jhpoy9bs_.dbf\nchannel ORA_DISK_1: starting datafile backup set restore\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\nchannel ORA_DISK_1: restoring datafile 00001 to \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\nchannel ORA_DISK_1: restoring datafile 00002 to \/oracle\/dados\/RMANDB\/datafile\/ts_hipo_catalog.dbf\nchannel ORA_DISK_1: restoring datafile 00003 to \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\nchannel ORA_DISK_1: restoring datafile 00004 to \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\nchannel ORA_DISK_1: restoring datafile 00005 to \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\nchannel ORA_DISK_1: reading from backup piece \/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T205535_jhpoqr62_.bkp\nchannel ORA_DISK_1: piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_07_23\/o1_mf_nnndf_TAG20210723T205535_jhpoqr62_.bkp tag=TAG20210723T205535\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:01:25\nFinished restore at 2021-07-23:21:04:26\n \nRMAN> RECOVER DATABASE;\n \nStarting recover at 2021-07-23:21:04:34\nusing channel ORA_DISK_1\n \nstarting media recovery\n \narchived log for thread 1 with sequence 123 is already on disk as file \/oracle\/dados\/RMANDB\/onlinelog\/o1_mf_3_h8nyv1ok_.log\narchived log for thread 1 with sequence 124 is already on disk as file \/oracle\/dados\/RMANDB\/onlinelog\/o1_mf_1_h8nytyh4_.log\narchived log for thread 1 with sequence 125 is already on disk as file \/oracle\/dados\/RMANDB\/onlinelog\/o1_mf_2_h8nytykj_.log\nRMAN-08187: warning: media recovery until SCN 3489796 complete\nFinished recover at 2021-07-23:21:04:34\n \nRMAN> ALTER DATABASE OPEN RESETLOGS;\n \nStatement processed\n<\/pre><\/div>\n\n\nJ\u00e1 que conseguimos salvar nosso banco, mesmo com o resetlogs, o mesmo “ganha” um novo incarnation:<\/p>\n\n\n
\nRMAN> SELECT INCARNATION#, RESETLOGS_CHANGE#, PRIOR_RESETLOGS_CHANGE#, STATUS FROM V$DATABASE_INCARNATION ORDER BY 1;\n \nINCARNATION# RESETLOGS_CHANGE# PRIOR_RESETLOGS_CHANGE# STATUS\n------------ ----------------- ----------------------- -------\n 1 1 0 PARENT\n 2 1477662 1 PARENT\n 3 3489797 1477662 CURRENT\n<\/pre><\/div>\n\n\nPor\u00e9m, nossa tabela n\u00e3o foi recuperada pois a mesma foi criada ap\u00f3s o backup FULL usado:<\/p>\n\n\n
\nRMAN> SELECT * FROM BSS.ASWAN;\n \nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of sql statement command at 07\/23\/2021 21:09:01\nORA-00942: table or view does not exist\n<\/pre><\/div>\n\n\nObs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laborat\u00f3rio pessoal para fins de aprendizado.<\/p>\n","protected":false},"excerpt":{"rendered":"
Hoje \u00e9 dia de destruir e reconstruir. Vamos simular a perda de um datafile “non-system” (ou seja, que n\u00e3o abriga os metadados do database), em um ambiente em noarchivelog mode. Reconhecendo o ambiente: Realizando um backup full do banco (como o mesmo est\u00e1 em noarchivelog mode, \u00e9 necess\u00e1rio mont\u00e1-lo para realizar o processo): Para explorarmos […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5883","post","type-post","status-publish","format-standard","hentry","category-backup-recovery"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=5883"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5883\/revisions"}],"predecessor-version":[{"id":9077,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5883\/revisions\/9077"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=5883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=5883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=5883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}