Dover_Proj._OCF_041_ICS_pg_097-185.pdf

Air Freight Terminal

0467-ICS Dover Air Force Base Page 97 of 206 Rev. 0 Mechanised Material Handling System Date: 07/02/2011 Chapter

AFT / OCF / DCS / FTF 4.1

5. Software ICS-Server

5.1. Windows User and Passwords

Do not delete or make any changes on this User accounts.

User Description Password

Administrator Domain Admin sound

Unitechnik Unitechnik Main user (normal user rights) unite987 ws Workstation user for IPC and

OPC

ws

0467-ICS Dover Air Force Base Page 98 of 206

5.2. Directories and Shared Names

Computername Drive Folder Shared Name Description

ICSSRV1 /2 C: \Drivers System-Drivers for Cluster Do not move or delete this folder!

ICSSRV1 /2 D: \Tools Setup files

ICSSRV1 /2 G: \MSCS

\Unitechnik\Warehouse

Cluster information Files

Unitechnik Project Applications

ICSSRV1 /2 H: \Oracle\OraData Oracle Database

ICSSRV1 /2 I: \Oracle\OraData Oracle Database

5.3. Standard-Software

Pos. Description Computer

1. Windows 2003 Server ICSSRV 1

ICSSRV 2

2. Oracle10g Release 10.2.0.2 ICSSRV 1

ICSSRV 2

3. JDK 1.5.0_11 ICSSRV 1

ICSSRV 2

0467-ICS Dover Air Force Base Page 99 of 206

5.4. Oracle10g - Standard Edition Release 10.2.0.1.0

5.4.1. Disk Structure

Figure 29: Disk Structure

0467-ICS Dover Air Force Base Page 100 of 206

Figure 30: Oracle Database File Structure

0467-ICS Dover Air Force Base Page 101 of 206

5.4.2. Installing Oracle Database on PC with Multiple IP Addresses

You can install Oracle Database on a computer that has multiple IP addresses, also known as a multihomed computer. Typically, a multihomed computer has multiple network cards. Each IP address is associated with a host name; additionally, you can set up aliases for the host name.

By default, Oracle Universal Installer uses the ORACLE_HOSTNAME environment variable setting to find the host name. If ORACLE_HOSTNAME is not set and you are installing on a computer that has multiple network cards, Oracle Universal Installer determines the host name by using the first name in the hosts file, typically located in

SYSTEM_DRIVE:\WINDOWS\system32\drivers\etc on Windows 2003 and Windows XP.

Clients must be able to access the computer using this host name, or using aliases for this host name. To check, ping the host name from the client computers using the short name (host name only) and the full name (host name and domain name). Both must work.

To set the ORACLE_HOSTNAME environment variable:

4. Display System in the Windows Control Panel.

5. In the System Properties dialog box, click Advanced.

6. In the Advanced tab, click Environment Variables.

7. In the Environment Variables dialog box, under System Variables, click New.

8. In the New System Variable dialog box, enter the following information:

Variable name: ORACLE_HOSTNAME

Variable value: ICSDATABASE

9. Click OK, then in the Environment Variables dialog box, click OK.

10. Click OK in the Environment Variables dialog box, then in the System Properties dialog box, click OK.

0467-ICS Dover Air Force Base Page 102 of 206

5.4.3. Server-1 and Server-2 – Installation

The installation of the Oracle software has be done on both servers.

Select “Advanced Installation”:

Figure 31: Oracle Installation Method

0467-ICS Dover Air Force Base Page 103 of 206

Select “Standard Edition”:

Figure 32: Oracle Installation – Welcome

0467-ICS Dover Air Force Base Page 104 of 206

Set environment variable to “OraHome10g” and the directory path to “C:\oracle\ora10g”:

Figure 33: Oracle Installation – Destination Path

0467-ICS Dover Air Force Base Page 105 of 206

Check the status of all that it is “SUCCEEDED”:

Figure 34: Oracle Installation – Products

Select “Install database Software only”. The database creation is done later for Server-1.

0467-ICS Dover Air Force Base Page 106 of 206

Figure 35: Oracle Installation – Configuration Option

0467-ICS Dover Air Force Base Page 107 of 206

Figure 36: Oracle Installation – Configuration Option

0467-ICS Dover Air Force Base Page 108 of 206

Figure 37: Oracle Installation – Tasks

0467-ICS Dover Air Force Base Page 109 of 206

Figure 38: Oracle Installation – End

0467-ICS Dover Air Force Base Page 110 of 206

5.4.4. Server-1 - Database Creation with Custom Scripts

You can create the Database directly by running the batch file “UNIWARE.bat”, which calls several scripts.

The yellow lines in the scripts have to be updated according to the project folders etc.

Make sure that the folders H:\Oracle\... and I:\Oracle\... exist. Refer to chapter 5.4.1 “Disk Structure”.

UNIWARE.sql CloneRmanRestore.sql rmanRestoreDatafiles.sql cloneDBCreation.sql postScripts.sql postDBCreation.sql customScripts.sql OraConfig-UniWare.sql

UNIWARE.bat:

mkdir C:\oracle\admin\UNIWARE\adump mkdir C:\oracle\admin\UNIWARE\bdump mkdir C:\oracle\admin\UNIWARE\cdump mkdir C:\oracle\admin\UNIWARE\dpdump mkdir C:\oracle\admin\UNIWARE\pfile mkdir C:\oracle\admin\UNIWARE\udump mkdir C:\oracle\Ora10g\cfgtoollogs\dbca\UNIWARE mkdir C:\oracle\Ora10g\dbs mkdir h:\oracle\oradata\UNIWARE mkdir i:\oracle\oradata\UNIWARE set ORACLE_SID=UNIWARE C:\oracle\Ora10g\bin\oradim.exe -new -sid UNIWARE -startmode manual -spfile C:\oracle\Ora10g\bin\oradim.exe -edit -sid UNIWARE -startmode auto -srvcstart system C:\oracle\Ora10g\bin\sqlplus /nolog @G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\scripts\UNIW ARE.sql

UNIWARE.sql:

set verify off

0467-ICS Dover Air Force Base Page 111 of 206

PROMPT specify a password for sys as parameter 1;

DEFINE sysPassword = &1 PROMPT specify a password for system as parameter 2;

DEFINE systemPassword = &2 PROMPT specify a password for sysman as parameter 3;

DEFINE sysmanPassword = &3 PROMPT specify a password for dbsnmp as parameter 4;

