Index
The list of files are –
- /vch27/VCHP/vchdata/wntitel01.dbf and /vch27/VCHP/vchdata/wntitel02.dbf of table space WNTITEL (File No-6 & 13).
- /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-
- Shut immediate;
- Copy the files to /vch32/VCHP/vchdata, /vch32/VCHP/rpdata and rename them if required.
- Startup mount
- ALTER DATABASE BACKUP CONTROLFILE TO ‘/vch32/VCHP/control.bkp’;
- ALTER DATABASE BACKUP CONTROLFILE TO TRACE NORESETLOGS;
- cp /vch8/VCHP/oradata/control01.ctl /vch32/VCHP/control01.ctl.
- ALTER DATABASE RENAME FILE ‘/vch27/VCHP/vchdata/wntitel01.dbf’ TO ‘/vch32/VCHP/vchdata/wntitel01.dbf‘;
- ALTER DATABASE RENAME FILE ‘/vch27/VCHP/vchdata/wntitel02.dbf’ TO ‘/vch32/VCHP/vchdata/wntitel02.dbf’;
- ALTER DATABASE RENAME FILE ‘/vch27/VCHP/rpdata/riepatables03.dbf’ TO ‘/vch32/VCHP/rpdata/riepatables03.dbf‘;
- Rename the old files.
- Alter database open;
Roll Back Steps -
- Shut immediate;
- Restore the old control files.
- Start the database.