{"id":10538,"date":"2016-03-21T15:20:44","date_gmt":"2016-03-21T19:20:44","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=10538"},"modified":"2016-03-23T11:53:25","modified_gmt":"2016-03-23T15:53:25","slug":"next-five-new-features-in-oracle-database-12c-for-dbas-part-ii","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/","title":{"rendered":"Next Five New Features in Oracle Database 12c for DBAs : Part II"},"content":{"rendered":"<p>This post is series of <strong>Oracle Database 12c new features<\/strong>, check out our previous post on <strong>Five New Features in Oracle Database 12c for DBAs : Part I<\/strong>\u00a0<a href=\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/\" target=\"_blank\">here<\/a><\/p>\n<p>The <strong>Oracle 12C<\/strong> means different things to different people. It all depends on which areas you are looking at, as there are improvements in many areas. Summarized below is the list of Top 5 Features of Oracle 12C . I have summarized below, the top 5 which I found interesting\u00a0in the area of <strong>Database Administration, RMAN, High Availability and Performance Tuning.\u00a0<\/strong><\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Next Five New Features in Oracle DBA 12C:<\/strong><\/span><\/p>\n<p><strong>1.\u00a0Temporary Undo<\/strong><\/p>\n<p>Each Oracle database contains a set of system related tablespaces, such as, SYSTEM, SYSAUX, UNDO &amp; TEMP, and each are used for different purposes within the Oracle database. Pre Oracle 12c R1, undo records generated by the temporary tables used to be stored in undo tablespace, much similar to a general\/persistent table undo records. However, with the temporary undo feature in 12c R1, the temporary undo records can now be stored in a temporary table instead of stored in undo tablespace. The prime benefits of temporary undo includes: reduction in undo tablespace and less redo data generation as the information won\u2019t be logged in redo logs. You have the flexibility to enable the temporary undo option either at session level or database level.<\/p>\n<p><strong>Enabling temporary undo<\/strong><\/p>\n<p>To be able to use the new feature, the following needs to be set:<\/p>\n<ul>\n<li>Compatibility parameter must be set to 12.0.0 or higher<\/li>\n<li>Enable TEMP_UNDO_ENABLED initialization parameter<\/li>\n<li>Since the temporary undo records now stored in a temp tablespace, you need to create the temporary tablespace with sufficient space<\/li>\n<li>For session level, you can use: <strong>ALTER SESSION SET TEMP_UNDO_ENABLE=TRUE;<\/strong><\/li>\n<\/ul>\n<p><strong>Query temporary undo information<\/strong><\/p>\n<p>The dictionary views listed below are used to view\/query the information\/statistics about the temporary undo data:<\/p>\n<ul>\n<li>V$TEMPUNDOSTAT<\/li>\n<li>DBA_HIST_UNDOSTAT<\/li>\n<li>V$UNDOSTAT<\/li>\n<\/ul>\n<p>To disable the feature, you simply need to set the following:<\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<pre>SQL&gt; ALTER SYSTEM|SESSION SET TEMP_UNDO_ENABLED=FALSE;<\/pre>\n<p>[\/code]<\/p>\n<p><strong>2.\u00a0Backup specific user privilege<\/strong><\/p>\n<p>In 11g R2, SYSASM privilege was introduced to perform ASM specific operations. Similarly, backup and recovery tasks specific privilege SYSBACKUP has been introduced in 12c to execute backup and recovery commands in Recovery Manager (RMAN). Therefore, you can create a local user in the database and grant the SYSBACKUP privilege to perform any backup and recovery related tasks in RMAN without being granting the SYSDBA privilege.<\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<pre>$ .\/rman target \"username\/password as SYSBACKUP\"<\/pre>\n<p>[\/code]<\/p>\n<p><strong>3.\u00a0How to execute SQL statement in RMAN<\/strong><\/p>\n<p>In 12c, you can now execute any SQL and PL\/SQL commands in RMAN without the need of a SQL prefix: you can execute any SQL and PLS\/SQL commands directly from RMAN. How you can execute SQL statements in RMAN:<\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<pre>RMAN&gt; SELECT username,machine FROM v$session;\r\n\tRMAN&gt; ALTER TABLESPACE users ADD DATAFILE SIZE 121m;<\/pre>\n<p>[\/code]<\/p>\n<p><strong>4.\u00a0Table or partition recovery in RMAN<\/strong><\/p>\n<p>Oracle database backups are mainly categorized into two types: logical and physical. Each backup type has its own pros and cons. In previous editions, it was not feasible to restore a table or partition using existing physical backups. In order to restore a particular object, you must have logical backup. With 12c R1, you can recover a particular table or partition to a point-in-time or SCN from RMAN backups in the event of a table drop or truncate.<\/p>\n<p>When a table or partition recovery is initiated via RMAN, the following action is performed:<\/p>\n<ul>\n<li>Required backup sets are identified to recover the table\/partition<\/li>\n<li>An auxiliary database will be configured to a point-in-time temporarily in the process of recovering the table\/partition<\/li>\n<li>Required table\/partitions will be then exported to a dumpfile using the data pumps<\/li>\n<li>Optionally, you can import the table\/partitions in the source database<\/li>\n<li>Rename option while recovery<\/li>\n<\/ul>\n<p>An example of a table point-in-time recovery via RMAN (ensure you already have a full database backup from earlier):<\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<pre>RMAN&gt; connect target \"username\/password as SYSBACKUP\";\r\n\tRMAN&gt; RECOVER TABLE username.tablename UNTIL TIME 'TIMESTAMP\u2026'\r\n\t\tAUXILIARY DESTINATION '\/u01\/tablerecovery'\r\n\t\tDATAPUMP DESTINATION '\/u01\/dpump'\r\n\t\tDUMP FILE 'tablename.dmp'\r\n\t\tNOTABLEIMPORT    -- this option avoids importing the table automatically.\r\nREMAP TABLE 'username.tablename': 'username.new_table_name';    -- can rename table with this option.<\/pre>\n<p>[\/code]<\/p>\n<p><strong>Important notes:<\/strong><\/p>\n<ul>\n<li>Ensure sufficient free space available under \/u01 filesystem for auxiliary database and also to keep the data pump file<\/li>\n<li>A full database backup must be exists, or at least the SYSTEM related tablespaces<\/li>\n<\/ul>\n<p>The following limitations\/restrictions are applied on table\/partition recovery in RMAN:<\/p>\n<ul>\n<li>SYS user table\/partition can\u2019t be recovered<\/li>\n<li>Tables\/partitions stored under SYSAUX and SYSTEM tablespaces can\u2019t be recovered<\/li>\n<li>Recovery of a table is not possible when REMAP option used to recovery a table that contains NOT NULL constraints<\/li>\n<\/ul>\n<p><strong>5.\u00a0Restricting PGA size<\/strong><\/p>\n<p>Pre Oracle 12c R1, there was no option to limit and control the PGA size. Although, you set a certain size to<strong>PGA_AGGREGATE_TARGET<\/strong> initialization parameter, Oracle could increase\/reduce the size of the PGA dynamically based on the workload and requirements. In 12c, you can set a hard limit on PGA by enabling the automatic PGA management, which requires <strong>PGA_AGGREGATE_LIMIT<\/strong> parameter settings. Therefore, you can now set the hard limit on PGA by setting the new parameter to avoid excessive PGA usage.<\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<pre>SQL&gt; ALTER SYSTEM SET PGA_AGGREGATE_LIMIT=2G;\r\nSQL&gt; ALTER SYSTEM SET PGA_AGGREGATE_LIMIT=0; --disables the hard limit<\/pre>\n<p>[\/code]<\/p>\n<p><strong>Important notes:<\/strong><\/p>\n<p>When the current PGA limits exceeds, Oracle will automatically terminates\/abort the session\/process that holds the most untenable PGA memory.<\/p>\n<p>In <strong>part III<\/strong>, you will learn more on new changes on <strong>Cluster, ASM, RMAN and database administration<\/strong> areas.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>References:<\/strong><\/span><\/p>\n<ul>\n<li><a href=\"http:\/\/www.orafaq.com\/node\/2822\" target=\"_blank\">http:\/\/www.orafaq.com\/node\/2822<\/a><\/li>\n<\/ul>\n<p>This post is from our <a href=\"http:\/\/www.k21technologies.com\/oracle-dba-12c-training\" target=\"_blank\">Oracle Database 12c Training<\/a>\u00a0where We cover <strong>Architecture, Installation, File System, Backup and Recovery\u00a0<\/strong>and<strong> difference in 12c\u00a0<\/strong>from<strong> previous version <\/strong>with<strong> Hands-On<\/strong>, \u00a0If interested in learning Oracle Database 12c you can Register here for\u00a0<a href=\"http:\/\/www.k21technologies.com\/oracle-dba-12c-training\" target=\"_blank\">Oracle Database 12c Training\u00a0<\/a><\/p>\n<div style=\"padding: 15px; margin-bottom: 15px; background: #ffffde; border: 1px solid #ddd; width: 85%;\" align=\"center\">\n<h2>Oracle DBA 12c Training starting from 26th March<br \/>\nWe are launching this with 50% Discount. Apply code: <span style=\"color: #ff0000;\">DBAOFF<\/span> for 50% Discount<\/h2>\n<p><a href=\"http:\/\/www.k21technologies.com\/oracle-dba-12c-training\" target=\"_blank\">Click Here to Register for DBA 12c Training<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This post is series of Oracle Database 12c new features, check out our previous post on Five New Features in [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":10444,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[424],"tags":[],"class_list":["post-10538","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Next Five New Features in Oracle Database 12c for DBAs : Part II -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Next Five New Features in Oracle Database 12c for DBAs : Part II -\" \/>\n<meta property=\"og:description\" content=\"This post is series of Oracle Database 12c new features, check out our previous post on Five New Features in [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-21T19:20:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-03-23T15:53:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"425\" \/>\n\t<meta property=\"og:image:height\" content=\"171\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/\",\"name\":\"Next Five New Features in Oracle Database 12c for DBAs : Part II -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg\",\"datePublished\":\"2016-03-21T19:20:44+00:00\",\"dateModified\":\"2016-03-23T15:53:25+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/#primaryimage\",\"url\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg\",\"contentUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg\",\"width\":425,\"height\":171},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Next Five New Features in Oracle Database 12c for DBAs : Part II\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Next Five New Features in Oracle Database 12c for DBAs : Part II -","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:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/","og_locale":"en_US","og_type":"article","og_title":"Next Five New Features in Oracle Database 12c for DBAs : Part II -","og_description":"This post is series of Oracle Database 12c new features, check out our previous post on Five New Features in [&hellip;]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/","article_published_time":"2016-03-21T19:20:44+00:00","article_modified_time":"2016-03-23T15:53:25+00:00","og_image":[{"width":425,"height":171,"url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg","type":"image\/jpeg"}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/","url":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/","name":"Next Five New Features in Oracle Database 12c for DBAs : Part II -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/#primaryimage"},"thumbnailUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg","datePublished":"2016-03-21T19:20:44+00:00","dateModified":"2016-03-23T15:53:25+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/#primaryimage","url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg","contentUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg","width":425,"height":171},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/21\/next-five-new-features-in-oracle-database-12c-for-dbas-part-ii\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Next Five New Features in Oracle Database 12c for DBAs : Part II"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/10538","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=10538"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/10538\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media\/10444"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=10538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=10538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=10538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}