DEFINE dbsnmpPassword = &4 host C:\oracle\Ora10g\bin\orapwd.exe file=C:\oracle\Ora10g\database\PWDUNIWARE.ora password=&&sysPassword force=y @G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\scripts\Clon eRmanRestore.sql @G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\scripts\clon eDBCreation.sql @G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\scripts\post Scripts.sql host "echo SPFILE='C:\oracle\Ora10g/dbs/spfileUNIWARE.ora' > C:\oracle\Ora10g\database\initUNIWARE.ora" @G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\scripts\post DBCreation.sql @G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\scripts\cust omScripts.sql cloneDBCreation.sql:

connect "SYS"/"&&sysPassword" as SYSDBA set echo on spool G\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\scripts\cloneD BCreation.log Create controlfile reuse set database "UNIWARE"

MAXINSTANCES 8

MAXLOGHISTORY 1

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

Datafile 'h:\oracle\oradata\UNIWARE\SYSTEM01.DBF', 'h:\oracle\oradata\UNIWARE\UNDOTBS01.DBF', 'h:\oracle\oradata\UNIWARE\SYSAUX01.DBF', 'h:\oracle\oradata\UNIWARE\USERS01.DBF' LOGFILE GROUP 1 ('h:\oracle\oradata\UNIWARE\redo01.log', 'i:\oracle\oradata\UNIWARE\redo01.log') SIZE 100M, 0467-ICS Dover Air Force Base Page 112 of 206

GROUP 2 ('h:\oracle\oradata\UNIWARE\redo02.log', 'i:\oracle\oradata\UNIWARE\redo02.log') SIZE 100M, GROUP 3 ('h:\oracle\oradata\UNIWARE\redo03.log', 'i:\oracle\oradata\UNIWARE\redo03.log') SIZE 100M RESETLOGS;

exec dbms_backup_restore.zerodbid(0);

shutdown immediate;

startup nomount pfile=" G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\scripts\initU NIWARETemp.ora";

alter system enable restricted session;

alter database "UNIWARE" open resetlogs;

alter database rename global_name to "UNIWARE";

ALTER TABLESPACE TEMP ADD TEMPFILE 'h:\oracle\oradata\UNIWARE\TEMP01.DBF'

SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;

select tablespace_name from dba_tablespaces where tablespace_name='USERS';

select sid, program, serial#, username from v$session;

alter database character set INTERNAL_CONVERT WE8MSWIN1252;

alter database national character set INTERNAL_CONVERT AL16UTF16;

alter user sys identified by "&&sysPassword";

alter user system identified by "&&systemPassword";

alter system disable restricted session;

postDBCreation.sql:

connect "SYS"/"&&sysPassword" as SYSDBA set echo on spool G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFBdb\OracleAdmin\scripts\postDB Creation.log connect "SYS"/"&&sysPassword" as SYSDBA set echo on rem *** %Mi060728 create spfile='C:\oracle\Ora10g/dbs/spfileUNIWARE.ora'

FROM

pfile='G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\script s\init.ora';

create spfile='C:\oracle\Ora10g/database/spfileUNIWARE.ora' FROM pfile='G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\script s\init.ora';

shutdown immediate;

connect "SYS"/"&&sysPassword" as SYSDBA startup ;

alter user SYSMAN identified by "&&sysmanPassword" account unlock;

alter user DBSNMP identified by "&&dbsnmpPassword" account unlock;

select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual;

0467-ICS Dover Air Force Base Page 113 of 206 execute utl_recomp.recomp_serial();

select 'utl_recomp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual;

host C:\oracle\Ora10g\bin\emca.bat -config dbcontrol db -silent - DB_UNIQUE_NAME UNIWARE -PORT 1521 -EM_HOME C:\oracle\Ora10g -LISTENER LISTENER -SERVICE_NAME UNIWARE -SYS_PWD &&sysPassword -SID UNIWARE - ORACLE_HOME C:\oracle\Ora10g -DBSNMP_PWD &&dbsnmpPassword -HOST ICSSRV1.ICSDOVER.COM -LISTENER_OH C:\oracle\Ora10g -LOG_FILE G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\scripts\emCon fig.log -SYSMAN_PWD &&sysmanPassword;

spool G:\Unitechnik\Warehouse\db\OracleAdmin\scripts\postDBCreation.log customScripts.sql:

set echo on spool G:\Unitechnik\Warehouse\db\OracleAdmin\scripts\customScripts.log connect "SYS"/"&&sysPassword" as SYSDBA @G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\Scripts\OraC onfig-UniWare.sql;

spool off exit;

OraConfig-UniWare.sql:

rem *** unitechnik script to create and set the project database uniware for oracle 10g rem *** 04.01.07 i.mix project EKFC SE-02 rem *** directories must exist !!!

rem !!!todo!!! lines marked like this have to be updated.

rem *** CONNECT SYSTEM/UNITE987 AS SYSDBA;

SPOOL

@G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB\db\OracleAdmin\scripts\ORAC

ONFIG-UNIWARE.LOG;

rem **************tablespace for project data********************* CREATE TABLESPACE UW_DATA DATAFILE 'h:\Oracle\OraData\UNIWARE\Uw_Data1.dbf'

SIZE 2000M DEFAULT STORAGE ( INITIAL 100M NEXT 10M MINEXTENTS 1 MAXEXTENTS

UNLIMITED PCTINCREASE 10);

ALTER DATABASE DATAFILE 'h:\Oracle\OraData\UNIWARE\Uw_Data1.dbf' AUTOEXTEND

ON;

rem **************tablespace for history data*********************

0467-ICS Dover Air Force Base Page 114 of 206

CREATE TABLESPACE UW_HIST DATAFILE 'h:\Oracle\OraData\UNIWARE\Uw_Hist1.dbf'

SIZE 3000M DEFAULT STORAGE ( INITIAL 100M NEXT 10M MINEXTENTS 1 MAXEXTENTS

UNLIMITED PCTINCREASE 10);

ALTER DATABASE DATAFILE 'h:\Oracle\OraData\UNIWARE\Uw_Hist1.dbf' AUTOEXTEND

ON;

rem **************tablespace for temporary*****************

CREATE TEMPORARY TABLESPACE UW_TEMP TEMPFILE

'h:\Oracle\OraData\UNIWARE\Uw_Temp1.dbf' SIZE 500M AUTOEXTEND ON;

ALTER USER SYS TEMPORARY TABLESPACE UW_TEMP;

ALTER USER SYSTEM DEFAULT TABLESPACE UW_DATA;

rem **************create unitechnik user******************** rem !!!todo!!! update the username according to the project e.g. UTDFC, UTDOVER

CREATE USER DOAFB IDENTIFIED BY manager DEFAULT TABLESPACE UW_DATA

TEMPORARY TABLESPACE UW_TEMP PROFILE DEFAULT;

GRANT "CONNECT" TO "DOAFB";

GRANT "DBA" TO " DOAFB " WITH ADMIN OPTION;

GRANT UNLIMITED TABLESPACE TO " DOAFB ";

