RMAN
Move to another OS and upgrade at the same time
User Rating: / 2
- Details
-
Parent Category: Articles
-
Created on Wednesday, 21 December 2011 16:56
-
Last Updated on Monday, 12 March 2012 13:54
-
Published on Wednesday, 21 December 2011 16:56
-
Hits: 4031
Move to another OS and upgrade at the same time.
1. You need to move your database to another OS ( with this example from Linux 64 bit to Windows 32 bit ) 2. You need to upgrade your database ( with this example from 10.2.0.3 to 11.2.0.3 ) 3. your database schema structure is complex, you use advanced features like Oracle Text, Oracle Spatial, Advanced Queueing 4. You tried to export your source database and import it into the target database but you run into issues. ( with AQ tables, invalid domain indexes, ... ) In short you wonder whether you can' t restore a database backup image on the other os and open the database in upgrade mode ?
From 10G R1 onwards
1. you can convert your entire database files to be "compatible" with another OS using RMAN assuming the endian format is identical. 2. You then restore your database on the target platform using RMAN and 3. You open the database with the "alter database open resetlogs upgrade" command 4. You then start with the upgrade as documented in the upgrade guide ( catupgrd.sql + pre & post upgrade steps )
If the endian format is not identical your options are limited to cross platform transportable tablespace technology
Both Linux and Microsoft have the same endian format thus we can convert the database files for cross platform migrations.
SQL> column platform_name format a40 SQL> select * from v$transportable_platform;
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT ---------------- ---------------------------------------- -------------- 1 Solaris[tm] OE (32-bit) Big 2 Solaris[tm] OE (64-bit) Big 7 Microsoft Windows IA (32-bit) Little 10 Linux IA (32-bit) Little 6 AIX-Based Systems (64-bit) Big 3 HP-UX (64-bit) Big 5 HP Tru64 UNIX Little 4 HP-UX IA (64-bit) Big 11 Linux IA (64-bit) Little 15 HP Open VMS Little 8 Microsoft Windows IA (64-bit) Little 9 IBM zSeries Based Linux Big 13 Linux x86 64-bit Little 16 Apple Mac OS Big 12 Microsoft Windows x86 64-bit Little 17 Solaris Operating System (x86) Little 18 IBM Power Based Linux Big 19 HP IA Open VMS Little 20 Solaris Operating System (x86-64) Little 21 Apple Mac OS (x86-64) Little
20 rows selected.
Here is the how to ?
STEP1 : on the source Platform ( this example uses Linux )
SQL> select * from global_name;
GLOBAL_NAME -------------------------------------------------------------------------------- SILVER
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started.
Total System Global Area 1224736768 bytes Fixed Size 2072352 bytes Variable Size 704643296 bytes Database Buffers 503316480 bytes Redo Buffers 14704640 bytes Database mounted. SQL> alter database open read only;
Database altered.
set serveroutput on declare db_ready boolean; begin db_ready := dbms_tdb.check_db('Microsoft Windows IA (32-bit)'); end; /
PL/SQL procedure successfully completed.
declare external boolean; begin external := dbms_tdb.check_external; end; /
The following directories exist in the database: SYS.ABC_DIR, SYS.EXPORT, SYS.DEF_DIR, SYS.WORK_DIR, SYS.ADMIN_DIR, SYS.DATA_PUMP_DIR
PL/SQL procedure successfully completed.
[oracle@myhost SILVER]$ $ORACLE_HOME/bin/rman target /
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Dec 5 10:46:46 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: SILVER (DBID=1566114764)
[oracle@myhost SILVER]$ $ORACLE_HOME/bin/rman target /
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Dec 5 10:46:46 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: SILVER (DBID=1566114764)
RMAN> convert database new database 'SILVER' 2> transport script '/u01/oradata/SILVER/windows_files/transport.sql' 3> to platform 'Microsoft Windows IA (32-bit)' 4> db_file_name_convert '/u01/oradata/SILVER' '/u01/oradata/SILVER/windows_files';
Starting convert at 05-DEC-11 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=153 devtype=DISK
Directory SYS.ABC_DIR found in the database Directory SYS.EXPORT found in the database Directory SYS.DEF_DIR found in the database Directory SYS.WORK_DIR found in the database Directory SYS.ADMIN_DIR found in the database Directory SYS.DATA_PUMP_DIR found in the database
User SYS with SYSDBA and SYSOPER privilege found in password file channel ORA_DISK_1: starting datafile conversion input datafile fno=00010 name=/u01/oradata/SILVER/MYAPP_EWB_LOB_INDX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_LOB_INDX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:05:35 channel ORA_DISK_1: starting datafile conversion input datafile fno=00009 name=/u01/oradata/SILVER/MYAPP_EWB_CDC_SUB_INDX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_CDC_SUB_INDX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:03:05 channel ORA_DISK_1: starting datafile conversion input datafile fno=00002 name=/u01/oradata/SILVER/undotbs01.dbf converted datafile=/u01/oradata/SILVER/windows_files/undotbs01.dbf channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:02:25 channel ORA_DISK_1: starting datafile conversion input datafile fno=00012 name=/u01/oradata/SILVER/MYAPP_EWB_CORE_INDX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_CORE_INDX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:01:45 channel ORA_DISK_1: starting datafile conversion input datafile fno=00005 name=/u01/oradata/SILVER/MYAPP_EWB_CORE_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_CORE_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:01:35 channel ORA_DISK_1: starting datafile conversion input datafile fno=00026 name=/u01/oradata/SILVER/MYAPP_DW_LOB_INDX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_LOB_INDX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:45 channel ORA_DISK_1: starting datafile conversion input datafile fno=00023 name=/u01/oradata/SILVER/MYAPP_IS_LOB_INDX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_IS_LOB_INDX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:35 channel ORA_DISK_1: starting datafile conversion input datafile fno=00029 name=/u01/oradata/SILVER/MYAPP_SA_LOB_INDX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_SA_LOB_INDX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:46 channel ORA_DISK_1: starting datafile conversion input datafile fno=00027 name=/u01/oradata/SILVER/MYAPP_DW_INDX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_INDX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:35 channel ORA_DISK_1: starting datafile conversion input datafile fno=00003 name=/u01/oradata/SILVER/sysaux01.dbf converted datafile=/u01/oradata/SILVER/windows_files/sysaux01.dbf channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting datafile conversion input datafile fno=00008 name=/u01/oradata/SILVER/MYAPP_EWB_INDX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_INDX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting datafile conversion input datafile fno=00001 name=/u01/oradata/SILVER/system01.dbf converted datafile=/u01/oradata/SILVER/windows_files/system01.dbf channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting datafile conversion input datafile fno=00025 name=/u01/oradata/SILVER/MYAPP_EWB_DW_DATA_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_DW_DATA_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting datafile conversion input datafile fno=00035 name=/u01/oradata/SILVER/MYAPP_DW_MAX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_MAX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting datafile conversion input datafile fno=00028 name=/u01/oradata/SILVER/MYAPP_EWB_SA_DATA_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_SA_DATA_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting datafile conversion input datafile fno=00004 name=/u01/oradata/SILVER/users01.dbf converted datafile=/u01/oradata/SILVER/windows_files/users01.dbf channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting datafile conversion input datafile fno=00036 name=/u01/oradata/SILVER/MYAPP_EWB_LOB_DATA_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_LOB_DATA_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting datafile conversion input datafile fno=00015 name=/u01/oradata/SILVER/MYAPP_EWB_CDC_SUB_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_CDC_SUB_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile conversion input datafile fno=00021 name=/u01/oradata/SILVER/MYAPP_EWB_CXTA_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_CXTA_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile conversion input datafile fno=00022 name=/u01/oradata/SILVER/MYAPP_EWB_IS_DATA_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_IS_DATA_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile conversion input datafile fno=00024 name=/u01/oradata/SILVER/MYAPP_IS_INDX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_IS_INDX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting datafile conversion input datafile fno=00006 name=/u01/oradata/SILVER/MYAPP_EWB_DICT_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_DICT_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile conversion input datafile fno=00007 name=/u01/oradata/SILVER/MYAPP_EWB_SEC_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_SEC_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile conversion input datafile fno=00011 name=/u01/oradata/SILVER/MYAPP_EWB_SEC_INDX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_SEC_INDX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile conversion input datafile fno=00013 name=/u01/oradata/SILVER/MYAPP_EWB_DICT_INDX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_DICT_INDX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting datafile conversion input datafile fno=00014 name=/u01/oradata/SILVER/MYAPP_EWB_CDC_PUB_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_CDC_PUB_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile conversion input datafile fno=00016 name=/u01/oradata/SILVER/MYAPP_01_01_2008_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_01_01_2008_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting datafile conversion input datafile fno=00017 name=/u01/oradata/SILVER/MYAPP_01_04_2008_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_01_04_2008_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile conversion input datafile fno=00018 name=/u01/oradata/SILVER/MYAPP_01_07_2008_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_01_07_2008_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting datafile conversion input datafile fno=00019 name=/u01/oradata/SILVER/MYAPP_01_10_2008_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_01_10_2008_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting datafile conversion input datafile fno=00020 name=/u01/oradata/SILVER/MYAPP_MAX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_MAX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting datafile conversion input datafile fno=00030 name=/u01/oradata/SILVER/MYAPP_SA_INDX_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_SA_INDX_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile conversion input datafile fno=00031 name=/u01/oradata/SILVER/MYAPP_DW_01_01_2008_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_01_01_2008_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile conversion input datafile fno=00032 name=/u01/oradata/SILVER/MYAPP_DW_01_04_2008_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_01_04_2008_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile conversion input datafile fno=00033 name=/u01/oradata/SILVER/MYAPP_DW_01_07_2008_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_01_07_2008_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile conversion input datafile fno=00034 name=/u01/oradata/SILVER/MYAPP_DW_01_10_2008_TS.DBS converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_01_10_2008_TS.DBS channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01 Run SQL script /u01/oradata/SILVER/windows_files/transport.sql on the target platform to create database Edit init.ora file /u01/app/oracle/product/10.2.0/db_2/dbs/init_00mtekh4_1_0.ora. This PFILE will be used to create the database on the target platform To recompile all PL/SQL modules, run utlirp.sql and utlrp.sql on the target platform To change the internal database identifier, use DBNEWID Utility Finished backup at 05-DEC-11
Important here is the script /u01/oradata/SILVER/windows_files/transport.sql We will edit this file on the target platfrom to reflect the right directories.
We off course move this script togther with the converted data files towards the target platform
STEP2 : on the target Platform ( this example uses Microsoft )
1. We prepare a parameter file 2. we startup nomount the database instance ( not shown ) 3. We edit the script transport.sql 3.1 we change the os path to reflect the directory structure 3.2 we replace the command "alter database open resetlogs" with "alter database open resetlogs upgrade"
#################################################################################################### -- The following commands will create a new control file and use it -- to open the database. -- Data used by Recovery Manager will be lost. -- The contents of online logs will be lost and all backups will -- be invalidated. Use this only if online logs are damaged.
-- After mounting the created controlfile, the following SQL -- statement will place the database in the appropriate -- protection mode: -- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE
--STARTUP NOMOUNT PFILE='/u01/app/oracle/product/10.2.0/db_2/dbs/init_00mtekh4_1_0.ora' CREATE CONTROLFILE REUSE SET DATABASE "SILVER" RESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 1168 LOGFILE GROUP 1 'D:\oracle\oradata\SILVER\redo01.rdo' SIZE 50M, GROUP 2 'D:\oracle\oradata\SILVER\redo02.rdo' SIZE 50M, GROUP 3 'D:\oracle\oradata\SILVER\redo03.rdo' SIZE 50M DATAFILE 'd:\oracle\oradata\SILVER\system01.dbf', 'd:\oracle\oradata\SILVER\undotbs01.dbf', 'd:\oracle\oradata\SILVER\sysaux01.dbf', 'd:\oracle\oradata\SILVER\users01.dbf', 'd:\oracle\oradata\SILVER\MYAPP_EWB_CORE_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_DICT_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_SEC_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_INDX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_CDC_SUB_INDX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_LOB_INDX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_SEC_INDX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_CORE_INDX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_DICT_INDX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_CDC_PUB_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_CDC_SUB_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_01_01_2008_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_01_04_2008_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_01_07_2008_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_01_10_2008_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_MAX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_CXTA_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_IS_DATA_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_IS_LOB_INDX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_IS_INDX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_DW_DATA_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_DW_LOB_INDX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_DW_INDX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_SA_DATA_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_SA_LOB_INDX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_SA_INDX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_DW_01_01_2008_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_DW_01_04_2008_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_DW_01_07_2008_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_DW_01_10_2008_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_DW_MAX_TS.DBS', 'd:\oracle\oradata\SILVER\MYAPP_EWB_LOB_DATA_TS.DBS' CHARACTER SET AL32UTF8 ;
-- Database can now be opened zeroing the online logs. ALTER DATABASE OPEN RESETLOGS UPGRADE;
-- Commands to add tempfiles to temporary tablespaces. -- Online tempfiles have complete space information. -- Other tempfiles may require adjustment. ALTER TABLESPACE TEMP ADD TEMPFILE 'd:\oracle\oradata\SILVER\temp01.dbf' SIZE 369098752 AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; -- End of tempfile additions. --
set echo off prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ prompt * Your database has been created successfully! prompt * There are many things to think about for the new database. Here prompt * is a checklist to help you stay on track: prompt * 1. You may want to redefine the location of the directory objects. prompt * 2. You may want to change the internal database identifier (DBID) prompt * or the global database name for this database. Use the prompt * NEWDBID Utility (nid). prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--SHUTDOWN IMMEDIATE --STARTUP UPGRADE PFILE='/u01/app/oracle/product/10.2.0/db_2/dbs/init_00mtekh4_1_0.ora' --@@ ?/rdbms/admin/utlirp.sql --SHUTDOWN IMMEDIATE --STARTUP PFILE='/u01/app/oracle/product/10.2.0/db_2/dbs/init_00mtekh4_1_0.ora' -- The following step will recompile all PL/SQL modules. -- It may take serveral hours to complete. --@@ ?/rdbms/admin/utlrp.sql --set feedback 6;
####################################################################################################
4. Once this script adjusted we run it as SYS ( note thet the database instance must be in nomount stage for this ) 4.1 controlfiles will be created 4.2 the database will be opened in upgrade mode 4.3 we can proceed with the upgrade as documented in the upgrade guide ( catupgrd.sql + pre & post upgrade steps )
SQL > start transport.sql
|