===== Moving Oracle =====

  * ALTER DATABASE BACKUP CONTROLFILE TO '/backupDir/control.dbf';
  * Shutdown Oracle
  * move *.dbf files to new location
  * change path in '/backupDir/control.dbf';
  * [[http://www.praetoriate.com/t_grid_rac_recreating_db.htm]]

  * I would first run 'alter database backup controlfile to "ctlFile.sql" '
  * Then I would edit this file and change all references to c:\jas to d:\newJas
  * Next I would shutdown my Jas database from sqlplus and copy the .dbf files from c:\jas to d:\newJas.
  * From sqlplus, I would execute the sql that in ctlFile.sql which will create the necessary controlFile in d:\newJas
  * Start Jas from sqlplus and it should now be looking at the datafiles in d:\newJas

Scott P. McGraw
Sr Principal  Database Analyst
CACI Federal
937-429-8422 Work
937-416-5873 Cell