ALTER USER "EKFCLS" DEFAULT ROLE ALL;

ALTER USER " DOAFB " DEFAULT TABLESPACE "UW_DATA";

ALTER USER " DOAFB " TEMPORARY TABLESPACE UW_TEMP;

rem **************update init parameters********************

ALTER SYSTEM SET PROCESSES=600 SCOPE=SPFILE;

ALTER SYSTEM SET SHARED_POOL_RESERVED_SIZE=6000000 SCOPE=SPFILE;

ALTER SYSTEM SET SHARED_POOL_SIZE=100000000 SCOPE=SPFILE;

rem !!!todo!!! the following parameter has to be set global by using the enterprise manager console, rem !!!todo!!! because it could only bet set by alter session command:

rem !!!todo!!! nls_timestamp_format=yyyy-mm-dd hh24:mi:ss.ff rem **************update init parameters for archivelog mode******************** rem !!!todo!!! set drive according to server properties

0467-ICS Dover Air Force Base Page 115 of 206

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1="location=I:\ORACLE\ORADATA\ARCHIVE"

SCOPE=SPFILE;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE SCOPE=SPFILE;

ALTER SYSTEM SET LOG_ARCHIVE_FORMAT="arcr_%t_%s_%r.arc" SCOPE=SPFILE;

SPOOL OFF;

Check the log files for any errors and if necessary repeat the script execution.

0467-ICS Dover Air Force Base Page 116 of 206

5.4.5. Server-1 - Database Custom Scripts Creation

This chapter has to be performed if there are no template scripts (as used in the chapter before) created by an earlier usage of the Database Configuration Assistant.

Create the database and the template scripts with the “Oracle Database Configuration

Assistant”:

Figure 39: Create Database – Step-1

0467-ICS Dover Air Force Base Page 117 of 206

Figure 40: Create Database– Step-2 Transaction Template

Figure 41: Create Database – Step-3 Global database name and SID

0467-ICS Dover Air Force Base Page 118 of 206

Figure 42: Create Database – Step-4 Management options

Figure 43: Create Database – Step-5 Database Credentials

0467-ICS Dover Air Force Base Page 119 of 206

Figure 44: Create Database – Step-6 Storage Options

Figure 45: Create Database – Step-7 Database File Locations

0467-ICS Dover Air Force Base Page 120 of 206

Figure 46: Create Database – Step-8 Recovery Configuration

0467-ICS Dover Air Force Base Page 121 of 206

Select from the directory “G:\Unitechnik\Warehouse\P0410437_ICM_Dover_AFB

\db\OracleAdmin\scripts” the file “OraConfig-UniWare.sql”:

Figure 47: Create Database – Step-9 Run Custom Script

0467-ICS Dover Air Force Base Page 122 of 206

Figure 48: Create Database – Step-10 Init Parameters Memory

Figure 49: Create Database – Step-10 Init Parameters Sizing

0467-ICS Dover Air Force Base Page 123 of 206

Figure 50: Create Database – Step-10 Init Parameters Char Sets

Figure 51: Create Database – Step-10 Init Parameters Connection Mode

0467-ICS Dover Air Force Base Page 124 of 206

Figure 52: Create Database– Set Variables of File Locations

0467-ICS Dover Air Force Base Page 125 of 206

The File Directory names must contain the backslash “\”.

Sometimes Oracle changes this to slash “/”.

Figure 53: Create Database – Step-11 Control Files

0467-ICS Dover Air Force Base Page 126 of 206

Figure 54: Oracle Create Database – Step 11 Data Files

0467-ICS Dover Air Force Base Page 127 of 206

Define for each redo log group a second member with file location variable

UNIWARE_BASE2.

Figure 55: Create Database – Step 11 Redo Log Groups

Select the hooks “Create Database” and “Generate Database Creation Scripts” to create the template scripts. This avoids the usage of the Database Configuration Assistant for the repeated creation of the project database.

0467-ICS Dover Air Force Base Page 128 of 206

Figure 56: Create Database – Step-12 Creation Options

0467-ICS Dover Air Force Base Page 129 of 206

Figure 57: Create Database – Creation Progress

0467-ICS Dover Air Force Base Page 130 of 206

Figure 58: Create Database – Database Creation Complete

The Database Control URL is “http://ICSDATABASE:5500/em”. To use the correct port, check the file “C:\oracle\Ora10g\install\PortList.ini”!

0467-ICS Dover Air Force Base Page 131 of 206

5.4.6. initUNIWARE.ORA and spfileUNIWARE.ORA

Oracle Fail Safe requires that the parameter file be a text initialization parameter file (PFILE). To use a binary server parameter file (SPFILE) with Oracle10g databases configured for high availability, specify the location of the SPFILE from within the PFILE using the

SPFILE=<SPFILE-location> parameter.

Edit the “initUNIWARE.ora” (C:\Oracle\ora10g\Database) in the way that it points to the server side PFILE “init2UNIWARE.ora”, which is located on the shared drive array

(H:\Oracle\Ora10g\Database):

IFILE='H:\Oracle\Ora10g\Database\init2UNIWARE.ora' local_listener="(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.5)(PORT=1521))"

The second line is added automatically during the Fail Safe setup.

This second PFILE is used to avoid problems during Fails Safe setup accessing the PFILE. The file “init2UNIWARE.ora” points to the file “SPFILEUNIWARE.ORA” (binary server parameter file), which is located on the shared drive array (H:\Oracle\Ora10g\Database):

SPFILE='H:\oracle\Ora10g\Database\spfileUNIWARE.ora'

Move the SPFILE “spfileUNIWARE.ora” from C:\Oracle\Ora10g\Database to

H:\Oracle\Ora10g\Database!

c:\Oracle\Ora10g\Database\ initUNIWARE.ora h:\Oracle\Ora10g\Database\ init2UNIWARE.ora h:\Oracle\Ora10g\Database\ spfileUNIWARE.ora

0467-ICS Dover Air Force Base Page 132 of 206

5.5. Oracle Patch - Standard Edition Release 10.2.0.2.0

The following chapter is an extract of the “Patch Set Notes

10g Release 2 (10.2.0.2) Patch Set for Microsoft Windows (32-Bit)

February 2006”:

5.5.1. Preinstallation Tasks (on both Servers)

Complete the following preinstallation tasks before installing the patch set:

5.5.1.1. Stop All Services

Stop all listeners and other processes running in the Oracle home directory, where you need to install the patch set.

If you are upgrading a single instance installation, shut down the following Oracle Database 10g processes before installing the patch set:

Note:

You must perform these steps in the order listed.

1. Shut down all processes in the Oracle home that might be accessing a database, for example Oracle Enterprise Manager Database Control or iSQL*Plus.

2. Shut down all database instances running in the Oracle home directory, where you need to install the patch set.

