MIG360 is a tool to advise Database migrations.
-
Unzip mig360.zip, navigate to the root mig360 directory, and connect as SYS, DBA, or any User with Data Dictionary access:
$ unzip mig360.zip $ cd mig360 $ sqlplus / as sysdba
-
Execute mig360.sql.
SQL> @mig360.sql
Usage:
@mig360
@mig360 T N
@mig360 T N 1-4
@mig360 T Y 8
1st parameter: (T)uning pack, (D)iagnostic pack, (N)one 2nd parameter: Y/N - run or not run eSCP 3rd parameter: sections (optional) - default all sections 4th parameter: Type of migration (To be implemented)
-
Unzip output MIG360___YYYYMMDD_HH24MI.zip into a directory on your PC
-
Review main html file 00001_mig360__index.html
-
As mig360 can run for a long time, in some systems it's recommend to execute it unattended:
$ nohup sqlplus / as sysdba @mig360.sql T Y &
-
If you need to execute MIG360 against all databases in the host, use mig360.sh:
$ unzip mig360.zip $ cd mig360 $ sh mig360.sh T Y
-
If you need to execute only a portion of MIG360 (i.e. a column, section or range) use these commands. Notice first parameter can be set to one section (i.e. 3b), one column (i.e. 3), a range of sections (i.e. 5c-6b) or range of columns (i.e. 5-7):
SQL> @mig360.sql T N 8
note: valid column range for first parameter is 1 to 9.
- v01 (2019-04-10) by Alex Zaballa