{"id":2176,"date":"2011-01-24T11:15:00","date_gmt":"2011-01-24T10:15:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/"},"modified":"2011-01-24T11:15:00","modified_gmt":"2011-01-24T10:15:00","slug":"a-test-database-in-one-click-with-oracle-data-guard-11g","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/","title":{"rendered":"A test database in one click &#8211; with Oracle Data Guard 11g"},"content":{"rendered":"<p>>Perhaps you know this situation: A developper or application owner quickly needs a test database to test new code or to validate changed code before implementing it. Sounds like a lot of work, but if you have Data Guard 11g, you can simply use the command &#8220;CONVERT TO SNAPSHOT STANDBY&#8221;.<\/p>\n<h3>How to activate a test Database with Data Guard 11g\u00a0 (convert to snapshot standby)<\/h3>\n<p>Before you convert the physical standby database, you need to verify your Data Guard configuration is running successfully:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"><samp><\/samp>DGMGRL&gt; show configuration\nConfiguration - DBITEST\n\u00a0\u00a0 Protection Mode: MaxAvailability\n\u00a0\u00a0 Databases:\n\u00a0\u00a0\u00a0 DBITEST_SITE1 - Primary database\n\u00a0\u00a0\u00a0 DBITEST_SITE2 - Physical standby database\nFast-Start Failover: DISABLED\nConfiguration Status:\nSUCCESS<\/pre>\n<p>Flashback database will be used, however, only the parameter db_recovery_file_dest and db_recovery_file_dest_size must be configured on the standby database:<span style=\"font-size: 10pt;\"><br \/>\n<\/span><\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\"><samp><\/samp>SQL&gt; select flashback_on from v$database;\nFLASHBACK_ON\n------------------\nNO\nSQL&gt; show parameter recovery\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\n------------------------------------ ----------- ------------------------------\ndb_recovery_file_dest\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 \/u02\/fast_recovery_area\ndb_recovery_file_dest_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 big integer 8G<\/pre>\n<p>Now, you can convert your physical standby database to a snapshot standby database.<br \/>\nAs soon as this command is completed, you will have a test database available with the current data.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">DGMGRL&gt; convert database 'DBITEST_SITE2' to snapshot standby;\nConverting database \"DBITEST_SITE2\" to a Snapshot Standby database, please wait...\nDatabase \"DBITEST_SITE2\" converted successfully\nDGMGRL&gt; show configuration\nConfiguration - DBITEST\nProtection Mode: MaxAvailability\n Databases:\n DBITEST_SITE1 - Primary database\n DBITEST_SITE2 - Snapshot standby database\nFast-Start Failover: DISABLED\nConfiguration Status:\nSUCCESS<\/pre>\n<p>Once you have changed the role of your physical standby database to snapshot standby database, it will still continue to get the changes from the primary database in order to keep it synchronized (no transport lag). However, in case of a snapshot standby database, these changes are not applied (Apply lag):<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"><samp><\/samp>DGMGRL&gt; show database 'DBITEST_SITE2';\nDatabase - DBITEST_SITE2\n\u00a0 Role:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SNAPSHOT STANDBY\n\u00a0 Intended State:\u00a0 APPLY-OFF\n\u00a0 Transport Lag:\u00a0\u00a0 0 seconds\n\u00a0 Apply Lag:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 minutes 31 seconds\n\u00a0 Instance(s):\n\u00a0\u00a0 DBITEST\nDatabase Status:\nSUCCESS<\/pre>\n<p>If not done yet, flashback database will be automatically activated once you convert a physical standby database to a snapshot standby database. This ensures the flashback to physical standby database once the tests are finished.<br \/>\nBe careful: in this case, flashback database is only activated for this restore point:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\"><samp><\/samp>SQL&gt; select flashback_on from v$database;\nFLASHBACK_ON\n------------------\nRESTORE POINT ONLY<\/pre>\n<h4>Snapshot standby database information<\/h4>\n<p>When you start a Snapshot Standby Database with the convert command, a new incarnation with a new resetlogs_id is created, and the archivelog files sequence# will restart with 1. In parallel, you will always get all changes from the primary database in order to ensure the high availability of your environement.<\/p>\n<p><span style=\"font-size: 10pt;\">\u00a0<\/span><\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; alter system archive log current;\nSQL&gt; alter system archive log current;\nSQL&gt; archive log list;\nDatabase log mode\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Archive Mode\nAutomatic archival\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Enabled\nArchive destination\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 USE_DB_RECOVERY_FILE_DEST\nOldest online log sequence\u00a0\u00a0\u00a0\u00a0 1\nNext log sequence to archive\u00a0\u00a0 3\nCurrent log sequence\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\nSQL&gt; select NAME,SEQUENCE# ,RESETLOGS_ID,applied from v$archived_log\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SEQUENCE# RESETLOGS_ID APPLIED\n--------------------------------------------------- --------- ------------ -------\n<span style=\"color: #0000ff;\">\/..\/archivelog\/2011_01_10\/o1_mf_1_369_6lq2ogcr_.arc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 369\u00a0\u00a0\u00a0 732132864 YES\n\/..\/archivelog\/2011_01_10\/o1_mf_1_370_6lq2ykj7_.arc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 370\u00a0\u00a0\u00a0 732132864 YES\n\/..\/archivelog\/2011_01_11\/o1_mf_1_371_6lr4tq8w_.arc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 371\u00a0\u00a0\u00a0 732132864 NO\n\/..\/archivelog\/2011_01_11\/o1_mf_1_372_6lr4tdr8_.arc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 372\u00a0\u00a0\u00a0 732132864 NO\n\/..\/archivelog\/2011_01_11\/o1_mf_1_373_6lr4txwb_.arc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 373\u00a0\u00a0\u00a0 732132864 NO\n\/..\/archivelog\/2011_01_11\/o1_mf_1_1_6lr60nx6_.arc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0 740136070 NO\n\/..\/archivelog\/2011_01_11\/o1_mf_1_2_6lr60pkx_.arc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0 740136070 NO<\/span><\/pre>\n<p><span style=\"color: #0000ff;\">Blue<\/span>: Archivelog sequence Information for the physical standby database<br \/>\nYou can see that the sequence# 371, 372, 373 are not applied, because the snapshot standby was activated between sequence# 370 and 371<\/p>\n<p><span style=\"color: #ff6600;\">Orange<\/span>: Archive log sequence information from the snapshot standby database. These archivelog files are created by the snapshot standby database, which runs as a primary database and therefore creates its own archivelog files.<\/p>\n<p>With a snapshot standby database, you will be in a special situation where the online redolog and the standby redolog files are used together. Standby redolog files are used for the physical standby database in order to keep it synchronized with the primary database, while the online redolog files are used for the snapshot standby database to log the current transactions activity.<\/p>\n<ul>\n<li>Online redolog file Information for the snapshot standby database<\/li>\n<\/ul>\n<pre class=\"brush: sql; gutter: true; first-line: 1\"><samp><\/samp>SQL&gt; select\u00a0 GROUP#,SEQUENCE#,ARCHIVED,STATUS from v$log;\n\u00a0 GROUP#\u00a0 SEQUENCE# ARC STATUS\n\u00a0 ---------- ---------- --- ---------------- \n\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 YES INACTIVE\n\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 YES INACTIVE\n\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <span style=\"color: #ff6600;\">3 NO\u00a0 CURRENT<\/span><\/pre>\n<ul>\n<li>Standby redolog file information for the Physical Standby Database<\/li>\n<\/ul>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; select GROUP#,DBID,sequence#,ARCHIVED,STATUS from v$standby_log;\n GROUP#\u00a0\u00a0\u00a0\u00a0 DBID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SEQUENCE# ARC STATUS\n---------- --------------- ---------- --- ----------\n 10\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UNASSIGNED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 NO\u00a0 UNASSIGNED\n 11\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UNASSIGNED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 NO\u00a0 UNASSIGNED\n 12\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <span style=\"color: #0000ff;\">449844864\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 374 YES ACTIVE<\/span>\n 13\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UNASSIGNED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 YES UNASSIGNED<\/pre>\n<h4>Snapshot Standby Database Explained Graphicaly<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/snapshot-standby5.jpg\" alt=\"\" \/><\/p>\n<h4><\/h4>\n<h4>Database service for the snapshot standby database<\/h4>\n<p>In order to allow only specific users to connect to this snapshot standby database, a separate database service will be created for the snapshot standby database users:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; execute\u00a0 DBMS_SERVICE.CREATE_SERVICE (- \n service_name\u00a0\u00a0\u00a0\u00a0 =&gt; 'DBITEST_SNAPSHOT.dbi-services.com',-\n network_name\u00a0\u00a0\u00a0\u00a0 =&gt; 'DBITEST_SNAPSHOT.dbi-services.com',-\n failover_method\u00a0 =&gt; 'BASIC',-\n failover_type\u00a0\u00a0\u00a0 =&gt; 'SELECT',-\n failover_retries =&gt; 1800,-\n failover_delay\u00a0\u00a0 =&gt; 1 );<\/pre>\n<p>To activate the new created service DBITEST_SNAPSHOT, a startup trigger will be used. This trigger is activated when the database role is changed to SNAPSHOT STANDBY:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; CREATE OR REPLACE TRIGGER snapshot_standby_trigger\nAFTER STARTUP ON DATABASE\nDECLARE\n database_role\u00a0 VARCHAR(25);\n BEGIN\n\u00a0\u00a0 SELECT database_role INTO database_role FROM v$database;\n\u00a0\u00a0 IF database_role = 'SNAPSHOT STANDBY' \n\u00a0\u00a0 THEN\n\u00a0\u00a0\u00a0\u00a0\u00a0 DBMS_SERVICE.START_SERVICE('DBITEST_SNAPSHOT.dbi-services.com');\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0 END IF;\nEND;\n\/\n\n\nHere is the corresponding OracleNet configuration for accessing to the snapshot standby database:\n\n\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">DBITEST_SNAPSHOT =\n(DESCRIPTION =\n\u00a0\u00a0\u00a0\u00a0\u00a0 (FAILOVER = ON)\n\u00a0\u00a0\u00a0\u00a0\u00a0 (LOAD_BALANCE = OFF)\n\u00a0\u00a0\u00a0\u00a0\u00a0 (ADDRESS_LIST =\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST =\n \n )(PORT = 1521))\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))\n\u00a0\u00a0\u00a0\u00a0\u00a0 )\n\u00a0\u00a0\u00a0\u00a0 (CONNECT_DATA =\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME = DBITEST_SNAPSHOT.dbi-services.com)\n\u00a0\u00a0\u00a0\u00a0 )\n )<\/pre>\n<h4>What happens in a disaster case ?<\/h4>\n<p>In case your primary database is not longer available (crash) and your Data Guard environment must be failovered to a standby database, you can directly trigger a failover to the snapshot standby database. The failover will only take longer, because the database first needs to be converted back to a physical standby database before it can be activated as new primary database.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">DGMGRL&gt; failover to 'DBITEST_SITE2';\nConverting database \"DBITEST_SITE2\" to a Physical Standby database, please wait...\nOperation requires shutdown of instance \"DBITEST\" on database \"DBITEST_SITE2\"\nShutting down instance \"DBITEST\"...\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\nOperation requires startup of instance \"DBITEST\" on database \"DBITEST_SITE2\"\nStarting instance \"DBITEST\"...\nORACLE instance started.\nDatabase mounted.\nContinuing to convert database \"DBITEST_SITE2\" ...\nOperation requires shutdown of instance \"DBITEST\" on database \"DBITEST_SITE2\"\nShutting down instance \"DBITEST\"...\nORA-01109: database not open\nDatabase dismounted.\nORACLE instance shut down.\nOperation requires startup of instance \"DBITEST\" on database \"DBITEST_SITE2\"\nStarting instance \"DBITEST\"...\nORACLE instance started.\nDatabase mounted.\nDatabase \"DBITEST_SITE2\" converted successfully\nPerforming failover NOW, please wait...\nFailover succeeded, new primary is \"DBITEST_SITE2\"\nDGMGRL&gt;<\/pre>\n<h4>Conclusion<\/h4>\n<p>If you need a test database to tests some scripts for a short time span, you can safely use a physical standby database and convert it to a snapshot standby database with Data Guard. You will not compromise the high availability of your database. However, if a disaster happens during your tests, the failover will take a little longer.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Are you confronted with&nbsp; Developper or Application Owner wich want to have very soon a test database available,&nbsp; to test the new developped code or to validate some code change before to&nbsp; implement it ? With Data Guard 11g you can offer this possibility with one click or command line.<\/p>\n","protected":false},"author":8,"featured_media":2177,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[199],"tags":[17,236,237,238],"type_dbi":[],"class_list":["post-2176","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hardware-storage","tag-oracle-11g","tag-oracle-data-guard","tag-snapshot","tag-standby"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>A test database in one click - with Oracle Data Guard 11g - dbi Blog<\/title>\n<meta name=\"description\" content=\"If you need a test database to tests some scripts for a short time span, you can safely use a physical standby database and convert it to a snapshot standby database with Data Guard. You will not compromise the high availability of your database. However, if a disaster happens during your tests, the failover will take a little longer\" \/>\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\/a-test-database-in-one-click-with-oracle-data-guard-11g\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A test database in one click - with Oracle Data Guard 11g\" \/>\n<meta property=\"og:description\" content=\"If you need a test database to tests some scripts for a short time span, you can safely use a physical standby database and convert it to a snapshot standby database with Data Guard. You will not compromise the high availability of your database. However, if a disaster happens during your tests, the failover will take a little longer\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-01-24T10:15:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/snapshot-standby5.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"670\" \/>\n\t<meta property=\"og:image:height\" content=\"363\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Herv\u00e9 Schweitzer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Herv\u00e9 Schweitzer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 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\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/\"},\"author\":{\"name\":\"Herv\u00e9 Schweitzer\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7\"},\"headline\":\"A test database in one click &#8211; with Oracle Data Guard 11g\",\"datePublished\":\"2011-01-24T10:15:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/\"},\"wordCount\":640,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/snapshot-standby5.jpg\",\"keywords\":[\"Oracle 11g\",\"Oracle Data Guard\",\"Snapshot\",\"Standby\"],\"articleSection\":[\"Hardware &amp; Storage\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/\",\"name\":\"A test database in one click - with Oracle Data Guard 11g - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/snapshot-standby5.jpg\",\"datePublished\":\"2011-01-24T10:15:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7\"},\"description\":\"If you need a test database to tests some scripts for a short time span, you can safely use a physical standby database and convert it to a snapshot standby database with Data Guard. You will not compromise the high availability of your database. However, if a disaster happens during your tests, the failover will take a little longer\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/snapshot-standby5.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/snapshot-standby5.jpg\",\"width\":670,\"height\":363},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A test database in one click &#8211; with Oracle Data Guard 11g\"}]},{\"@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\/7fb08fbefcb9b2c146ef4533cfee00c7\",\"name\":\"Herv\u00e9 Schweitzer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g\",\"caption\":\"Herv\u00e9 Schweitzer\"},\"description\":\"Herv\u00e9 Schweitzer has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies such as standardisation, Backup and Recovery, Tuning, and in High Availability solutions such as Oracle Data Guard, Oracle Grid Infrastructure, Oracle Real Application Clusters (RAC), Oracle GoldenGate, and Oracle Failsafe. Herv\u00e9 Schweitzer is \\\"Oracle Certified Master 11g (OCM 11g)\\\". Prior to joining dbi services, Herv\u00e9 Schweitzer was Senior Consultant at Trivadis in Basel. He also worked as an IT Administrator and Oracle DBA at Crossair in Basel. Herv\u00e9 Schweitzer holds a BTS degree in Information Systems from France. His branch-related experience covers Pharma, Transport and Logistics, Banking, Energy, Automotive etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/herve-schweitzer\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"A test database in one click - with Oracle Data Guard 11g - dbi Blog","description":"If you need a test database to tests some scripts for a short time span, you can safely use a physical standby database and convert it to a snapshot standby database with Data Guard. You will not compromise the high availability of your database. However, if a disaster happens during your tests, the failover will take a little longer","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\/a-test-database-in-one-click-with-oracle-data-guard-11g\/","og_locale":"en_US","og_type":"article","og_title":"A test database in one click - with Oracle Data Guard 11g","og_description":"If you need a test database to tests some scripts for a short time span, you can safely use a physical standby database and convert it to a snapshot standby database with Data Guard. You will not compromise the high availability of your database. However, if a disaster happens during your tests, the failover will take a little longer","og_url":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/","og_site_name":"dbi Blog","article_published_time":"2011-01-24T10:15:00+00:00","og_image":[{"width":670,"height":363,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/snapshot-standby5.jpg","type":"image\/jpeg"}],"author":"Herv\u00e9 Schweitzer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Herv\u00e9 Schweitzer","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/"},"author":{"name":"Herv\u00e9 Schweitzer","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7"},"headline":"A test database in one click &#8211; with Oracle Data Guard 11g","datePublished":"2011-01-24T10:15:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/"},"wordCount":640,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/snapshot-standby5.jpg","keywords":["Oracle 11g","Oracle Data Guard","Snapshot","Standby"],"articleSection":["Hardware &amp; Storage"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/","url":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/","name":"A test database in one click - with Oracle Data Guard 11g - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/snapshot-standby5.jpg","datePublished":"2011-01-24T10:15:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7"},"description":"If you need a test database to tests some scripts for a short time span, you can safely use a physical standby database and convert it to a snapshot standby database with Data Guard. You will not compromise the high availability of your database. However, if a disaster happens during your tests, the failover will take a little longer","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/snapshot-standby5.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/snapshot-standby5.jpg","width":670,"height":363},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/a-test-database-in-one-click-with-oracle-data-guard-11g\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"A test database in one click &#8211; with Oracle Data Guard 11g"}]},{"@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\/7fb08fbefcb9b2c146ef4533cfee00c7","name":"Herv\u00e9 Schweitzer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g","caption":"Herv\u00e9 Schweitzer"},"description":"Herv\u00e9 Schweitzer has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies such as standardisation, Backup and Recovery, Tuning, and in High Availability solutions such as Oracle Data Guard, Oracle Grid Infrastructure, Oracle Real Application Clusters (RAC), Oracle GoldenGate, and Oracle Failsafe. Herv\u00e9 Schweitzer is \"Oracle Certified Master 11g (OCM 11g)\". Prior to joining dbi services, Herv\u00e9 Schweitzer was Senior Consultant at Trivadis in Basel. He also worked as an IT Administrator and Oracle DBA at Crossair in Basel. Herv\u00e9 Schweitzer holds a BTS degree in Information Systems from France. His branch-related experience covers Pharma, Transport and Logistics, Banking, Energy, Automotive etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/herve-schweitzer\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2176","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2176"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2176\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2177"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2176"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}