3. Shut down all listeners running in the Oracle home directory, where you need to install the patch set.

5.5.2. Installation Tasks (on both Servers)

To install the Oracle Database 10g patch set interactively:

1. Log on as a member of the Administrators group to the computer on which to install Oracle components. If you are installing on a Primary Domain Controller (PDC) or a Backup

Domain Controller (BDC), log on as a member of the Domain Administrators group.

0467-ICS Dover Air Force Base Page 133 of 206

2. Start Oracle Universal Installer located in the unzipped area of the patch set. For example, Oracle_patch\setup.exe.

3. On the Welcome screen, click Next.

4. On the Specify File Locations screen, click Browse next to the Path field in the Source section.

5. Select the products.xml file from the stage directory where you extracted the patch set files, then click Next. For example:

6. C:\Oracle_patch> Oracle_patch\stage\products.xml

7. In the Name field in the Destination section, select the 10.2.0.x Oracle home that you want to update from the drop down list, then click Next.

8. On the Summary screen, click Install.

When the installation is complete, the End of Installation screen appears.

9. On the End of Installation screen, click Exit, then click Yes to exit from Oracle Universal

Installer.

5.5.3. Postinstallation Tasks (only for the database on one Server)

5.5.3.1. Upgrade the Release 10.2 Database

After you install the patch set, you must perform the following steps on every database associated with the upgraded Oracle home:

Note:

If you do not run the catupgrd.sql script as described in this section and you start up a database for normal operation, then ORA-01092:

ORACLE instance terminated. Disconnection forced errors will occur and the error ORA-39700: database must be opened with UPGRADE option will be in the alert log.

1. Log in with administrator privileges.

0467-ICS Dover Air Force Base Page 134 of 206

2. For single-instance installations, start the listener as follows:

$ lsnrctl start

3. For single-instance installations, use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:

C:\> sqlplus /NOLOG

SQL> CONNECT SYS/password AS SYSDBA

4. Enter the following SQL*Plus commands:

SQL> STARTUP UPGRADE

SQL> SPOOL patch.log

SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catupgrd.sql

SQL> SPOOL OFF

5. Review the patch.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script.

This list provides the version and status of each SERVER component in the database.

6. If necessary, rerun the catupgrd.sql script after correcting any problems.

7. Restart the database:

SQL> SHUTDOWN

SQL> STARTUP

8. Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.

SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql

Note:

When the 10.2.0.2 patch set is applied to an Oracle Database 10g Standard

Edition database or Standard Edition One database, there may be 42 invalid objects after the utlrp.sql script runs. These objects belong to the unsupported components and do not affect the database operation.

Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following:

0467-ICS Dover Air Force Base Page 135 of 206

5.6. Create OracleDBConsole on Server-2

After moving the cluster groups to the second node, you must create the OracleDBConsole service by using the “Database Configuration Assistant”.

This configuration creates the also the directory “C:\oracle\ora10g\ICSDATABASE_UNIWARE”:

Figure 59: DbConfigAssistant – Configure Database Options

Click here and on the following tabs “Next”. Do not make any changes!

That the assistant detects a modification just set a hook at any option and reset. On the last page, press finish to create the new console.

0467-ICS Dover Air Force Base Page 136 of 206

If the DBConsole already exists, you can drop the service and the data files with following command: emca –deconfig dbcontrol db –repos drop

5.7. Cluster Administrator – Configuration-2

To avoid timeout failure during the system boot of starting the OracleDBConsole as a normal service and to provide the console on the other node after fail over, you must create a new resource in the Database Group with resource type “Generic Service”.

The startup mode of the existing service has to be set to “Manual” using the Control Panel, because now the cluster manager controls starting and stopping.

Figure 60: OracleDBConsole - General

0467-ICS Dover Air Force Base Page 137 of 206

Figure 61: OracleDBConsole - Dependencies

0467-ICS Dover Air Force Base Page 138 of 206

Figure 62: OracleDBConsole - Advanced

0467-ICS Dover Air Force Base Page 139 of 206

Figure 63: OracleDBConsole - Parameters

0467-ICS Dover Air Force Base Page 140 of 206

Figure 64: OracleDBConsole - Registry

5.8. Oracle Fail Safe Release 3.3.4

5.8.1. Preinstallation Checks

Check if the folder “C:\Oracle\admin\UNIWARE\...” already exists on Server-2.

If not, copy the folder from Server-1 to Server-2.

Make sure that the files LISTENER.ORA and TNSNAMES.ORA exist on Server-2.

5.8.2. Installation

Failsafe handles the high availability of Oracle Database running on Microsoft cluster.

NOTE: Install Oracle Fail Safe on all cluster nodes. The nodes have to be rebooted after the installation has been finished.

0467-ICS Dover Air Force Base Page 141 of 206

Figure 65: Oracle Fail Safe - Install

0467-ICS Dover Air Force Base Page 142 of 206

Figure 66: Oracle Fail Safe - Welcome

0467-ICS Dover Air Force Base Page 143 of 206

Figure 67: Oracle Fail Safe – File Locations

0467-ICS Dover Air Force Base Page 144 of 206

Figure 68: Oracle Fail Safe – Typical

0467-ICS Dover Air Force Base Page 145 of 206

Figure 69: Oracle Fail Safe – Reboot After Installation

0467-ICS Dover Air Force Base Page 146 of 206

Figure 70: Oracle Fail Safe - Summary

0467-ICS Dover Air Force Base Page 147 of 206

Figure 71: Oracle Fail Safe – MSCS Account

Figure 72: Oracle Fail Safe – Installation End

0467-ICS Dover Air Force Base Page 148 of 206

5.8.3. Setup

The following steps have to be executed only on one node!

Figure 73: Oracle Fail Manager – Setup

Figure 74: Oracle Fail Safe Manager– Add Cluster

0467-ICS Dover Air Force Base Page 149 of 206

Figure 75: Oracle Fail Safe Manager – Connect to the cluster

Verifying cluster “ICSCLUSTER” shows the following result:(sample from another projekt)

Versions: client = 3.3.3 server = 3.3.3 OS =

Operation: Verifying cluster "SE02CLUSTER" Starting Time: Jan 04, 2007 10:30:48 Elapsed Time: 0 minutes, 3 seconds

1 10:30:48 Starting clusterwide operation

2 10:30:49 > FS-10998:

3 10:30:49 FS-10500: SE02CMS : Starting verification of cluster

SE02CLUSTER

4 10:30:49 > FS-10998:

5 10:30:49 FS-10544: SE02CMS : Verifying the cluster quorum resource 6 10:30:49 > FS-10545: Cluster quorum resource IPSHA Disk G: is located at G:\MSCS\

0467-ICS Dover Air Force Base Page 150 of 206

