Předpokladem je, že na cílovém serveru byl nainstalován software Oracle. V našem případě se jedna o sw pro databázi 11.2.0.2. Jako ORACLE_HOME je použitá cesta d:\Oracle\product\11.2.0\dbhome_1
Pomocí nástroje NETCA vytvořit listener.
Vytvořil jsem listener s defaultní konfiguracíJméno: LISTENERPort: 1521d:\Oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN>lsnrctl statusLSNRCTL for 64-bit Windows: Version 11.2.0.2.0 – Production on 11-MAR-2011 09:37:49Copyright (c) 1991, 2010, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=trgwin2008.ad.solar.cz)(PORT=1521)))STATUS of the LISTENER————————Alias LISTENERVersion TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 – ProductionStart Date 24-FEB-2011 13:35:42Uptime 14 days 20 hr. 2 min. 7 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFF

Listener Parameter File D:\Oracle\product\11.2.0\dbhome_1\network\admin\listener.oraListener Log File D:\Oracle\diag\tnslsnr\trgwin2008\listener\alert\log.xmlListening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=trgwin2008.ad.solar.cz)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))Services Summary…Service “orcl.ad.solar.cz” has 2 instance(s). Instance “orcl“, status UNKNOWN, has 1 handler(s) for this service… Instance “orcl”, status READY, has 1 handler(s) for this service…Service “orclXDB.ad.solar.cz” has 1 instance(s). Instance “orcl”, status READY, has 1 handler(s) for this service…Service “CLRExtProc” has 1 instance(s). Instance “CLRExtProc”, status UNKNOWN, has 1 handler(s) for this service…The command completed successfully

Registrace služby do listeneru

Soubor listener.ora by měl obsahovat údaje o databázi orcl# listener.ora Network Configuration File: D:\Oracle\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\Oracle\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = “EXTPROC_DLLS=ONLY:D:\Oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll”) ) (SID_DESC = (GLOBAL_DBNAME = orcl.ad.solar.cz) (ORACLE_HOME = D:\Oracle\product\11.2.0\dbhome_1) (SID_NAME = orcl) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = trgwin2008.ad.solar.cz)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )ADR_BASE_LISTENER = D:\Oracle

Vytvoření service ve windows pomoci oradim

CMD musí být spuštěné pod účtem administrátora.C:\Windows\system32>set ORACLE_HOME=d:\Oracle\product\11.2.0\dbhome_1C:\Windows\system32>set ORACLE_SID=orcld:\Oracle\product\11.2.0\dbhome_1\BIN>oradim -new -sid orcl -intpwd -startmode AUTO -pfile d:\Oracle\product\11.2.0\dbhome_1\dbs\initorcl.oraInstance created.Překopírovat init soubor do ORACLE_HOME\dbsPřekopíroval jsem soubor ze záloh do d:\Oracle\product\11.2.0\dbhome_1\dbs\initorcl.oraDaný soubor je potřeba upravit tak, aby obsahoval parametry potřebné pro spuštění databáze verze 11R2.- změnit uložení kontrolních souborů- zakomentovat/smazat obsole parametry *dump- změnit parameter compatible- přidat parametry pro nastavení paměti *target- přidata parametr pro ukládaní trace souborů diagnostic_dest*.aq_tm_processes=1#*.background_dump_dest=’d:\oradb\admin\orcl\bdump’#*.compatible=’9.2.0.8.0’#*.compatible=’9.2.0.0.0’*.compatible=’11.2.0.0.0’*.control_files=’F:\orcl\control01.ctl’,’F:\orcl\control02.ctl’,’F:\orcl\control03.ctl’#*.core_dump_dest=’d:\oradb\admin\orcl\cdump’*.db_block_size=8192*.db_cache_size=25165824*.db_domain=’ad.solar.cz’*.db_file_multiblock_read_count=16*.db_name=’orcl’*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)’*.fast_start_mttr_target=300*.hash_join_enabled=TRUE*.instance_name=’orcl’*.java_pool_size=33554432*.job_queue_processes=10*.large_pool_size=8388608*.open_cursors=300*.pga_aggregate_target=25165824*.processes=150*.query_rewrite_enabled=’FALSE’*.remote_login_passwordfile=’EXCLUSIVE’*.shared_pool_size=50331648*.sort_area_size=524288*.star_transformation_enabled=’FALSE’*.timed_statistics=TRUE*.undo_management=’AUTO’*.undo_retention=10800*.undo_tablespace=’UNDOTBS1’#*.user_dump_dest=’d:\oradb\admin\orcl\udump’# nove parametry*.memory_target=2080M*.diagnostic_dest=’d:\oracle\diag’*.audit_file_dest=’F:\orcl\adump’*.audit_trail=’db’*.sga_target=2G

