Database verplaatsen van windows server naar Linux 64 bits server via RMAN

CONVERT DATABASE NEW DATABASE 'isjgtst' transport script
'e:\trans\script.sql' to platform 'Linux IA (64-bit)'db_file_name_convert 'E:\Oracle\ISJGTST\' 'e:\TRANS\';

als het goed is staan nu de dbf files in de trans directory. nu ook nog extra de .ora file meenemen
actie: kopieer deze file INIT_00PJ7TI0_1_0.ORA naar de trans directory


Kopieer directoriy trans naar de target omgeving

OP DE TARGET SERVER

mkdir -p /u01/app/oracle/admin/isjgtst/adump
mkdir -p /u01/app/oracle/admin/isjgtst/bdump
mkdir -p /u01/app/oracle/admin/isjgtst/cdump
mkdir -p /u01/app/oracle/admin/isjgtst/udump
mkdir -p /u01/app/oracle/oradata/isjgtst/
mkdir -p /u01/app/oracle/flash_recovery_ae

kopieer alle data naar  /u01/app/oracle/oradata/isjgtst/



HOME= /u01/app/oracle/product/11.2.0/11r2standard/dbs

Bestand init.ora D:\APP\ORACLE\DB11\HOME_1\DATABASE\INIT_00PJ7TI0_1_0.ORA bewerken. --> dos2unix

Dit PFILE wordt gebruikt om de database aan te maken op het doelplatform. 

kopieer naar /u01/app/oracle/product/11.2.0/11r2standard/dbs/initISJGTST.ora

# Please change the values of the following parameters:
  control_files            = "/u01/app/oracle/product/11.2.0/11r2standard/dbs/ISJGTST01.ctl"
  audit_file_dest          = "/u01/app/oracle/admin/isjgtst/adump"
  db_name                  = "ISJGTST"

# Please review the values of the following parameters:
# __oracle_base            = "/u01/app/oracle"
  __shared_pool_size       = 822083584
  __large_pool_size        = 16777216
  __java_pool_size         = 16777216
  __streams_pool_size      = 33554432
  __sga_target             = 1409286144
  __db_cache_size          = 503316480
  __shared_io_pool_size    = 0
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=ISJGTSTXDB)"
  __pga_aggregate_target   = 738197504


# The values of the following parameters are from source database:
  processes                = 150
  nls_language             = "DUTCH"
  nls_territory            = "THE NETHERLANDS"
  memory_target            = 2147483648
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  undo_tablespace          = "UNDOTBS1"
  audit_trail              = "OS"
  open_cursors             = 300
# diagnostic_dest          = "D:\APP\ORACLE"







SQL-script E:\TRANS\SCRIPT.SQL uitvoeren op het doelplatform om database aan te maken
Voer utlirp.sql en utlrp.sql uit op het doelplatform om alle PL/SQL-modules opnieuw te compileren.
Gebruik het hulpprogramma DBNEWID om de interne database-ID te wijzigen.\
Voltooien van conversion at source op 23-09-14.

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/11r2standard
xport ORACLE_SID=ISJGTST
sqlplus / as sysdba

STARTUP NOMOUNT PFILE='/u01/app/oracle/product/11.2.0/11r2standard/dbs/initISJGTST.ora'
CREATE CONTROLFILE REUSE SET DATABASE "ISJGTST" RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 2336
LOGFILE
  GROUP 1 '/u01/app/oracle/product/11.2.0/11r2standard/dbs/ARCH_D-ISJGTST_ID-2693527894_S-19864_T-1_A-761157189_03PJ7TI0'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/u01/app/oracle/product/11.2.0/11r2standard/dbs/ARCH_D-ISJGTST_ID-2693527894_S-19862_T-1_A-761157189_04PJ7TI0'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/u01/app/oracle/product/11.2.0/11r2standard/dbs/ARCH_D-ISJGTST_ID-2693527894_S-19863_T-1_A-761157189_05PJ7TI0'  SIZE 50M BLOCKSIZE 512
DATAFILE
  '/u01/app/oracle/oradata/isjgtst/SYSTEM01.DBF',
  '/u01/app/oracle/oradata/isjgtst//SYSAUX01.DBF',
  '/u01/app/oracle/oradata/isjgtst//UNDOTBS01.DBF',
  '/u01/app/oracle/oradata/isjgtst//USERS01.DBF',
  '/u01/app/oracle/oradata/isjgtst//TS_DATA1.DBF',
  '/u01/app/oracle/oradata/isjgtst//TS_DATAINT1.DBF',
  '/u01/app/oracle/oradata/isjgtst//TS_INDEX1.DBF',
  '/u01/app/oracle/oradata/isjgtst//TS_LOBDATA1.DBF',
  '/u01/app/oracle/oradata/isjgtst//USERS02.DBF',
  '/u01/app/oracle/oradata/isjgtst//TS_APEX1.DBF',
  '/u01/app/oracle/oradata/isjgtst//APEX_2195415342875418.DBF'
CHARACTER SET AL32UTF8
;

-- Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS;

-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/isjgtst//DATA_D-ISJGTST_I-2693527894_TS-TEMP_FNO-1_06PJ7TI0'
     SIZE 613416960  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/11.2.0/11r2standard/dbs/initISJGTST.ora'
@@ ?/rdbms/admin/utlirp.sql
SHUTDOWN IMMEDIATE
STARTUP PFILE='/u01/app/oracle/product/11.2.0/11r2standard/dbs/initISJGTST.ora'
-- The following step will recompile all PL/SQL modules.
-- It may take serveral hours to complete.
@@ ?/rdbms/admin/utlrp.sql
set feedback 6;

;