7 10:30:49 > FS-10998:

8 10:30:49 FS-10660: SE02CMS : Gathering cluster information

9 10:30:50 > FS-10998:

10 10:30:50 FS-10660: SE02CMCS : Gathering cluster information

11 10:30:51 > FS-10998:

12 10:30:51 FS-10502: SE02CMS : Verifying the Oracle homes 13 10:30:51 > FS-10645: SE02CMS has home OfsHome33 in C:\Oracle\Ofs33 14 10:30:51 > FS-10645: SE02CMS has home OraHome10g in C:\oracle\Ora10g 15 10:30:51 > FS-10645: SE02CMCS has home OfsHome33 in C:\Oracle\Ofs33 16 10:30:51 > FS-10645: SE02CMCS has home OraHome10g in C:\oracle\ora10g

17 10:30:51 > FS-10998:

18 10:30:51 FS-10501: SE02CMS : Verifying the Oracle Services for MSCS installation 19 10:30:51 >>> FS-10652: SE02CMS has Oracle Services for MSCS version

3.3.4.0 installed in OfsHome33 20 10:30:51 >>> FS-10652: SE02CMCS has Oracle Services for MSCS version

3.3.4.0 installed in OfsHome33

21 10:30:51 > FS-10998:

22 10:30:51 FS-10650: SE02CMS : Verifying the Oracle Services for MSCS resource providers 23 10:30:51 > FS-10651: Verifying the Generic Service resource 24 10:30:51 >> FS-10665: Checking DLLs for resource provider

25 10:30:51 > FS-10998:

26 10:30:51 > FS-10651: Verifying the Oracle Management Agent resource 27 10:30:51 >> FS-10665: Checking DLLs for resource provider 28 10:30:51 >> FS-10667: Checking for software installation 29 10:30:51 ** WARNING : FS-10658: The Oracle Management Agent software is not installed on any of the cluster nodes

30 10:30:51 > FS-10998:

31 10:30:51 > FS-10651: Verifying the Oracle Intelligent Agent resource 32 10:30:51 >> FS-10665: Checking DLLs for resource provider 33 10:30:51 >> FS-10667: Checking for software installation 34 10:30:51 ** WARNING : FS-10658: The Oracle Intelligent Agent software is not installed on any of the cluster nodes

35 10:30:51 > FS-10998:

36 10:30:51 > FS-10651: Verifying the Oracle Application Server resource 37 10:30:51 >> FS-10665: Checking DLLs for resource provider 38 10:30:51 >> FS-10667: Checking for software installation 39 10:30:51 ** WARNING : FS-10658: The Oracle Application Server software is not installed on any of the cluster nodes

40 10:30:51 > FS-10998:

41 10:30:51 > FS-10651: Verifying the Oracle Database resource 42 10:30:51 >> FS-10665: Checking DLLs for resource provider

0467-ICS Dover Air Force Base Page 151 of 206

43 10:30:51 >> FS-10666: Checking for MSCS resource DLLs provided by Oracle 44 10:30:51 >> FS-10667: Checking for software installation 45 10:30:51 >>> FS-10652: SE02CMS has Oracle Database version 10.2.0 installed in OraHome10g 46 10:30:51 >>> FS-10652: SE02CMCS has Oracle Database version 10.2.0 installed in OraHome10g

47 10:30:51 > FS-10998:

48 10:30:51 FS-10503: SE02CMS : Verifying the network configuration 49 10:30:51 > FS-10510: Cluster Interconnect network on the cluster uses subnet 192.168.1.0 50 10:30:51 > FS-10510: Public Lan PLC network on the cluster uses subnet 172.31.20.0

51 10:30:51 > FS-10998:

52 10:30:51 > FS-10512: SE02CMS maps to 172.31.20.152, 192.168.1.2 on

SE02CMS

53 10:30:51 > FS-10512: SE02CMS maps to 172.31.20.152 on SE02CMCS

54 10:30:51 > FS-10998:

55 10:30:51 > FS-10512: SE02CMCS maps to 172.31.20.151, 192.168.1.1 on

SE02CMS

56 10:30:51 > FS-10512: SE02CMCS maps to 172.31.20.151, 192.168.1.1 on

SE02CMCS

57 10:30:51 > FS-10998:

58 10:30:51 > FS-10512: SE02DATABASE maps to 172.31.20.156 on SE02CMS 59 10:30:51 > FS-10512: SE02DATABASE maps to 172.31.20.156 on SE02CMCS

60 10:30:51 > FS-10998:

61 10:30:51 > FS-10512: SE02CLUSTER maps to 172.31.20.154 on SE02CMS 62 10:30:51 > FS-10512: SE02CLUSTER maps to 172.31.20.154 on SE02CMCS

63 10:30:51 > FS-10998:

64 10:30:51 The clusterwide operation completed successfully, however, the server reported some warnings.

0467-ICS Dover Air Force Base Page 152 of 206

Figure 76: Oracle Fail Safe – SE02CLUSTER

0467-ICS Dover Air Force Base Page 153 of 206

Figure 77: Oracle Fail Safe – Add Resource to Group

Right click on the tree entry “Cluster Resources” and select “Add Resource to Group”. Select the resource type “Oracle Database” and the above screen will be opened.

The entered Service Name has to exist in the TNSNAMES.ORA. If not, then add the service name by using the tool “Net Manager”. Use the following settings:

Service name = UNIWARE

Host name = 192.168.0.5 (corresponds to ICSDATABASE)

Port = 1521 (default)

Protocol = TCP/IP

The Parameter File is “C:\oracle\Ora10g\database\initUNIWARE.ora”. The file must exist on

BOTH nodes.

0467-ICS Dover Air Force Base Page 154 of 206

Figure 78: Oracle Fail Safe Manager – Database Authentification

0467-ICS Dover Air Force Base Page 155 of 206

Figure 79: Oracle Fail Safe Manager – Database Summary

0467-ICS Dover Air Force Base Page 156 of 206

Figure 80: Oracle Fail Safe Manager – Database Confirm YES

0467-ICS Dover Air Force Base Page 157 of 206

Figure 81: Oracle Fail Safe Manager – Add Database Successfully

Adding database shows the following result:

Versions: client = 3.3.3 server = 3.3.3 OS =

Operation: Adding resource "UNIWARE" to group "Database" Starting Time: Jan 04, 2007 12:21:08 Elapsed Time: 2 minutes, 41 seconds

1 12:21:08 Starting clusterwide operation 2 12:21:08 FS-10370: Adding the resource UNIWARE to group Database 3 12:21:08 FS-10371: SE02CMS : Performing initialization processing 4 12:21:08 FS-10371: SE02CMCS : Performing initialization processing 5 12:21:09 FS-10372: SE02CMS : Gathering resource owner information 6 12:21:09 FS-10372: SE02CMCS : Gathering resource owner information 7 12:21:09 FS-10373: SE02CMS : Determining owner node of resource

