{"id":200,"date":"2012-03-02T03:41:10","date_gmt":"2012-03-02T03:41:10","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=200"},"modified":"2012-03-02T03:41:48","modified_gmt":"2012-03-02T03:41:48","slug":"hot-backup","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=200","title":{"rendered":"Hot backup"},"content":{"rendered":"<p><code><\/p>\n<pre class=\"qcode\">\r\nsource database:\r\nselect * from dba_tablespaces;\r\n\r\nalter tablespace <tbs_name> begin backup;\r\n...\r\n\r\n--\r\nselect 'alter tablespace '||tablespace_name||' begin backup;' from dba_tablespaces\r\nwhere contents != 'TEMPORARY';\r\n\r\nselect * from v$backup;\r\n\r\nselect 'alter tablespace '||tablespace_name||' end backup;' from dba_tablespaces\r\nwhere contents != 'TEMPORARY';\r\n\r\nselect * from v$backup;\r\n--\r\n\r\nscp (copy datafiles from host1 to host2)\r\n\r\nalter tablespace <tbs_name> end backup;\r\n...\r\n\r\n\r\ntarget database:\r\nstartup mount;\r\n\r\nalter database rename file '<tbs_name>' to '<tbs_name1>';\r\n...\r\n\r\nalter database rename file '<log_file_name>' to '<log_file_name1>';\r\n...\r\n\r\n--\r\nselect * from v$datafile;\r\nselect 'alter database rename file '''||NAME||''' to '''||NAME||''';' from v$datafile;\r\n\r\nselect * from v$logfile;\r\nselect 'alter database rename file '''||MEMBER||''' to '''||MEMBER||''';' from v$logfile;\r\n--\r\n\r\n-- alter database tempfile '<temp_file_name>' drop;\r\nselect 'alter database tempfile '''||NAME||''' drop' from v$tempfile;\r\n--\r\n\r\nrecover database; \r\nor\r\nrecover database using backup controlfile;\r\nor\r\nrecover database until cancel using backup controlfile;\r\n\r\n--shutdown immediate;\r\n\r\n-- if there are no archivelogs\r\nalter database noarchivelog; \r\nalter database open [resetlogs];\r\n<\/pre>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>source database: select * from dba_tablespaces; alter tablespace begin backup; &#8230; &#8212; select &#8216;alter tablespace &#8216;||tablespace_name||&#8217; begin backup;&#8217; from dba_tablespaces where contents != &#8216;TEMPORARY&#8217;; select * from v$backup; select &#8216;alter tablespace &#8216;||tablespace_name||&#8217; end backup;&#8217; from dba_tablespaces where contents != &#8216;TEMPORARY&#8217;; select * from v$backup; &#8212; scp (copy datafiles from host1 to host2) alter tablespace end [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":198,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-200","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-3e","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=200"}],"version-history":[{"count":2,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/200\/revisions"}],"predecessor-version":[{"id":203,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/200\/revisions\/203"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/198"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}