10400414-002 05/2013
©2013 Overland Storage, Inc.
3-27
SnapSAN S5000 Data Migration User Guide
3.
Stop and delete the database.
For Oracle
a.
Stop the database.
b.
When migrating the application server, copy the directories shown below to the
source logical disk.
* After copied to the destination logical disk during data migration, these directories
are used to restore the database on the new application server.
$ORACLE_HOME/dbs/
$ORACLE_BASE/admin/<SID-name>
$ORACLE_BASE/diag/rdbms/<SID-name>
* This step is not necessary if the application server is not migrated.
c.
When migrating the application server, delete the directories shown below and
delete the database instance.
$ORACLE_HOME/dbs/
$ORACLE_BASE/admin/<SID-name>
$ORACLE_BASE/diag/rdbms/<SID-name>
For Windows
•
Delete services by executing the following command:
> oradim -delete -sid <SID-name>
* This step is not necessary if the application server is not migrated.
For SQL Server (example)
a.
Detach the database
sqlcmd -E -b -Q"EXEC sp_detach_db <database-name>"
4.
Unmount the logical disk.
For Windows
Command example:
# MOUNTVOL <drive-name>: /P
* The logical disks must be unmounted from both nodes in the case of cluster operation.
For UNIX
Command example:
# umount <mountpoint>
In Windows, be sure to execute MOUNTVOL /N so that the logical disk is not automatically
mounted at OS startup in addition to unmounting the logical disk with the MOUNTVOL /P
command.
5.
Delete the database and disk monitor settings in the case of cluster operation.
These steps are the same as those for data migration stopping the server. See
Operations (Application Server).”
During data migration stopping operations, the ongoing operations and data migration may
affect each other's I/O performance. (Compared to data migration stopping the server, the
I/O speed decreases by about 30%.)