UNIWARE

8 12:21:09 FS-10374: SE02CMS : Gathering cluster information needed to perform the specified operation

0467-ICS Dover Air Force Base Page 158 of 206

9 12:21:09 FS-10374: SE02CMCS : Gathering cluster information needed to perform the specified operation 10 12:21:09 FS-10375: SE02CMS : Analyzing cluster information needed to perform the specified operation 11 12:21:09 >>> FS-10652: SE02CMS has Oracle Database version 10.2.0 installed in OraHome10g 12 12:21:09 >>> FS-10652: SE02CMCS has Oracle Database version 10.2.0 installed in OraHome10g 13 12:21:09 FS-10376: SE02CMS : Starting configuration of resource

UNIWARE

14 12:21:09 FS-10378: SE02CMS : Preparing for configuration of resource

UNIWARE

15 12:21:09 FS-10380: SE02CMS : Configuring virtual server information for resource UNIWARE 16 12:21:09 > FS-10496: Generating the Oracle Net migration plan for

UNIWARE

17 12:21:09 > FS-10490: Configuring the Oracle Net listener for UNIWARE 18 12:21:09 >> FS-10600: Oracle Net configuration file updated:

C:\ORACLE\ORA10G\NETWORK\ADMIN\LISTENER.ORA

19 12:21:09 >> FS-10606: Listener configuration updated in database parameter file: C:\oracle\Ora10g\database\initUNIWARE.ora 20 12:21:12 >> FS-10605: Oracle Net listener Fslse02database created 21 12:21:12 > FS-10491: Configuring the Oracle Net service name for

UNIWARE

22 12:21:12 >> FS-10600: Oracle Net configuration file updated:

C:\ORACLE\ORA10G\NETWORK\ADMIN\TNSNAMES.ORA

23 12:21:12 FS-10381: SE02CMS : Creating the resource information for resource UNIWARE 24 12:21:12 > FS-10424: Checking whether the database UNIWARE is online 25 12:21:26 > FS-10425: Querying the disks used by the database UNIWARE 26 12:21:26 ** WARNING : FS-10288: Parameter file C:\oracle\Ora10g\database\initUNIWARE.ora is not located on a cluster disk 27 12:21:26 ** WARNING : FS-10404: The database uses a nonclustered disk in one of the system parameters. Value of parameter is

C:\ORACLE\ADMIN\UNIWARE\ADUMP

28 12:21:26 ** WARNING : FS-10404: The database uses a nonclustered disk in one of the system parameters. Value of parameter is

C:\ORACLE\ADMIN\UNIWARE\BDUMP

29 12:21:27 ** WARNING : FS-10404: The database uses a nonclustered disk in one of the system parameters. Value of parameter is

C:\ORACLE\ADMIN\UNIWARE\CDUMP

30 12:21:27 ** WARNING : FS-10404: The database uses a nonclustered disk in one of the system parameters. Value of parameter is

C:\ORACLE\ADMIN\UNIWARE\UDUMP

31 12:21:27 > FS-10426: Adding the database resource UNIWARE to group Database

0467-ICS Dover Air Force Base Page 159 of 206

32 12:21:27 FS-10382: SE02CMS : Bringing resource UNIWARE online 33 12:22:03 FS-10385: SE02CMS : Completed configuration of resource

UNIWARE

34 12:22:03 FS-10376: SE02CMCS : Starting configuration of resource

UNIWARE

35 12:22:03 FS-10378: SE02CMCS : Preparing for configuration of resource

UNIWARE

36 12:22:03 FS-10383: SE02CMCS : Bringing the resource UNIWARE offline 37 12:22:16 FS-10482: SE02CMCS Moving group Database to SE02CMCS 38 12:22:16 > FS-10480: Starting to move group Database to SE02CMCS 39 12:22:16 > FS-10481: Performing resource-specific operations to prepare for the move operation 40 12:22:16 > FS-10482: Moving group Database to SE02CMCS 41 12:22:17 > FS-10483: Waiting for the operation to move group Database to SE02CMCS to complete 42 12:22:49 > FS-10484: Group Database successfully moved to SE02CMCS 43 12:22:49 FS-10380: SE02CMCS : Configuring virtual server information for resource UNIWARE 44 12:22:49 > FS-10496: Generating the Oracle Net migration plan for

UNIWARE

45 12:22:49 > FS-10490: Configuring the Oracle Net listener for UNIWARE 46 12:22:49 >> FS-10600: Oracle Net configuration file updated:

C:\ORACLE\ORA10G\NETWORK\ADMIN\LISTENER.ORA

47 12:22:49 >> FS-10606: Listener configuration updated in database parameter file: C:\oracle\Ora10g\database\initUNIWARE.ora 48 12:22:52 >> FS-10605: Oracle Net listener Fslse02database created 49 12:22:52 > FS-10491: Configuring the Oracle Net service name for

UNIWARE

50 12:22:52 >> FS-10600: Oracle Net configuration file updated:

C:\ORACLE\ORA10G\NETWORK\ADMIN\TNSNAMES.ORA

51 12:22:52 FS-10381: SE02CMCS : Creating the resource information for resource UNIWARE 52 12:22:52 > FS-10427: Creating database instance UNIWARE for Oracle Net service name UNIWARE 53 12:23:13 FS-10382: SE02CMCS : Bringing resource UNIWARE online 54 12:23:49 FS-10385: SE02CMCS : Completed configuration of resource

UNIWARE

55 12:23:49 > FS-11065: Starting move of group Database to preferred owner node 56 12:23:49 >> FS-11066: The preferred owner for group Database is not specified. The current node is the preferred owner 57 12:23:49 FS-10384: Resource UNIWARE was successfully added to group Database 58 12:23:49 The clusterwide operation completed successfully, however, the server reported some warnings.

0467-ICS Dover Air Force Base Page 160 of 206

Figure 82: Oracle Fail Safe Manager – Resources

0467-ICS Dover Air Force Base Page 161 of 206

5.9. Oracle Backup Concept

5.9.1. Full Backup Daily

The backup of the whole database includes the control file and all database files, which are part of a database. Complete database backups are the backup type occurring the most frequent. With this option the whole database is safeguarded suddenly. The safeguarding is carried out at a time if no transportation or optimizations be executed more. The backup of the whole database includes the control file and all database files, which are part of a database.

5.9.2. Archivelog-Mode and Files

An Oracle database can run into two modes:

Like the name NOARCHIVELOG already says -- : The Redo Logs aren't archived. The possibilities of an efficient restoration go down complete backup to the last one in the reason with that of course.

