{"id":2523,"date":"2012-09-21T01:44:00","date_gmt":"2012-09-20T23:44:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/"},"modified":"2012-09-21T01:44:00","modified_gmt":"2012-09-20T23:44:00","slug":"qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/","title":{"rendered":"&#8220;ORA-01665: control file is not a standby control file&#8221;: what can I do?"},"content":{"rendered":"<p>You have certainly also received this error once in you Oracle DBA career: &#8220;ORA-01665: control file is not a standby control file&#8221; while trying to create a standby database with RMAN through a full database backup. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called the &#8220;Restore Failover&#8221;.<\/p>\n<p>In order to create a Data Guard configuration, you need a standby database on the standby server.<\/p>\n<p>For this purpose you might use a &#8220;duplicate for standby&#8221; with RMAN. However in some cases, RMAN might complain since the the used backup controlfile is not a &#8220;standby controlfile&#8221;. This can appear even if the &#8220;backup current controlfile for standby&#8221; commandwas included in the the RMAN script.<\/p>\n<p>The reason for this trouble is that after the &#8220;backup current controlfile for standby&#8221; command, another controlfile backup or backup copy has been started.<\/p>\n<p>Let&#8217;s analyze the script:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">run\n{\n\u00a0\u00a0 ALLOCATE_CHANNELS\n\u00a0\u00a0 backup filesperset 10 archivelog all delete input format 'your_backup_path\/your_backup_format';\n\u00a0\u00a0 backup incremental level 0 filesperset 10 database format 'your_backup_path\/your_backup_format';\n\u00a0\u00a0 sql \"alter system archive log current\";\n\u00a0\u00a0 backup filesperset 10 archivelog all delete input format 'your_backup_path\/your_backup_format';\n\u00a0\u00a0 backup current controlfile for standby format 'your_backup_path\/ctl_stdby.ctl';\n\u00a0\u00a0 sql \"create pfile=''your_backup_path\/initSID.ora'' from spfile\";\n\u00a0\u00a0 sql \"alter database backup controlfile to ''your_backup_path\/controlfile.ctl''\";\n\u00a0\u00a0 sql \"alter database backup controlfile to trace as ''your_backup_path\/cre_controlfile.trc''\";\n\u00a0\u00a0 \n}<\/pre>\n<p>As you can see after the &#8220;backup current controlfile for standby&#8221;, we also have a backup controlfile copy:<\/p>\n<p><span style=\"color: #ff0000;\"><strong><span style=\"font-family: courier new,courier;\">sql &#8220;alter database backup controlfile to &#8221;your_backup_path\/controlfile.ctl&#8221;&#8221;;<\/span><\/strong><\/span><\/p>\n<p>As a consequence, during the duplicate for standby, the database mount operation will fail since it will try to access to the controlfile copy which is NOT a standby controlfile ! Since 11.2 RMAN should be able to convert a control file in a standby controlfile during a duplication for standby, but with such a controlfile backup (through sql) it seems to fail:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">RMAN&gt; connect target \/\nRMAN&gt; connect auxiliary sys\/XXXXXXX@ORACLESID_STDBY\nRMAN&gt; duplicate target database for standby dorecover nofilenamecheck;\n\u00a0\n....\n....\nStarting restore at 14-FEB-12\nusing channel ORA_AUX_DISK_1\nchannel ORA_AUX_DISK_1: restoring control file\nchannel ORA_AUX_DISK_1: copied control file copy\ninput file name=\/u00\/app\/oracle\/admin\/ORACLESID\/backup\/controlfile.ctl\noutput file name=\/u00\/oradata\/ORACLESID\/control01ORACLESID.dbf\noutput file name=\/u01\/oradata\/ORACLESID\/control02ORACLESID.dbf\noutput file name=\/u02\/oradata\/ORACLESID\/control03ORACLESID.dbf\nFinished restore at 14-FEB-12\ncontents of Memory Script:\n{\n\u00a0\u00a0 sql clone 'alter database mount standby database';\n}\nexecuting Memory Script\nsql statement: alter database mount standby database\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of Duplicate Db command at 02\/14\/2012 14:37:45\nRMAN-05501: aborting duplication of target database\nRMAN-03015: error occurred in stored script Memory Script\nRMAN-03009: failure of sql command on clone_default channel at 02\/14\/2012 14:37:45\nRMAN-11003: failure during parse\/execution of SQL statement: alter database mount standby database\nORA-01665: control file is not a standby control file\n....\n....<\/pre>\n<p>Since I experienced this issue several times, I decided to invest some minutes to find out another solution than:<\/p>\n<ul>\n<li>\u00a0Duplicate from active (disturbing the production)<\/li>\n<li>\u00a0Perform a new backup without &#8220;sql &#8220;alter database backup controlfile to &#8221;controlfile__&#8221;&#8221;;&#8221;<\/li>\n<\/ul>\n<p>Below is a possible solution. First of all, perform a new backup of the standby control file:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">RMAN&gt; run {\n2&gt; allocate channel disk1 device type disk ;\n3&gt; backup current controlfile for standby format '\/u00\/app\/oracle\/admin\/ORACLESID\/std_ctl_%d_s%s_p%p_last.ctl';\n4&gt; }<\/pre>\n<p>As we can see on the output, in fact two backups are performed, a standby controlfile and a normal controlfile. While connected to the target we RMAN we recognize them:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">RMAN&gt; list backup of controlfile completed after 'sysdate - 1\/24';\nList of Backup Sets\n===================\nBS Key\u00a0 Type LV Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Device Type Elapsed Time Completion Time\u00a0\u00a0\u00a0\u00a0 \n------- ---- -- ---------- ----------- ------------ --------------------\n44289\u00a0\u00a0 Full\u00a0\u00a0\u00a0 49.11M\u00a0\u00a0\u00a0\u00a0 DISK\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:01\u00a0\u00a0\u00a0\u00a0 14-FEB-2012 14:35:30\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BP Key: 44292\u00a0\u00a0 Status: AVAILABLE\u00a0 Compressed: NO\u00a0 Tag: TAG20120214T143529\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <span style=\"color: #ff0000;\">Piece Name: \/u00\/app\/oracle\/admin\/ORACLESID\/std_ctl_ORACLESID_s353_p1_last.ctl<\/span>\n<span style=\"color: #ff0000;\">\u00a0 Standby Control File Included: Ckp SCN: 5369136371\u00a0\u00a0 Ckp time: 14-FEB-2012 14:35:29<\/span>\nBS Key\u00a0 Type LV Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Device Type Elapsed Time Completion Time\u00a0\u00a0\u00a0\u00a0 \n------- ---- -- ---------- ----------- ------------ --------------------\n44298\u00a0\u00a0 Full\u00a0\u00a0\u00a0 49.14M\u00a0\u00a0\u00a0\u00a0 DISK\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00\u00a0\u00a0\u00a0\u00a0 14-FEB-2012 14:35:32\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BP Key: 44300\u00a0\u00a0 Status: AVAILABLE\u00a0 Compressed: NO\u00a0 Tag: TAG20120214T143532\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <span style=\"color: #ff0000;\">Piece Name: \/u00\/app\/oracle\/admin\/ORACLESID\/backup\/c-1290365060-20120214-02<\/span>\n<span style=\"color: #ff0000;\">\u00a0 Control File Included: Ckp SCN: 5369136386\u00a0\u00a0 Ckp time: 14-FEB-2012 14:35:32<\/span><\/pre>\n<p>&nbsp;<\/p>\n<p>We should copy the standby controlfile backup from the primary server to the standby server:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"><span style=\"color: #ff0000;\">scp \/std_ctl_ORACLESID_s353_p1_last.ctl server_standby:$PWD\u00a0<\/span><\/pre>\n<p>&nbsp;<\/p>\n<p>Then, once connected to the primary database and to the catalog with RMAN we try to identify the controlfile copy which is required by the &#8220;duplicate for standby&#8221; procedure (see the logs above). The required control file is stored in the file:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"><span style=\"color: #ff0000;\">\/u00\/app\/oracle\/admin\/ORACLESID\/backup\/controlfile.ctl<\/span><\/pre>\n<p>Let&#8217;s identify this item (controlfile copy) in the RMAN catalog:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">RMAN&gt; <span style=\"color: #ff0000;\">list copy of controlfile completed after 'sysdate - 1\/2';<\/span>\nList of Control File Copies\n===========================\nKey\u00a0\u00a0\u00a0\u00a0 S Completion Time\u00a0\u00a0\u00a0\u00a0\u00a0 Ckp SCN\u00a0\u00a0\u00a0 Ckp Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n------- - -------------------- ---------- --------------------\n14\u00a0\u00a0\u00a0\u00a0\u00a0 A 14-FEB-2012 09:09:05 5368236664 14-FEB-2012 09:09:04\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Name: \/u00\/app\/oracle\/admin\/ORACLESID\/backup\/controlfile.ctl\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Tag: TAG20120214T090905<\/pre>\n<p>We now delete this copy to prevent RMAN to use it:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">RMAN&gt; <span style=\"color: #ff0000;\">delete copy of controlfile TAG 'TAG20120214T090905';<\/span>\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=1145 device type=DISK\nList of Control File Copies\n===========================\nKey\u00a0\u00a0\u00a0\u00a0 S Completion Time\u00a0\u00a0\u00a0\u00a0\u00a0 Ckp SCN\u00a0\u00a0\u00a0 Ckp Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n------- - -------------------- ---------- --------------------\n14\u00a0\u00a0\u00a0\u00a0\u00a0 A 14-FEB-2012 09:09:05 5368236664 14-FEB-2012 09:09:04\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Name: \/u00\/app\/oracle\/admin\/ORACLESID\/backup\/controlfile_ORACLESID_20120214_085409\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Tag: TAG20120214T090905\n\nDo you really want to delete the above objects (enter YES or NO)? YES\ndeleted control file copy\ncontrol file copy file name=\/u00\/app\/oracle\/admin\/ORACLESID\/backup\/controlfile_ORACLESID_20120214_085409 RECID=14 STAMP=775213745\nDeleted 1 objects<\/pre>\n<p>Now, we should restart a duplicate for standby:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">RMAN&gt; duplicate target database for standby dorecover nofilenamecheck;<\/pre>\n<p>RMAN focuses now on the controlfile backup. As explained previously we get two controlfile backups (one &#8220;normal&#8221; and one &#8220;standby&#8221; controlfile). However the &#8220;normal&#8221; control file backup has not been copied to the standby server, therefore RMAN &#8220;fails over&#8221; to the &#8220;standby&#8221; controlfile backup:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">channel ORA_AUX_DISK_1: starting datafile backup set restore\nchannel ORA_AUX_DISK_1: restoring control file\nchannel ORA_AUX_DISK_1: reading from backup piece \/u00\/app\/oracle\/admin\/ORACLESID\/backup\/c-1290365060-20120214-02\nchannel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece \/u00\/app\/oracle\/admin\/ORACLESID\/backup\/c-1290365060-20120214-02\nORA-19505: failed to identify file \"\/u00\/app\/oracle\/admin\/ORACLESID\/backup\/c-1290365060-20120214-02\"\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 3\n<span style=\"color: #ff0000;\">failover to previous backup<\/span>\nchannel ORA_AUX_DISK_1: starting datafile backup set restore\nchannel ORA_AUX_DISK_1: restoring control file\nchannel ORA_AUX_DISK_1: reading from backup piece \/u00\/app\/oracle\/admin\/ORACLESID\/std_ctl_ORACLESID_s353_p1_last.ctl\nchannel ORA_AUX_DISK_1: piece handle=<span style=\"color: #ff0000;\">\/u00\/app\/oracle\/admin\/ORACLESID\/std_ctl_ORACLESID_s353_p1_last.ctl<\/span> tag=TAG20120214T143529\nchannel ORA_AUX_DISK_1: restored backup piece 1\nchannel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01\noutput file name=\/u00\/oradata\/ORACLESID\/control01ORACLESID.dbf\noutput file name=\/u01\/oradata\/ORACLESID\/control02ORACLESID.dbf\noutput file name=\/u02\/oradata\/ORACLESID\/control03ORACLESID.dbf\nFinished restore at 14-FEB-2012 14:45:31\n.......<\/pre>\n<p>The message about missing archives at the end of the duplicate can be ignored as usual, since the Data Guard configuration will solve the problem:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">RMAN-06025: no backup of archived log for thread 1 with sequence 1683 and starting SCN of 5369129120 found to restore\nRMAN-06025: no backup of archived log for thread 1 with sequence 1682 and starting SCN of 5369088625 found to restore\nRMAN-06025: no backup of archived log for thread 1 with sequence 1681 and starting SCN of 5369047176 found to restore\nRMAN-06025: no backup of archived log for thread 1 with sequence 1680 and starting SCN of 5369025699 found to restore\n....<\/pre>\n<p>As you can see , Oracle failed over from the backup set (BS Key) &#8220;44298&#8221; to the &#8220;44289&#8221; since only the file \/u00\/app\/oracle\/admin\/ORACLESID\/std_ctl_ORACLESID_s353_p1_last.ctl (standby control file) has been copied to the standby server.<\/p>\n<p>Finally we can also conclude that a simple remove of the file &#8220;your_backup_path\/controlfile.ctl&#8221; from the first backup would have had the same result since the &#8220;previous&#8221; control file backup was a standby controlfile. This post finally show how to delete some backup sets :-).<\/p>\n<p>As a conclusion, deleting entires in the catalog and\/or providing the wished backup sets to the standby side allowed us to influe on RMAN to take the right decisions.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You have certainly also received this error once in you Oracle DBA career: &#8220;ORA-01665: control file is not a standby control file&#8221; while trying to create a standby database with RMAN through a full database backup. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[310,221,311,17,270,238],"type_dbi":[],"class_list":["post-2523","post","type-post","status-publish","format-standard","hentry","category-database-management","tag-controlfile","tag-data-guard","tag-duplicate","tag-oracle-11g","tag-rman","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>&quot;ORA-01665: control file is not a standby control file&quot;: what can I do? - dbi Blog<\/title>\n<meta name=\"description\" content=\"&quot;ORA-01665: control file is not a standby control file&quot; while trying to create a standby database with RMAN through a full database backup. You have certainly also received this error once in you Oracle DBA career. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called the &quot;Restore Failover&quot;.\" \/>\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\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"&quot;ORA-01665: control file is not a standby control file&quot;: what can I do?\" \/>\n<meta property=\"og:description\" content=\"&quot;ORA-01665: control file is not a standby control file&quot; while trying to create a standby database with RMAN through a full database backup. You have certainly also received this error once in you Oracle DBA career. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called the &quot;Restore Failover&quot;.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-09-20T23:44:00+00:00\" \/>\n<meta name=\"author\" content=\"Yann Neuhaus\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yann Neuhaus\" \/>\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\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/\"},\"author\":{\"name\":\"Yann Neuhaus\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681\"},\"headline\":\"&#8220;ORA-01665: control file is not a standby control file&#8221;: what can I do?\",\"datePublished\":\"2012-09-20T23:44:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/\"},\"wordCount\":616,\"commentCount\":0,\"keywords\":[\"Controlfile\",\"Data Guard\",\"duplicate\",\"Oracle 11g\",\"RMAN\",\"Standby\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/\",\"name\":\"\\\"ORA-01665: control file is not a standby control file\\\": what can I do? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2012-09-20T23:44:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681\"},\"description\":\"\\\"ORA-01665: control file is not a standby control file\\\" while trying to create a standby database with RMAN through a full database backup. You have certainly also received this error once in you Oracle DBA career. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called the \\\"Restore Failover\\\".\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"&#8220;ORA-01665: control file is not a standby control file&#8221;: what can I do?\"}]},{\"@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\/5bfc203607127a4915b7950c4a108681\",\"name\":\"Yann Neuhaus\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g\",\"caption\":\"Yann Neuhaus\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/yann-neuhaus\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\"ORA-01665: control file is not a standby control file\": what can I do? - dbi Blog","description":"\"ORA-01665: control file is not a standby control file\" while trying to create a standby database with RMAN through a full database backup. You have certainly also received this error once in you Oracle DBA career. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called the \"Restore Failover\".","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\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/","og_locale":"en_US","og_type":"article","og_title":"\"ORA-01665: control file is not a standby control file\": what can I do?","og_description":"\"ORA-01665: control file is not a standby control file\" while trying to create a standby database with RMAN through a full database backup. You have certainly also received this error once in you Oracle DBA career. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called the \"Restore Failover\".","og_url":"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/","og_site_name":"dbi Blog","article_published_time":"2012-09-20T23:44:00+00:00","author":"Yann Neuhaus","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yann Neuhaus","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/"},"author":{"name":"Yann Neuhaus","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681"},"headline":"&#8220;ORA-01665: control file is not a standby control file&#8221;: what can I do?","datePublished":"2012-09-20T23:44:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/"},"wordCount":616,"commentCount":0,"keywords":["Controlfile","Data Guard","duplicate","Oracle 11g","RMAN","Standby"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/","url":"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/","name":"\"ORA-01665: control file is not a standby control file\": what can I do? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2012-09-20T23:44:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681"},"description":"\"ORA-01665: control file is not a standby control file\" while trying to create a standby database with RMAN through a full database backup. You have certainly also received this error once in you Oracle DBA career. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called the \"Restore Failover\".","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/qora-01665-control-file-is-not-a-standby-control-fileq-what-can-i-do\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"&#8220;ORA-01665: control file is not a standby control file&#8221;: what can I do?"}]},{"@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\/5bfc203607127a4915b7950c4a108681","name":"Yann Neuhaus","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g","caption":"Yann Neuhaus"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/yann-neuhaus\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2523","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2523"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2523\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2523"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}