{"id":73153,"date":"2015-07-14T12:01:22","date_gmt":"2015-07-14T12:01:22","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/uncategorized\/integrating-acfs-snapshots-with-rman\/"},"modified":"2021-07-14T13:07:22","modified_gmt":"2021-07-14T13:07:22","slug":"integrating-acfs-snapshots-with-rman","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/oracle-databases\/integrating-acfs-snapshots-with-rman\/","title":{"rendered":"Integrating ACFS Snapshots With RMAN"},"content":{"rendered":"<p>In my <a href=\"https:\/\/allthingsoracle.com\/12c-database-backups-using-acfs-snapshots\/\">last article<\/a>, I demonstrated that starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment) supports database files (database version 11.2.0.4 and up) in addition to general purpose files, so that entire Oracle databases can be stored inside Oracle Cloud FS. In addition, for a database with its files stored on Oracle Cloud file system, Oracle ACFS Snapshots may serve as point-in-time backups of the database which can be used for online recovery of database files.<\/p>\n<p>In this article, I will demonstrate that ACFS snapshots can be integrated with RMAN and hence employed to perform complete recovery using RMAN RESTORE \/ RECOVER commands, thereby complementing RMAN functionality.<\/p>\n<p>Currently\u00a0I am working in an Oracle Database 12.1.0.2 cluster environment and have created a database named cfsdb, with all of its files stored on the cloud file system as shown below:<\/p>\n<pre>[oracle@host01 ~]$ srvctl config database -d cfsdb\r\nDatabase unique name: cfsdb\r\nDatabase name: cfsdb\r\nOracle home: \/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\r\nOracle user: oracle\r\n<strong><span style=\"color: red;\">Spfile: \/mnt\/acfs\/oradata\/cfsdb\/spfilecfsdb.ora<\/span><\/strong>\r\n<strong><span style=\"color: red;\">Password file: \/mnt\/acfs\/oradata\/cfsdb\/orapwcfsdb<\/span><\/strong>\r\nDomain:\r\nStart options: open\r\nStop options: immediate\r\nDatabase role: PRIMARY\r\nManagement policy: AUTOMATIC\r\nServer pools:\r\nDisk Groups:\r\n<strong><span style=\"color: red;\">Mount point paths: \/mnt\/acfs<\/span><\/strong>\r\nServices:\r\nType: RAC\r\nStart concurrency:\r\nStop concurrency:\r\nOSDBA group: dba\r\nOSOPER group: oper\r\nDatabase instances: cfsdb1\r\nConfigured nodes: host01\r\nDatabase is administrator managed\r\n\r\nCFSDB &gt; select name from v$controlfile;\r\n\r\nNAME\r\n----------------------------------------\r\n<strong><span style=\"color: red;\">\/mnt\/acfs<\/span><\/strong>\/oradata\/cfsdb\/control01.ctl\r\n<strong><span style=\"color: red;\">\/mnt\/acfs<\/span><\/strong>\/cfsdb\/control02.ctl\r\n\r\nCFSDB &gt; select member from v$logfile;\r\nMEMBER\r\n----------------------------------------\r\n<strong><span style=\"color: red;\">\/mnt\/acfs<\/span><\/strong>\/oradata\/cfsdb\/redo03.log\r\n<strong><span style=\"color: red;\">\/mnt\/acfs<\/span><\/strong>\/oradata\/cfsdb\/redo02.log\r\n<strong><span style=\"color: red;\">\/mnt\/acfs<\/span><\/strong>\/oradata\/cfsdb\/redo01.log\r\n\r\nCFSDB &gt; select name from v$archived_log;\r\n\r\nNAME\r\n-----------------------------------------------------------------\r\n<strong><span style=\"color: red;\">\/mnt\/acfs<\/span><\/strong>\/CFSDB\/archivelog\/2015_07_07\/o1_mf_1_7_bsqsor96_.arc\r\n\r\nCFSDB &gt; select name from v$datafile;\r\n\r\nNAME\r\n-----------------------------------------------------------------\r\n<strong><span style=\"color: red;\">\/mnt\/acfs<\/span><\/strong>\/oradata\/cfsdb\/system01.dbf\r\n<strong><span style=\"color: red;\">\/mnt\/acfs<\/span><\/strong>\/oradata\/cfsdb\/sysaux01.dbf\r\n<strong><span style=\"color: red;\">\/mnt\/acfs<\/span><\/strong>\/oradata\/cfsdb\/undotbs01.dbf\r\n<strong><span style=\"color: red;\">\/mnt\/acfs<\/span><\/strong>\/oradata\/cfsdb\/example01.dbf\r\n<strong><span style=\"color: red;\">\/mnt\/acfs<\/span><\/strong>\/oradata\/cfsdb\/users01.dbf\r\n\r\nCFSDB&gt;sho parameter db_recovery\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_recovery_file_dest                string <strong><span style=\"color: red;\">     \/mnt\/acfs<\/span><\/strong>\r\ndb_recovery_file_dest_size           big integer 3000M<\/pre>\n<h3>Let&#8217;s confirm that the database cfsdb is in archivelog mode<\/h3>\n<pre>CFSDB &gt; archive log list;\r\n\r\nDatabase log mode <strong>              <span style=\"color: red;\">Archive Mode<\/span><\/strong>\r\nAutomatic archival              Enabled\r\nArchive destination             USE_DB_RECOVERY_FILE_DEST\r\nOldest online log sequence      6\r\nNext log sequence to archive    8\r\nCurrent log sequence            8<\/pre>\n<h3>Create a test table HR.EMP with 107 rows in EXAMPLE tablespace:<\/h3>\n<pre>SQL&gt; create table hr.emp tablespace example as select * from hr.employees;\r\n\r\nSQL&gt; select owner, table_name, tablespace_name\r\n\t\t\tfrom dba_tables\r\n\t\t\twhere owner = 'HR' and table_name = 'EMP';\r\n\r\nOWNER      TABLE_NAME      TABLESPACE_NAME\r\n---------- --------------- ------------------------------\r\nHR         EMP             <strong><span style=\"color: red;\">EXAMPLE<\/span><\/strong>\r\n\r\nSQL&gt; select count(*) from hr.emp;\r\n\r\n  COUNT(*)\r\n----------\r\n<strong>       107<\/strong><\/pre>\n<h3>Verify that currently there are no snapshots of the cloud file system hosting the database files:<\/h3>\n<pre>[root@host01 oracle]# acfsutil snap info \/mnt\/acfs\r\n\r\n\tnumber of snapshots: <strong>0<\/strong>\r\n\tsnapshot space usage: 0 ( 0.00 )<\/pre>\n<h3>Take snapshot (example_dbsnap) of the cloud file system while the database is in backup mode:<\/h3>\n<pre>SQL&gt; alter database begin backup;\r\n\r\nDatabase altered.\r\n\r\n[root@host01 acfs]# acfsutil snap create example_dbsnap \/mnt\/acfs\r\n\r\nacfsutil snap create: Snapshot operation is complete.\r\n\r\n[root@host01 acfs]# acfsutil snap info \/mnt\/acfs\r\n\r\nsnapshot name:                <strong><span style=\"color: red;\">example_dbsnap<\/span><\/strong>\r\nsnapshot location:            <strong><span style=\"color: red;\">\/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap<\/span><\/strong>\r\nRO snapshot or RW snapshot:   RO\r\nparent name:                  \/mnt\/acfs\r\nsnapshot creation time:       Tue Jul 7 20:34:18 2015\r\n\r\nnumber of snapshots: 1\r\nsnapshot space usage: 9486336 ( 9.04 MB )\r\n\r\nSQL&gt; alter database end backup;\r\n\r\nDatabase altered.<\/pre>\n<h3>Check that all the datafiles, control file and spfile are available in snapshot:<\/h3>\n<pre>[root@host01 acfs]# ls -l \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\r\n\r\ntotal 3038112\r\n-rw-r----- 1 oracle oinstall   18956288 Jul  7 20:25 control01.ctl\r\n-rw-r----- 1 oracle oinstall 1304174592 Jul  7 20:22 example01.dbf\r\n-rw-r----- 1 oracle oinstall       7680 Jul  7 19:38 orapwcfsdb\r\n-rw-r----- 1 oracle oinstall   52429312 Jul  7 20:03 redo01.log\r\n-rw-r----- 1 oracle oinstall   52429312 Jul  7 20:30 redo02.log\r\n-rw-r----- 1 oracle oinstall   52429312 Jul  7 19:44 redo03.log\r\n-rw-r----- 1 oracle oinstall       3584 Jul  7 20:11 spfilecfsdb.ora\r\n-rw-r----- 1 oracle oinstall  629153792 Jul  7 20:30 sysaux01.dbf\r\n-rw-r----- 1 oracle oinstall  828383232 Jul  7 20:30 system01.dbf\r\n-rw-r----- 1 oracle oinstall   62922752 Jul  7 20:25 temp01.dbf\r\n-rw-r----- 1 oracle oinstall  104865792 Jul  7 20:30 undotbs01.dbf\r\n-rw-r----- 1 oracle oinstall    5251072 Jul  7 20:22 users01.dbf<\/pre>\n<h3>Insert records in hr.emp so that it has 214 rows:<\/h3>\n<pre>SQL&gt; insert into hr.emp select * from hr.emp;\r\n\r\n107 rows created.\r\n\r\nSQL&gt; commit;\r\n\r\nCommit complete\r\n\r\nSQL&gt; select count(*) from hr.emp;\r\n\r\n  COUNT(*)\r\n----------\r\n       <strong><span style=\"color: red;\">214<\/span><\/strong><\/pre>\n<h3>Simulate loss of datafile for EXAMPLE tablespace:<\/h3>\n<pre>SQL&gt; ho mv \/mnt\/acfs\/oradata\/cfsdb\/example01.dbf \/mnt\/acfs\/oradata\/cfsdb\/example01.bak\r\n\r\nSQL&gt; alter tablespace example offline;\r\n\r\nTablespace altered.\r\n\r\nSQL&gt; alter tablespace example online;\r\nalter tablespace example online\r\n*\r\n<strong><span style=\"color: red;\">ERROR at line 1:<\/span><\/strong>\r\n<strong><span style=\"color: red;\">ORA-01157: cannot identify\/lock data file 5 - see DBWR trace file<\/span><\/strong>\r\n<strong><span style=\"color: red;\">ORA-01110: data file 5: '\/mnt\/acfs\/oradata\/cfsdb\/example01.dbf'.<\/span><\/strong><\/pre>\n<h3>Locate the datafile for EXAMPLE tablespace in snapshot example_dbsnap:<\/h3>\n<pre>[root@host01 cfsdb]# ls -l \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/example01.dbf\r\n\r\n-rw-r----- 1 oracle oinstall 1304174592 Jul 7 20:22 <strong><span style=\"color: red;\">\/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/example01.dbf<\/span><\/strong><\/pre>\n<h3>Copy datafile for EXAMPLE tablespace from snapshot and attempt to bring EXAMPLE tablespace online:<\/h3>\n<pre>[oracle@host01 ~]$ cp \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/example01.dbf \/mnt\/acfs\/oradata\/cfsdb\/example01.dbf\r\n\r\n[oracle@host01 ~]$ ls -l \/mnt\/acfs\/oradata\/cfsdb\/example01.dbf\r\n-rw-r----- 1 oracle oinstall 1304174592 Jul 7 20:44 \/mnt\/acfs\/oradata\/cfsdb\/example01.dbf\r\n\r\nSQL&gt; alter tablespace example online;\r\nalter tablespace example online\r\n*\r\n<strong><span style=\"color: red;\">ERROR at line 1:<\/span><\/strong>\r\n<strong><span style=\"color: red;\">ORA-01113: file 5 needs media recovery<\/span><\/strong>\r\n<strong><span style=\"color: red;\">ORA-01110: data file 5: '\/mnt\/acfs\/oradata\/cfsdb\/example01.dbf'<\/span><\/strong><\/pre>\n<h3>Employ RMAN to perform complete recovery using archived logs in FRA:<\/h3>\n<pre>RMAN&gt; recover tablespace example;\r\n\r\nStarting recover at 07-JUL-15\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=77 instance=cfsdb1 device type=DISK\r\n\r\nstarting media recovery\r\nmedia recovery complete, elapsed time: 00:00:06\r\n\r\nFinished recover at 07-JUL-15\r\n\r\nSQL&gt; alter tablespace example online;\r\n\r\nTablespace altered.\r\n\r\nSQL&gt; select count(*) from hr.emp;\r\n\r\n  COUNT(*)\r\n----------\r\n       <strong><span style=\"color: red;\">214<\/span><\/strong><\/pre>\n<p>Thus, we have been able to perform complete recovery by employing:<\/p>\n<ul>\n<li>OS commands to copy the datafile from the snapshot example_dbsnap taken while the database was in backup mode.<\/li>\n<li>RMAN RECOVER command to perform complete recovery using Archived logs stored in FRA (\/mnt\/acfs).<\/li>\n<\/ul>\n<p>Now, let us explore if we can catalog the datafile copies stored in the snapshot with RMAN and hence employ RMAN for RESTORE as well as RECOVER.<\/p>\n<h3>Catalog all the files in the snapshot example_dbsnap in directory \u201c\/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/\u201d<\/h3>\n<pre>RMAN&gt; catalog start with '\/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/';\r\nsearching\u00a0for all files that match the pattern\/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/\r\n\r\nList of Files Unknown to the Database\r\n=====================================\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/orapwcfsdb\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/sysaux01.dbf\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/system01.dbf\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/users01.dbf\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/undotbs01.dbf\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/control01.ctl\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/redo01.log\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/redo02.log\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/redo03.log\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/temp01.dbf\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/example01.dbf\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/spfilecfsdb.ora\r\n\r\nDo you really want to catalog the above files (enter YES or NO)? yes\r\ncataloging files...\r\ncataloging done\r\n\r\nList of Cataloged Files\r\n=======================\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/sysaux01.dbf\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/system01.dbf\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/users01.dbf\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/undotbs01.dbf\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/temp01.dbf\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/example01.dbf\r\n\r\nList of Files Which Were Not Cataloged\r\n=======================================\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/orapwcfsdb\r\nRMAN-07518: Reason: Foreign database file DBID: 0 Database Name:\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/control01.ctl\r\nRMAN-07519: Reason: Error while cataloging. See alert.log.\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/redo01.log\r\nRMAN-07529: Reason: catalog is not supported for this file type\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/redo02.log\r\nRMAN-07529: Reason: catalog is not supported for this file type\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/redo03.log\r\nRMAN-07529: Reason: catalog is not supported for this file type\r\nFile Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/spfilecfsdb.ora\r\nRMAN-07518: Reason: Foreign database file DBID: 0 Database Name:\r\n\r\nRMAN&gt; list copy of database;\r\n\r\nList of Datafile Copies\r\n=======================\r\n\r\nKey     File S Completion Time Ckp SCN    Ckp Time\r\n------- ---- - --------------- ---------- ---------------\r\n2       1    A 08-JUL-15       1639217    07-JUL-15\r\n        Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/system01.dbf\r\n\r\n1       3    A 08-JUL-15       1639217    07-JUL-15\r\n        Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/sysaux01.dbf\r\n\r\n4       4    A 08-JUL-15       1639217    07-JUL-15\r\n        Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/undotbs01.dbf\r\n\r\n5       5    A 08-JUL-15       1639217    07-JUL-15\r\n        Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/example01.dbf\r\n\r\n3       6    A 08-JUL-15       1639217    07-JUL-15\r\n        Name: \/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/users01.dbf<\/pre>\n<p>It can be seen that all the datafile copies have been catalogued whereas SPfile and controlfile have not been registered with RMAN.<\/p>\n<p>Now we will again simulate the loss of datafile for the EXAMPLE tablespace, and then we&#8217;ll attempt to employ RMAN for RESTORE as well RECOVER.<\/p>\n<h3>Simulate loss of datafile for EXAMPLE tablespace:<\/h3>\n<pre>SQL&gt; ho rm \/mnt\/acfs\/oradata\/cfsdb\/example01.dbf\r\n\r\n\talter tablespace example offline;\r\n\r\nTablespace altered.\r\n\r\nSQL&gt; alter tablespace example online;\r\nalter tablespace example online\r\n*\r\n<strong><span style=\"color: red;\">ERROR at line 1:<\/span><\/strong>\r\n<strong><span style=\"color: red;\">ORA-01157: cannot identify\/lock data file 5 - see DBWR trace file<\/span><\/strong>\r\n<strong><span style=\"color: red;\">ORA-01110: data file 5: '\/mnt\/acfs\/oradata\/cfsdb\/example01.dbf'<\/span><\/strong><\/pre>\n<h3>Restore EXAMPLE tablespace from the catalogued datafile copy in the snapshot using RMAN and attempt to bring EXAMPLE tablespace online:<\/h3>\n<pre>RMAN&gt; restore tablespace example;\r\n\r\nStarting restore at 08-JUL-15\r\nusing channel ORA_DISK_1\r\nchannel ORA_DISK_1: restoring datafile 00005\r\n<strong><span style=\"color: red;\">input datafile copy RECID=5 STAMP=884515151 file name=\/mnt\/acfs\/.ACFS\/snaps\/example_dbsnap\/oradata\/cfsdb\/example01.dbf<\/span><\/strong>\r\ndestination for restore of datafile 00005: \/mnt\/acfs\/oradata\/cfsdb\/example01.dbf\r\nchannel ORA_DISK_1: copied datafile copy of datafile 00005\r\noutput file name=\/mnt\/acfs\/oradata\/cfsdb\/example01.dbf RECID=0 STAMP=0\r\nFinished restore at 08-JUL-15\r\n\r\nSQL&gt; alter tablespace example online;\r\nalter tablespace example online\r\n*\r\n<strong><span style=\"color: red;\">ERROR at line 1:<\/span><\/strong>\r\n<strong><span style=\"color: red;\">ORA-01113: file 5 needs media recovery<\/span><\/strong>\r\n<strong><span style=\"color: red;\">ORA-01110: data file 5: '\/mnt\/acfs\/oradata\/cfsdb\/example01.dbf'<\/span><\/strong><\/pre>\n<h3>Employ RMAN to perform complete recovery using archived logs in FRA:<\/h3>\n<pre>RMAN&gt; recover tablespace example;\r\n\r\nStarting recover at 08-JUL-15\r\nusing channel ORA_DISK_1\r\n\r\nstarting media recovery\r\nmedia recovery complete, elapsed time: 00:00:09\r\n\r\nFinished recover at 08-JUL-15\r\n\r\n\r\nSQL&gt; alter tablespace example online;\r\n\r\nTablespace altered.\r\n\r\nSQL&gt; select count(*) from hr.emp;\r\n\r\n  COUNT(*)\r\n----------\r\n       214<\/pre>\n<p>Thus, we have been able to perform complete recovery by employing:<\/p>\n<ul>\n<li>RMAN RESTORE command to RESTORE the datafile from the snapshot example_dbsnap taken while the database was in backup mode.<\/li>\n<li>RMAN RECOVER command to perform complete recovery using Archived logs stored in FRA (\/mnt\/acfs).<\/li>\n<\/ul>\n<h2>Conclusion:<\/h2>\n<ul>\n<li>Starting with Oracle Grid Infrastructure 12c (12.1), ACFS supports database files in cluster environment so that entire Oracle databases can be stored inside a cloud file system.<\/li>\n<li>ACFS snapshots taken while the database is in backup mode can be integrated with RMAN and employed to perform complete recovery using RMAN RESTORE \/ RECOVER commands.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In my last article, I demonstrated that starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment) supports database files (database version 11.2.0.4 and up) in addition to general purpose files, so that entire Oracle databases can be stored inside Oracle Cloud FS. In addition, for a database with its files stored&hellip;<\/p>\n","protected":false},"author":316217,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143533],"tags":[48350,48492],"coauthors":[],"class_list":["post-73153","post","type-post","status-publish","format-standard","hentry","category-oracle-databases","tag-acfs-snapshots","tag-rman"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/316217"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=73153"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73153\/revisions"}],"predecessor-version":[{"id":91647,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73153\/revisions\/91647"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=73153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=73153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=73153"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=73153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}