title: Backup/Restore database for oracle 10g testing using sqlplus or rman
body: <p>Using Oracle 10g with our testing server what is the most efficient/easy way to backup and restore a database to a static point, assuming that you always want to go back to the given point once a backup has been created.</p>
  
  <p>A sample use case would be the following</p>
  
  <ol>
  <li>install and configure all software</li>
  <li>Modify data to the base testing point</li>
  <li>take a backup somehow (this is part of the question, how to do this)</li>
  <li>do testing</li>
  <li>return to step 3 state (restore back to backup point, this is the other half of the question)</li>
  </ol>
  
  <p><strong>Optimally this would be completed through sqlplus or rman or some other scriptable method.</strong></p>