COLD BACKUP - OracleConnections2024-03-29T09:41:08Zhttp://www.oracleconnections.com/forum/topics/cold-backup?commentId=6612035%3AComment%3A15775&x=1&feed=yes&xn_auth=no> 2) copy oradata folder (…tag:www.oracleconnections.com,2013-06-21:6612035:Comment:157752013-06-21T06:45:54.164ZTom Danielhttp://www.oracleconnections.com/profile/TomDaniel
<p>> 2) copy oradata folder (which contains datafile,controlfile and redolog files) and paste it to another location .</p>
<p>Except your Oracle version is 8i or higher. In this case you should use RMAN ...</p>
<p>> 2) copy oradata folder (which contains datafile,controlfile and redolog files) and paste it to another location .</p>
<p>Except your Oracle version is 8i or higher. In this case you should use RMAN ...</p> Way of taking cold backup :
1…tag:www.oracleconnections.com,2013-06-21:6612035:Comment:158582013-06-21T06:44:25.710ZJohnson Groundshttp://www.oracleconnections.com/profile/JohnsonGrounds
<p>Way of taking cold backup :</p>
<p>1) shutdown the database</p>
<p>2) copy oradata folder (which contains datafile,controlfile and redolog files) and paste it to another location .</p>
<p>we need to take datafile,controlfile,redolog files because mainly the main parts of a database are the above thing . so we need to take all these thing as a cold backup .</p>
<p>Also , when ur database make any corruption then u just copy the contents of oradata folder and paste it to the original location…</p>
<p>Way of taking cold backup :</p>
<p>1) shutdown the database</p>
<p>2) copy oradata folder (which contains datafile,controlfile and redolog files) and paste it to another location .</p>
<p>we need to take datafile,controlfile,redolog files because mainly the main parts of a database are the above thing . so we need to take all these thing as a cold backup .</p>
<p>Also , when ur database make any corruption then u just copy the contents of oradata folder and paste it to the original location (example : C:\oracle\product\9.2.0\oradata)</p> Many Many thanks, another one…tag:www.oracleconnections.com,2013-06-21:6612035:Comment:158552013-06-21T06:43:08.288ZJimmie Morontahttp://www.oracleconnections.com/profile/JimmieMoronta
<p>Many Many thanks, another one thing can you tell me how can i take cold backup ??</p>
<p>Many Many thanks, another one thing can you tell me how can i take cold backup ??</p> COLD backup means to take a f…tag:www.oracleconnections.com,2013-06-21:6612035:Comment:159352013-06-21T06:40:57.984ZJohnson Groundshttp://www.oracleconnections.com/profile/JohnsonGrounds
<p>COLD backup means to take a full backup while the database is in shutdown . Mainly during cold backup , we just take the backup of oradata folder (which contains datafile,controlfile,redolog files) to the other place .</p>
<p>The facility of cold backup are :</p>
<p>The cold backup always maintain consistancy . At any inconsistent problem of database or if any of datafile are corrupted at any moment then u can copy/paste all the oradata folder contains and can recover the database . But the…</p>
<p>COLD backup means to take a full backup while the database is in shutdown . Mainly during cold backup , we just take the backup of oradata folder (which contains datafile,controlfile,redolog files) to the other place .</p>
<p>The facility of cold backup are :</p>
<p>The cold backup always maintain consistancy . At any inconsistent problem of database or if any of datafile are corrupted at any moment then u can copy/paste all the oradata folder contains and can recover the database . But the main problem is , the database goes to that previous moment at when u take the cold backup .</p>
<p>(N.B: During cold backup , you should copy paste all the oradata folder's contents .)</p>
<p>Cold backup is more secured rather than other backup , if ur database is not too large enough . If the database size is going too large then u need to take rman or export/import backup .</p>
<p>I think you are clear now ..</p>