Překopírovat password file

Z původního ORACLE_HOME\database do d:\Oracle\product\11.2.0\dbhome_1\database\ PWDorcl.ORAÚprava tnsnames.oraDo tnsnames.ora je potřeba přidat novou službu.orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = trgwin2008)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl.ad.solar.cz) ) )Ověření:d:\Oracle\product\11.2.0\dbhome_1\BIN>tnsping orclTNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 – Production on 24-FEB-2011 13:36:11Copyright (c) 1997, 2010, Oracle. All rights reserved.Used parameter files:d:\Oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.oraUsed TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = trgwin2008)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl.ad.solar.cz)))OK (20 msec)

Otevření databáze do nomount režimu

Je potřeba nastavit parameter memory_target na dostatečně velikoou hodnotuSQL> startup nomountORA-01078: failure in processing system parametersORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 2080MSQL> startup nomountORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.Total System Global Area 2171289600 bytesFixed Size 2254976 bytesVariable Size 251660160 bytesDatabase Buffers 1912602624 bytesRedo Buffers 4771840 bytesV init souboru jsou ještě některé obsolete parametry, ale to nevadí, protože budou automaticky ignorovány. Může se pročistit později.Důležité je, že databáze je v režimu nomount.

Obnova kontrolního souboru, otevření do mount režimu

RMAN> restore controlfile from ‘y:\C-2140195091-20110224-00’;Starting restore at 24-FEB-11using channel ORA_DISK_1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 02/24/2011 15:22:39RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or pieceProblém s oprávněním. Soubory nemohou být na sdíleném disku, tak jsem je překopíroval na lokální.RMAN> restore controlfile from ‘f:\orcl\C-2140195091-20110224-00’;Starting restore at 24-FEB-11using channel ORA_DISK_1channel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore complete, elapsed time: 00:00:01output file name=F:\orcl\CONTROL01.CTLoutput file name=F:\orcl\CONTROL02.CTLoutput file name=F:\orcl\CONTROL03.CTLFinished restore at 24-FEB-11RMAN> alter database mount;database mountedreleased channel: ORA_DISK_1Obnova datových souborůRegistrace záloh do cataloguRMAN> catalog start with ‘f:\orcl\0GM5FHSI_1_1’;searching for all files that match the pattern f:\orcl\0GM5FHSI_1_1List of Files Unknown to the Database=====================================File Name: F:\orcl\0GM5FHSI_1_1Do you really want to catalog the above files (enter YES or NO)? yescataloging files…cataloging doneList of Cataloged Files=======================File Name: F:\orcl\0GM5FHSI_1_1

Obnovení do jíného adresáře než na zdrojovém serveru

RMAN> run{set newname for datafile 1 to ‘F:\orcl\SYSTEM01.DBF’;set newname for datafile 2 to ‘F:\orcl\UNDOTBS01.DBF’;set newname for datafile 3 to ‘F:\orcl\DRSYS01.DBF’;set newname for datafile 4 to ‘F:\orcl\EXAMPLE01.DBF’;set newname for datafile 5 to ‘F:\orcl\INDX01.DBF’;set newname for datafile 6 to ‘F:\orcl\TOOLS01.DBF’;set newname for datafile 7 to ‘F:\orcl\USERS01.DBF’;set newname for datafile 8 to ‘F:\orcl\XDB01.DBF’;restore database;}executing command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEStarting restore at 24-FEB-11using channel ORA_DISK_1channel 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 F:\orcl\SYSTEM01.DBFchannel ORA_DISK_1: restoring datafile 00002 to F:\orcl\UNDOTBS01.DBFchannel ORA_DISK_1: restoring datafile 00003 to F:\orcl\DRSYS01.DBFchannel ORA_DISK_1: restoring datafile 00004 to F:\orcl\EXAMPLE01.DBFchannel ORA_DISK_1: restoring datafile 00005 to F:\orcl\INDX01.DBFchannel ORA_DISK_1: restoring datafile 00006 to F:\orcl\TOOLS01.DBFchannel ORA_DISK_1: restoring datafile 00007 to F:\orcl\USERS01.DBFchannel ORA_DISK_1: restoring datafile 00008 to F:\orcl\XDB01.DBFchannel ORA_DISK_1: reading from backup piece E:\MIGRACE\0GM5FHSI_1_1channel ORA_DISK_1: errors found reading piece handle=E:\MIGRACE\0GM5FHSI_1_1channel ORA_DISK_1: failover to piece handle=F:\orcl\0GM5FHSI_1_1 tag=TAG20110224T125026channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:01:25Finished restore at 24-FEB-11