ARCHIVELOG : Logswitch to a new Redo unite Oracle as soon as lied makes, the previous Redo is lied archived. A Redo lied you can only then recycle also if it has been archived successfully. Archived Redo Logs together with the just current ones the put a complete history of all changes for online Redo Logs at the database. Oracle can comprehend all transactions completed by 'Commit' to exactly at the time of the bug with that.

One must also certainly take care that is in the archive lied target directory enough space for the archives Logs: Oracle stops if Logs doesn't have disk space for it for archives.

Archived it it is critical for the Redo Logs for a complete Datenbak-Recovery? One can have several copies of the archives Logs written also into different target directories.

5.9.3. Archivelog-Mode - Configuration

On the Home screen of the “DBConsole” click on the link “Disabled” under “High

Availability”.

0467-ICS Dover Air Force Base Page 162 of 206

Figure 83: Configuration - Recovery

Set the hook of the checkbox “ARCHIVELOG Mode” and press APPLY.

0467-ICS Dover Air Force Base Page 163 of 206

Figure 84: Media Recovery – Archivelog Mode

A restart of the database is required.

0467-ICS Dover Air Force Base Page 164 of 206

Figure 85: Media Recovery – Confirmation

5.9.4. RMAN Backup

Start the script “RMAN_BACKUP.CMD” as a “Scheduled Task”. The daily start time is now set to 23:30.

The script will perform a fullback up, clean up the archive log files and keeps the latest two backups.

RMAN cmdfile D:\Unitechnik\Warehouse\….\db\OracleAdmin\RMAN\RMAN_BACKUP.SQL log D:\Unitechnik\Warehouse\….\db\OracleAdmin\RMAN\RMAN_BACKUP.LOG

RMAN-BACKUP.SQL includes the following RMAN commands:

# Project: Dover Air Force Base

# 06-DEC-2006/Mi

0467-ICS Dover Air Force Base Page 165 of 206

#---- Mit Datenbank verbinden / Connect with database connect target sys/unite987@uniware;

#---- Nur die zwei jüngsten Backup's soll erhalten bleiben. / Only the two latest backups should be kept.

#---- Diese Anweiung muss nur einmal ausgeführt werden. / This statement has to be processed at least once.

configure retention policy to redundancy 2;

#---- Datenbank-Backup & ArchiveLog-Backup:

#---- Es werden ALLE ALogs ins Backup aufgenommen. / ALL Archive-Logs will be included into the backup.

#---- Anschliessend werden alle ALogs von der Festplatte gelöscht / All Archive-Logs will be deleted from the harddisk.

run allocate channel Channel1 type disk format 'I:\oracle\oradata\Backup\UNIWARE_%u_%p_%c';

backup ( database include current controlfile );

backup ( archivelog all delete all input );

allocate channel for maintenance device type disk;

#---- Überflüssige Backups löschen. / Delete obsolete Backups.

delete obsolete device type disk;

exit;

0467-ICS Dover Air Force Base Page 166 of 206

5.9.5. Task Scheduler as Cluster Resource

To avoid conflicts during the scheduled start of the RMAN_BACKP scripts on the passive node, the Task Scheduler service has to be controlled by the Cluster Administrator.

Set the Windows service “Task Scheduler” to MANUAL and create the cluster resource as a

“Generic Service” which depends on UNIWARE (Oracle Database).

0467-ICS Dover Air Force Base Page 167 of 206

5.10. Oracle Recovery

5.10.1. General

Exclusively a practised staff should execute the processing of a recovery of the database.

Furthermore it is unconditional to have basic SQL knowledge.

In principle, there are two ways to restore an Oracle database. The first way leads about the procedure over the console (DOS box), the second uses the Oracle Enterprise

Manager console. The processing with Oracle Enterprise Manager is described here.

The preconditions for a recovery are the created backup, saved Redo archive log files and a database built up with ARCHIVELOG (testable through: “archive log list " in the Sql

Worksheet).

As a result a complete and an incomplete recovery is possible. Which one at long last is the right one depends on the existing data

The complete recovery has to correct all transactions as a target in the database until the last current timestamp. On the other hand, either an incomplete arises consciously, if the administrator carries out the recovery for example until an event defined quite precisely or if the data of the backup allow only such a one (faulty backups or missing/faulty Redo Logs archived).

0467-ICS Dover Air Force Base Page 168 of 206

5.10.2. Detecting Of Database Errors And First Preparations

If the database is damaged and furthermore operational, then an error cannot be recognized immediately. Clear becomes it only during an access to the database, which normally "takes" itself offline according to a bug. The database stops at media error. All bugs of the database are distributed in the file “alert_uniware.log”.

If one tries to start the database with the instruction "Startup", then one or more bugs are displayed after the status "NoMount" or "Mount". These bugs point at different approaches.

After server crash one or more files can be damaged. These files are shown at the startup error message. All bugs and reports must be recorded! A saving of the file

“alert_uniware.log” is recommended.

The database should be started with status "MOUNT". All files should be checked whether available. Also in the Mount mode the SQL Worksheet can be started. Here you can display all file names by executing „select name from v$datafile“. Furthermore all

Controlfiles should be available („select name from v$controlfile“).

A check of all other files like Red Logs and archived Logs is also recommended (v$log, v$logfile).

General information are available by executing the query on v$database.

Processes, which are still connected with the database, could be detected by query on v$process.

0467-ICS Dover Air Force Base Page 169 of 206

5.10.3. Oracle Folder for Trace and Log Files

The Oracle database folder “\oracle\admin\uniware\” includes further folders like bdump, cdump and udump. If an aleret file “alert_uniware.log” is generated, then ths could be found in the folder bdump.

An extract if a control file is corrupt or missing:

Tue Aug 17 15:27:59 2004 /* OracleOEM */ ALTER DATABASE MOUNT Tue Aug 17 15:27:59 2004 ORA-00202: control file: 'D:\oracle\oradata\uniware\CONTROL02.CTL' ORA-27041: unable to open file OSD-04002: Datei kann nicht geöffnet werden / File could not be opened O/S-Error: (OS 2) Das System kann die angegebene Datei nicht finden. / The system cannot find the specified file.

Tue Aug 17 15:28:02 2004 ORA-205 signalled during: /* OracleOEM */ ALTER DATABASE MOUNT...

0467-ICS Dover Air Force Base Page 170 of 206

5.10.4. Recovery of the database via the OEM console

Open the Oracle Enterprise Manager Console.

Login with sysman/[password].

Select the database UniWare.

Login at the database with an account having “sysdba” rights.

Depending on status of the database everything or only some data can be recovered. This indicates that as recovery options the complete database or only parts can be restored.

With the recovery assistant options buttons don't always show the correct data defaults. Sometimes the options have to be deselected and selected again to get the correct setting!

