Data File Relocation Steps

  1. /vch27/VCHP/vchdata/wntitel01.dbf and /vch27/VCHP/vchdata/wntitel02.dbf of table space WNTITEL (File No-6 & 13).
  2. /vch27/VCHP/rpdata/riepatables03.dbf of table space RIEPATABLES (File No-21).

Control File Location-

/vch8/VCHP/oradata/control01.ctl, /vch8/VCHP/oradata/control02.ctl, /vch8/VCHP/oradata/control03.ctl

The steps are as follows-

  1. Shut immediate;
  2. Copy the files to /vch32/VCHP/vchdata, /vch32/VCHP/rpdata and rename them if required.
  3. Startup mount
  4. ALTER DATABASE BACKUP CONTROLFILE TO ‘/vch32/VCHP/control.bkp’;
  5. ALTER DATABASE BACKUP CONTROLFILE TO TRACE NORESETLOGS;
  6. cp /vch8/VCHP/oradata/control01.ctl /vch32/VCHP/control01.ctl.
  7. ALTER DATABASE RENAME FILE ‘/vch27/VCHP/vchdata/wntitel01.dbf’ TO ‘/vch32/VCHP/vchdata/wntitel01.dbf‘;
  8. ALTER DATABASE RENAME FILE ‘/vch27/VCHP/vchdata/wntitel02.dbf’ TO ‘/vch32/VCHP/vchdata/wntitel02.dbf’;
  9. ALTER DATABASE RENAME FILE ‘/vch27/VCHP/rpdata/riepatables03.dbf’ TO ‘/vch32/VCHP/rpdata/riepatables03.dbf‘;
  10. Rename the old files.
  11. Alter database open;

Roll Back Steps -

  1. Shut immediate;
  2. Restore the old control files.
  3. Start the database.

Leave a Comment

Your email address will not be published. Required fields are marked *