{"id":651,"date":"2024-10-12T10:51:10","date_gmt":"2024-10-12T10:51:10","guid":{"rendered":"https:\/\/humtechno.com\/intro\/?p=651"},"modified":"2024-10-12T12:42:13","modified_gmt":"2024-10-12T12:42:13","slug":"restore-oracle-rman-backup-on-windows","status":"publish","type":"post","link":"https:\/\/humtechno.com\/intro\/2024\/10\/12\/restore-oracle-rman-backup-on-windows\/","title":{"rendered":"Restore Oracle RMAN Backup on Windows"},"content":{"rendered":"\n\n\n\n\n<p><a href=\"https:\/\/humtechno.com\/intro\/wp-content\/uploads\/2024\/10\/Oracle-RMAN-Restore-on-Windows.pdf\">Download PDF with Complete Steps<\/a><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Restore Oracle Database on Windows | Oracle RMAN on Windows\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/uVVWc6MlmbI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><strong>New Database Instance<\/strong> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: test2<\/p>\n\n\n\n<p><strong>Backup Path<\/strong> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : C:\\backups_new<\/p>\n\n\n\n<p><strong>New Database Instance Path<\/strong> &nbsp;&nbsp;&nbsp;&nbsp;    : C:\\Database\\test2<\/p>\n\n\n\n<p><strong>Recovery Destination Path<\/strong> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;    : C:\\Database\\flashrecovery\\test2<\/p>\n\n\n\n<p><strong>Oracle_sid<\/strong> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  : test2<\/p>\n\n\n\n<p><strong>Open Command Prompt<\/strong><\/p>\n\n\n\n<p>set oracle_sid=test2<\/p>\n\n\n\n<p>oradim -NEW -SID test2 -STARTMODE auto -PFILE C:\\app\\Administrator\\product\\11.2.0\\dbhome_1\\database\\inittest2.ora<\/p>\n\n\n\n<p><strong>Verify Backup Location<\/strong><\/p>\n\n\n\n<p><strong>Restore SPFile<\/strong><\/p>\n\n\n\n<p>rman target \/ <\/p>\n\n\n\n<p>startup nomount;<\/p>\n\n\n\n<p>Restore spfile from \u2018C:\\backups_new\\LEVEL0_SPFILE_0D364AFC_1_1_28_09_2024.BKP\u2019;<\/p>\n\n\n\n<p>exit;<\/p>\n\n\n\n<p>Sqlplus \/ as sysdba<\/p>\n\n\n\n<p>Create pfile from spfile;<\/p>\n\n\n\n<p><strong>Change Parameters in Pfiles<\/strong><\/p>\n\n\n\n<p>Default Path of Parameter File : C:\\app\\Administrator\\product\\11.2.0\\dbhome_1\\database<\/p>\n\n\n\n<p><strong>Normally need to change below Parameters<\/strong><\/p>\n\n\n\n<p>*.audit_file_dest=&#8217;C:\\app\\Administrator\\admin\\test2\\adump&#8217;<\/p>\n\n\n\n<p>*.control_files=&#8217;C:\\Database\\test2\\control01.ctl&#8217;,&#8217;c:\\Database\\flashrecovery\\test2\\control02.ctl&#8217;<\/p>\n\n\n\n<p>*.db_unique_name=test2<\/p>\n\n\n\n<p>*.dispatchers='(PROTOCOL=TCP) (SERVICE=test2XDB)&#8217;<\/p>\n\n\n\n<p>*.db_recovery_file_dest=&#8217;\\Database\\flashrecovery&#8217;<\/p>\n\n\n\n<p><strong>Shutdown dummy instance<\/strong><\/p>\n\n\n\n<p>Sqlplus \/ as sysdba<\/p>\n\n\n\n<p>Shutdown immediate;<\/p>\n\n\n\n<p><strong>Create Server Parameter File<\/strong><\/p>\n\n\n\n<p>sqlplus \/ as sysdba<\/p>\n\n\n\n<p>Create spfile from pfile;<\/p>\n\n\n\n<p><strong>Startup Instance with New Server Parameter File<\/strong><\/p>\n\n\n\n<p>sqlplus \/ as sysdba<\/p>\n\n\n\n<p>Startup nomount;<\/p>\n\n\n\n<p><strong>Create Directories<\/strong><\/p>\n\n\n\n<p>mkdir c:\\database\\test2<\/p>\n\n\n\n<p>mkdir C:\\Database\\flashrecovery\\test2<\/p>\n\n\n\n<p><strong>Restore Control file<\/strong><\/p>\n\n\n\n<p>Restore controlfile from \u2018C:\\backups_new\\LEVEL0_DBCTL_0A364AF6_1_1_28_09_2024.BKP\u2019;<\/p>\n\n\n\n<p>Alter database mount;<\/p>\n\n\n\n<p>Crosscheck backup;<\/p>\n\n\n\n<p>Delete expired backup;<\/p>\n\n\n\n<p>catalog start with \u2018C:\\backups_new\u2019;<\/p>\n\n\n\n<p><strong>Restore Database<\/strong><\/p>\n\n\n\n<p>sqlplus \/ as sysdba<\/p>\n\n\n\n<p>select &#8216;SET NEWNAME FOR DATAFILE &#8216; || file# || &#8216; TO &#8216; || &#8221;&#8221; || name || &#8221;&#8221; || &#8216;;&#8217; from v$datafile;<\/p>\n\n\n\n<p>Rman target \/<\/p>\n\n\n\n<p>run{<\/p>\n\n\n\n<p>SET NEWNAME FOR DATAFILE 1 TO &#8216;C:\\DATABASE\\test2\\SYSTEM01.DBF&#8217;;<\/p>\n\n\n\n<p>SET NEWNAME FOR DATAFILE 2 TO &#8216;C:\\DATABASE\\test2\\SYSAUX01.DBF&#8217;;<\/p>\n\n\n\n<p>SET NEWNAME FOR DATAFILE 3 TO &#8216;C:\\DATABASE\\test2\\UNDOTBS01.DBF&#8217;;<\/p>\n\n\n\n<p>SET NEWNAME FOR DATAFILE 4 TO &#8216;C:\\DATABASE\\test2\\USERS01.DBF&#8217;;<\/p>\n\n\n\n<p>restore database;<\/p>\n\n\n\n<p>SWITCH DATAFILE ALL;<\/p>\n\n\n\n<p>Recover database;<\/p>\n\n\n\n<p>}<\/p>\n\n\n\n<p><strong><u>Change Path of Redo Log File<\/u><\/strong><\/p>\n\n\n\n<p><strong>Note<\/strong>: be careful copy paste in windows and remove spaces<\/p>\n\n\n\n<p>Sqlplus \/ as sysdba<\/p>\n\n\n\n<p>select &#8216;Alter database rename file &#8216; || &#8221;&#8221; || member || &#8221;&#8221; || &#8216; to &#8216; || &#8221;&#8221; || member || &#8221;&#8221; || &#8216;;&#8217; from v$logfile;<\/p>\n\n\n\n<p>Alter database rename file &#8216;C:\\DATABASE\\CONVD\\REDO03.LOG&#8217; to &#8216;C:\\DATABASE\\TEST2\\REDO03.LOG&#8217;;<\/p>\n\n\n\n<p>Alter database rename file &#8216;C:\\DATABASE\\CONVD\\REDO02.LOG&#8217; to &#8216;C:\\DATABASE\\TEST2\\REDO02.LOG&#8217;;<\/p>\n\n\n\n<p>Alter database rename file &#8216;C:\\DATABASE\\CONVD\\REDO01.LOG&#8217; to &#8216;C:\\DATABASE\\TEST2\\REDO01.LOG&#8217;;<\/p>\n\n\n\n<p>Select member from v$logfile;<\/p>\n\n\n\n<p><strong><u>Change Path of Temp Files<\/u><\/strong><\/p>\n\n\n\n<p><strong>Note<\/strong>: be careful copy paste in windows and remove spaces<\/p>\n\n\n\n<p>select &#8216;Alter database rename file &#8216; || &#8221;&#8221; || name || &#8221;&#8221; || &#8216; to &#8216; || &#8221;&#8221; || name || &#8221;&#8221; || &#8216;;&#8217; from v$tempfile;<\/p>\n\n\n\n<p>Alter database rename file &#8216;C:\\DATABASE\\CONVD\\TEMP01.DBF&#8217; to \u2018C:\\DATABASE\\TEST2\\TEMP01.DBF&#8217;;<\/p>\n\n\n\n<p>Select name from v$tempfile;<\/p>\n\n\n\n<p><strong>Open Database<\/strong><\/p>\n\n\n\n<p>sqlplus \/ as sysdba<\/p>\n\n\n\n<p>recover database using backup controlfile until cancel;<\/p>\n\n\n\n<p><strong>Note<\/strong>: Enter &#8220;Cancel&#8221; in above input and &#8220;Media Recovery Complete&#8221; should show for Complete Recovery else need to provide more archive files for recovery.<\/p>\n\n\n\n<p>Alter database open resetlogs;<\/p>\n\n\n\n<p>Select open_mode from v$database;<\/p>\n\n\n\n<p>Select instance_name from v$instance;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><span style=\"text-decoration: underline;\">Full Script<\/span><\/strong><\/h2>\n\n\n\n<p>open command prompt<\/p>\n\n\n\n<p>set oracle_sid=test2<\/p>\n\n\n\n<p>oradim -NEW -SID test2 -STARTMODE auto -PFILE C:\\app\\Administrator\\product\\11.2.0\\dbhome_1\\database\\inittest2.ora<\/p>\n\n\n\n<p>rman target \/<\/p>\n\n\n\n<p>Restore spfile from \u2018C:\\backups_new\\LEVEL0_SPFILE_0D364AFC_1_1_28_09_2024.BKP\u2019;<\/p>\n\n\n\n<p>exit<\/p>\n\n\n\n<p>sqlplus \/ as sysdba<\/p>\n\n\n\n<p>Create pfile from spfile;<\/p>\n\n\n\n<p>exit;<\/p>\n\n\n\n<p>Change Pfile Accordingly <\/p>\n\n\n\n<p>sqlplus \/ as sysdba<\/p>\n\n\n\n<p>shutdown immediate<\/p>\n\n\n\n<p>exit<\/p>\n\n\n\n<p>sqlplus \/ as sysdba<\/p>\n\n\n\n<p>Create spfile from pfile;<\/p>\n\n\n\n<p>exit<\/p>\n\n\n\n<p>mkdir c:\\database\\test2<\/p>\n\n\n\n<p>mkdir C:\\Database\\flashrecovery\\test2<\/p>\n\n\n\n<p>rman target \/<\/p>\n\n\n\n<p>Restore controlfile from &#8216;C:\\backups_new\\LEVEL0_DBCTL_0A364AF6_1_1_28_09_2024.BKP\u2019;<\/p>\n\n\n\n<p>Crosscheck backup;<\/p>\n\n\n\n<p>delete expired backup;<\/p>\n\n\n\n<p>catalog start with &#8216;C:\\backups_new\u2019;<\/p>\n\n\n\n<p>exit;<\/p>\n\n\n\n<p>sqlplus \/ as sysdba<\/p>\n\n\n\n<p>select &#8216;SET NEWNAME FOR DATAFILE &#8216; || file# || &#8216; TO &#8216; || &#8221;&#8221; || name || &#8221;&#8221; || &#8216;;&#8217; from v$datafile;<\/p>\n\n\n\n<p>exit<\/p>\n\n\n\n<p>Make script of Restore and Change Like below<\/p>\n\n\n\n<p>rman target \/<\/p>\n\n\n\n<p>run{<\/p>\n\n\n\n<p>SET NEWNAME FOR DATAFILE 1 TO &#8216;C:\\DATABASE\\TEST2\\SYSTEM01.DBF&#8217;;<\/p>\n\n\n\n<p>SET NEWNAME FOR DATAFILE 2 TO &#8216;C:\\DATABASE\\TEST2\\SYSAUX01.DBF&#8217;;<\/p>\n\n\n\n<p>SET NEWNAME FOR DATAFILE 3 TO &#8216;C:\\DATABASE\\TEST2\\UNDOTBS01.DBF&#8217;;<\/p>\n\n\n\n<p>SET NEWNAME FOR DATAFILE 4 TO &#8216;C:\\DATABASE\\TEST2\\USERS01.DBF&#8217;;<\/p>\n\n\n\n<p>restore database;<\/p>\n\n\n\n<p>SWITCH DATAFILE ALL;<\/p>\n\n\n\n<p>Recover database;<\/p>\n\n\n\n<p>}<\/p>\n\n\n\n<p>exit<\/p>\n\n\n\n<p>sqlplus \/ as sysdba<\/p>\n\n\n\n<p>select &#8216;Alter database rename file &#8216; || &#8221;&#8221; || member || &#8221;&#8221; || &#8216; to &#8216; || &#8221;&#8221; || member || &#8221;&#8221; || &#8216;;&#8217; from v$logfile;<\/p>\n\n\n\n<p>Alter database rename file &#8216;C:\\DATABASE\\CONVD\\REDO03.LOG&#8217; to &#8216;C:\\DATABASE\\TEST2\\REDO03.LOG&#8217;;<\/p>\n\n\n\n<p>Alter database rename file &#8216;C:\\DATABASE\\CONVD\\REDO02.LOG&#8217; to &#8216;C:\\DATABASE\\TEST2\\REDO02.LOG&#8217;;<\/p>\n\n\n\n<p>Alter database rename file &#8216;C:\\DATABASE\\CONVD\\REDO01.LOG&#8217; to &#8216;C:\\DATABASE\\TEST2\\REDO01.LOG&#8217;;<\/p>\n\n\n\n<p>Select member from v$logfile;<\/p>\n\n\n\n<p>select &#8216;Alter database rename file &#8216; || &#8221;&#8221; || name || &#8221;&#8221; || &#8216; to &#8216; || &#8221;&#8221; || name || &#8221;&#8221; || &#8216;;&#8217; from v$tempfile;<\/p>\n\n\n\n<p>Alter database rename file &#8216;C:\\DATABASE\\CONVD\\TEMP01.DBF&#8217; to &#8216;C:\\DATABASE\\TEST2\\TEMP01.DBF&#8217;;<\/p>\n\n\n\n<p>Select name from v$tempfile;<\/p>\n\n\n\n<p>recover database using backup controlfile until cancel;<\/p>\n\n\n\n<p>Enter &#8220;Cancel&#8221; &#8221; Media Recovery Cancel&#8221; should show.<\/p>\n\n\n\n<p>Alter database open resetlogs;<\/p>\n\n\n\n<p>Select open_mode from v$database;<\/p>\n\n\n\n<p>Select instance_name from v$instance;<\/p>\n\n\n\n<p><\/p>\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":333,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[3],"tags":[23,103],"class_list":["post-651","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-oracle-database-restore","tag-rman-restore-on-windows"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/comments?post=651"}],"version-history":[{"count":8,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/651\/revisions"}],"predecessor-version":[{"id":660,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/651\/revisions\/660"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media\/333"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media?parent=651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/categories?post=651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/tags?post=651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}