All That JAS

• 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