dd and RAW devices

[rromero]

Hi, I need to know what's the way to backup and restore a Oracle Data Base that it was created in RAW devices, and I need to do a backup at soon as possible without install another product like ACR Server or something like that.<br>Thank in advance

 

[MikeLacey]

Hi,<br><br>This is quite a difficult question to answer as there are many ways to backup and Oracle database.<br><br>In the long term - could I suggest that you read the Oracle backup documentation carefully.<br><br>In the short term. The simplest way to backup a database is to:<br><br>1 - Make a list of <b>all</b> the files and raw devices associated with your database.<br><br>2 - <b>Find out the name of the the &quot;no-rewind&quot; tape device. This is important.</b><br><br>3 - Shutdown the database.<br><br>4 - Copy (using tar) the normal files to tape. Make sure you are using the &quot;no-rewind&quot; tape device. Make sure you get all the files.<br><br>5 - Copy (using dd, as you suggest) each raw device to tape. Again. Make sure you are using the &quot;no-rewind&quot; tape device. Make sure you get all the raw devices.<br><br>There are a number of better ways to backup an Oracle DB, and the people in the Tek-Tips Oracle forums will be able to help you with the more advanced methods, but I believe that these steps will take a good copy of an Oracle DB.<br> <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[ElgisRamon]

By the way, <b>/dev/rmt0<font color=red>.1</font></b> normally it´s the first no-rewind tapedevice, then you use<br><FONT FACE=monospace><br>tar -cvf /dev/rmt0.1 <b>/some/of/your/files</b><br></font><br>and<br><FONT FACE=monospace><br>dd if=/dev/<font color=red>r</font>LogicalVolumeName of=/dev/rmt0.1<br></font><br>to backup your files and your raw logical volumes.<br><br>I hope it works...