Vytvoření nového kontrolního souboru

Záloha obnoveného kontrolního souboruSQL> alter database backup controlfile to trace;Database altered.V alert.logu je link na textový kontrolní soubor, který je potřeba upravitBackup controlfile written to trace file D:\ORACLE\DIAG\diag\rdbms\orcl\orcl\trace\orcl_ora_3532.trcJe potřeba změnit sekci s NORESETLOGSKonkrétně umístění souborů redlo.log a datových souborů

Redo logy překopírujte ze záloh.

STARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE “orcl” NORESETLOGS NOARCHIVELOG MAXLOGFILES 5 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 453LOGFILE GROUP 1 ‘F:\orcl\REDO01.LOG’ SIZE 100M BLOCKSIZE 512, GROUP 2 ‘F:\orcl\REDO02.LOG’ SIZE 100M BLOCKSIZE 512, GROUP 3 ‘F:\orcl\REDO03.LOG’ SIZE 100M BLOCKSIZE 512DATAFILE ‘F:\orcl\SYSTEM01.DBF’, ‘F:\orcl\UNDOTBS01.DBF’, ‘F:\orcl\DRSYS01.DBF’, ‘F:\orcl\EXAMPLE01.DBF’, ‘F:\orcl\INDX01.DBF’, ‘F:\orcl\TOOLS01.DBF’, ‘F:\orcl\USERS01.DBF’, ‘F:\orcl\XDB01.DBF’CHARACTER SET UTF8;

Nastartování do nomount s novým umístěním souborů

SQL> shutdown immediateORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> startup nomountORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.Total System Global Area 2171289600 bytesFixed Size 2254976 bytesVariable Size 251660160 bytesDatabase Buffers 1912602624 bytesRedo Buffers 4771840 bytesSQL> CREATE CONTROLFILE REUSE DATABASE “orcl” RESETLOGS NOARCHIVELOG 2 MAXLOGFILES 5 3 MAXLOGMEMBERS 3 4 MAXDATAFILES 100 5 MAXINSTANCES 1 6 MAXLOGHISTORY 453 7 LOGFILE 8 GROUP 1 ‘F:\orcl\REDO01.LOG’ SIZE 100M BLOCKSIZE 512, 9 GROUP 2 ‘F:\orcl\REDO02.LOG’ SIZE 100M BLOCKSIZE 512, 10 GROUP 3 ‘F:\orcl\REDO03.LOG’ SIZE 100M BLOCKSIZE 512 11 DATAFILE 12 ‘F:\orcl\SYSTEM01.DBF’, 13 ‘F:\orcl\UNDOTBS01.DBF’, 14 ‘F:\orcl\DRSYS01.DBF’, 15 ‘F:\orcl\EXAMPLE01.DBF’, 16 ‘F:\orcl\INDX01.DBF’, 17 ‘F:\orcl\TOOLS01.DBF’, 18 ‘F:\orcl\USERS01.DBF’, 19 ‘F:\orcl\XDB01.DBF’ 20 CHARACTER SET UTF8 21 ;Control file created.

Recover databáze

Databázi nejde jednoduše otevřít, protože obnovená databáze je stále na verzi 9.2.0.8.SQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01092: ORACLE instance terminated. Disconnection forcedORA-00704: bootstrap process failureORA-39700: database must be opened with UPGRADE optionProcess ID: 3068Session ID: 125 Serial number: 3Je potřeba ji spustit v upgrade módu a provést recover souboru manuálně.SQL> connect sys@orcl as sysdbaEnter password:Connected to an idle instance.SQL> startup upgradeORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.Total System Global Area 2171289600 bytesFixed Size 2254976 bytesVariable Size 251660160 bytesDatabase Buffers 1912602624 bytesRedo Buffers 4771840 bytesDatabase mounted.ORA-01113: file 1 needs media recoveryORA-01110: data file 1: ‘F:\orcl\SYSTEM01.DBF’SQL> recover datafile 1;Media recovery complete.SQL> recover datafile 2;Media recovery complete.SQL> recover datafile 3;Media recovery complete.SQL> recover datafile 4;Media recovery complete.SQL> recover datafile 5;Media recovery complete.SQL> recover datafile 6;Media recovery complete.SQL> recover datafile 7;Media recovery complete.SQL> recover datafile 8;Media recovery complete.SQL> shutdown immediateORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> startup upgradeORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.Total System Global Area 2171289600 bytesFixed Size 2254976 bytesVariable Size 251660160 bytesDatabase Buffers 1912602624 bytesRedo Buffers 4771840 bytesDatabase mounted.Database opened.

V této chvíli je databáze otevřená a připravená pro upgrade.



Komentáře