Explain the way to swap a db device along with other

Question

Explain the way to swap a db device along with other.

Answer 1

Now there are four approaches. Before attempting any of the given: Backup, Backup and Backup.

Dump and Restore

1. Backup the databases upon the device drop the devices, drop the databases.
2. Rebuild the newly devices.
3. Rebuild the databases (ensure you recreate the fragments correctly - for a sp which helps you do this while you have lost your notes. Failure to do it will possibly lead to data upon log segments and log on the data segments).
4. Reload that database dumps!

For only brave experts handle the Data Dictionary-

1. Shut down the server.
2. Do a physical dump (by using dd(1), or that utility) of the device to be moved.
3. Load the dump to newly devices
4. Edit the data dictionary that is sysdevices.physname, to point to the new device.