5.10.4.1. Database Status „Shutdown“

If the database is shutdown, then no recovery actions could be started.

5.10.4.2. Database Status „NoMount“

The recovery of control files is wih this status possible. Each other recovery (media failure of data files) has to be executed in the “Mount” status.

During startup and detecting failure in the control files or files do not exist, then the database goes into the status “Nomount”.

If the Backup is in another location as shown, then change here.

By pressing “OK” the created job is added to the job queue. The info screen shows the script for using by RMAN:

run { allocate channel Channel1 type disk format 'C:\ORACLE\ORADATA\UNIWARE\backup\wwi_b_%u_%p_%c';

restore controlfile from autobackup;

sql "alter database mount";

0467-ICS Dover Air Force Base Page 171 of 206

After recovery of the control file from the backup, the database will switch to “Mount”. If there are further failures, then proceed with following steps.

5.10.4.3. Recovery with Database Status “Mount” and Mode

“Archivelog”

In case of media failure of the data files, the database could not be used. If this failure occurs, e.g. during startup of the server, then the database goes automatically into the status “Mount”.

A recovery of an entire database is a recovery of all database files that belong to a database. RMAN uses the backups and copies that you made earlier and restores the files to their correct locations. Then, it uses archived redo logs (if needed) to recover the database. You can recover the entire database to the latest time or to a point in time if the database is in ARCHIVELOG mode and MOUNT state. To restore and recover the database using the default disk channel, perform the following steps:

From the Backup Management menu, choose Recover to access the Recovery Wizard.On the Operation Selection page, select “Restore and recover”.

0467-ICS Dover Air Force Base Page 172 of 206

Figure 86: Database in ARCHIVELOG mode and Mount state

If it is not clear which parts of the database are corrupt and need a recovery, then select the option “Entire database”.

0467-ICS Dover Air Force Base Page 173 of 206

Figure 87: Recovery Selection Mount

If the timestamp is not known at which the failure occurred, then select the option “Recover to the latest time”.

If it is comprehensible, when the failure occurred, then specify a point-in-time in the past by giving a time, 0467-ICS Dover Air Force Base Page 174 of 206

Figure 88: Range Selection for Recover Database

Specify if you want to restore the files to a different location and rename them. You keep the corrupt files for a later analysis.

The parameter of the backup strategy are displayed, but could not be changed. Press finish to get a summary screen, which show at the end the RMAN script.

Press again finish to add the job to the queue.

Recovery Manager-Script:

run { allocate channel Channel1 type disk format 'C:\ORACLE\ORADATA\UNIWARE\backup\wwi_b_%u_%p_%c';

restore ( database);

recover database ;

The successful execution of the recovery job could be viewed in the Oracle Enterprise

Manager – Job History.

0467-ICS Dover Air Force Base Page 175 of 206

Figure 89: Job Detail View in the Console

0467-ICS Dover Air Force Base Page 176 of 206

5.10.5. Recovery of Rollback Segment

The functionality is not available in the Oracle Enterprise Manager.

Either during operation of the database or by an application query the message „Rollback

Segment Recovery Needed“ or similar is displayed. This means that one or more transactions are open, which could not be finished with COMMIT.

There can be the following reasons: A tablespace or a data file are offline or not existing.

By executing of „select tablespace_name, segment_id, status from dba_rollback_segs;“ it has to be checked, which segment is not okay.

Step-1: All tablespaces and dat files must be online (status in v$datafile). Which data file belongs to which tablespace: „select * from dba_tablespaces;“. If a file is offline, then bring online. If a file is missing, then restore.

Step-2: If this does not solve the problem, then the following event has be entered in the file “init.ora”:

„event = (10015 trace name context forever, level 10)

This setting produces a trace file, which includes the required information of the transaction, which Oracle wants to rollback. And more important which the obejct Oracle wants to assign the undo.

Step-3 : Shutwdown of the database. Attempt the following sequence:

“Shutdown normal” “Shutdown immediate” “Shutdown abort”

Step-4 : Startup the database.

An error ORA-1545 or another error can occur. If the database could not startup, then call the Oracle Customer Support.

Step-5: Check the folder, which has been defined by the parameter “user_dump_dest”, for a trace file, which has been created during startup.

Step-6: The trace file should include a message like from the recovery failure “TX(#,#) object#”. “TX(#,#)” refers to the transaction information. “object#” is the same as the object_id in sys.dba_objects.

0467-ICS Dover Air Force Base Page 177 of 206

Step-7: Execute the following query to detect, with which object Oracle trys the recovery:

„select owner, object_name, object_type, status from dba_objects where object_id=<object#>;”

Step-8: This object must be deleted, so that an UNDO could be executed. An export or backup could be necessary to perform a restore of the object, after a corrupt Rollback

Segment has been deleted.

Step-9: After deleteing the object remove the name of the Rollback Segement from the parameter „rollback_segments“ in the “init.ora” and respectively set the corresponding

Rollback Segement offline.

Step-10: The corresponding Rollback Segment must be dropped from the database.

If the error could not be solved, then error is in the actual Rollback Segment. Contact the Oracle Customer Support.

0467-ICS Dover Air Force Base Page 178 of 206

5.10.6. RMAN Job Scripts

If the Oracle Enterprise Manager is not available for what ever reasons, then it is possible to execute the scripts directly with RMAN.

Starting and login of RMAN:

Windows Start Menu Execute Enter „cmd“ and press enter Enter “rman target sys/[password]r@uniware”

Figure 90: Recovery Manager RMAN – Command Window

For scripts with date values, it has to be considered that the format is different then in the Oracle Enterprise Manager Console

0467-ICS Dover Air Force Base Page 179 of 206

5.10.6.1. Overview of the Functions

Status “Mount”

Modus “Archivelog”

Display and Selection

Options Renaming possible and selection of different location

Job

Restore and recovery

Entire Database Latest timestamp

Yes (1111)

Exact timestamp Yes (1112) Tablespaces Display of tablespace selection

Yes (1121)

Data files Display of data file(s) selection

Yes (1131)

Restore only Entire database Restore from latest backup Yes (1211)

From earlier backup

Yes (1212)

Tablespaces Display of tablespace selection

Restore from latest backup

Yes (12211)

From earlier backup

Yes (12212)

Data files Display of data file(s) selection

Restore from latest backup

Yes (12311)

From earlier backup

Yes (12312)

Archivelogs Selection of time range or SCN or log sequence no.

No (1241) further not comprehensib le

Recovery only Entire database Latest timestamp No (1311)

Defined timestamp

No (13121) further not comprehensib le

Tablespaces Display of tablespace selection

No (1321)

Data files Display of data file(s) selection

No (1331)

Data block only Corruption List No (1411) Data files Selection of data blocks by data…