{"id":73158,"date":"2015-07-03T15:28:42","date_gmt":"2015-07-03T15:28:42","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/uncategorized\/upgrading-a-database-using-recovery-manager-rman-duplicate-command-in-oracle-12c\/"},"modified":"2021-07-14T13:07:23","modified_gmt":"2021-07-14T13:07:23","slug":"upgrading-a-database-using-recovery-manager-rman-duplicate-command-in-oracle-12c","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/oracle-databases\/upgrading-a-database-using-recovery-manager-rman-duplicate-command-in-oracle-12c\/","title":{"rendered":"Upgrading A Database Using Recovery Manager (RMAN) Duplicate Command In Oracle 12c"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>For versions of Oracle 11g R2, Oracle Recovery Manager (RMAN) replicates a database to a different Oracle home and opens it with NORESET LOGS option. From Oracle 12cR1, database RMAN introduced an option called \u2018NO OPEN\u2019, which duplicates your database to a new location and keeps it in an unopened state. Using this feature we can duplicate a database to more recent target database version, allowing us to update our existing database to the most recent version.<\/p>\n<h2>RMAN duplicate command using backup:<\/h2>\n<p>Duplicate process can make use of an existing source database backup. All backup pieces should be kept in the same location and the location should be same for both source and destination.<\/p>\n<h3>Configuring the source server:<\/h3>\n<ul>\n<li>Switch the source database to archive log mode if it is not already:<\/li>\n<\/ul>\n<pre>SQL&gt; select log_mode from v$database;<\/pre>\n<p>In the mount state change the LOG mode of the database:<\/p>\n<pre>SQL&gt; alter database archivelog;<\/pre>\n<p>Execute the pre-upgrade script at source database server and make necessary changes for upgrade. Pre-upgrade script (Preupgrd.sql, utluppkg.sql) is located at: <code>&lt;Target Database server home&gt;\/rdbms\/admin<\/code><\/p>\n<ul>\n<li>Copy the file(s) to source Oracle home and execute it as \u2018SYS\u2019 user. This will validate the source database and provide recommendations for performing the upgrade process. This is a mandatory step for the upgrade process.<\/li>\n<\/ul>\n<ul>\n<li>Take a full backup of the source database including archive logs. A RMAN full database backup has to be taken. Your database can be either in the OPEN or MOUNT state. Use following commands:<\/li>\n<\/ul>\n<pre>RMAN&gt; connect target \/ catalog &lt;catalog_schema&gt;\/&lt;password&gt;@&lt;catalog database&gt;\r\nRMAN&gt; backup database including archivelog;<\/pre>\n<p>This will generate a backup set.<\/p>\n<ul>\n<li>Create pfile from spfile:<\/li>\n<\/ul>\n<pre>SQL&gt; create pfile from spfile;<\/pre>\n<p>Move your database backup and the backup of pfile to the target database server.<\/p>\n<h3>Configuring the Target Database Server<\/h3>\n<ul>\n<li>Create a password file for the database service\n<ul>\n<li><code>Orapwd file=&lt;12c password file&gt; password=&lt;password for sys user&gt;<\/code><\/li>\n<\/ul>\n<\/li>\n<li>Make the necessary changes to initialization file at target database server.<\/li>\n<\/ul>\n<p>Change the compatible parameter value if it is recommended by pre-upgrade script.<\/p>\n<ul>\n<li>Start the database in nomount state:<\/li>\n<\/ul>\n<pre>SQL&gt; startup nomount pfile=&lt;modified pfile&gt;<\/pre>\n<ul>\n<li>Ensure that you keep the backup pieces at same location as the source database server. This is required as catalog has recorded the backup location.<\/li>\n<li>Execute the duplicate database command with the \u201cNo Open\u201d option using backup location:<\/li>\n<\/ul>\n<pre>RMAN&gt; Connect target \/\r\nRMAN&gt; Duplicate database to \u2018DB12c\u2019 nopen backup location\r\n\u2018&lt;location of backup&gt;\u2019;<\/pre>\n<ul>\n<li>Start the database in upgrade mode with the reset logs option<\/li>\n<\/ul>\n<pre>SQL&gt; alter database open resetlogs upgrade;<\/pre>\n<ul>\n<li>Execute catupgrade script using catctl.pl script:<\/li>\n<\/ul>\n<pre>$ORACLE_HOME\/perl\/bin\/perl $ORACLE_HOME\/rdbms\/admin\/catctl.pl \u2013n &lt;parallelism&gt; -l &lt;log location&gt; catupgrd.sql<\/pre>\n<ul>\n<li>Check the database component status:<\/li>\n<\/ul>\n<pre>col comp_id format a10\r\ncol comp_name format a30\r\ncol version format a10\r\ncol status format a8\r\nselect substr(comp_id,1,15) comp_id,substr(comp_name,1,30) comp_name,substr(version,1,10) version,status\r\nfrom dba_registry<\/pre>\n<ul>\n<li>Make an entry in the listener file for database service.<\/li>\n<li>Create tnsnames.ora entry for the newly-created database service.<\/li>\n<li>Restart the listener.<\/li>\n<\/ul>\n<p><strong>Scenario:<\/strong> Upgrading an Oracle 10g database to an Oracle 12c database using the RMAN Duplicate method. The versions of source database and target database :<\/p>\n<ol>\n<li>Source database: DB10g (10.2.0.5.0)<\/li>\n<li>Target database: DB12c (12.1.0.1.0)<\/li>\n<\/ol>\n<h3>The Steps:<\/h3>\n<ol>\n<li>Switch the source database from No Archive Log Mode to Archive Log Mode if it is not already that way:<\/li>\n<\/ol>\n<pre>SYS:DB10g&gt; startup mount\r\nORACLE instance started.\r\nTotal System Global Area 876609536 bytes\r\nFixed Size 2100232 bytes\r\nVariable Size 234882040 bytes\r\nDatabase Buffers 633339904 bytes\r\nRedo Buffers 6287360 bytes\r\nDatabase mounted.<\/pre>\n<ul>\n<li>Check the LOG Mode from v$database view<\/li>\n<\/ul>\n<pre>SYS:DB10g&gt; select log_mode from v$database;\r\nLOG_MODE\r\n----------------\r\nNOARCHIVELOG<\/pre>\n<pre>SYS:DB10g&gt; alter database archivelog;\r\nDatabase altered.<\/pre>\n<ul>\n<li>Check the LOG Mode after converting from v$database view<\/li>\n<\/ul>\n<pre>SYS:DB10g&gt; select log_mode from v$database;\r\nLOG_MODE\r\n------------\r\nARCHIVELOG<\/pre>\n<pre>SYS:DB10g&gt; alter database open;\r\nDatabase altered.<\/pre>\n<ol start=\"2\">\n<li>Execute the pre-upgrade script at the source database server, review the output and make necessary changes for the upgrade.<\/li>\n<\/ol>\n<pre>SYS:DB10g&gt; @preupgrd.sql\r\nLoading Pre-Upgrade Package...\r\nExecuting Pre-Upgrade Checks...\r\nPre-Upgrade Checks Complete.<\/pre>\n<p>Results of the checks are located at:<\/p>\n<pre>\/u01\/app\/oracle\/cfgtoollogs\/DB10g\/preupgrade\/preupgrade.log<\/pre>\n<p>Pre-Upgrade Fixup Script (run in source database environment):<\/p>\n<pre>\/u01\/app\/oracle\/cfgtoollogs\/DB10g\/preupgrade\/preupgrade_fixups.sql<\/pre>\n<p>Post-Upgrade Fixup Script (run shortly after upgrade):<\/p>\n<pre>\/u01\/app\/oracle\/cfgtoollogs\/DB10g\/preupgrade\/postupgrade_fixups.sql<\/pre>\n<pre>************************************************************\r\nFixup scripts must be reviewed prior to being executed.\r\n************************************************************\r\n************************************************************\r\n====&gt;&gt; USER ACTION REQUIRED &lt;&lt;====\r\n************************************************************<\/pre>\n<p>The following are <strong>Error level conditions<\/strong> that must be addressed prior to attempting your upgrade. Failure to do so will result in a failed upgrade:<\/p>\n<ul>\n<li>Check Tag 1: COMPATIBLE_PARAMETER\n<pre>Check Summary: Verify that the compatible parameter value is valid Fixup\r\nSummary:\r\n\"\"compatible\" parameter must be increased manually prior to upgrade.\"\r\n\r\n+++ Source Database Manual Action Required +++<\/pre>\n<\/li>\n<\/ul>\n<p>You <strong>must<\/strong> resolve the above error prior to upgrade.<\/p>\n<p>The Minimum Compatible parameter value for Oracle 12c database is 11.1.0.0.0. This needs to be modified in the parameter file. Check <code>\/u01\/app\/oracle\/cfgtoollogs\/DB10g\/preupgrade\/preupgrade.log<\/code> for recommended changes to the database for performing the upgrade.<\/p>\n<ol start=\"3\">\n<li>Take full backup of the 10g database including archive logs:<\/li>\n<\/ol>\n<pre>oracle@localhost:\/u01\/app\/oracle\/product\/10.2.0\/rdbms\/admin$ rman target \/\r\n\r\nRecovery Manager: Release 10.2.0.5.0 - Production on Fri Jun 12 18:21:21 2015\r\nCopyright (c) 1982, 2007, Oracle. All rights reserved.\r\nconnected to target database: DB10G (DBID=269577939)\r\n\r\nRMAN&gt; backup database plus archivelog tag 'Full database backup';\r\n\r\nStarting backup at 12-JUN-15\r\ncurrent log archived\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: sid=143 devtype=DISK\r\nchannel ORA_DISK_1: starting archive log backupset\r\nchannel ORA_DISK_1: specifying archive log(s) in backup set\r\ninput archive log thread=1 sequence=1 recid=19 stamp=882072342\r\ninput archive log thread=1 sequence=2 recid=20 stamp=882073330\r\ninput archive log thread=1 sequence=4 recid=21 stamp=882210136\r\nchannel ORA_DISK_1: starting piece 1 at 12-JUN-15\r\nchannel ORA_DISK_1: finished piece 1 at 12-JUN-15\r\npiece handle=\/oradata\/DB10g\/DB10G\/backupset\/2015_06_12\/o1_mf_annnn_FULL_DATABASE_BACKUP_bqp8ttl8_.bkp tag=FULL DATABASE BACKUP comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:08\r\nchannel ORA_DISK_1: starting archive log backupset\r\nchannel ORA_DISK_1: specifying archive log(s) in backup set\r\ninput archive log thread=1 sequence=11 recid=2 stamp=881380916\r\ninput archive log thread=1 sequence=12 recid=4 stamp=881380916\r\ninput archive log thread=1 sequence=13 recid=5 stamp=881380916\r\nchannel ORA_DISK_1: starting piece 1 at 12-JUN-15\r\nchannel ORA_DISK_1: finished piece 1 at 12-JUN-15\r\npiece handle=\/oradata\/DB10g\/DB10G\/backupset\/2015_06_12\/o1_mf_annnn_FULL_DATABASE_BACKUP_bqp8v2mr_.bkp tag=FULL DATABASE BACKUP comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02\r\nchannel ORA_DISK_1: starting archive log backupset\r\nchannel ORA_DISK_1: specifying archive log(s) in backup set\r\ninput archive log thread=1 sequence=1 recid=7 stamp=881383026\r\ninput archive log thread=1 sequence=2 recid=8 stamp=881383027\r\ninput archive log thread=1 sequence=3 recid=9 stamp=881383032\r\ninput archive log thread=1 sequence=4 recid=10 stamp=881383032\r\ninput archive log thread=1 sequence=5 recid=11 stamp=881383035\r\ninput archive log thread=1 sequence=6 recid=12 stamp=881383035\r\ninput archive log thread=1 sequence=7 recid=13 stamp=881383038\r\ninput archive log thread=1 sequence=8 recid=17 stamp=881383308\r\ninput archive log thread=1 sequence=9 recid=18 stamp=881383308\r\ninput archive log thread=1 sequence=10 recid=16 stamp=881383307\r\nchannel ORA_DISK_1: starting piece 1 at 12-JUN-15\r\nchannel ORA_DISK_1: finished piece 1 at 12-JUN-15\r\npiece handle=\/oradata\/DB10g\/DB10G\/backupset\/2015_06_12\/o1_mf_annnn_FULL_DATABASE_BACKUP_bqp8v4pz_.bkp tag=FULL DATABASE BACKUP comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02\r\nchannel ORA_DISK_1: starting archive log backupset\r\nchannel ORA_DISK_1: specifying archive log(s) in backup set\r\ninput archive log thread=1 sequence=1 recid=1 stamp=881380916\r\nchannel ORA_DISK_1: starting piece 1 at 12-JUN-15\r\nchannel ORA_DISK_1: finished piece 1 at 12-JUN-15\r\npiece handle=\/oradata\/DB10g\/DB10G\/backupset\/2015_06_12\/o1_mf_annnn_FULL_DATABASE_BACKUP_bqp8v6s3_.bkp tag=FULL DATABASE BACKUP comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02\r\nchannel ORA_DISK_1: starting archive log backupset\r\nchannel ORA_DISK_1: specifying archive log(s) in backup set\r\ninput archive log thread=1 sequence=1 recid=3 stamp=881380916\r\nchannel ORA_DISK_1: starting piece 1 at 12-JUN-15\r\nchannel ORA_DISK_1: finished piece 1 at 12-JUN-15\r\npiece handle=\/oradata\/DB10g\/DB10G\/backupset\/2015_06_12\/o1_mf_annnn_FULL_DATABASE_BACKUP_bqp8v8vq_.bkp tag=FULL DATABASE BACKUP comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02\r\nFinished backup at 12-JUN-15\r\n\r\nStarting backup at 12-JUN-15\r\nusing channel ORA_DISK_1\r\nchannel ORA_DISK_1: starting full datafile backupset\r\nchannel ORA_DISK_1: specifying datafile(s) in backupset\r\ninput datafile fno=00001 name=\/oradata\/DB10g\/system01.dbf\r\ninput datafile fno=00003 name=\/oradata\/DB10g\/sysaux01.dbf\r\ninput datafile fno=00002 name=\/oradata\/DB10g\/undotbs01.dbf\r\ninput datafile fno=00004 name=\/oradata\/DB10g\/users01.dbf\r\nchannel ORA_DISK_1: starting piece 1 at 12-JUN-15\r\nchannel ORA_DISK_1: finished piece 1 at 12-JUN-15\r\npiece handle=\/oradata\/DB10g\/DB10G\/backupset\/2015_06_12\/o1_mf_nnndf_TAG20150612T182233_bqp8vbp6_.bkp tag=TAG20150612T182233 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:45\r\n\r\nchannel ORA_DISK_1: starting full datafile backupset\r\n\r\nchannel ORA_DISK_1: specifying datafile(s) in backupset\r\n\r\nincluding current control file in backupset\r\n\r\nincluding current SPFILE in backupset\r\nchannel ORA_DISK_1: starting piece 1 at 12-JUN-15\r\nchannel ORA_DISK_1: finished piece 1 at 12-JUN-15\r\npiece handle=\/oradata\/DB10g\/DB10G\/backupset\/2015_06_12\/o1_mf_ncsnf_TAG20150612T182233_bqp8wrnd_.bkp tag=TAG20150612T182233 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:04\r\nFinished backup at 12-JUN-15\r\n\r\nStarting backup at 12-JUN-15\r\ncurrent log archived\r\nusing channel ORA_DISK_1\r\nchannel ORA_DISK_1: starting archive log backupset\r\nchannel ORA_DISK_1: specifying archive log(s) in backup set\r\ninput archive log thread=1 sequence=5 recid=22 stamp=882210203\r\nchannel ORA_DISK_1: starting piece 1 at 12-JUN-15\r\nchannel ORA_DISK_1: finished piece 1 at 12-JUN-15\r\npiece handle=\/oradata\/DB10g\/DB10G\/backupset\/2015_06_12\/o1_mf_annnn_FULL_DATABASE_BACKUP_bqp8wwrc_.bkp tag=FULL DATABASE BACKUP comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02\r\nFinished backup at 12-JUN-15<\/pre>\n<ol start=\"4\">\n<li>Created pfile from spfile:<\/li>\n<\/ol>\n<pre>SYS:DB10g&gt; create pfile from spfile;\r\nFile created.<\/pre>\n<ol start=\"5\">\n<li>Move the Oracle 10g database backup and pfile to target database server.<\/li>\n<\/ol>\n<p>Create a password file for database service. The database name can be different from the source database server.<\/p>\n<pre>oracle@localhost:~$ export ORACLE_HOME=\/u01\/app\/oracle\/product\/12.1.0\r\noracle@localhost:~$ export PATH=$ORACLE_HOME\/bin:$PATH\r\noracle@localhost:\/u01\/app\/oracle\/product\/12.1.0\/dbs$ orapwd file=orapwDB12c password=syspwd entries=5\r\noracle@localhost:\/u01\/app\/oracle\/product\/12.1.0\/dbs$ ls -lrt orapwDB12c\r\n-rw-r----- 1 oracle oinstall 5120 Jun 12 18:28 orapwDB12c<\/pre>\n<ol start=\"6\">\n<li>Make the necessary changes to the initialization file at target database server. Change the compatible parameter value if it is recommended by the Pre-upgrade script. For Oracle 12c, the minimum required compatible parameter value is 11.1.0.0.0.<\/li>\n<\/ol>\n<pre>oracle@localhost:\/u01\/app\/oracle\/product\/12.1.0\/dbs$ cat initDB12c.ora\r\n\r\n*.audit_file_dest='\/u01\/app\/oracle\/admin\/DB12c\/adump'\r\n*.diagnostic_dest='\/u01\/app\/oracle\/diag'\r\n*.compatible='12.1.0.1.0'\r\n*.control_files='\/oradata\/DB12c\/control01.ctl','\/oradata\/DB12c\/control02.ctl','\/oradata\/DB12c\/control03.ctl'\r\n*.db_block_size=8192\r\n*.db_domain=''\r\n*.db_file_multiblock_read_count=16\r\n*.db_name='DB12c'\r\n*.db_recovery_file_dest_size=1073741824\r\n*.db_recovery_file_dest='\/oradata\/DB12c'\r\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=DB12cXDB)'\r\n*.job_queue_processes=10\r\n*.open_cursors=300\r\n*.pga_aggregate_target=291504128\r\n*.processes=150\r\n*.remote_login_passwordfile='EXCLUSIVE'\r\n*.sga_target=876609536\r\n*.undo_management='AUTO'\r\n*.undo_tablespace='UNDOTBS1'\r\n*.db_file_name_convert='\/oradata\/DB10g','\/oradata\/DB12c\/data'\r\n*.log_file_name_convert='\/oradata\/DB10g','\/oradata\/DB12c\/log'<\/pre>\n<ol start=\"7\">\n<li>Start the database in NOMOUNT state using pfile.<\/li>\n<\/ol>\n<pre>oracle@localhost:\/u01\/app\/oracle\/product\/12.1.0\/dbs$ sqlplus \"\/ as sysdba\"\r\n\r\nSQL*Plus: Release 12.1.0.1.0 Production on Fri Jun 12 18:38:25 2015\r\nCopyright (c) 1982, 2013, Oracle. All rights reserved.\r\nConnected to an idle instance.<\/pre>\n<pre>SYS:DB12c&gt; startup nomount pfile=initDB12c.ora\r\nORACLE instance started.\r\nTotal System Global Area 872685568 bytes\r\nFixed Size 2293680 bytes\r\nVariable Size 289407056 bytes\r\nDatabase Buffers 574619648 bytes\r\nRedo Buffers 6365184 bytes\r\nSYS:DB12c&gt;<\/pre>\n<ol start=\"8\">\n<li>Specify the backup piece location while executing the Duplicate command, since this location is not cataloged in the database. Execute the duplicate database command with the \u201cNOOPEN\u201d option.<\/li>\n<\/ol>\n<pre>oracle@localhost:\/oradata\/DB12c\/backup$ rman\r\nRecovery Manager: Release 12.1.0.1.0 - Production on Fri Jun 12 18:48:36 2015\r\nCopyright (c) 1982, 2013, Oracle and\/or its affiliates. All rights reserved.\r\nRMAN&gt; connect auxiliary sys\/syspwd\r\nconnected to auxiliary database: DB12C (not mounted)\r\n\r\nRMAN&gt; Duplicate database to 'DB12c' noopen\r\nbackup location '\/oradata\/DB12c\/backup\/\u2019;\r\nStarting Duplicate Db at 12-JUN-15\r\ncontents of Memory Script:\r\n{\r\n.\r\n.\r\n.\r\ncataloged datafile copy\r\ndatafile copy file name=\/oradata\/DB12c\/data\/undotbs01.dbf RECID=1 STAMP=882211842\r\ncataloged datafile copy\r\ndatafile copy file name=\/oradata\/DB12c\/data\/sysaux01.dbf RECID=2 STAMP=882211842\r\ncataloged datafile copy\r\ndatafile copy file name=\/oradata\/DB12c\/data\/users01.dbf RECID=3 STAMP=882211842\r\ndatafile 2 switched to datafile copy\r\ninput datafile copy RECID=1 STAMP=882211842 file name=\/oradata\/DB12c\/data\/undotbs01.dbf\r\ndatafile 3 switched to datafile copy\r\ninput datafile copy RECID=2 STAMP=882211842 file name=\/oradata\/DB12c\/data\/sysaux01.dbf\r\ndatafile 4 switched to datafile copy\r\ninput datafile copy RECID=3 STAMP=882211842 file name=\/oradata\/DB12c\/data\/users01.dbf\r\nLeaving database unopened, as requested\r\nCannot remove created server parameter file\r\nFinished Duplicate Db at 12-JUN-15<\/pre>\n<ol start=\"9\">\n<li>Step-9: Start the database in upgrade mode with reset logs option<\/li>\n<\/ol>\n<pre>SYS:DB12c&gt; alter database open resetlogs upgrade;\r\nDatabase altered.<\/pre>\n<ol style=\"padding-left: 5px;\" start=\"10\">\n<li>Step-10: Execute the catupgrade script using catctl.pl script:<\/li>\n<\/ol>\n<pre>oracle@localhost:\/u01\/app\/oracle\/product\/12.1.0\/rdbms\/admin\r\n$ \/u01\/app\/oracle\/product\/12.1.0\/perl\/bin\/perl catctl.pl -n 4 -l \/u01\/app\/oracle\/log catupgrd.sql\r\nAnalyzing file catupgrd.sql\r\nLog files in \/u01\/app\/oracle\/log\r\nParallelism 4 is used<\/pre>\n<ol style=\"padding-left: 5px;\" start=\"11\">\n<li>The database upgrade will be executed in parallel using the Perl script \u201ccatctl.pl\u201d. This is a new piece of functionality introduced in 12c. The database upgrade will be executed in phases. In case any particular phase fails, we can re-execute the upgrade from that particular phase using the command:<\/li>\n<\/ol>\n<pre>$ORACLE_HOME\/perl\/bin\/perl catctl.pl -n 4 -l $ORACLE_HOME\/diagnostics -p &lt;phase number&gt; catupgrd.sql<\/pre>\n<p>Once the upgrade completes successfully, check the database component status through dba_registry view.<\/p>\n<h2>Summary<\/h2>\n<p>This feature is possible only when Duplicate command performed with backup, it is <em>not<\/em> possible with the Active duplication option. It is an alternative for the RMAN backup restore and recovery method.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction For versions of Oracle 11g R2, Oracle Recovery Manager (RMAN) replicates a database to a different Oracle home and opens it with NORESET LOGS option. From Oracle 12cR1, database RMAN introduced an option called \u2018NO OPEN\u2019, which duplicates your database to a new location and keeps it in an unopened state. Using this feature we can duplicate a databas&hellip;<\/p>\n","protected":false},"author":316218,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143533],"tags":[48347,48403,48487,48492],"coauthors":[],"class_list":["post-73158","post","type-post","status-publish","format-standard","hentry","category-oracle-databases","tag-12c","tag-duplication","tag-recovery-manager","tag-rman"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73158","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\/316218"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=73158"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73158\/revisions"}],"predecessor-version":[{"id":91651,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73158\/revisions\/91651"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=73158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=73158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=73158"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=73158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}