https:\/\/docs.oracle.com\/database\/122\/ADMIN\/managing-tablespaces.htm#ADMIN-GUID-55A6AE10-6875-4B73-9A5C-CB4965AD5AFE<\/a><\/p>\nFor my Active DataGuard environment, I would like to use Temporary Tablespace Groups in combination with Temporary Undo, which is enabled by default as soon as you activate the ADG feature. And of course, I would like to do it online, without shutting down neither the primary nor the ADG standby.<\/p>\n
Is this possible? We will see. I start first with creating a Temporary Tablespace Group called DBITEMP
\nwith 3 bigfile temp tablespaces DBITEMP1\/DBITEMP2\/DBITEMP3.<\/p>\n
-- On Primary\n\nSQL> CREATE BIGFILE TEMPORARY TABLESPACE DBITEMP1 TEMPFILE SIZE 32M AUTOEXTEND ON MAXSIZE 12T TABLESPACE GROUP DBITEMP;\n\nTablespace created.\n\nSQL> CREATE BIGFILE TEMPORARY TABLESPACE DBITEMP2 TEMPFILE SIZE 32M AUTOEXTEND ON MAXSIZE 12T TABLESPACE GROUP DBITEMP;\n\nTablespace created.\n\nSQL> CREATE BIGFILE TEMPORARY TABLESPACE DBITEMP3 TEMPFILE SIZE 32M AUTOEXTEND ON MAXSIZE 12T TABLESPACE GROUP DBITEMP;\n\nTablespace created.\n\nSQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE DBITEMP;\n\nDatabase altered.\n\nSQL> alter system archive log current;\n\nSystem altered.\n\nSQL> select TABLESPACE_NAME, CONTENTS, BIGFILE from dba_tablespaces where CONTENTS = 'TEMPORARY' and TABLESPACE_NAME like '%DBI%';\n\nTABLESPACE_NAME CONTENTS BIG\n------------------------------ --------------------- ---\nDBITEMP1 TEMPORARY YES\nDBITEMP2 TEMPORARY YES\nDBITEMP3 TEMPORARY YES\n\nSQL> select * from DBA_TABLESPACE_GROUPS;\n\nGROUP_NAME TABLESPACE_NAME\n------------------------------ ------------------------------\nDBITEMP DBITEMP1\nDBITEMP DBITEMP2\nDBITEMP DBITEMP3\n\nSQL> select NAME, BYTES from v$tempfile where name like '%dbitemp%';\n\nNAME BYTES\n-------------------------------------------------------------------- -------------\n\/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp1_d52c66g5_.tmp 33554432\n\/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp2_d52c6yqv_.tmp 33554432\n\/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp3_d52c7954_.tmp 33554432\n\nSQL> !ls -l \/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp1_d52c66g5_.tmp\n-rw-r----- 1 oracle oinstall 33562624 Dec 14 12:28 \/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp1_d52c66g5_.tmp\n\nSQL> !ls -l \/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp2_d52c6yqv_.tmp\n-rw-r----- 1 oracle oinstall 33562624 Dec 14 12:29 \/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp2_d52c6yqv_.tmp\n\nSQL> !ls -l \/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp3_d52c7954_.tmp\n-rw-r----- 1 oracle oinstall 33562624 Dec 14 12:28 \/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp3_d52c7954_.tmp\n\nSQL> SELECT PROPERTY_NAME, PROPERTY_VALUE FROM database_properties\n 2 WHERE property_name='DEFAULT_TEMP_TABLESPACE';\n\nPROPERTY_NAME PROPERTY_VALUE\n------------------------ ----------------------\nDEFAULT_TEMP_TABLESPACE DBITEMP\n\n\nDGMGRL> show database 'DBIT122_SITE1';\n\nDatabase - DBIT122_SITE1\n\n Role: PRIMARY\n Intended State: TRANSPORT-ON\n Instance(s):\n DBIT122\n\nDatabase Status:\nSUCCESS\n\nDGMGRL> show database 'DBIT122_SITE2';\n\nDatabase - DBIT122_SITE2\n\n Role: PHYSICAL STANDBY\n Intended State: APPLY-ON\n Transport Lag: 0 seconds (computed 1 second ago)\n Apply Lag: 0 seconds (computed 1 second ago)\n Average Apply Rate: 0 Byte\/s\n Real Time Query: ON\n Instance(s):\n DBIT122\n\nDatabase Status:\nSUCCESS<\/pre>\nOn the primary database, it looks good. Everything was setup correctly, and the Temporary Tablespace Group is ready to be used. Now lets check what we have on the Standby … almost nothing.<\/p>\n
My temporary tablespaces and the group are there, however, the tempfiles are missing. So … not really useful at that stage.<\/p>\n
SQL> select TABLESPACE_NAME, CONTENTS, BIGFILE from dba_tablespaces where CONTENTS = 'TEMPORARY' and TABLESPACE_NAME like '%DBI%';\n\nTABLESPACE_NAME CONTENTS BIG\n------------------------------ --------------------- ---\nDBITEMP1 TEMPORARY YES\nDBITEMP2 TEMPORARY YES\nDBITEMP3 TEMPORARY YES\n\nSQL> select * from DBA_TABLESPACE_GROUPS;\n\nGROUP_NAME TABLESPACE_NAME\n------------------------------ ------------------------------\nDBITEMP DBITEMP1\nDBITEMP DBITEMP2\nDBITEMP DBITEMP3\n\n\nSQL> SELECT PROPERTY_NAME, PROPERTY_VALUE FROM database_properties\n 2 WHERE property_name='DEFAULT_TEMP_TABLESPACE';\n\nPROPERTY_NAME PROPERTY_VALUE\n------------------------ ----------------------\nDEFAULT_TEMP_TABLESPACE DBITEMP\n\nSQL> select NAME, BYTES from v$tempfile where name like '%dbitemp%';\n\nno rows selected<\/pre>\nOk. Lets take a look at the alert.log, if Oracle is telling something. And yes, indeed, a big WARNING message is posted into the alert.log saying that the temporary tablespaces DBITEMP1\/2\/3 are empty.<\/p>\n
*********************************************************************\nWARNING: The following temporary tablespaces contain no files.\n This condition can occur when a backup controlfile has\n been restored. It may be necessary to add files to these\n tablespaces. That can be done using the SQL statement:\n\n ALTER TABLESPACE <tablespace_name> ADD TEMPFILE\n\n Alternatively, if these temporary tablespaces are no longer\n needed, then they can be dropped.\n Empty temporary tablespace: DBITEMP1\n Empty temporary tablespace: DBITEMP2\n Empty temporary tablespace: DBITEMP3\n*********************************************************************<\/pre>\nOk. With 12.2 it is like it always was. You have to do it manually.<\/p>\n
SQL> ALTER TABLESPACE DBITEMP1 ADD TEMPFILE SIZE 32M AUTOEXTEND ON MAXSIZE 12T;\n\nTablespace altered.\n\nSQL> ALTER TABLESPACE DBITEMP2 ADD TEMPFILE SIZE 32M AUTOEXTEND ON MAXSIZE 12T;\n\nTablespace altered.\n\nSQL> ALTER TABLESPACE DBITEMP3 ADD TEMPFILE SIZE 32M AUTOEXTEND ON MAXSIZE 12T;\n\nTablespace altered.<\/pre>\nNow I have everthing in place. What about dropping a temporary tablespace out of the tablespace group First, I take it out of temporary tablespace group. This change is immediately reflected on the Standby.<\/p>\n
-- Primary\n\nSQL> alter tablespace DBITEMP3 TABLESPACE GROUP '';\n\nTablespace altered.\n\nSQL> select * from DBA_TABLESPACE_GROUPS;\n\nGROUP_NAME TABLESPACE_NAME\n------------------------------ ------------------------------\nDBITEMP DBITEMP1\nDBITEMP DBITEMP2\n\n-- Standby \n\nSQL> select * from DBA_TABLESPACE_GROUPS;\n\nGROUP_NAME TABLESPACE_NAME\n------------------------------ ------------------------------\nDBITEMP DBITEMP1\nDBITEMP DBITEMP2<\/pre>\nAnd now you can drop it.<\/p>\n
-- Primary\n\nSQL> drop tablespace DBITEMP3 including contents and datafiles;\n\nTablespace dropped.\n\nalert.log\n...\ndrop tablespace DBITEMP3 including contents and datafiles\n2016-12-14T16:35:25.567597+01:00\nDeleted Oracle managed file \/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp3_d52c7954_.tmp\nCompleted: drop tablespace DBITEMP3 including contents and datafiles\n...\n\n-- Standby\n\nalert.log\n...\nDeleted Oracle managed file \/u02\/oradata\/DBIT122_SITE2\/datafile\/o1_mf_dbitemp3_d52dv3dv_.tmp\nRecovery deleting tempfile #4:'\/u02\/oradata\/DBIT122_SITE2\/datafile\/o1_mf_dbitemp3_d52dv3dv_.tmp'\nRecovery dropped temporary tablespace 'DBITEMP3'\n...<\/pre>\nok. Dropping works fine. This change is also immediately reflected. What about resizing a temporary file? Is this change also immediately reflected on the standby? Due to OMF, we do have different names for the tempfiles, so should we use a “alter database tempfile <NAME> resize” or a “alter database tempfile <NUMBER> resize” to make it work. In regards of regular datafiles, it doesn’t matter, you can use both ways and Oracle does it correctly.<\/p>\n
- Primary\n\nSQL> select file#, name, bytes from v$tempfile where name like '%dbitemp%';\n\n FILE# NAME BYTES\n---------- -------------------------------------------------------------------- ----------\n 2 \/u02\/oradata\/DBIT122_SITE2\/datafile\/o1_mf_dbitemp1_d52dthwg_.tmp 33554432\n 3 \/u02\/oradata\/DBIT122_SITE2\/datafile\/o1_mf_dbitemp2_d52dtx7f_.tmp 33554432\n\n\t\t \nSQL> alter database tempfile '\/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp1_d52c66g5_.tmp' resize 512M;\n\nDatabase altered.\n\nSQL> select file#, name, bytes from v$tempfile where name like '%dbitemp%';\n\n FILE# NAME BYTES\n---------- -------------------------------------------------------------------- ----------\n 2 \/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp1_d52c66g5_.tmp 536870912\n 3 \/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp2_d52c6yqv_.tmp 33554432\n\n\n-- Standby\n\nSQL> select file#, name, bytes from v$tempfile where name like '%dbitemp%';\n\n FILE# NAME BYTES\n---------- -------------------------------------------------------------------- ----------\n 2 \/u02\/oradata\/DBIT122_SITE2\/datafile\/o1_mf_dbitemp1_d52dthwg_.tmp 33554432\n 3 \/u02\/oradata\/DBIT122_SITE2\/datafile\/o1_mf_dbitemp2_d52dtx7f_.tmp 33554432<\/pre>\nOk. Resizing by name is not reflected on the standby. But what about resizing the tempfile by using the file number instead of the name?<\/p>\n
-- Primary\n \nSQL> alter database tempfile 3 resize 768M;\n\nDatabase altered.\n\nSQL> select file#, name, bytes from v$tempfile where name like '%dbitemp%';\n\n FILE# NAME BYTES\n---------- -------------------------------------------------------------------- ----------\n 2 \/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp1_d52c66g5_.tmp 536870912\n 3 \/u02\/oradata\/DBIT122_SITE1\/datafile\/o1_mf_dbitemp2_d52c6yqv_.tmp 805306368\n\n\t\t \n-- Standby\n\nSQL> select file#, name, bytes from v$tempfile where name like '%dbitemp%';\n\n FILE# NAME BYTES\n---------- -------------------------------------------------------------------- ----------\n 2 \/u02\/oradata\/DBIT122_SITE2\/datafile\/o1_mf_dbitemp1_d52dthwg_.tmp 33554432\n 3 \/u02\/oradata\/DBIT122_SITE2\/datafile\/o1_mf_dbitemp2_d52dtx7f_.tmp 33554432<\/pre>\nAs you can see, I doesn’t matter. Resize operations on tempfiles are not replicated to the standby.<\/p>\n
Conclusion<\/h3>\n
Temporary Tablespace Groups can be used with Active DataGuard, and of course, it can be done online. However, when you initially create them, or when you resized them, some manual work has to be done on the standby. And yes, the Temporary Tablespace Groups can be used in combination with the Temporary UNDO feature on the Active DataGuard Standby.<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
By William Sescu Temporary Tablespaces Groups exist for quite a while now (since 10gR2), but they are, for whatever reason not so often used. Personally, I think they are quite cool. Very easy to setup, and especially in big environments with a lot of parallel processing very useful. But this blog will not be about […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[999,988],"type_dbi":[],"class_list":["post-9594","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-dataguard","tag-oracle-12-2"],"acf":[],"yoast_head":"\n
Oracle 12cR2 - Howto setup Active DataGuard with Temporary Tablespace Groups - dbi Blog<\/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:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 12cR2 - Howto setup Active DataGuard with Temporary Tablespace Groups\" \/>\n<meta property=\"og:description\" content=\"By William Sescu Temporary Tablespaces Groups exist for quite a while now (since 10gR2), but they are, for whatever reason not so often used. Personally, I think they are quite cool. Very easy to setup, and especially in big environments with a lot of parallel processing very useful. But this blog will not be about […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-15T11:01:29+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 12cR2 – Howto setup Active DataGuard with Temporary Tablespace Groups\",\"datePublished\":\"2016-12-15T11:01:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\\\/\"},\"wordCount\":496,\"commentCount\":0,\"keywords\":[\"DataGuard\",\"Oracle 12.2\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\\\/\",\"name\":\"Oracle 12cR2 - Howto setup Active DataGuard with Temporary Tablespace Groups - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2016-12-15T11:01:29+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 12cR2 – Howto setup Active DataGuard with Temporary Tablespace Groups\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle 12cR2 - Howto setup Active DataGuard with Temporary Tablespace Groups - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 12cR2 - Howto setup Active DataGuard with Temporary Tablespace Groups","og_description":"By William Sescu Temporary Tablespaces Groups exist for quite a while now (since 10gR2), but they are, for whatever reason not so often used. Personally, I think they are quite cool. Very easy to setup, and especially in big environments with a lot of parallel processing very useful. But this blog will not be about […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/","og_site_name":"dbi Blog","article_published_time":"2016-12-15T11:01:29+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 12cR2 – Howto setup Active DataGuard with Temporary Tablespace Groups","datePublished":"2016-12-15T11:01:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/"},"wordCount":496,"commentCount":0,"keywords":["DataGuard","Oracle 12.2"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/","name":"Oracle 12cR2 - Howto setup Active DataGuard with Temporary Tablespace Groups - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-12-15T11:01:29+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-howto-setup-active-dataguard-with-temporary-tablespace-groups\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 12cR2 – Howto setup Active DataGuard with Temporary Tablespace Groups"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9594"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9594\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9594"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9594"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9594"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}