Zdrojová databázeSID: migdbVerze: 11.1.0.6OS: Windows 2003 32bCílová databázeSID: migdbVerze: 11.1.0.6OS: OEL 5.6 (Oracle Enterprise Linux 5.6)Předpoklad- záloha provedená RMAN, když byla databáze v read/write módu.
Zdrojový server
Kontrola Endianu
– zda-li je možné migraci provést pomocí RMANa a příkazu CONVERT- zdrojový a cílový operační systém musí být na stejném ENDIANUSQL> select PLATFORM_NAME, ENDIAN_FORMAT from V$TRANSPORTABLE_PLATFORM;PLATFORM_NAME ENDIAN_FOR———————————– ———-Solaris[tm] OE (32-bit) BigSolaris[tm] OE (64-bit) BigMicrosoft Windows IA (32-bit) LittleLinux IA (32-bit) LittleAIX-Based Systems (64-bit) BigHP-UX (64-bit) BigHP Tru64 UNIX LittleHP-UX IA (64-bit) BigLinux IA (64-bit) LittleHP Open VMS LittleMicrosoft Windows IA (64-bit) LittleIBM zSeries Based Linux BigLinux 64-bit for AMD LittleApple Mac OS BigMicrosoft Windows 64-bit for AMD LittleSolaris Operating System (x86) LittleIBM Power Based Linux Big
Zdroj:
SQL> select platform_id, platform_name from v$database;PLATFORM_ID PLATFORM_NAME——————————————— 7 Microsoft Windows IA (32-bit)Cíl:SQL> select platform_id, platform_name from v$database;PLATFORM_ID PLATFORM_NAME——————————————— 10 Linux IA (32-bit)
Kontrola databáze pro transport:
–
!!! Databáze musí být přepnutá do READ ONLY móduC:\oracle\product\11.1.0\db_1\BIN>sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 – Production on Fri Jun 24 12:10:13 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup mount;ORACLE instance started.Total System Global Area 535662592 bytesFixed Size 1334380 bytesVariable Size 192938900 bytesDatabase Buffers 335544320 bytesRedo Buffers 5844992 bytesDatabase mounted.SQL> alter database open read only;Database altered. SQL> set serveroutput onSQL> declare 2 db_ready boolean; 3 begin 4 db_ready := dbms_tdb.check_db(‘Linux IA (32-bit)’); 5 end; 6 /PL/SQL procedure successfully completed.SQL> set serveroutput onSQL> declare 2 external boolean; 3 begin 4 external := dbms_tdb.check_external; 5 end; 6 /The following external tables exist in the database:SH.SALES_TRANSACTIONS_EXTThe following directories exist in the database:SYS.ORACLE_OCM_CONFIG_DIR, SYS.DATA_PUMP_DIR, SYS.AUDIT_DIR, SYS.DATA_FILE_DIR,SYS.LOG_FILE_DIR, SYS.MEDIA_DIR, SYS.XMLDIR, SYS.SUBDIRThe following BFILEs exist in the database:PM.PRINT_MEDIAPL/SQL procedure successfully completed.- Toto jsou jen informativní zprávy
Provedení konverze s RMANa:
C:\oracle\product\11.1.0\db_1\BIN>rman target /Recovery Manager: Release 11.1.0.6.0 – Production on Fri Jun 24 12:20:44 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: MIGDB (DBID=959485668)RMAN> CONVERT DATABASE ON TARGET PLATFORM2> CONVERT SCRIPT ‘C:\convert\convertscript.rman’3> TRANSPORT SCRIPT ‘C:\convert\transportscript.sql’4> new database ‘migdb’5> FORMAT ‘C:\convert\%U’;Starting conversion at source at 24-JUN-11using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=144 device type=DISKExternal table SH.SALES_TRANSACTIONS_EXT found in the databaseDirectory SYS.ORACLE_OCM_CONFIG_DIR found in the databaseDirectory SYS.DATA_PUMP_DIR found in the databaseDirectory SYS.AUDIT_DIR found in the databaseDirectory SYS.DATA_FILE_DIR found in the databaseDirectory SYS.LOG_FILE_DIR found in the databaseDirectory SYS.MEDIA_DIR found in the databaseDirectory SYS.XMLDIR found in the databaseDirectory SYS.SUBDIR found in the databaseBFILE PM.PRINT_MEDIA found in the databaseUser SYS with SYSDBA and SYSOPER privilege found in password filechannel ORA_DISK_1: starting to check datafilesinput datafile file number=00001 name=C:\ORACLE\ORADATA\MIGDB\SYSTEM01.DBFchannel ORA_DISK_1: datafile checking complete, elapsed time: 00:00:00channel ORA_DISK_1: starting to check datafilesinput datafile file number=00002 name=C:\ORACLE\ORADATA\MIGDB\SYSAUX01.DBFchannel ORA_DISK_1: datafile checking complete, elapsed time: 00:00:00channel ORA_DISK_1: starting to check datafilesinput datafile file number=00005 name=C:\ORACLE\ORADATA\MIGDB\EXAMPLE01.DBFchannel ORA_DISK_1: datafile checking complete, elapsed time: 00:00:00channel ORA_DISK_1: starting to check datafilesinput datafile file number=00003 name=C:\ORACLE\ORADATA\MIGDB\UNDOTBS01.DBFchannel ORA_DISK_1: datafile checking complete, elapsed time: 00:00:00channel ORA_DISK_1: starting to check datafilesinput datafile file number=00004 name=C:\ORACLE\ORADATA\MIGDB\USERS01.DBFchannel ORA_DISK_1: datafile checking complete, elapsed time: 00:00:00Edit init.ora file C:\CONVERT\INIT_00MFMELF_1_0.ORA. This PFILE will be used tocreate the database on the target platformRun RMAN script C:\CONVERT\CONVERTSCRIPT.RMAN on target platform to convert datafilesRun SQL script C:\CONVERT\TRANSPORTSCRIPT.SQL on the target platform to create databaseTo recompile all PL/SQL modules, run utlirp.sql and utlrp.sql on the target platformTo change the internal database identifier, use DBNEWID UtilityFinished conversion at source at 24-JUN-11
Záloha init souboru:
SQL> create pfile=’c:\convert\pfile.ora’ from spfile;File created.
Teď již na cílovém serveru.
– přenesl jsem obsah celého adresáře convert na linuxový server[oracle@publicdbsrv02 convert]$ pwd/opt/convert[oracle@publicdbsrv02 convert]$ ls -ltrtotal 1128928-rw-r–r– 1 oracle oinstall 38185472 Jun 24 12:18 O1_MF_ANNNN_TAG20110624T131836_708WNDFX_.BKP-rw-r–r– 1 oracle oinstall 1116774400 Jun 24 12:19 O1_MF_NNNDF_TAG20110624T131839_708WNHY1_.BKP-rw-r–r– 1 oracle oinstall 9830400 Jun 24 12:19 O1_MF_NCSNF_TAG20110624T131839_708WPW72_.BKP-rw-r–r– 1 oracle oinstall 132096 Jun 24 12:19 O1_MF_ANNNN_TAG20110624T131957_708WPXPP_.BKP-rw-r–r– 1 oracle oinstall 2748 Jun 24 11:21 TRANSPORTSCRIPT.SQL-rw-r–r– 1 oracle oinstall 1294 Jun 24 11:21 INIT_00MFMELF_1_0.ORA-rw-r–r– 1 oracle oinstall 738 Jun 24 11:21 CONVERTSCRIPT.RMAN-rw-r–r– 1 oracle oinstall 945 Jun 24 11:28 pfile.ora
Změna parametrů v init souboru
Původní:migdb.__db_cache_size=335544320migdb.__java_pool_size=12582912migdb.__large_pool_size=4194304migdb.__oracle_base=’C:\oracle’#ORACLE_BASE set from environmentmigdb.__pga_aggregate_target=343932928migdb.__sga_target=515899392migdb.__shared_io_pool_size=0migdb.__shared_pool_size=159383552migdb.__streams_pool_size=0*.audit_file_dest=’C:\oracle\admin\migdb\adump’*.audit_trail=’db’*.compatible=’11.1.0.0.0’*.control_files=’C:\oracle\oradata\migdb\control01.ctl’,’C:\oracle\oradata\migdb\control02.ctl’,’C:\oracle\oradata\migdb\control03.ctl’*.db_block_size=8192*.db_domain=”*.db_name=’migdb’*.db_recovery_file_dest=’C:\oracle\flash_recovery_area’*.db_recovery_file_dest_size=2147483648*.diagnostic_dest=’C:\oracle’*.dispatchers='(PROTOCOL=TCP) (SERVICE=migdbXDB)’*.local_listener=’LISTENER_MIGDB’*.memory_target=857735168*.open_cursors=300*.processes=150*.remote_login_passwordfile=’EXCLUSIVE’*.undo_tablespace=’UNDOTBS1′Změněný:migdb.__db_cache_size=335544320migdb.__java_pool_size=12582912migdb.__large_pool_size=4194304migdb.__oracle_base=’/opt/app/oracle’migdb.__pga_aggregate_target=343932928migdb.__sga_target=515899392migdb.__shared_io_pool_size=0migdb.__shared_pool_size=159383552migdb.__streams_pool_size=0*.audit_file_dest=’/opt/app/oracle/product/11.1.0/dbhome_1/admin/migdb/’*.audit_trail=’db’*.compatible=’11.1.0.0.0’*.control_files=’/opt/app/oracle/oradata/migdb/control01.ctl’,’/opt/app/oracle/oradata/migdb/control02.ctl’,’/opt/app/oracle/oradata/migdb/control03.ctl’*.db_block_size=8192*.db_domain=”*.db_name=’migdb’*.db_recovery_file_dest=’/opt/app/oracle/fast_recovery_area/migdb’*.db_recovery_file_dest_size=2147483648*.diagnostic_dest=’/opt/app/oracle’*.dispatchers='(PROTOCOL=TCP) (SERVICE=migdbXDB)’*.local_listener=’LISTENER_MIGDB’*.memory_target=857735168*.open_cursors=300*.processes=150*.remote_login_passwordfile=’EXCLUSIVE’*.undo_tablespace=’UNDOTBS1′
Registrace databáze do listeneru a nastavení tnsnames.ora
[oracle@publicdbsrv02 admin]$ cat tnsnames.ora# tnsnames.ora Network Configuration File: /opt/app/oracle/product/11.1.0/dbhome_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.MIGDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = migdb) ) )LISTENER_MIGDB = (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1522))
Restore datavých souborů ze zálohy
Nastarování databáze do nomount módu z upraveného init soboru
SQL> STARTUP NOMOUNT PFILE=’/opt/convert/pfile.ora’ORACLE instance started.Total System Global Area 857903104 bytesFixed Size 1303272 bytesVariable Size 490736920 bytesDatabase Buffers 360710144 bytesRedo Buffers 5152768 bytes
Obnova kontrolního souboru
RMAN> restore controlfile from ‘/opt/convert/O1_MF_NCSNF_TAG20110624T131839_708WPW72_.BKP’;Starting restore at 24-JUN-11using channel ORA_DISK_1channel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore complete, elapsed time: 00:00:03output file name=/opt/app/oracle/oradata/migdb/control01.ctloutput file name=/opt/app/oracle/oradata/migdb/control02.ctloutput file name=/opt/app/oracle/oradata/migdb/control03.ctlFinished restore at 24-JUN-11
Restore datových souborů
RMAN> alter database mount;database mountedreleased channel: ORA_DISK_1RMAN> catalog start with ‘/opt/convert/’;searching for all files that match the pattern /opt/convert/List of Files Unknown to the Database=====================================File Name: /opt/convert/O1_MF_NNNDF_TAG20110624T131839_708WNHY1_.BKPFile Name: /opt/convert/O1_MF_ANNNN_TAG20110624T131957_708WPXPP_.BKPFile Name: /opt/convert/O1_MF_NCSNF_TAG20110624T131839_708WPW72_.BKPFile Name: /opt/convert/pfile.oraFile Name: /opt/convert/TRANSPORTSCRIPT.SQLFile Name: /opt/convert/CONVERTSCRIPT.RMANFile Name: /opt/convert/O1_MF_ANNNN_TAG20110624T131836_708WNDFX_.BKPFile Name: /opt/convert/INIT_00MFMELF_1_0.ORADo you really want to catalog the above files (enter YES or NO)? yescataloging files…cataloging doneList of Cataloged Files=======================File Name: /opt/convert/O1_MF_NNNDF_TAG20110624T131839_708WNHY1_.BKPFile Name: /opt/convert/O1_MF_ANNNN_TAG20110624T131957_708WPXPP_.BKPFile Name: /opt/convert/O1_MF_NCSNF_TAG20110624T131839_708WPW72_.BKPFile Name: /opt/convert/O1_MF_ANNNN_TAG20110624T131836_708WNDFX_.BKPList of Files Which Where Not Cataloged=======================================File Name: /opt/convert/pfile.ora RMAN-07517: Reason: The file header is corruptedFile Name: /opt/convert/TRANSPORTSCRIPT.SQL RMAN-07517: Reason: The file header is corruptedFile Name: /opt/convert/CONVERTSCRIPT.RMAN RMAN-07517: Reason: The file header is corruptedFile Name: /opt/convert/INIT_00MFMELF_1_0.ORA RMAN-07517: Reason: The file header is corruptedRMAN> run{SET NEWNAME FOR DATAFILE 1 TO ‘/opt/convert/dbf_win/SYSTEM01.DBS’;SET NEWNAME FOR DATAFILE 2 TO ‘/opt/convert/dbf_win/SYSAUX01.DBS’;SET NEWNAME FOR DATAFILE 3 TO ‘/opt/convert/dbf_win/UNDOTBS01.DBS’;SET NEWNAME FOR DATAFILE 4 TO ‘/opt/convert/dbf_win/USERS01.DBS’;SET NEWNAME FOR DATAFILE 5 TO ‘/opt/convert/dbf_win/EXAMPLE01.DBS’;restore database;}executing command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEStarting restore at 24-JUN-11using channel ORA_DISK_1channel ORA_DISK_1: restoring datafile 00003input datafile copy RECID=3 STAMP=754666968 file name=/opt/app/oracle/product/11.1.0/dbhome_1/dbs/C:ORACLEORADATAMIGDBUNDOTBS01.DBFdestination for restore of datafile 00003: /opt/convert/dbf_win/UNDOTBS01.DBSchannel ORA_DISK_1: copied datafile copy of datafile 00003output file name=/opt/convert/dbf_win/UNDOTBS01.DBS RECID=5 STAMP=754667049channel ORA_DISK_1: restoring datafile 00004input datafile copy RECID=2 STAMP=754666958 file name=/opt/app/oracle/product/11.1.0/dbhome_1/dbs/C:ORACLEORADATAMIGDBUSERS01.DBFdestination for restore of datafile 00004: /opt/convert/dbf_win/USERS01.DBSchannel ORA_DISK_1: copied datafile copy of datafile 00004output file name=/opt/convert/dbf_win/USERS01.DBS RECID=6 STAMP=754667050channel ORA_DISK_1: restoring datafile 00005input datafile copy RECID=4 STAMP=754666971 file name=/opt/app/oracle/product/11.1.0/dbhome_1/dbs/C:ORACLEORADATAMIGDBEXAMPLE01.DBFdestination for restore of datafile 00005: /opt/convert/dbf_win/EXAMPLE01.DBSchannel ORA_DISK_1: copied datafile copy of datafile 00005output file name=/opt/convert/dbf_win/EXAMPLE01.DBS RECID=7 STAMP=754667055channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00001 to /opt/convert/dbf_win/SYSTEM01.DBSchannel ORA_DISK_1: restoring datafile 00002 to /opt/convert/dbf_win/SYSAUX01.DBSchannel ORA_DISK_1: reading from backup piece /opt/convert/O1_MF_NNNDF_TAG20110624T131839_708WNHY1_.BKPchannel ORA_DISK_1: piece handle=/opt/convert/O1_MF_NNNDF_TAG20110624T131839_708WNHY1_.BKP tag=TAG20110624T131839channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:01:05Finished restore at 24-JUN-11[oracle@publicdbsrv02 dbf_win]$ pwd/opt/convert/dbf_win[oracle@publicdbsrv02 dbf_win]$ ls -ltrtotal 1442372-rw-r—– 1 oracle oinstall 47194112 Jun 24 13:44 UNDOTBS01.DBS-rw-r—– 1 oracle oinstall 5251072 Jun 24 13:44 USERS01.DBS-rw-r—– 1 oracle oinstall 104865792 Jun 24 13:44 EXAMPLE01.DBS-rw-r—– 1 oracle oinstall 594681856 Jun 24 13:45 SYSAUX01.DBS-rw-r—– 1 oracle oinstall 723525632 Jun 24 13:45 SYSTEM01.DBS[oracle@publicdbsrv02 migdb]$ cp /opt/convert/dbf_win/* /opt/app/oracle/oradata/migdb/[oracle@publicdbsrv02 migdb]$ ls -ltrtotal 1470980-rw-r—– 1 oracle oinstall 9748480 Jun 24 13:46 control03.ctl-rw-r—– 1 oracle oinstall 9748480 Jun 24 13:46 control02.ctl-rw-r—– 1 oracle oinstall 9748480 Jun 24 13:46 control01.ctl-rw-r—– 1 oracle oinstall 104865792 Jun 24 13:55 EXAMPLE01.DBS-rw-r—– 1 oracle oinstall 594681856 Jun 24 13:56 SYSAUX01.DBS-rw-r—– 1 oracle oinstall 723525632 Jun 24 13:56 SYSTEM01.DBS-rw-r—– 1 oracle oinstall 47194112 Jun 24 13:56 UNDOTBS01.DBS-rw-r—– 1 oracle oinstall 5251072 Jun 24 13:56 USERS01.DBS[oracle@publicdbsrv02 migdb]$ pwd/opt/app/oracle/oradata/migdb
Vytvoření dummy kontrolního souboru
SQL> shutdown database;SP2-0717: illegal SHUTDOWN optionSQL> shutdown immediate;ORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> STARTUP NOMOUNT PFILE=’/opt/convert/pfile.ora’ORACLE instance started.Total System Global Area 857903104 bytesFixed Size 1303272 bytesVariable Size 490736920 bytesDatabase Buffers 360710144 bytesRedo Buffers 5152768 bytesSQL> CREATE CONTROLFILE REUSE SET DATABASE “MIGDB” RESETLOGS ARCHIVELOG 2 MAXLOGFILES 16MAXLOGMEMBERS 3 3 4 MAXDATAFILES 100 5 MAXINSTANCES 8MAXLOGHISTORY 292 6 7 LOGFILE 8 GROUP 4 ‘/opt/app/oracle/oradata/migdb/redo01.log’ SIZE 10M, 9 GROUP 5 ‘/opt/app/oracle/oradata/migdb/redo02.log’ SIZE 10M,GROUP 6 ‘/opt/app/oracle/oradata/migdb/redo03.log’ SIZE 10M 10 11 DATAFILE 12 ‘/opt/app/oracle/oradata/migdb/SYSTEM01.DBS’, 13 ‘/opt/app/oracle/oradata/migdb/SYSAUX01.DBS’, 14 ‘/opt/app/oracle/oradata/migdb/UNDOTBS01.DBS’, 15 ‘/opt/app/oracle/oradata/migdb/USERS01.DBS’, 16 ‘/opt/app/oracle/oradata/migdb/EXAMPLE01.DBS’ 17 CHARACTER SET WE8MSWIN1252 18 ;Control file created.
Úprava skriptu CONVERTSCRIPT.RMAN
Původní CONVERTSCRIPT.RMAN
STARTUP NOMOUNT PFILE = ‘C:\CONVERT\INIT_00MFMELF_1_0.ORA’;RUN { CONVERT FROM PLATFORM ‘Microsoft Windows IA (32-bit)’ PARALLELISM 1DATAFILE ‘C:\ORACLE\ORADATA\MIGDB\SYSTEM01.DBF’ FORMAT ‘C:\CONVERT\DATA_D-MIGDB_I-959485668_TS-SYSTEM_FNO-1_05MFMELF’DATAFILE ‘C:\ORACLE\ORADATA\MIGDB\SYSAUX01.DBF’ FORMAT ‘C:\CONVERT\DATA_D-MIGDB_I-959485668_TS-SYSAUX_FNO-2_06MFMELF’DATAFILE ‘C:\ORACLE\ORADATA\MIGDB\EXAMPLE01.DBF’ FORMAT ‘C:\CONVERT\DATA_D-MIGDB_I-959485668_TS-EXAMPLE_FNO-5_07MFMELG’DATAFILE ‘C:\ORACLE\ORADATA\MIGDB\UNDOTBS01.DBF’ FORMAT ‘C:\CONVERT\DATA_D-MIGDB_I-959485668_TS-UNDOTBS1_FNO-3_08MFMELG’DATAFILE ‘C:\ORACLE\ORADATA\MIGDB\USERS01.DBF’ FORMAT ‘C:\CONVERT\DATA_D-MIGDB_I-959485668_TS-USERS_FNO-4_09MFMELG’; }Upravený:RUN { CONVERT FROM PLATFORM ‘Microsoft Windows IA (32-bit)’ PARALLELISM 1DATAFILE ‘/opt/app/oracle/oradata/migdb/SYSTEM01.DBS’ FORMAT ‘/opt/app/oracle/oradata/migdb/dbf_lin/SYSTEM01.DBS’DATAFILE ‘/opt/app/oracle/oradata/migdb/SYSAUX01.DBS’ FORMAT ‘/opt/app/oracle/oradata/migdb/dbf_lin/SYSAUX01.DBS’DATAFILE ‘/opt/app/oracle/oradata/migdb/UNDOTBS01.DBS’ FORMAT ‘/opt/app/oracle/oradata/migdb/dbf_lin/UNDOTBS01.DBS’DATAFILE ‘/opt/app/oracle/oradata/migdb/USERS01.DBS’ FORMAT ‘/opt/app/oracle/oradata/migdb/dbf_lin/USERS01.DBS’DATAFILE ‘/opt/app/oracle/oradata/migdb/EXAMPLE01.DBS’ FORMAT ‘/opt/app/oracle/oradata/migdb/dbf_lin/EXAMPLE01.DBS’; }RMAN> RUN {2> CONVERT3> FROM PLATFORM ‘Microsoft Windows IA (32-bit)’4> PARALLELISM 15> DATAFILE ‘/opt/app/oracle/oradata/migdb/SYSTEM01.DBS’ FORMAT ‘/opt/app/oracle/oradata/migdb/dbf_lin/SYSTEM01.DBS’6> DATAFILE ‘/opt/app/oracle/oradata/migdb/SYSAUX01.DBS’ FORMAT ‘/opt/app/oracle/oradata/migdb/dbf_lin/SYSAUX01.DBS’7> DATAFILE ‘/opt/app/oracle/oradata/migdb/UNDOTBS01.DBS’ FORMAT ‘/opt/app/oracle/oradata/migdb/dbf_lin/UNDOTBS01.DBS’8> DATAFILE ‘/opt/app/oracle/oradata/migdb/USERS01.DBS’ FORMAT ‘/opt/app/oracle/oradata/migdb/dbf_lin/USERS01.DBS’9> DATAFILE ‘/opt/app/oracle/oradata/migdb/EXAMPLE01.DBS’ FORMAT ‘/opt/app/oracle/oradata/migdb/dbf_lin/EXAMPLE01.DBS’10> ; }11>Starting conversion at target at 24-JUN-11allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=170 device type=DISKchannel ORA_DISK_1: starting datafile conversioninput file name=/opt/app/oracle/oradata/migdb/SYSTEM01.DBSconverted datafile=/opt/app/oracle/oradata/migdb/dbf_lin/SYSTEM01.DBSchannel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:35channel ORA_DISK_1: starting datafile conversioninput file name=/opt/app/oracle/oradata/migdb/SYSAUX01.DBSconverted datafile=/opt/app/oracle/oradata/migdb/dbf_lin/SYSAUX01.DBSchannel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:36channel ORA_DISK_1: starting datafile conversioninput file name=/opt/app/oracle/oradata/migdb/EXAMPLE01.DBSconverted datafile=/opt/app/oracle/oradata/migdb/dbf_lin/EXAMPLE01.DBSchannel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:07channel ORA_DISK_1: starting datafile conversioninput file name=/opt/app/oracle/oradata/migdb/UNDOTBS01.DBSconverted datafile=/opt/app/oracle/oradata/migdb/dbf_lin/UNDOTBS01.DBSchannel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03channel ORA_DISK_1: starting datafile conversioninput file name=/opt/app/oracle/oradata/migdb/USERS01.DBSconverted datafile=/opt/app/oracle/oradata/migdb/dbf_lin/USERS01.DBSchannel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01Finished conversion at target at 24-JUN-11RMAN-06497: WARNING: control file is not current, control file AUTOBACKUP skippedRecovery Manager complete.SQL> shutdown immediate;ORA-01109: database not openDatabase dismounted.ORACLE instance shut down.
Úprava skriptu TRANSPORTSCRIPT.SQL
PůvodníSTARTUP NOMOUNT PFILE=’C:\CONVERT\INIT_00MFMELF_1_0.ORA’CREATE CONTROLFILE REUSE SET DATABASE “MIGDB” RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 ‘C:\CONVERT\ARCH_D-MIGDB_ID-959485668_S-4_T-1_A-754658407_03MFMELF’ SIZE 50M, GROUP 2 ‘C:\CONVERT\ARCH_D-MIGDB_ID-959485668_S-5_T-1_A-754658407_04MFMELF’ SIZE 50M, GROUP 3 ‘C:\CONVERT\ARCH_D-MIGDB_ID-959485668_S-3_T-1_A-754658407_05MFMELF’ SIZE 50MDATAFILE ‘C:\CONVERT\DATA_D-MIGDB_I-959485668_TS-SYSTEM_FNO-1_05MFMELF’, ‘C:\CONVERT\DATA_D-MIGDB_I-959485668_TS-SYSAUX_FNO-2_06MFMELF’, ‘C:\CONVERT\DATA_D-MIGDB_I-959485668_TS-UNDOTBS1_FNO-3_08MFMELG’, ‘C:\CONVERT\DATA_D-MIGDB_I-959485668_TS-USERS_FNO-4_09MFMELG’, ‘C:\CONVERT\DATA_D-MIGDB_I-959485668_TS-EXAMPLE_FNO-5_07MFMELG’CHARACTER SET WE8MSWIN1252;– 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 ‘C:\CONVERT\DATA_D-MIGDB_I-959485668_TS-TEMP_FNO-1_06MFMELF’ SIZE 20971520 AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;– End of tempfile additions.–set echo offprompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~prompt * Your database has been created successfully!prompt * There are many things to think about for the new database. Hereprompt * 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 theprompt * NEWDBID Utility (nid).prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~SHUTDOWN IMMEDIATESTARTUP UPGRADE PFILE=’C:\CONVERT\INIT_00MFMELF_1_0.ORA’@@ ?/rdbms/admin/utlirp.sqlSHUTDOWN IMMEDIATESTARTUP PFILE=’C:\CONVERT\INIT_00MFMELF_1_0.ORA’– The following step will recompile all PL/SQL modules.– It may take serveral hours to complete.@@ ?/rdbms/admin/utlrp.sqlset feedback 6;UpravenýSTARTUP NOMOUNT STARTUP NOMOUNT PFILE=’/opt/convert/pfile.ora’CREATE CONTROLFILE REUSE SET DATABASE “MIGDB” RESETLOGS ARCHIVELOGMAXLOGFILES 16MAXLOGMEMBERS 3MAXDATAFILES 100MAXINSTANCES 8MAXLOGHISTORY 292LOGFILEGROUP 1 ‘/opt/app/oracle/oradata/migdb/dbf_lin/redo01.log’ SIZE 50M,GROUP 2 ‘/opt/app/oracle/oradata/migdb/dbf_lin/redo02.log’ SIZE 50M,GROUP 3 ‘/opt/app/oracle/oradata/migdb/dbf_lin/redo03.log’ SIZE 50MDATAFILE’/opt/app/oracle/oradata/migdb/dbf_lin/SYSTEM01.DBS’,’/opt/app/oracle/oradata/migdb/dbf_lin/SYSAUX01.DBS’,’/opt/app/oracle/oradata/migdb/dbf_lin/UNDOTBS01.DBS’,’/opt/app/oracle/oradata/migdb/dbf_lin/USERS01.DBS’,’/opt/app/oracle/oradata/migdb/dbf_lin/EXAMPLE01.DBS’CHARACTER SET WE8MSWIN1252;– 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 ‘/opt/app/oracle/oradata/migdb/dbf_lin/TEMP01.DBS’ SIZE 20971520 AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;– End of tempfile additions.–set echo offprompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~prompt * Your database has been created successfully!prompt * There are many things to think about for the new database. Hereprompt * 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 theprompt * NEWDBID Utility (nid).prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~SHUTDOWN IMMEDIATESTARTUP UPGRADE PFILE=’/opt/convert/pfile.ora’@@ ?/rdbms/admin/utlirp.sqlSHUTDOWN IMMEDIATESTARTUP PFILE=’/opt/convert/pfile.ora’– The following step will recompile all PL/SQL modules.– It may take serveral hours to complete.@@ ?/rdbms/admin/utlrp.sqlset feedback 6;
Spuštění transportu
[oracle@publicdbsrv02 convert]$ echo $ORACLE_SIDmigdb[oracle@publicdbsrv02 convert]$ echo $ORACLE_HOME/opt/app/oracle/product/11.1.0/dbhome_1[oracle@publicdbsrv02 convert]$ export PATH=$ORACLE_HOME/bin:$PATH[oracle@publicdbsrv02 convert]$ sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 – Production on Fri Jun 24 14:19:54 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.Connected to an idle instance.SQL> @TRANSPORTSCRIPT.SQLORACLE instance started.Total System Global Area 857903104 bytesFixed Size 1303272 bytesVariable Size 520097048 bytesDatabase Buffers 331350016 bytesRedo Buffers 5152768 bytesControl file created.Database altered.Tablespace altered.~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~* Your database has been created successfully!* There are many things to think about for the new database. Here* is a checklist to help you stay on track:* 1. You may want to redefine the location of the directory objects.* 2. You may want to change the internal database identifier (DBID)* or the global database name for this database. Use the* NEWDBID Utility (nid).~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Database closed.Database dismounted.ORACLE instance shut down.ORACLE instance started.Total System Global Area 857903104 bytesFixed Size 1303272 bytesVariable Size 520097048 bytesDatabase Buffers 331350016 bytesRedo Buffers 5152768 bytesDatabase mounted.Database opened.
Kontrola:
SQL> select open_mode from v$database;OPEN_MODE———-READ WRITESQL> show parameter instance;NAME TYPE VALUE———————————— ———– ——————————active_instance_count integercluster_database_instances integer 1instance_groups stringinstance_name string migdbinstance_number integer 0instance_type string RDBMSopen_links_per_instance integer 4parallel_instance_group stringparallel_server_instances integer 1