Saturday, October 8, 2016

Step-by-Step Guide to Setting Up and Upgrading Oracle CCB Database with Patching and Schema Enhancements

Oracle’s Customer Care and Billing (CCB) platform is a robust utility solution. This post details a comprehensive process for validating, installing, configuring, and upgrading an Oracle CCB database instance—from validating components to applying patches and running schema upgrades. Whether provisioning a new instance or upgrading to a newer release, this guide will walk you through a tested, real-world workflow.

Step 1 : Check that the Spatial and Oracle Text have been installed with the Database.

SQL> column COMP_NAME format a60
SQL> column STATUS format a60
SQL> SELECT COMP_NAME,STATUS FROM DBA_REGISTRY WHERE COMP_NAME IN ('Spatial','Oracle Text');

COMP_NAME STATUS
------------------------------------------------------------ ------------------------------------------------------------
Spatial VALID
Oracle Text VALID

SQL>

==================================================================

Step 2 Create Tablespace for CCB Schema

==================================================================

We need to create the tablespace and Schema that will be used to store the CCB tables

SQL> CREATE TABLESPACE CISTS_DATA LOGGING DATAFILE

'/u03/app/oracle/oradata/OMCCB/cists01.dbf' SIZE 10240M REUSE

AUTOEXTEND ON

NEXT 8192K

MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL

UNIFORM SIZE 1M;

2 3 4 5 6 7

Tablespace created.

============================================================

Step 3 Create the User 's for CCB

=============================================================

`CIS_USER` – Limited Privilege User

This user is granted restricted access suitable for day-to-day CCB operations that don’t require elevated privileges. Ideal for application-level data modifications.

SQL> CREATE ROLE CIS_USER;

Role created.

CIS_READ – Read-Only Access

This role is used for reporting or monitoring purposes, where users only need to query data without making any changes.

SQL> CREATE ROLE CIS_READ;

Role created.

===

CISADM – Super User / Admin Schema Owner

This is the primary schema owner for the CCB application. It has full administrative rights, including table creation, schema modifications, and patching capabilities

SQL> CREATE USER CISADM IDENTIFIED BY CISADM DEFAULT TABLESPACE CISTS_DATA

TEMPORARY TABLESPACE TEMP PROFILE DEFAULT; 2

User created.

SQL>

SQL> GRANT UNLIMITED TABLESPACE TO CISADM WITH ADMIN OPTION;

Grant succeeded.

SQL> GRANT SELECT ANY TABLE TO CISADM;

Grant succeeded.

SQL> GRANT CREATE DATABASE LINK TO CISADM;

Grant succeeded.

SQL> GRANT CONNECT TO CISADM;

Grant succeeded.

SQL> GRANT RESOURCE TO CISADM;

Grant succeeded.

SQL> GRANT DBA TO CISADM WITH ADMIN OPTION;

Grant succeeded.

SQL> GRANT CREATE ANY SYNONYM TO CISADM;

Grant succeeded.

SQL> GRANT SELECT ANY DICTIONARY TO CISADM;

Grant succeeded.

SQL>

================================================================

Step 4: Apply CCB related Database Patches

=================================================================

Provide Patch Parameters:

Schema: CISADM
DB Connection: <Hostname of the database>:<DB port>:<CCB DB Name>
Environment: Production

C:\CCB\FW43010-HFix>SET TOOLSBIN=C:\CCB\database_standalone\bin

C:\CCB\FW43010-HFix>ouafDatabasePatch.cmd
"CMDLINE::: C:\Java\jdk1.7.0_79\bin\java.exe -cp C:\CCB\database_standalone\lib\*;C:\CCB\database_standalone\config com.oracle.ouaf.database.patch.OUAFPatch "

Enter the target database type (O/M/D) [O]:

Enter the username that owns the schema: CISADM

Enter the password for the CISADM user:

Enter the name of the Oracle Database Connection String: omccb.Domain.com:1533:CCDDB

Target Schema is a Production Schema

Ready to process patches, Do you want to continue? (Y/N): Y

Working Directory: OMCCB001

***********************************

Setting up language file: OMCCB001\CDXPatch.lang
exit value: 0

Applying 21647369 ...

Writing to log file: OMCCB001\log21647369.log

-----------------------------------------------------------

--Applying patch 21647369 at 06-09-2016 15:06:02

---------------------------------------------------------------

--Copying language information

-----------------------------------------------------------

--Patch 21647369 applied successfully at 06-09-2016 15:06:02

---------------------------------------------------------------

Applying 21196697 ...

Writing to log file: OMCCB001\log21196697.log

-----------------------------------------------------------

--Applying patch 21196697 at 06-09-2016 15:06:02

---------------------------------------------------------------

--Copying language information

-----------------------------------------------------------

--Patch 21196697 applied successfully at 06-09-2016 15:06:03

---------------------------------------------------------------

Applying 21792146 ...

Writing to log file: OMCCB001\log21792146.log

-----------------------------------------------------------

--Applying patch 21792146 at 06-09-2016 15:06:03

---------------------------------------------------------------

--Copying language information

-----------------------------------------------------------

--Patch 21792146 applied successfully at 06-09-2016 15:06:05

---------------------------------------------------------------

Patch applied successfully..

C:\CCB\FW43010-HFix>

====================================================================

Step 5 CCB Schema Install and Upgrade in the database

=====================================================================

execute the OraDBI.exe

C:\Users\Palane\Downloads\Compressed\New folder\CCB\V78183-01\CCB-V2.5.0.1.0-Oracle-Database-MultiplatForm\CCB\Upgrade\Install-Upgrade>OraDBI.exe

Enter the name of the target database: OMCCB

Enter your database username: CISADM

Enter your password username:

Enter the location for Java Home(e.g. C:\Java\jdk1.6.0_18): C:\Java\jdk1.7.0_79

Enter the TUGBU jarfiles location (e.g.C:\Database-Install\Jarfiles): C:\CCB\jarfiles

Enter the Oracle user with read-write privileges to Database Schema: CISUSER

Enter the Oracle user with read-only privileges to Database Schema: CISREAD

Enter the database role with read-write privileges to Database Schema: CIS_USER

Enter the database role with read-only privileges to Database Schema: CIS_READ

Enter the name of the target Schema where you want to install or upgrade: CISADM
Enter the password for CISADM schema (or hit ENTER to quit):
Re-enter the value:

Connecting to the Target Database as user CISADM
User Name : CISADM
Database Name : OMCCB

Ready to upgrade the target database from V2.5.0.1.0 to V2.5.0.1.0, do you want to continue (Y/N)? Y

Executing Database Setup Scripts...

Processing file cdx_bp_crtlog.sql ...

Connecting to the Target Database as user CISADM
User Name : CISADM
Database Name : OMCCB

Executing Initialization Scripts...

Processing file CCB230_BPSCHEMA1.SQL ...

Processing file CCB_240_INI_SCH1.SQL ...

Processing file CCB231_BPSCHEMA1.SQL ...

Processing file CCB240_bpschema3.sql ...

Processing file CCB2401_BpSchema1.sql ...

Processing file 24020_C1_BP_BpSchema1.sql ...

Processing file 24020_C1_BP_BpSchema2.SQL ...

Processing file 25010_C1_BP_BpSchema1.SQL ...

Performing Schema Upgrade for CCB...

Running the Schema Upgrade process in the Modification Mode

Connecting to the Target Database
User Name : CISADM
Database Name : OMCCB
Schema Name : CISADM

Setting Current Schema to CISADM
Loading Blueprint
Loading the schema information from the target database
Creating the missing tables
Upgrading the columns
Upgrading indexes
Upgrading Primary Keys
Upgrading the sequences
Upgrading the views
Upgrading the triggers
Schema Upgraded Successfully, Now Exiting

Executing Intermediate Scripts...

Processing file 6683177_RS1.SQL ...

Processing file CCB220_APDATA1.SQL ...

Processing file CCB220_APDATA2.SQL ...

Processing file CCB220_APDATA3.SQL ...

Processing file CDX_AP_INIDATA.SQL ...

Processing file CCB230_APDATA1.SQL ...

Processing file CCB230_APDATA2.SQL ...

Processing file CCB231_APDATA1.SQL ...

Processing file CCB240_APDATA1.SQL ...

Processing file CCB240_APDATA2.SQL ...

Processing file CCB240_APDATA3.SQL ...

Processing file CCB240_APDATA4.SQL ...

Processing file CCB240_appdata_Bld22.sql ...

Processing file 14510546_RS1.sql ...

Processing file CCB240_BP_SCH2.SQL ...

Processing file 24030_BUG_20878127.SQL ...

Processing file 24030_BUG_21165656.SQL ...

Setting Environment ID...

******************************************
Executing the Environment ID Setup Process
******************************************

Connecting to the Target Database ...
User Name : CISADM
Database Name : OMCCB
Schema Name : CISADM

Setting Current Schema to CISADM
The Environment ID of the target database is already set to 200164.

Environment ID Setup Process completed successfully, Now Exiting ...

Auto Delete Upgrade for CCB...

Running Auto System Data Deletion process in Modification Mode

Connecting to the Target Database
User Name : CISADM
Database Name : OMCCB
Schema Name : CISADM

Setting Current Schema to CISADM
Reading Blueprint
Loading CI_ALG_TYPE from the blueprint
Loading CI_ALG_TYPE from the target database
Comparing CI_ALG_TYPE
Loading CI_ALG_TYPE_L from the blueprint
Loading CI_ALG_TYPE_L from the target database
Comparing CI_ALG_TYPE_L
Loading CI_ALG_TYPE_PRM from the blueprint
Loading CI_ALG_TYPE_PRM from the target database
Comparing CI_ALG_TYPE_PRM
Loading CI_ALG_TYPE_PRM_L from the blueprint
Loading CI_ALG_TYPE_PRM_L from the target database
Comparing CI_ALG_TYPE_PRM_L
Loading CI_APP_SVC_ACC from the blueprint
Loading CI_APP_SVC_ACC from the target database
Comparing CI_APP_SVC_ACC
Loading CI_BATCH_CTRL from the blueprint
Loading CI_BATCH_CTRL from the target database
Comparing CI_BATCH_CTRL
Loading CI_BATCH_CTRL_L from the blueprint
Loading CI_BATCH_CTRL_L from the target database
Comparing CI_BATCH_CTRL_L
Loading CI_BATCH_CTRL_ALG from the blueprint
Loading CI_BATCH_CTRL_ALG from the target database
Comparing CI_BATCH_CTRL_ALG
Loading CI_BATCH_CTRL_P from the blueprint
Loading CI_BATCH_CTRL_P from the target database
Comparing CI_BATCH_CTRL_P
Loading CI_BATCH_CTRL_P_L from the blueprint
Loading CI_BATCH_CTRL_P_L from the target database
Comparing CI_BATCH_CTRL_P_L
Loading CI_DISP_ICON from the blueprint
Loading CI_DISP_ICON from the target database
Comparing CI_DISP_ICON
Loading CI_DISP_ICON_L from the blueprint
Loading CI_DISP_ICON_L from the target database
Comparing CI_DISP_ICON_L
Loading CI_FK_REF from the blueprint
Loading CI_FK_REF from the target database
Comparing CI_FK_REF
Loading CI_FK_REF_L from the blueprint
Loading CI_FK_REF_L from the target database
Comparing CI_FK_REF_L
Loading CI_LANGUAGE from the blueprint
Loading CI_LANGUAGE from the target database
Comparing CI_LANGUAGE
Loading CI_LOOKUP_FIELD from the blueprint
Loading CI_LOOKUP_FIELD from the target database
Comparing CI_LOOKUP_FIELD
Loading CI_LOOKUP_VAL from the blueprint
Loading CI_LOOKUP_VAL from the target database
Comparing CI_LOOKUP_VAL
Loading CI_LOOKUP_VAL_L from the blueprint
Loading CI_LOOKUP_VAL_L from the target database
Comparing CI_LOOKUP_VAL_L
Loading CI_MD_CONST from the blueprint
Loading CI_MD_CONST from the target database
Comparing CI_MD_CONST
Loading CI_MD_CONST_FLD from the blueprint
Loading CI_MD_CONST_FLD from the target database
Comparing CI_MD_CONST_FLD
Loading CI_MD_FLD from the blueprint
Loading CI_MD_FLD from the target database
Comparing CI_MD_FLD
Loading CI_MD_FLD_L from the blueprint
Loading CI_MD_FLD_L from the target database
Comparing CI_MD_FLD_L
Loading CI_MD_MENU from the blueprint
Loading CI_MD_MENU from the target database
Comparing CI_MD_MENU
Loading CI_MD_MENU_L from the blueprint
Loading CI_MD_MENU_L from the target database
Comparing CI_MD_MENU_L
Loading CI_MD_MENU_LINE from the blueprint
Loading CI_MD_MENU_LINE from the target database
Comparing CI_MD_MENU_LINE
Loading CI_MD_MENU_LINE_L from the blueprint
Loading CI_MD_MENU_LINE_L from the target database
Comparing CI_MD_MENU_LINE_L
Loading CI_MD_MENU_ITEM from the blueprint
Loading CI_MD_MENU_ITEM from the target database
Comparing CI_MD_MENU_ITEM
Loading CI_MD_MENU_ITEM_L from the blueprint
Loading CI_MD_MENU_ITEM_L from the target database
Comparing CI_MD_MENU_ITEM_L
Loading CI_MD_MENU_IMOD from the blueprint
Loading CI_MD_MENU_IMOD from the target database
Comparing CI_MD_MENU_IMOD
Loading CI_MD_MO from the blueprint
Loading CI_MD_MO from the target database
Comparing CI_MD_MO
Loading CI_MD_MO_L from the blueprint
Loading CI_MD_MO_L from the target database
Comparing CI_MD_MO_L
Loading CI_MD_MO_TBL from the blueprint
Loading CI_MD_MO_TBL from the target database
Comparing CI_MD_MO_TBL
Loading CI_MD_MO_WRK from the blueprint
Loading CI_MD_MO_WRK from the target database
Comparing CI_MD_MO_WRK
Loading CI_MD_MO_OPT from the blueprint
Loading CI_MD_MO_OPT from the target database
Comparing CI_MD_MO_OPT
Loading CI_MD_NAV from the blueprint
Loading CI_MD_NAV from the target database
Comparing CI_MD_NAV
Loading CI_MD_PRG_COM from the blueprint
Loading CI_MD_PRG_COM from the target database
Comparing CI_MD_PRG_COM
Loading CI_MD_PRG_ELEM from the blueprint
Loading CI_MD_PRG_ELEM from the target database
Comparing CI_MD_PRG_ELEM
Loading CI_MD_PRG_EL_AT from the blueprint
Loading CI_MD_PRG_EL_AT from the target database
Comparing CI_MD_PRG_EL_AT
Loading CI_MD_PRG_LOC from the blueprint
Loading CI_MD_PRG_LOC from the target database
Comparing CI_MD_PRG_LOC
Loading CI_MD_PRG_MOD from the blueprint
Loading CI_MD_PRG_MOD from the target database
Comparing CI_MD_PRG_MOD
Loading CI_MD_PRG_SEC from the blueprint
Loading CI_MD_PRG_SEC from the target database
Comparing CI_MD_PRG_SEC
Loading CI_MD_PRG_SQL from the blueprint
Loading CI_MD_PRG_SQL from the target database
Comparing CI_MD_PRG_SQL
Loading CI_MD_PRG_TAB from the blueprint
Loading CI_MD_PRG_TAB from the target database
Comparing CI_MD_PRG_TAB
Loading CI_MD_PRG_VAR from the blueprint
Loading CI_MD_PRG_VAR from the target database
Comparing CI_MD_PRG_VAR
Loading CI_MD_SO from the blueprint
Loading CI_MD_SO from the target database
Comparing CI_MD_SO
Loading CI_MD_SO_L from the blueprint
Loading CI_MD_SO_L from the target database
Comparing CI_MD_SO_L
Loading CI_MD_SO_RSFLD from the blueprint
Loading CI_MD_SO_RSFLD from the target database
Comparing CI_MD_SO_RSFLD
Loading CI_MD_SO_RSFLDAT from the blueprint
Loading CI_MD_SO_RSFLDAT from the target database
Comparing CI_MD_SO_RSFLDAT
Loading CI_MD_SOCG from the blueprint
Loading CI_MD_SOCG from the target database
Comparing CI_MD_SOCG
Loading CI_MD_SOCG_FLD from the blueprint
Loading CI_MD_SOCG_FLD from the target database
Comparing CI_MD_SOCG_FLD
Loading CI_MD_SOCG_FLDAT from the blueprint
Loading CI_MD_SOCG_FLDAT from the target database
Comparing CI_MD_SOCG_FLDAT
Loading CI_MD_SOCG_L from the blueprint
Loading CI_MD_SOCG_L from the target database
Comparing CI_MD_SOCG_L
Loading CI_MD_SOCG_SORT from the blueprint
Loading CI_MD_SOCG_SORT from the target database
Comparing CI_MD_SOCG_SORT
Loading CI_MD_SVC from the blueprint
Loading CI_MD_SVC from the target database
Comparing CI_MD_SVC
Loading CI_MD_SVC_L from the blueprint
Loading CI_MD_SVC_L from the target database
Comparing CI_MD_SVC_L
Loading CI_MD_SVC_PRG from the blueprint
Loading CI_MD_SVC_PRG from the target database
Comparing CI_MD_SVC_PRG
Loading CI_MD_TAB_MOD from the blueprint
Loading CI_MD_TAB_MOD from the target database
Comparing CI_MD_TAB_MOD
Loading CI_MD_TBL from the blueprint
Loading CI_MD_TBL from the target database
Comparing CI_MD_TBL
Loading CI_MD_TBL_FLD from the blueprint
Loading CI_MD_TBL_FLD from the target database
Comparing CI_MD_TBL_FLD
Loading CI_MD_TBL_FLD_L from the blueprint
Loading CI_MD_TBL_FLD_L from the target database
Comparing CI_MD_TBL_FLD_L
Loading CI_MD_TBL_L from the blueprint
Loading CI_MD_TBL_L from the target database
Comparing CI_MD_TBL_L
Loading CI_MD_WRK_TBL from the blueprint
Loading CI_MD_WRK_TBL from the target database
Comparing CI_MD_WRK_TBL
Loading CI_MD_WRK_TBLFLD from the blueprint
Loading CI_MD_WRK_TBLFLD from the target database
Comparing CI_MD_WRK_TBLFLD
Loading CI_MD_WRK_TBL_L from the blueprint
Loading CI_MD_WRK_TBL_L from the target database
Comparing CI_MD_WRK_TBL_L
Loading CI_MSG from the blueprint
Loading CI_MSG from the target database
Comparing CI_MSG
Loading CI_MSG_CATEGORY from the blueprint
Loading CI_MSG_CATEGORY from the target database
Comparing CI_MSG_CATEGORY
Loading CI_MSG_CATEGORY_L from the blueprint
Loading CI_MSG_CATEGORY_L from the target database
Comparing CI_MSG_CATEGORY_L
Loading CI_MSG_L from the blueprint
Loading CI_MSG_L from the target database
Comparing CI_MSG_L
Loading CI_NAV_OPT from the blueprint
Loading CI_NAV_OPT from the target database
Comparing CI_NAV_OPT
Loading CI_NAV_OPT_CTXT from the blueprint
Loading CI_NAV_OPT_CTXT from the target database
Comparing CI_NAV_OPT_CTXT
Loading CI_NAV_OPT_L from the blueprint
Loading CI_NAV_OPT_L from the target database
Comparing CI_NAV_OPT_L
Loading CI_NAV_OPT_USG from the blueprint
Loading CI_NAV_OPT_USG from the target database
Comparing CI_NAV_OPT_USG
Loading CI_PORTAL from the blueprint
Loading CI_PORTAL from the target database
Comparing CI_PORTAL
Loading CI_PORTAL_L from the blueprint
Loading CI_PORTAL_L from the target database
Comparing CI_PORTAL_L
Loading CI_PORTAL_ZONE from the blueprint
Loading CI_PORTAL_ZONE from the target database
Comparing CI_PORTAL_ZONE
Loading CI_TD_DRLKEY_TY from the blueprint
Loading CI_TD_DRLKEY_TY from the target database
Comparing CI_TD_DRLKEY_TY
Loading CI_TD_SRTKEY_TY from the blueprint
Loading CI_TD_SRTKEY_TY from the target database
Comparing CI_TD_SRTKEY_TY
Loading CI_TD_SRTKEY_TY_L from the blueprint
Loading CI_TD_SRTKEY_TY_L from the target database
Comparing CI_TD_SRTKEY_TY_L
Loading CI_TD_TYPE from the blueprint
Loading CI_TD_TYPE from the target database
Comparing CI_TD_TYPE
Loading CI_TD_TYPE_L from the blueprint
Loading CI_TD_TYPE_L from the target database
Comparing CI_TD_TYPE_L
Loading CI_XAI_ADAPTER from the blueprint
Loading CI_XAI_ADAPTER from the target database
Comparing CI_XAI_ADAPTER
Loading CI_XAI_ADAPTER_L from the blueprint
Loading CI_XAI_ADAPTER_L from the target database
Comparing CI_XAI_ADAPTER_L
Loading CI_XAI_CLASS from the blueprint
Loading CI_XAI_CLASS from the target database
Comparing CI_XAI_CLASS
Loading CI_XAI_CLASS_L from the blueprint
Loading CI_XAI_CLASS_L from the target database
Comparing CI_XAI_CLASS_L
Loading CI_XAI_ENV_HNDL from the blueprint
Loading CI_XAI_ENV_HNDL from the target database
Comparing CI_XAI_ENV_HNDL
Loading CI_XAI_ENV_HNDL_L from the blueprint
Loading CI_XAI_ENV_HNDL_L from the target database
Comparing CI_XAI_ENV_HNDL_L
Loading CI_XAI_FORMAT from the blueprint
Loading CI_XAI_FORMAT from the target database
Comparing CI_XAI_FORMAT
Loading CI_XAI_FORMAT_L from the blueprint
Loading CI_XAI_FORMAT_L from the target database
Comparing CI_XAI_FORMAT_L
Loading CI_XAI_IN_SVC from the blueprint
Loading CI_XAI_IN_SVC from the target database
Comparing CI_XAI_IN_SVC
Loading CI_XAI_IN_SVC_L from the blueprint
Loading CI_XAI_IN_SVC_L from the target database
Comparing CI_XAI_IN_SVC_L
Loading CI_XAI_SVC_PARM from the blueprint
Loading CI_XAI_SVC_PARM from the target database
Comparing CI_XAI_SVC_PARM
Loading CI_ZONE from the blueprint
Loading CI_ZONE from the target database
Comparing CI_ZONE
Loading CI_ZONE_L from the blueprint
Loading CI_ZONE_L from the target database
Comparing CI_ZONE_L
Loading CI_ZONE_HDL from the blueprint
Loading CI_ZONE_HDL from the target database
Comparing CI_ZONE_HDL
Loading CI_ZONE_HDL_L from the blueprint
Loading CI_ZONE_HDL_L from the target database
Comparing CI_ZONE_HDL_L
Loading CI_ZONE_HDL_PRM from the blueprint
Loading CI_ZONE_HDL_PRM from the target database
Comparing CI_ZONE_HDL_PRM
Loading CI_ZONE_HDL_PRM_L from the blueprint
Loading CI_ZONE_HDL_PRM_L from the target database
Comparing CI_ZONE_HDL_PRM_L
Loading CI_ZONE_PRM from the blueprint
Loading CI_ZONE_PRM from the target database
Comparing CI_ZONE_PRM
Loading SC_ACCESS_CNTL from the blueprint
Loading SC_ACCESS_CNTL from the target database
Comparing SC_ACCESS_CNTL
Loading SC_APP_SERVICE from the blueprint
Loading SC_APP_SERVICE from the target database
Comparing SC_APP_SERVICE
Loading SC_APP_SERVICE_L from the blueprint
Loading SC_APP_SERVICE_L from the target database
Comparing SC_APP_SERVICE_L
Loading SC_USR_GRP_PROF from the blueprint
Loading SC_USR_GRP_PROF from the target database
Comparing SC_USR_GRP_PROF
Loading F1_MD_DB_OBJ from the blueprint
Loading F1_MD_DB_OBJ from the target database
Comparing F1_MD_DB_OBJ
Loading CI_ALG from the blueprint
Loading CI_ALG from the target database
Comparing CI_ALG
Loading CI_ALG_L from the blueprint
Loading CI_ALG_L from the target database
Comparing CI_ALG_L
Loading CI_ALG_PARM from the blueprint
Loading CI_ALG_PARM from the target database
Comparing CI_ALG_PARM
Loading CI_ALG_VER from the blueprint
Loading CI_ALG_VER from the target database
Comparing CI_ALG_VER
Loading CI_CHAR_ENTITY from the blueprint
Loading CI_CHAR_ENTITY from the target database
Comparing CI_CHAR_ENTITY
Loading CI_CHAR_TYPE from the blueprint
Loading CI_CHAR_TYPE from the target database
Comparing CI_CHAR_TYPE
Loading CI_CHAR_TYPE_L from the blueprint
Loading CI_CHAR_TYPE_L from the target database
Comparing CI_CHAR_TYPE_L
Loading CI_CHAR_VAL from the blueprint
Loading CI_CHAR_VAL from the target database
Comparing CI_CHAR_VAL
Loading CI_CHAR_VAL_L from the blueprint
Loading CI_CHAR_VAL_L from the target database
Comparing CI_CHAR_VAL_L
Loading CI_MD_MO_ALG from the blueprint
Loading CI_MD_MO_ALG from the target database
Comparing CI_MD_MO_ALG
Loading CI_SCR from the blueprint
Loading CI_SCR from the target database
Comparing CI_SCR
Loading CI_SCR_CRT from the blueprint
Loading CI_SCR_CRT from the target database
Comparing CI_SCR_CRT
Loading CI_SCR_CRT_GRP from the blueprint
Loading CI_SCR_CRT_GRP from the target database
Comparing CI_SCR_CRT_GRP
Loading CI_SCR_CRT_GRP_L from the blueprint
Loading CI_SCR_CRT_GRP_L from the target database
Comparing CI_SCR_CRT_GRP_L
Loading CI_SCR_DA from the blueprint
Loading CI_SCR_DA from the target database
Comparing CI_SCR_DA
Loading CI_SCR_FLD_MAP from the blueprint
Loading CI_SCR_FLD_MAP from the target database
Comparing CI_SCR_FLD_MAP
Loading CI_SCR_L from the blueprint
Loading CI_SCR_L from the target database
Comparing CI_SCR_L
Loading CI_SCR_PRMPT from the blueprint
Loading CI_SCR_PRMPT from the target database
Comparing CI_SCR_PRMPT
Loading CI_SCR_PRMPT_L from the blueprint
Loading CI_SCR_PRMPT_L from the target database
Comparing CI_SCR_PRMPT_L
Loading CI_SCR_STEP from the blueprint
Loading CI_SCR_STEP from the target database
Comparing CI_SCR_STEP
Loading CI_SCR_STEP_L from the blueprint
Loading CI_SCR_STEP_L from the target database
Comparing CI_SCR_STEP_L
Loading CI_UI_ZONE from the blueprint
Loading CI_UI_ZONE from the target database
Comparing CI_UI_ZONE
Loading F1_BUS_OBJ from the blueprint
Loading F1_BUS_OBJ from the target database
Comparing F1_BUS_OBJ
Loading F1_BUS_OBJ_ALG from the blueprint
Loading F1_BUS_OBJ_ALG from the target database
Comparing F1_BUS_OBJ_ALG
Loading F1_BUS_OBJ_L from the blueprint
Loading F1_BUS_OBJ_L from the target database
Comparing F1_BUS_OBJ_L
Loading F1_BUS_OBJ_OPT from the blueprint
Loading F1_BUS_OBJ_OPT from the target database
Comparing F1_BUS_OBJ_OPT
Loading F1_BUS_OBJ_STATUS from the blueprint
Loading F1_BUS_OBJ_STATUS from the target database
Comparing F1_BUS_OBJ_STATUS
Loading F1_BUS_OBJ_STATUS_ALG from the blueprint
Loading F1_BUS_OBJ_STATUS_ALG from the target database
Comparing F1_BUS_OBJ_STATUS_ALG
Loading F1_BUS_OBJ_STATUS_L from the blueprint
Loading F1_BUS_OBJ_STATUS_L from the target database
Comparing F1_BUS_OBJ_STATUS_L
Loading F1_BUS_OBJ_STATUS_OPT from the blueprint
Loading F1_BUS_OBJ_STATUS_OPT from the target database
Comparing F1_BUS_OBJ_STATUS_OPT
Loading F1_BUS_OBJ_TR_RULE from the blueprint
Loading F1_BUS_OBJ_TR_RULE from the target database
Comparing F1_BUS_OBJ_TR_RULE
Loading F1_BUS_OBJ_TR_RULE_L from the blueprint
Loading F1_BUS_OBJ_TR_RULE_L from the target database
Comparing F1_BUS_OBJ_TR_RULE_L
Loading F1_BUS_SVC from the blueprint
Loading F1_BUS_SVC from the target database
Comparing F1_BUS_SVC
Loading F1_BUS_SVC_L from the blueprint
Loading F1_BUS_SVC_L from the target database
Comparing F1_BUS_SVC_L
Loading F1_DATA_AREA from the blueprint
Loading F1_DATA_AREA from the target database
Comparing F1_DATA_AREA
Loading F1_DATA_AREA_L from the blueprint
Loading F1_DATA_AREA_L from the target database
Comparing F1_DATA_AREA_L
Loading F1_MAP from the blueprint
Loading F1_MAP from the target database
Comparing F1_MAP
Loading F1_MAP_L from the blueprint
Loading F1_MAP_L from the target database
Comparing F1_MAP_L
Loading F1_SCHEMA from the blueprint
Loading F1_SCHEMA from the target database
Comparing F1_SCHEMA
Loading F1_MANAG_CONTENT from the blueprint
Loading F1_MANAG_CONTENT from the target database
Comparing F1_MANAG_CONTENT
Loading F1_MANAG_CONTENT_L from the blueprint
Loading F1_MANAG_CONTENT_L from the target database
Comparing F1_MANAG_CONTENT_L
Loading F1_BUS_OBJ_STATUS_RSN from the blueprint
Loading F1_BUS_OBJ_STATUS_RSN from the target database
Comparing F1_BUS_OBJ_STATUS_RSN
Loading F1_BUS_OBJ_STATUS_RSN_L from the blueprint
Loading F1_BUS_OBJ_STATUS_RSN_L from the target database
Comparing F1_BUS_OBJ_STATUS_RSN_L
Loading F1_BUS_OBJ_STATUS_RSN_CHAR from the blueprint
Loading F1_BUS_OBJ_STATUS_RSN_CHAR from the target database
Comparing F1_BUS_OBJ_STATUS_RSN_CHAR
Loading F1_EXT_LOOKUP_VAL from the blueprint
Loading F1_EXT_LOOKUP_VAL from the target database
Comparing F1_EXT_LOOKUP_VAL
Loading F1_EXT_LOOKUP_VAL_L from the blueprint
Loading F1_EXT_LOOKUP_VAL_L from the target database
Comparing F1_EXT_LOOKUP_VAL_L
Loading F1_DB_OBJECTS_REPO from the blueprint
Loading F1_DB_OBJECTS_REPO from the target database
Comparing F1_DB_OBJECTS_REPO
Loading F1_MIGR_PLAN from the blueprint
Loading F1_MIGR_PLAN from the target database
Comparing F1_MIGR_PLAN
Loading F1_MIGR_PLAN_L from the blueprint
Loading F1_MIGR_PLAN_L from the target database
Comparing F1_MIGR_PLAN_L
Loading F1_MIGR_PLAN_INSTR from the blueprint
Loading F1_MIGR_PLAN_INSTR from the target database
Comparing F1_MIGR_PLAN_INSTR
Loading F1_MIGR_PLAN_INSTR_L from the blueprint
Loading F1_MIGR_PLAN_INSTR_L from the target database
Comparing F1_MIGR_PLAN_INSTR_L
Loading F1_MIGR_PLAN_INSTR_ALG from the blueprint
Loading F1_MIGR_PLAN_INSTR_ALG from the target database
Comparing F1_MIGR_PLAN_INSTR_ALG
Loading F1_MIGR_REQ from the blueprint
Loading F1_MIGR_REQ from the target database
Comparing F1_MIGR_REQ
Loading F1_MIGR_REQ_L from the blueprint
Loading F1_MIGR_REQ_L from the target database
Comparing F1_MIGR_REQ_L
Loading F1_MIGR_REQ_INSTR from the blueprint
Loading F1_MIGR_REQ_INSTR from the target database
Comparing F1_MIGR_REQ_INSTR
Loading F1_MIGR_REQ_INSTR_L from the blueprint
Loading F1_MIGR_REQ_INSTR_L from the target database
Comparing F1_MIGR_REQ_INSTR_L
Loading F1_MIGR_REQ_INSTR_ENTITY from the blueprint
Loading F1_MIGR_REQ_INSTR_ENTITY from the target database
Comparing F1_MIGR_REQ_INSTR_ENTITY
Loading F1_IWS_SVC_L from the blueprint
Loading F1_IWS_SVC_L from the target database
Comparing F1_IWS_SVC_L
Loading F1_IWS_SVC from the blueprint
Loading F1_IWS_SVC from the target database
Comparing F1_IWS_SVC
Loading F1_IWS_SVC_OPER_L from the blueprint
Loading F1_IWS_SVC_OPER_L from the target database
Comparing F1_IWS_SVC_OPER_L
Loading F1_IWS_SVC_OPER from the blueprint
Loading F1_IWS_SVC_OPER from the target database
Comparing F1_IWS_SVC_OPER
Loading F1_IWS_ANN_L from the blueprint
Loading F1_IWS_ANN_L from the target database
Comparing F1_IWS_ANN_L
Loading F1_IWS_ANN_PARM from the blueprint
Loading F1_IWS_ANN_PARM from the target database
Comparing F1_IWS_ANN_PARM
Loading F1_IWS_ANN from the blueprint
Loading F1_IWS_ANN from the target database
Comparing F1_IWS_ANN
Loading F1_IWS_ANN_TYPE_PARM_L from the blueprint
Loading F1_IWS_ANN_TYPE_PARM_L from the target database
Comparing F1_IWS_ANN_TYPE_PARM_L
Loading F1_IWS_ANN_TYPE_L from the blueprint
Loading F1_IWS_ANN_TYPE_L from the target database
Comparing F1_IWS_ANN_TYPE_L
Loading F1_IWS_ANN_TYPE from the blueprint
Loading F1_IWS_ANN_TYPE from the target database
Comparing F1_IWS_ANN_TYPE
Loading F1_IWS_ANN_TYPE_PARM from the blueprint
Loading F1_IWS_ANN_TYPE_PARM from the target database
Comparing F1_IWS_ANN_TYPE_PARM
Loading CI_PORTAL_OPT from the blueprint
Loading CI_PORTAL_OPT from the target database
Comparing CI_PORTAL_OPT
Loading F1_EXT_LOOKUP_VAL_CHAR from the blueprint
Loading F1_EXT_LOOKUP_VAL_CHAR from the target database
Comparing F1_EXT_LOOKUP_VAL_CHAR
Upgrading Database
Pass:1
Auto System Data Deletion Process Executed Successfully, Now Exiting

Performing English System Data Upgrade for CCB...

Running System Data Upgrade process in Modification Mode

Connecting to the Target Database
User Name : CISADM
Database Name : OMCCB
Schema Name : CISADM

Setting Current Schema to CISADM
Reading Blueprint
Loading CI_CURRENCY_CD from the blueprint
Loading CI_CURRENCY_CD from the target database
Comparing CI_CURRENCY_CD
Loading CI_CURRENCY_CD_L from the blueprint
Loading CI_CURRENCY_CD_L from the target database
Comparing CI_CURRENCY_CD_L
Loading CI_DISP_PROF from the blueprint
Loading CI_DISP_PROF from the target database
Comparing CI_DISP_PROF
Loading CI_DISP_PROF_L from the blueprint
Loading CI_DISP_PROF_L from the target database
Comparing CI_DISP_PROF_L
Loading CI_USR_PORTAL from the blueprint
Loading CI_USR_PORTAL from the target database
Comparing CI_USR_PORTAL
Loading CI_XAI_RCVR from the blueprint
Loading CI_XAI_RCVR from the target database
Comparing CI_XAI_RCVR
Loading CI_XAI_RCVR_CTX from the blueprint
Loading CI_XAI_RCVR_CTX from the target database
Comparing CI_XAI_RCVR_CTX
Loading CI_XAI_RCVR_L from the blueprint
Loading CI_XAI_RCVR_L from the target database
Comparing CI_XAI_RCVR_L
Loading CI_XAI_RCVR_RGRP from the blueprint
Loading CI_XAI_RCVR_RGRP from the target database
Comparing CI_XAI_RCVR_RGRP
Loading CI_XAI_RCVR_RSP from the blueprint
Loading CI_XAI_RCVR_RSP from the target database
Comparing CI_XAI_RCVR_RSP
Loading CI_XAI_SENDER from the blueprint
Loading CI_XAI_SENDER from the target database
Comparing CI_XAI_SENDER
Loading CI_XAI_SENDER_L from the blueprint
Loading CI_XAI_SENDER_L from the target database
Comparing CI_XAI_SENDER_L
Loading CI_XAI_SNDR_CTX from the blueprint
Loading CI_XAI_SNDR_CTX from the target database
Comparing CI_XAI_SNDR_CTX
Loading CI_XAI_OPTION from the blueprint
Loading CI_XAI_OPTION from the target database
Comparing CI_XAI_OPTION
Loading SC_USER_GROUP from the blueprint
Loading SC_USER_GROUP from the target database
Comparing SC_USER_GROUP
Loading SC_USER_GROUP_L from the blueprint
Loading SC_USER_GROUP_L from the target database
Comparing SC_USER_GROUP_L
Loading SC_USR_GRP_USR from the blueprint
Loading SC_USR_GRP_USR from the target database
Comparing SC_USR_GRP_USR
Loading CI_ALG_TYPE from the blueprint
Loading CI_ALG_TYPE from the target database
Comparing CI_ALG_TYPE
Loading CI_ALG_TYPE_L from the blueprint
Loading CI_ALG_TYPE_L from the target database
Comparing CI_ALG_TYPE_L
Loading CI_ALG_TYPE_PRM from the blueprint
Loading CI_ALG_TYPE_PRM from the target database
Comparing CI_ALG_TYPE_PRM
Loading CI_ALG_TYPE_PRM_L from the blueprint
Loading CI_ALG_TYPE_PRM_L from the target database
Comparing CI_ALG_TYPE_PRM_L
Loading CI_APP_SVC_ACC from the blueprint
Loading CI_APP_SVC_ACC from the target database
Comparing CI_APP_SVC_ACC
Loading CI_BATCH_CTRL from the blueprint
Loading CI_BATCH_CTRL from the target database
Comparing CI_BATCH_CTRL
Loading CI_BATCH_CTRL_L from the blueprint
Loading CI_BATCH_CTRL_L from the target database
Comparing CI_BATCH_CTRL_L
Loading CI_BATCH_CTRL_ALG from the blueprint
Loading CI_BATCH_CTRL_ALG from the target database
Comparing CI_BATCH_CTRL_ALG
Loading CI_BATCH_CTRL_P from the blueprint
Loading CI_BATCH_CTRL_P from the target database
Comparing CI_BATCH_CTRL_P
Loading CI_BATCH_CTRL_P_L from the blueprint
Loading CI_BATCH_CTRL_P_L from the target database
Comparing CI_BATCH_CTRL_P_L
Loading CI_DISP_ICON from the blueprint
Loading CI_DISP_ICON from the target database
Comparing CI_DISP_ICON
Loading CI_DISP_ICON_L from the blueprint
Loading CI_DISP_ICON_L from the target database
Comparing CI_DISP_ICON_L
Loading CI_FK_REF from the blueprint
Loading CI_FK_REF from the target database
Comparing CI_FK_REF
Loading CI_FK_REF_L from the blueprint
Loading CI_FK_REF_L from the target database
Comparing CI_FK_REF_L
Loading CI_LANGUAGE from the blueprint
Loading CI_LANGUAGE from the target database
Comparing CI_LANGUAGE
Loading CI_LOOKUP_FIELD from the blueprint
Loading CI_LOOKUP_FIELD from the target database
Comparing CI_LOOKUP_FIELD
Loading CI_LOOKUP_VAL from the blueprint
Loading CI_LOOKUP_VAL from the target database
Comparing CI_LOOKUP_VAL
Loading CI_LOOKUP_VAL_L from the blueprint
Loading CI_LOOKUP_VAL_L from the target database
Comparing CI_LOOKUP_VAL_L
Loading CI_MD_CONST from the blueprint
Loading CI_MD_CONST from the target database
Comparing CI_MD_CONST
Loading CI_MD_CONST_FLD from the blueprint
Loading CI_MD_CONST_FLD from the target database
Comparing CI_MD_CONST_FLD
Loading CI_MD_FLD from the blueprint
Loading CI_MD_FLD from the target database
Comparing CI_MD_FLD
Loading CI_MD_FLD_L from the blueprint
Loading CI_MD_FLD_L from the target database
Comparing CI_MD_FLD_L
Loading CI_MD_MENU from the blueprint
Loading CI_MD_MENU from the target database
Comparing CI_MD_MENU
Loading CI_MD_MENU_L from the blueprint
Loading CI_MD_MENU_L from the target database
Comparing CI_MD_MENU_L
Loading CI_MD_MENU_LINE from the blueprint
Loading CI_MD_MENU_LINE from the target database
Comparing CI_MD_MENU_LINE
Loading CI_MD_MENU_LINE_L from the blueprint
Loading CI_MD_MENU_LINE_L from the target database
Comparing CI_MD_MENU_LINE_L
Loading CI_MD_MENU_ITEM from the blueprint
Loading CI_MD_MENU_ITEM from the target database
Comparing CI_MD_MENU_ITEM
Loading CI_MD_MENU_ITEM_L from the blueprint
Loading CI_MD_MENU_ITEM_L from the target database
Comparing CI_MD_MENU_ITEM_L
Loading CI_MD_MENU_IMOD from the blueprint
Loading CI_MD_MENU_IMOD from the target database
Comparing CI_MD_MENU_IMOD
Loading CI_MD_MO from the blueprint
Loading CI_MD_MO from the target database
Comparing CI_MD_MO
Loading CI_MD_MO_L from the blueprint
Loading CI_MD_MO_L from the target database
Comparing CI_MD_MO_L
Loading CI_MD_MO_TBL from the blueprint
Loading CI_MD_MO_TBL from the target database
Comparing CI_MD_MO_TBL
Loading CI_MD_MO_WRK from the blueprint
Loading CI_MD_MO_WRK from the target database
Comparing CI_MD_MO_WRK
Loading CI_MD_MO_OPT from the blueprint
Loading CI_MD_MO_OPT from the target database
Comparing CI_MD_MO_OPT
Loading CI_MD_NAV from the blueprint
Loading CI_MD_NAV from the target database
Comparing CI_MD_NAV
Loading CI_MD_PRG_COM from the blueprint
Loading CI_MD_PRG_COM from the target database
Comparing CI_MD_PRG_COM
Loading CI_MD_PRG_ELEM from the blueprint
Loading CI_MD_PRG_ELEM from the target database
Comparing CI_MD_PRG_ELEM
Loading CI_MD_PRG_EL_AT from the blueprint
Loading CI_MD_PRG_EL_AT from the target database
Comparing CI_MD_PRG_EL_AT
Loading CI_MD_PRG_LOC from the blueprint
Loading CI_MD_PRG_LOC from the target database
Comparing CI_MD_PRG_LOC
Loading CI_MD_PRG_MOD from the blueprint
Loading CI_MD_PRG_MOD from the target database
Comparing CI_MD_PRG_MOD
Loading CI_MD_PRG_SEC from the blueprint
Loading CI_MD_PRG_SEC from the target database
Comparing CI_MD_PRG_SEC
Loading CI_MD_PRG_SQL from the blueprint
Loading CI_MD_PRG_SQL from the target database
Comparing CI_MD_PRG_SQL
Loading CI_MD_PRG_TAB from the blueprint
Loading CI_MD_PRG_TAB from the target database
Comparing CI_MD_PRG_TAB
Loading CI_MD_PRG_VAR from the blueprint
Loading CI_MD_PRG_VAR from the target database
Comparing CI_MD_PRG_VAR
Loading CI_MD_SO from the blueprint
Loading CI_MD_SO from the target database
Comparing CI_MD_SO
Loading CI_MD_SO_L from the blueprint
Loading CI_MD_SO_L from the target database
Comparing CI_MD_SO_L
Loading CI_MD_SO_RSFLD from the blueprint
Loading CI_MD_SO_RSFLD from the target database
Comparing CI_MD_SO_RSFLD
Loading CI_MD_SO_RSFLDAT from the blueprint
Loading CI_MD_SO_RSFLDAT from the target database
Comparing CI_MD_SO_RSFLDAT
Loading CI_MD_SOCG from the blueprint
Loading CI_MD_SOCG from the target database
Comparing CI_MD_SOCG
Loading CI_MD_SOCG_FLD from the blueprint
Loading CI_MD_SOCG_FLD from the target database
Comparing CI_MD_SOCG_FLD
Loading CI_MD_SOCG_FLDAT from the blueprint
Loading CI_MD_SOCG_FLDAT from the target database
Comparing CI_MD_SOCG_FLDAT
Loading CI_MD_SOCG_L from the blueprint
Loading CI_MD_SOCG_L from the target database
Comparing CI_MD_SOCG_L
Loading CI_MD_SOCG_SORT from the blueprint
Loading CI_MD_SOCG_SORT from the target database
Comparing CI_MD_SOCG_SORT
Loading CI_MD_SVC from the blueprint
Loading CI_MD_SVC from the target database
Comparing CI_MD_SVC
Loading CI_MD_SVC_L from the blueprint
Loading CI_MD_SVC_L from the target database
Comparing CI_MD_SVC_L
Loading CI_MD_SVC_PRG from the blueprint
Loading CI_MD_SVC_PRG from the target database
Comparing CI_MD_SVC_PRG
Loading CI_MD_TAB_MOD from the blueprint
Loading CI_MD_TAB_MOD from the target database
Comparing CI_MD_TAB_MOD
Loading CI_MD_TBL from the blueprint
Loading CI_MD_TBL from the target database
Comparing CI_MD_TBL
Loading CI_MD_TBL_FLD from the blueprint
Loading CI_MD_TBL_FLD from the target database
Comparing CI_MD_TBL_FLD
Loading CI_MD_TBL_FLD_L from the blueprint
Loading CI_MD_TBL_FLD_L from the target database
Comparing CI_MD_TBL_FLD_L
Loading CI_MD_TBL_L from the blueprint
Loading CI_MD_TBL_L from the target database
Comparing CI_MD_TBL_L
Loading CI_MD_WRK_TBL from the blueprint
Loading CI_MD_WRK_TBL from the target database
Comparing CI_MD_WRK_TBL
Loading CI_MD_WRK_TBLFLD from the blueprint
Loading CI_MD_WRK_TBLFLD from the target database
Comparing CI_MD_WRK_TBLFLD
Loading CI_MD_WRK_TBL_L from the blueprint
Loading CI_MD_WRK_TBL_L from the target database
Comparing CI_MD_WRK_TBL_L
Loading CI_MSG from the blueprint
Loading CI_MSG from the target database
Comparing CI_MSG
Loading CI_MSG_CATEGORY from the blueprint
Loading CI_MSG_CATEGORY from the target database
Comparing CI_MSG_CATEGORY
Loading CI_MSG_CATEGORY_L from the blueprint
Loading CI_MSG_CATEGORY_L from the target database
Comparing CI_MSG_CATEGORY_L
Loading CI_MSG_L from the blueprint
Loading CI_MSG_L from the target database
Comparing CI_MSG_L
Loading CI_NAV_OPT from the blueprint
Loading CI_NAV_OPT from the target database
Comparing CI_NAV_OPT
Loading CI_NAV_OPT_CTXT from the blueprint
Loading CI_NAV_OPT_CTXT from the target database
Comparing CI_NAV_OPT_CTXT
Loading CI_NAV_OPT_L from the blueprint
Loading CI_NAV_OPT_L from the target database
Comparing CI_NAV_OPT_L
Loading CI_NAV_OPT_USG from the blueprint
Loading CI_NAV_OPT_USG from the target database
Comparing CI_NAV_OPT_USG
Loading CI_PORTAL from the blueprint
Loading CI_PORTAL from the target database
Comparing CI_PORTAL
Loading CI_PORTAL_L from the blueprint
Loading CI_PORTAL_L from the target database
Comparing CI_PORTAL_L
Loading CI_PORTAL_ZONE from the blueprint
Loading CI_PORTAL_ZONE from the target database
Comparing CI_PORTAL_ZONE
Loading CI_TD_DRLKEY_TY from the blueprint
Loading CI_TD_DRLKEY_TY from the target database
Comparing CI_TD_DRLKEY_TY
Loading CI_TD_SRTKEY_TY from the blueprint
Loading CI_TD_SRTKEY_TY from the target database
Comparing CI_TD_SRTKEY_TY
Loading CI_TD_SRTKEY_TY_L from the blueprint
Loading CI_TD_SRTKEY_TY_L from the target database
Comparing CI_TD_SRTKEY_TY_L
Loading CI_TD_TYPE from the blueprint
Loading CI_TD_TYPE from the target database
Comparing CI_TD_TYPE
Loading CI_TD_TYPE_L from the blueprint
Loading CI_TD_TYPE_L from the target database
Comparing CI_TD_TYPE_L
Loading CI_XAI_ADAPTER from the blueprint
Loading CI_XAI_ADAPTER from the target database
Comparing CI_XAI_ADAPTER
Loading CI_XAI_ADAPTER_L from the blueprint
Loading CI_XAI_ADAPTER_L from the target database
Comparing CI_XAI_ADAPTER_L
Loading CI_XAI_CLASS from the blueprint
Loading CI_XAI_CLASS from the target database
Comparing CI_XAI_CLASS
Loading CI_XAI_CLASS_L from the blueprint
Loading CI_XAI_CLASS_L from the target database
Comparing CI_XAI_CLASS_L
Loading CI_XAI_ENV_HNDL from the blueprint
Loading CI_XAI_ENV_HNDL from the target database
Comparing CI_XAI_ENV_HNDL
Loading CI_XAI_ENV_HNDL_L from the blueprint
Loading CI_XAI_ENV_HNDL_L from the target database
Comparing CI_XAI_ENV_HNDL_L
Loading CI_XAI_FORMAT from the blueprint
Loading CI_XAI_FORMAT from the target database
Comparing CI_XAI_FORMAT
Loading CI_XAI_FORMAT_L from the blueprint
Loading CI_XAI_FORMAT_L from the target database
Comparing CI_XAI_FORMAT_L
Loading CI_XAI_IN_SVC from the blueprint
Loading CI_XAI_IN_SVC from the target database
Comparing CI_XAI_IN_SVC
Loading CI_XAI_IN_SVC_L from the blueprint
Loading CI_XAI_IN_SVC_L from the target database
Comparing CI_XAI_IN_SVC_L
Loading CI_XAI_SVC_PARM from the blueprint
Loading CI_XAI_SVC_PARM from the target database
Comparing CI_XAI_SVC_PARM
Loading CI_ZONE from the blueprint
Loading CI_ZONE from the target database
Comparing CI_ZONE
Loading CI_ZONE_L from the blueprint
Loading CI_ZONE_L from the target database
Comparing CI_ZONE_L
Loading CI_ZONE_HDL from the blueprint
Loading CI_ZONE_HDL from the target database
Comparing CI_ZONE_HDL
Loading CI_ZONE_HDL_L from the blueprint
Loading CI_ZONE_HDL_L from the target database
Comparing CI_ZONE_HDL_L
Loading CI_ZONE_HDL_PRM from the blueprint
Loading CI_ZONE_HDL_PRM from the target database
Comparing CI_ZONE_HDL_PRM
Loading CI_ZONE_HDL_PRM_L from the blueprint
Loading CI_ZONE_HDL_PRM_L from the target database
Comparing CI_ZONE_HDL_PRM_L
Loading CI_ZONE_PRM from the blueprint
Loading CI_ZONE_PRM from the target database
Comparing CI_ZONE_PRM
Loading SC_ACCESS_CNTL from the blueprint
Loading SC_ACCESS_CNTL from the target database
Comparing SC_ACCESS_CNTL
Loading SC_APP_SERVICE from the blueprint
Loading SC_APP_SERVICE from the target database
Comparing SC_APP_SERVICE
Loading SC_APP_SERVICE_L from the blueprint
Loading SC_APP_SERVICE_L from the target database
Comparing SC_APP_SERVICE_L
Loading SC_USR_GRP_PROF from the blueprint
Loading SC_USR_GRP_PROF from the target database
Comparing SC_USR_GRP_PROF
Loading F1_MD_DB_OBJ from the blueprint
Loading F1_MD_DB_OBJ from the target database
Comparing F1_MD_DB_OBJ
Loading CI_ALG from the blueprint
Loading CI_ALG from the target database
Comparing CI_ALG
Loading CI_ALG_L from the blueprint
Loading CI_ALG_L from the target database
Comparing CI_ALG_L
Loading CI_ALG_PARM from the blueprint
Loading CI_ALG_PARM from the target database
Comparing CI_ALG_PARM
Loading CI_ALG_VER from the blueprint
Loading CI_ALG_VER from the target database
Comparing CI_ALG_VER
Loading CI_CHAR_ENTITY from the blueprint
Loading CI_CHAR_ENTITY from the target database
Comparing CI_CHAR_ENTITY
Loading CI_CHAR_TYPE from the blueprint
Loading CI_CHAR_TYPE from the target database
Comparing CI_CHAR_TYPE
Loading CI_CHAR_TYPE_L from the blueprint
Loading CI_CHAR_TYPE_L from the target database
Comparing CI_CHAR_TYPE_L
Loading CI_CHAR_VAL from the blueprint
Loading CI_CHAR_VAL from the target database
Comparing CI_CHAR_VAL
Loading CI_CHAR_VAL_L from the blueprint
Loading CI_CHAR_VAL_L from the target database
Comparing CI_CHAR_VAL_L
Loading CI_MD_MO_ALG from the blueprint
Loading CI_MD_MO_ALG from the target database
Comparing CI_MD_MO_ALG
Loading CI_SCR from the blueprint
Loading CI_SCR from the target database
Comparing CI_SCR
Loading CI_SCR_CRT from the blueprint
Loading CI_SCR_CRT from the target database
Comparing CI_SCR_CRT
Loading CI_SCR_CRT_GRP from the blueprint
Loading CI_SCR_CRT_GRP from the target database
Comparing CI_SCR_CRT_GRP
Loading CI_SCR_CRT_GRP_L from the blueprint
Loading CI_SCR_CRT_GRP_L from the target database
Comparing CI_SCR_CRT_GRP_L
Loading CI_SCR_DA from the blueprint
Loading CI_SCR_DA from the target database
Comparing CI_SCR_DA
Loading CI_SCR_FLD_MAP from the blueprint
Loading CI_SCR_FLD_MAP from the target database
Comparing CI_SCR_FLD_MAP
Loading CI_SCR_L from the blueprint
Loading CI_SCR_L from the target database
Comparing CI_SCR_L
Loading CI_SCR_PRMPT from the blueprint
Loading CI_SCR_PRMPT from the target database
Comparing CI_SCR_PRMPT
Loading CI_SCR_PRMPT_L from the blueprint
Loading CI_SCR_PRMPT_L from the target database
Comparing CI_SCR_PRMPT_L
Loading CI_SCR_STEP from the blueprint
Loading CI_SCR_STEP from the target database
Comparing CI_SCR_STEP
Loading CI_SCR_STEP_L from the blueprint
Loading CI_SCR_STEP_L from the target database
Comparing CI_SCR_STEP_L
Loading CI_UI_ZONE from the blueprint
Loading CI_UI_ZONE from the target database
Comparing CI_UI_ZONE
Loading F1_BUS_OBJ from the blueprint
Loading F1_BUS_OBJ from the target database
Comparing F1_BUS_OBJ
Loading F1_BUS_OBJ_ALG from the blueprint
Loading F1_BUS_OBJ_ALG from the target database
Comparing F1_BUS_OBJ_ALG
Loading F1_BUS_OBJ_L from the blueprint
Loading F1_BUS_OBJ_L from the target database
Comparing F1_BUS_OBJ_L
Loading F1_BUS_OBJ_OPT from the blueprint
Loading F1_BUS_OBJ_OPT from the target database
Comparing F1_BUS_OBJ_OPT
Loading F1_BUS_OBJ_STATUS from the blueprint
Loading F1_BUS_OBJ_STATUS from the target database
Comparing F1_BUS_OBJ_STATUS
Loading F1_BUS_OBJ_STATUS_ALG from the blueprint
Loading F1_BUS_OBJ_STATUS_ALG from the target database
Comparing F1_BUS_OBJ_STATUS_ALG
Loading F1_BUS_OBJ_STATUS_L from the blueprint
Loading F1_BUS_OBJ_STATUS_L from the target database
Comparing F1_BUS_OBJ_STATUS_L
Loading F1_BUS_OBJ_STATUS_OPT from the blueprint
Loading F1_BUS_OBJ_STATUS_OPT from the target database
Comparing F1_BUS_OBJ_STATUS_OPT
Loading F1_BUS_OBJ_TR_RULE from the blueprint
Loading F1_BUS_OBJ_TR_RULE from the target database
Comparing F1_BUS_OBJ_TR_RULE
Loading F1_BUS_OBJ_TR_RULE_L from the blueprint
Loading F1_BUS_OBJ_TR_RULE_L from the target database
Comparing F1_BUS_OBJ_TR_RULE_L
Loading F1_BUS_SVC from the blueprint
Loading F1_BUS_SVC from the target database
Comparing F1_BUS_SVC
Loading F1_BUS_SVC_L from the blueprint
Loading F1_BUS_SVC_L from the target database
Comparing F1_BUS_SVC_L
Loading F1_DATA_AREA from the blueprint
Loading F1_DATA_AREA from the target database
Comparing F1_DATA_AREA
Loading F1_DATA_AREA_L from the blueprint
Loading F1_DATA_AREA_L from the target database
Comparing F1_DATA_AREA_L
Loading F1_MAP from the blueprint
Loading F1_MAP from the target database
Comparing F1_MAP
Loading F1_MAP_L from the blueprint
Loading F1_MAP_L from the target database
Comparing F1_MAP_L
Loading F1_SCHEMA from the blueprint
Loading F1_SCHEMA from the target database
Comparing F1_SCHEMA
Loading F1_MANAG_CONTENT from the blueprint
Loading F1_MANAG_CONTENT from the target database
Comparing F1_MANAG_CONTENT
Loading F1_MANAG_CONTENT_L from the blueprint
Loading F1_MANAG_CONTENT_L from the target database
Comparing F1_MANAG_CONTENT_L
Loading F1_BUS_OBJ_STATUS_RSN from the blueprint
Loading F1_BUS_OBJ_STATUS_RSN from the target database
Comparing F1_BUS_OBJ_STATUS_RSN
Loading F1_BUS_OBJ_STATUS_RSN_L from the blueprint
Loading F1_BUS_OBJ_STATUS_RSN_L from the target database
Comparing F1_BUS_OBJ_STATUS_RSN_L
Loading F1_BUS_OBJ_STATUS_RSN_CHAR from the blueprint
Loading F1_BUS_OBJ_STATUS_RSN_CHAR from the target database
Comparing F1_BUS_OBJ_STATUS_RSN_CHAR
Loading F1_EXT_LOOKUP_VAL from the blueprint
Loading F1_EXT_LOOKUP_VAL from the target database
Comparing F1_EXT_LOOKUP_VAL
Loading F1_EXT_LOOKUP_VAL_L from the blueprint
Loading F1_EXT_LOOKUP_VAL_L from the target database
Comparing F1_EXT_LOOKUP_VAL_L
Loading F1_DB_OBJECTS_REPO from the blueprint
Loading F1_DB_OBJECTS_REPO from the target database
Comparing F1_DB_OBJECTS_REPO
Loading F1_MIGR_PLAN from the blueprint
Loading F1_MIGR_PLAN from the target database
Comparing F1_MIGR_PLAN
Loading F1_MIGR_PLAN_L from the blueprint
Loading F1_MIGR_PLAN_L from the target database
Comparing F1_MIGR_PLAN_L
Loading F1_MIGR_PLAN_INSTR from the blueprint
Loading F1_MIGR_PLAN_INSTR from the target database
Comparing F1_MIGR_PLAN_INSTR
Loading F1_MIGR_PLAN_INSTR_L from the blueprint
Loading F1_MIGR_PLAN_INSTR_L from the target database
Comparing F1_MIGR_PLAN_INSTR_L
Loading F1_MIGR_PLAN_INSTR_ALG from the blueprint
Loading F1_MIGR_PLAN_INSTR_ALG from the target database
Comparing F1_MIGR_PLAN_INSTR_ALG
Loading F1_MIGR_REQ from the blueprint
Loading F1_MIGR_REQ from the target database
Comparing F1_MIGR_REQ
Loading F1_MIGR_REQ_L from the blueprint
Loading F1_MIGR_REQ_L from the target database
Comparing F1_MIGR_REQ_L
Loading F1_MIGR_REQ_INSTR from the blueprint
Loading F1_MIGR_REQ_INSTR from the target database
Comparing F1_MIGR_REQ_INSTR
Loading F1_MIGR_REQ_INSTR_L from the blueprint
Loading F1_MIGR_REQ_INSTR_L from the target database
Comparing F1_MIGR_REQ_INSTR_L
Loading F1_MIGR_REQ_INSTR_ENTITY from the blueprint
Loading F1_MIGR_REQ_INSTR_ENTITY from the target database
Comparing F1_MIGR_REQ_INSTR_ENTITY
Loading F1_IWS_SVC_L from the blueprint
Loading F1_IWS_SVC_L from the target database
Comparing F1_IWS_SVC_L
Loading F1_IWS_SVC from the blueprint
Loading F1_IWS_SVC from the target database
Comparing F1_IWS_SVC
Loading F1_IWS_SVC_OPER_L from the blueprint
Loading F1_IWS_SVC_OPER_L from the target database
Comparing F1_IWS_SVC_OPER_L
Loading F1_IWS_SVC_OPER from the blueprint
Loading F1_IWS_SVC_OPER from the target database
Comparing F1_IWS_SVC_OPER
Loading F1_IWS_ANN_L from the blueprint
Loading F1_IWS_ANN_L from the target database
Comparing F1_IWS_ANN_L
Loading F1_IWS_ANN_PARM from the blueprint
Loading F1_IWS_ANN_PARM from the target database
Comparing F1_IWS_ANN_PARM
Loading F1_IWS_ANN from the blueprint
Loading F1_IWS_ANN from the target database
Comparing F1_IWS_ANN
Loading F1_IWS_ANN_TYPE_L from the blueprint
Loading F1_IWS_ANN_TYPE_L from the target database
Comparing F1_IWS_ANN_TYPE_L
Loading F1_IWS_ANN_TYPE from the blueprint
Loading F1_IWS_ANN_TYPE from the target database
Comparing F1_IWS_ANN_TYPE
Loading F1_IWS_ANN_TYPE_PARM from the blueprint
Loading F1_IWS_ANN_TYPE_PARM from the target database
Comparing F1_IWS_ANN_TYPE_PARM
Loading F1_IWS_ANN_TYPE_PARM_L from the blueprint
Loading F1_IWS_ANN_TYPE_PARM_L from the target database
Comparing F1_IWS_ANN_TYPE_PARM_L
Loading CI_PORTAL_OPT from the blueprint
Loading CI_PORTAL_OPT from the target database
Comparing CI_PORTAL_OPT
Loading F1_EXT_LOOKUP_VAL_CHAR from the blueprint
Loading F1_EXT_LOOKUP_VAL_CHAR from the target database
Comparing F1_EXT_LOOKUP_VAL_CHAR
Upgrading Database
Pass:1
System Data Upgraded Successfully, Now Exiting

Executing Finalization Scripts...

Processing file CCB_cleanup.sql ...

Processing file cdx_security.sql ...

Processing file CCB230_APDATA3.SQL ...

Processing file CCB231_POST_DATA1.SQL ...

Processing file CCB240_cleanup.sql ...

Processing file CCB240_cleanup2.sql ...

Processing file 24020_C1_AP_apData1.sql ...

Processing file 24020_C1_AP_APDATA2.SQL ...

Processing file 24030_BUG_18906800.SQL ...

Processing file 24030_BUG_19162075.SQL ...

Processing file 24030_BUG_20023780.SQL ...

Processing file 24030_BUG_20426547.SQL ...

Processing file 24030_BUG_21078919.SQL ...

Processing file 24030_BUG_19707998.SQL ...

Processing file 25010_BUG_21482753.SQL ...

Configuring Security...

Connecting to the Target Database ...
User Name : CISADM
Database Name : OMCCB

Generating security ...

Security privileges and Synonyms generated successfully, Now Exiting ...

Storing Database Credential with ecncrypted password...

Install/Upgrade of Database Rel.V2.5.0.1.0 Completed Sucessfully, Now Exiting ...

Press Enter to Continue ...

C:\Users\Palane\Downloads\Compressed\New folder\CCB\V78183-01\CCB-V2.5.0.1.0-Oracle-Database-MultiplatForm\CCB\Upgrade\Install-Upgrade>

===

Error handling

ERROR: ORA-03113: end-of-file on communication channel
Process ID: 27462
Session ID: 1138 Serial number: 20663 (DBD ERROR: error possibly near <*> indicator at char 19 in 'update CISADM.CI_UT<*>_INSTL_DTL set end_dttm=to_date('06-10-2016 10:56:44','MM-DD-YYYY HH24:MI:SS'), run_status_flg='02'
where instl_log_id=20 and seq_num = 31 - 1') occured while executing update CISADM.CI_UT_INSTL_DTL set end_dttm=to_date('06-10-2016 10:56:44','MM-DD-YYYY HH24:MI:SS'), run_status_flg='02'
where instl_log_id=20 and seq_num = 31 - 1
Error Occured, Process being aborted ...

Wednesday, June 15, 2016

keytool error: java.lang.Exception: Cannot derive signature algorithm" When Creating a Keystore with AES

When working with Java keystores (JKS or JCEKS), especially in environments like Oracle Utilities Application Framework (OUAF), creating keys correctly is critical for SSL and application integration. In this post, we cover a common error:

When we generate the keystore with the key tool, we get this error. This typically occurs when trying to generate a key pair with a symmetric algorithm like AES, which is not designed for digital signatures.

Step 1

keytool -genkeypair -alias ouaf.system -keyalg AES -keystore /u02/app/oracle/product/OUAF/OMCCB/ouafkeystore.jks -keysize 128 -storetype JCEKS -dname "CN=omccb ,OU=Andavatit O=adavattecht,C=AE" -validity 365

Understanding the Root Cause

-genkeypair is used for asymmetric keys (e.g., RSA), not symmetric keys like AES.
AES is a symmetric encryption algorithm and doesn’t support public/private key pairs or digital signatures.

Step 2

with the ASE we can't use the gen key pair as the

The genkey option is for generating a public key and associated private key, so it only works with asymmetric algorithms (AES is symmetric, so you can't use -genkey with it).

cissys @ omccb/home/cissys >cat ss.sh

keytool -genseckey -alias ouaf.system -keyalg AES -keystore /u02/app/oracle/product/OUAF/OMCCB/ouafkeystore.jks -keysize 128 -storetype JCEKS -dname "CN=omccb ,OU=OICIT O=<Companyname>,C=AE" -validity 365

cissys @ omccb.oasiserp.com/home/cissys >

cissys @ omccb.oasiserp.com/home/cissys >./ss.sh

Enter keystore password:

Re-enter new password:

Enter key password for <ouaf.system>

(RETURN if same as keystore password):

Re-enter new password:

Steps for Creating a Full Public Key Infrastructure (PKI)

Step 1: Generate an AES Secret Key (Symmetric Key)

$ ./root_cert.sh

Generating a 4096 bit RSA private key

.............................................................................................................................................................................................................++

..........................................++

writing new private key to 'cakey.pem'

Enter PEM pass phrase:

Verifying - Enter PEM pass phrase:

-----

You are about to be asked to enter information that will be incorporated

into your certificate request.

What you are about to enter is what is called a Distinguished Name or a DN.

There are quite a few fields but you can leave some blank

For some fields there will be a default value,

If you enter '.', the field will be left blank.

-----

Country Name (2 letter code) [AU]:AE

State or Province Name (full name) [Some-State]:Dubai

Locality Name (eg, city) []:Dubai

Organization Name (eg, company) [Internet Widgits Pty Ltd]: Company Name

Organizational Unit Name (eg, section) []:OICIT

Common Name (e.g. server FQDN or YOUR name) []:omccb.

Email Address []:palaneandavar@alshirawi.ae

Step 2: Create an RSA Public/Private Key Pair for SSL

keytool -genkey -alias omccb -keyalg RSA -keysize 4096 -sigalg SHA256withRSA -dname "CN=<domain name>,OU=OICIT,O=<company name> ,C=AE" -keypass OMccb123 -keystore omccb.jks -storepass <Password>

$ keytool -list -keystore omccb.jks -storepass <Password>

Keystore type: JKS

Keystore provider: SUN

Your keystore contains 1 entry

omccb, Jun 15, 2016, PrivateKeyEntry,

Certificate fingerprint (SHA1): DD:F2:BE:B1:7F:EF:ED:68:D3:42:5C:77:7E:DF:E3:6A:CE:47:B8:DA

Step 3: Generate a CSR (Certificate Signing Request)

$ keytool -certreq -v -alias omccb -file omccb..csr -sigalg SHA256withRSA -keypass <keypass> -storepass <Storepass< -keystore omccb.jks

Certification request stored in file <omccb.csr>

Submit this to your CA

Step 4: Sign the CSR Using OpenSSL (as CA)

If you are acting as your own CA, sign the CSR:

You’ll be prompted for the CA’s Password.

$ openssl x509 -req -in omccb.csr -CA cacert.pem -CAkey cakey.pem -CAcreateserial -out omccb.cer

Signature ok

subject=/C=AE/O=OasisInvestmentC0mpany/OU=OICIT/CN=omccb.oasiserp.com

Getting CA Private Key

Enter pass phrase for cakey.pem:

Step 5: Import the CA Root Certificate into the Keystore

Before importing your signed certificate, you must trust the CA root:

$ keytool -import -v -noprompt -trustcacerts -alias rootcacert -file cacert.pem -keystore omccb.jks -storepass <Passowrd>

Certificate was added to keystore

[Storing omccb.jks]

Step 6: Import the Signed Certificate Back to the Keystore

Finally, import the signed certificate to complete the keystore:

$ keytool -import -v -alias omccb. -file omccb.cer -keystore omccb.jks -keypass OMccb123 -storepass

Certificate reply was installed in keystore

[Storing omccb.jks]

Wednesday, June 1, 2016

EXIM

Managing and Clearing the Exim Mail Queue on a cPanel Server

When running a cPanel-based mail server, it’s not uncommon to encounter situations where the Exim mail queue grows unexpectedly—sometimes due to spam, mail loops, or misconfigured scripts. Regularly monitoring and clearing the mail queue is essential for maintaining a healthy email environment.

Here’s a step-by-step guide on how to view, analyze, and clear Exim’s mail queue using command-line tools

Step 1: Viewing the Exim Mail Queue

exim -bp

exim -bp | exiqsumm

root@vserver622 [~]# exim -bp | exiqsumm

Count Volume Oldest Newest Domain

----- ------ ------ ------ ------

1 740 2m 2m alshirawi.ae

1 677 2m 2m yahoo.com

---------------------------------------------------------------

2 1417 2m 2m TOTAL

This quickly shows you which domains have messages stuck in the queue and how many there are.

Step 2: Removing Messages from the Queue

exiqgrep -i|xargs exim -Mrm

exiqgrep -i lists all message IDs.

xargs exim -Mrm deletes each message by its ID.

If a message is locked, Exim will notify you (e.g., Message ... is locked). In this case, you may need to retry after a few minutes or investigate why the message is locked.

B. Alternative Bulk Removal Methods

exim -bp|grep "<"|awk {'print $3'}|xargs exim -Mrm

exim -bp | awk '/^ *[0-9]+[mhd]/{print "exim -Mrm " $3}' | bash

root@vserver622 [/usr/local/cpanel/whostmgr/bin]# exiqgrep -i|xargs exim -Mrm

Message 1b86cI-0000yS-EX is locked

Step 3: Verifying the Mail Queue is Cleared

bashvserver622 [~]# exim -bp | awk '/^ *[0-9]+[mhd]/{print "exim -Mrm " $3}' |

root@vserver622 [~]# exim -bp | exiqsumm

Count Volume Oldest Newest Domain

----- ------ ------ ------ ------

2 6553 2h 2h pooae.com

8 26KB 2h 2h yahoo.com

---------------------------------------------------------------

10 32KB 2h 2h TOTAL

Step 4: Removing Specific Locked Messages

root@vserver622 [~]# exim -Mrm 1b86cI-0000yS-EX

Message 1b86cI-0000yS-EX has been removed

root@vserver622 [~]# exim -bp | exiqsumm

Count Volume Oldest Newest Domain

----- ------ ------ ------ ------

1 740 0m 0m alshirawi.ae

1 677 0m 0m yahoo.com

---------------------------------------------------------------

2 1417 0m 0m TOTAL

Conclusion

Regularly monitoring and managing the Exim mail queue is essential for email delivery health on any cPanel server. With these command-line tools, you can quickly identify, summarize, and clean up problematic or stuck mail, ensuring that your users experience reliable email service.

Pro Tip:

If you regularly encounter large queues or locked messages, investigate the root cause—check for scripts sending excessive mail, look for authentication issues, or consider rate limiting outbound mail to avoid future problems.

Thursday, May 26, 2016

ORA-19909: datafile 1 belongs to an orphan incarnation

Recovery Slave PR00 previously exited with exception 19909
Step 1 Recovery Slave PR00 previously exited with exception 19909

Case

When we want to start the managed recovery [MRP] in the stand by if we are getting the the message in alert log and we are not able to start the MRP process in the stand by database

Step 1 starting the redo apply in the Physical standby database

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT

Attempt to start background Managed Standby Recovery process (OMTST1)

Wed May 25 06:57:12 2016

MRP0 started with pid=60, OS id=18711

MRP0: Background Managed Standby Recovery process started (OMTST1)

started logmerger process

Wed May 25 06:57:17 2016

Managed Standby Recovery not using Real Time Apply

Wed May 25 06:57:17 2016

Warning: Recovery target destination is in a sibling branch

of the controlfile checkpoint. Recovery will only recover

changes to datafiles.

Datafile 1 (ckpscn 67283504852) is orphaned on incarnation#=2

MRP0: Detected orphaned datafiles!

Recovery will possibly be retried after flashback...

Errors in file /prod02/oracle/oratst/diag/diag/rdbms/omtst/OMTST1/trace/OMTST1_pr00_18715.trc:

ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1: '+DATA/omtst/datafile/system.806.911262335'

Recovery Slave PR00 previously exited with exception 19909

The MRP exist' with the error and not able to start the redo apply process .. and it report's the problem is with the rman incarnation

Step 2 list the incarnation form both the database

Primary database

RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations

DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1 1 OMPROD 3907334877 PARENT 23900323136 12-DEC-13

2 2 OMPROD 3907334877 CURRENT 38315839033 31-DEC-14

DR Stand by Database

RMAN> list incarnation of database;

using target database control file instead of recovery catalog

List of Database Incarnations

DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1 1 OMPROD 3907334877 PARENT 23900323136 12-DEC-13

2 2 OMPROD 3907334877 PARENT 38315839033 31-DEC-14

3 3 OMPROD 3907334877 CURRENT 66684359815 17-MAY-16

now you can find the Primary and stand by have different incarnation in the control file so we can reset the incarnation to same in the PROD before we start the MRP process

Step 3 Change the incarnation to the match the primary database and both the incarnations should be same

IN the Stand by database we need to change the rman incarnation to match as same as the PROD primary incarnation to start the recovery process the new incarnation which is set and update in the control file will not allow to start the MRP process until we reset the incarnation to as same in Primary

RMAN> list incarnation of database;

using target database control file instead of recovery catalog

List of Database Incarnations

DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1 1 OMPROD 3907334877 PARENT 23900323136 12-DEC-13

2 2 OMPROD 3907334877 PARENT 38315839033 31-DEC-14

3 3 OMPROD 3907334877 CURRENT 66684359815 17-MAY-16 -- new incarnation created after restore incremental from primary

RMAN> reset database to incarnation 2;

database reset to incarnation 2

RMAN> list incarnation of database;

using target database control file instead of recovery catalog

List of Database Incarnations

DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1 1 OMPROD 3907334877 PARENT 23900323136 12-DEC-13

2 2 OMPROD 3907334877 CURRENT 38315839033 31-DEC-14

3 3 OMPROD 3907334877 ORPHAN 66684359815 17-MAY-16

once the incarnation in both the control file are same then start the MRP process

Step 4 Start the MRP process in the physical stand by

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT

Recovery Slave PR00 previously exited with exception 19909

Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT

Wed May 25 07:04:00 2016

MRP0: Background Media Recovery process shutdown (OMTST1)

Wed May 25 07:13:26 2016

Setting recovery target incarnation to 2

Wed May 25 07:16:14 2016

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT

Attempt to start background Managed Standby Recovery process (OMTST1)

Wed May 25 07:16:14 2016

MRP0 started with pid=56, OS id=19646

MRP0: Background Managed Standby Recovery process started (OMTST1)

started logmerger process

Wed May 25 07:16:19 2016

Managed Standby Recovery not using Real Time Apply

Parallel Media Recovery started with 4 slaves

Wed May 25 07:16:20 2016

Warning: recovery process PR01 cannot use async I/O

Wed May 25 07:16:20 2016

Warning: recovery process PR02 cannot use async I/O

Wed May 25 07:16:20 2016

Warning: recovery process PR03 cannot use async I/O

Wed May 25 07:16:21 2016

Warning: recovery process PR04 cannot use async I/O

check the alert long you can see the the MRP process had been started ..

RMAN-03002: failure of switch to copy command

RMAN-06571: datafile 1 does not have recoverable copy

Case
When we are Performing the Rolling forward with the Physical Standby database we may get this error when we are in the final step switch database to copy this error can occur if we have multiple data file destinations

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 05/24/2016 12:53:45
RMAN-06571: datafile 1 does not have recoverable copy

Steps to fix the issue

Step 1 check the data file size's after getting the error by using the report schema command on the physical stand by database

RMAN> report schema;

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name OMTST

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.355.867865357
2 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.356.867865373
3 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.357.867865387
4 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.358.867865403
5 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.359.867865417
6 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.345.867865095
7 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.346.867865121
8 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.347.867865145
9 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.348.867865171
10 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.360.867865433
11 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.361.867865449
12 0 APPS_TS_IZU_DAT *** +DATA/omtst/omprod/datafile/apps_ts_izu_dat.364.867865477
13 0 APPS_TS_ARCHIVE *** +DATA/omtst/omprod/datafile/apps_ts_archive.335.867864683
14 0 APPS_TS_INTERFACE *** +DATA/omtst/omprod/datafile/apps_ts_interface.258.867855485
15 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.259.867855671
16 0 APPS_TS_NOLOGGING *** +DATA/omtst/omprod/datafile/apps_ts_nologging.309.867862737
17 0 APPS_TS_QUEUES *** +DATA/omtst/omprod/datafile/apps_ts_queues.316.867863425
18 0 APPS_TS_QUEUES *** +DATA/omtst/omprod/datafile/apps_ts_queues.332.867864497
19 0 APPS_TS_SEED *** +DATA/omtst/omprod/datafile/apps_ts_seed.353.867865317
20 0 APPS_TS_SEED *** +DATA/omtst/omprod/datafile/apps_ts_seed.349.867865197
21 0 APPS_TS_SUMMARY *** +DATA/omtst/omprod/datafile/apps_ts_summary.256.867855057
22 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.271.867857825
23 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.273.867858165
24 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.272.867858001
25 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.313.867863169
26 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.308.867862611
27 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.310.867862863
28 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.299.867861393
29 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.274.867858331
30 0 CTXD *** +DATA/omtst/omprod/datafile/ctxd.367.867865487
31 0 ODM *** +DATA/omtst/omprod/datafile/odm.368.867865491
32 0 OLAP *** +DATA/omtst/omprod/datafile/olap.369.867865491
33 0 OWAPUB *** +DATA/omtst/omprod/datafile/owapub.372.867865495
34 0 PORTAL *** +DATA/omtst/omprod/datafile/portal.370.867865493
35 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.350.867865221
36 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.307.867862477
37 0 APPS_TS_CUSTM_IDX *** +DATA/omtst/omprod/datafile/apps_ts_custm_idx.362.867865463
38 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.343.867865025
39 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.336.867864739
40 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.266.867856949
41 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.311.867862967
42 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.260.867855855
43 0 ORABPEL *** +DATA/omtst/omprod/datafile/orabpel.371.867865493
44 0 APPS_TS_IZU_IDX *** +DATA/omtst/omprod/datafile/apps_ts_izu_idx.365.867865481
45 0 APPS_TS_TOOLS *** +DATA/omtst/omprod/datafile/apps_ts_tools.363.867865471
46 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.333.867864573
47 0 UNDOTBS2 *** +DATA/omtst/omprod/datafile/undotbs2.337.867864773
48 0 APPS_TS_ARCHIVE *** +DATA/omtst/omprod/datafile/apps_ts_archive.338.867864809
49 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.351.867865257
50 0 APPS_TS_INTERFACE *** +DATA/omtst/omprod/datafile/apps_ts_interface.275.867858487
51 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.300.867861529
52 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.261.867856041
53 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.301.867861665
54 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.339.867864855
55 0 UNDOTBS2 *** +DATA/omtst/omprod/datafile/undotbs2.315.867863369
56 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.302.867861799
57 0 APPS_TS_INTERFACE *** +DATA/omtst/omprod/datafile/apps_ts_interface.276.867858621
58 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.262.867856227
59 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.340.867864889
60 0 APPS_TS_ARCHIVE *** +DATA/omtst/omprod/datafile/apps_ts_archive.312.867863073
61 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.267.867857133
62 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.352.867865291
63 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.303.867861935
64 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.334.867864619
65 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.277.867858757
66 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.263.867856403
67 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.268.867857309
68 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.304.867862071
69 0 APPS_TS_SUMMARY *** +DATA/omtst/omprod/datafile/apps_ts_summary.257.867855299
70 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.269.867857475
71 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.278.867858923
72 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.354.867865343
73 0 APPS_TS_NOLOGGING *** +DATA/omtst/omprod/datafile/apps_ts_nologging.314.867863273
74 0 APPS_TS_QUEUES *** +DATA/omtst/omprod/datafile/apps_ts_queues.317.867863509
75 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.305.867862205
76 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.264.867856577
77 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.265.867856763
78 0 APPS_TS_NOLOGGING *** +DATA/omtst/omprod/datafile/apps_ts_nologging.306.867862341
79 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.341.867864935
80 0 APPS_TS_TOOLS *** +DATA/omtst/omprod/datafile/apps_ts_tools.344.867865071
81 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.270.867857649
82 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.279.867859087
83 0 INTERIM *** +DATA/omtst/omprod/datafile/interim.366.867865483
84 0 UNDOTBS2 *** +DATA/omtst/omprod/datafile/undotbs2.318.867863595
85 0 UNDOTBS2 *** +DATA/omtst/omprod/datafile/undotbs2.319.867863639
86 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.320.867863685
87 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.280.867859263
88 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.281.867859399
89 0 APPS_TS_CUSTM_IDX *** +DATA/omtst/omprod/datafile/apps_ts_custm_idx.282.867859543
90 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.321.867863731
91 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.322.867863805
92 0 APPS_TS_NOLOGGING *** +DATA/omtst/omprod/datafile/apps_ts_nologging.293.867860723
93 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.323.867863881
94 0 APPS_TS_INTERFACE *** +DATA/omtst/omprod/datafile/apps_ts_interface.324.867863955
95 0 APPS_TS_QUEUES *** +DATA/omtst/omprod/datafile/apps_ts_queues.325.867864001
96 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.326.867864067
97 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.327.867864141
98 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.328.867864217
99 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.329.867864283
100 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.330.867864347
101 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.331.867864423
102 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.283.867859639
103 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.284.867859785
104 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.342.867864979
105 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.285.867859919
106 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.286.867860005
107 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.287.867860091
108 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.288.867860185
109 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.294.867860847
110 0 APPS_TS_SUMMARY *** +DATA/omtst/omprod/datafile/apps_ts_summary.295.867860953
111 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.296.867861037
112 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.297.867861163
113 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.298.867861259
114 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.289.867860321
115 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.290.867860427
116 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.291.867860521
117 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.292.867860607
118 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.394.869490097
119 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.395.872426247
120 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.396.872426271
121 0 APPS_TS_QUEUES *** +DATA/omtst/omprod/datafile/apps_ts_queues.397.872509221
122 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.398.872509571
123 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.399.872509661
124 0 APPS_TS_NOLOGGING *** +DATA/omtst/omprod/datafile/apps_ts_nologging.400.872510081
125 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.409.875113199
126 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.410.875262145
127 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.411.875262309
128 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.412.876319533
129 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.413.876562541
130 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.414.877597745
131 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.415.877600247
132 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.416.877600353
133 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.417.878573823
134 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.418.878831985
135 0 AUDIT_TS *** +DATA/omtst/omprod/datafile/audit_ts.419.878575229
136 0 AUDIT_TS *** +DATA/omtst/omprod/datafile/audit_ts.420.878575491
137 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.421.878832133
138 0 CTXD *** +DATA/omtst/omprod/datafile/ctxd.422.881502199
139 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.423.881502271
140 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.424.881502327
141 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.425.881502379
142 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.426.881628301
143 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.427.881809197
144 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.428.882271107
145 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.429.883236289
146 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.430.885207931
147 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.431.885208011
148 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.432.887565481
149 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.433.889281883
150 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.434.890506819
151 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.435.892462431
152 10204 XXLAAPPS_TS_PGC *** +DATA/omtst/omprod/datafile/xxlaapps_ts_pgc.dbf
153 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.437.893754595
154 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.438.894619813
155 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.439.894979101
156 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.440.896180625
157 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.441.896180719
158 0 APPS_TS_NOLOGGING *** +DATA/omtst/omprod/datafile/apps_ts_nologging.442.897699837
159 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.443.898082229
160 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.444.899803901
161 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.445.900753991
162 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.446.900846513
163 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.447.901015201
164 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.448.902575489
165 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.449.902575561
166 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.450.903180065
167 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.451.903180117
168 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.452.903180321
169 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.453.903784535
170 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.454.904572949
171 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.455.904573113
172 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.456.906548515
173 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.457.906986501
174 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.458.907597677
175 0 APPS_TS_ARCHIVE *** +DATA/omtst/omprod/datafile/apps_ts_archive.459.907837785
176 0 APPS_TS_ARCHIVE *** +DATA/omtst/omprod/datafile/apps_ts_archive.460.907837823
177 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.461.908189713
178 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.462.908528903
179 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.463.909752353
180 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.464.910091463
181 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.465.910259333
182 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.466.910787657
183 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.467.911390073
184 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.468.911578213
185 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.469.912070637
186 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.470.912247599

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20460 TMP 20460 +DATA/omtst/omprod/tempfile/tmp.393.868592555

RMAN>

Check the File size if it is zero we are good and we can proceed as the particular file structure is not available in the server . the File structure had been mentioned in the wrong path and the actual files lies in the different place inside the ASM . so to check the current file path structure we need to use list copy of database command to find the current structure of the database

Step 2 Check the database copy in the Physical stand by database

Check the copy of the database by using the list copy of database command in rman to find what is the location of the data file and if it is the oracle managed files the file names[ the numeric digit appeared in the file names might be changed but the data file number remains same ]

RMAN> list copy of database;

using target database control file instead of recovery catalog

List of Datafile Copies

=======================

Key File S Completion Time Ckp SCN Ckp Time

------- ---- - --------------- ---------- ---------------

631 1 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/system.806.911262335

766 2 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/system.1115.911357993

735 3 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/system.910.911310973

678 4 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/system.853.911278423

632 5 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/system.807.911262345

732 6 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/system.907.911310387

674 7 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/system.849.911277801

628 8 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/system.803.911261643

764 9 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/system.1113.911357807

767 10 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/system.1116.911358029

736 11 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/system.911.911311025

768 12 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_izu_dat.1117.911358163

729 13 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_archive.904.911309895

636 14 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_interface.811.911262669

637 15 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.812.911262669

752 16 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_nologging.1101.911354973

665 17 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_queues.840.911275265

670 18 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_queues.845.911277123

734 19 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_seed.909.911310941

733 20 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_seed.908.911310925

682 21 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_summary.857.911278681

594 22 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.768.911247503

698 23 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.875.911295151

686 24 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.861.911278685

722 25 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.897.911307251

721 26 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.896.911307149

618 27 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.793.911258823

661 28 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.836.911274599

595 29 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.419.911247503

634 30 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/ctxd.809.911262553

680 31 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/odm.855.911278599

770 32 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/olap.1119.911358175

635 33 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/owapub.810.911262553

681 34 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/portal.856.911278599

675 35 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.850.911278095

617 36 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.792.911258635

679 37 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_idx.854.911278589

627 38 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.802.911261641

625 39 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.800.911261379

639 40 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.814.911262671

664 41 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.839.911275115

591 42 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.771.911247499

738 43 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/orabpel.913.911311065

769 44 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_izu_idx.1118.911358169

633 45 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tools.808.911262553

671 46 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.846.911277279

730 47 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/undotbs2.905.911309895

672 48 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_archive.847.911277643

629 49 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.804.911261715

641 50 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_interface.816.911262671

719 51 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.894.911306493

683 52 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.858.911278683

750 53 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.1099.911354347

626 54 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.801.911261379

723 55 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/undotbs2.898.911307481

662 56 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.837.911274599

699 57 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_interface.874.911295151

638 58 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.813.911262669

761 59 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.1110.911357433

753 60 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_archive.1102.911355143

593 61 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.767.911247501

765 62 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.1114.911357895

616 63 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.791.911258447

760 64 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.1109.911357283

687 65 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.862.911278685

592 66 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.418.911247501

685 67 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.860.911278685

720 68 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.895.911307147

590 69 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_summary.772.911247499

697 70 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.876.911295149

596 71 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.770.911247503

676 72 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.851.911278367

619 73 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_nologging.794.911259193

754 74 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_queues.1103.911355439

751 75 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.1100.911354831

684 76 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.859.911278683

696 77 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.870.911295149

663 78 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_nologging.838.911274961

731 79 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.906.911310071

762 80 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tools.1111.911357433

640 81 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.815.911262671

642 82 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.817.911262673

737 83 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/interim.912.911311025

755 84 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/undotbs2.1104.911355441

724 85 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/undotbs2.899.911307789

620 86 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.795.911259193

700 87 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.873.911295151

688 88 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.863.911278687

597 89 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_idx.769.911247505

667 90 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.842.911275271

756 91 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.1105.911356719

709 92 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_nologging.884.911300681

725 93 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.900.911309439

621 94 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_interface.796.911259557

668 95 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_queues.843.911276821

757 96 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.1106.911356887

726 97 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.901.911309571

622 98 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.797.911260813

669 99 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.844.911276843

758 100 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.1107.911357121

727 101 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.902.911309679

643 102 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.818.911262673

701 103 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.872.911295153

673 104 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.848.911277801

689 105 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.864.911278687

598 106 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.773.911251135

644 107 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.819.911266667

702 108 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.877.911295153

741 109 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.916.911350069

606 110 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_summary.781.911254385

652 111 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.827.911270197

710 112 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.885.911303003

742 113 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.917.911350779

690 114 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.865.911283137

599 115 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.774.911251781

645 116 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.820.911267235

703 117 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.878.911299341

607 118 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.782.911254843

695 119 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.871.911295147

653 120 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.828.911270773

711 121 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_queues.886.911303003

691 122 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.866.911283137

600 123 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.775.911251783

646 124 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_nologging.821.911267235

704 125 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/system.879.911299341

692 126 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.867.911283807

601 127 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.776.911251971

647 128 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/system.822.911267587

743 129 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/system.918.911350781

705 130 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/system.880.911299341

693 131 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/system.868.911283997

608 132 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/system.783.911254843

623 133 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/system.798.911261103

654 134 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/system.829.911270775

602 135 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/audit_ts.777.911252157

712 136 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/audit_ts.887.911303003

744 137 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.919.911351415

630 138 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/ctxd.805.911262279

648 139 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.823.911267759

706 140 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.881.911299949

759 141 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/system.1108.911357185

728 142 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/system.903.911309827

624 143 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/system.799.911261205

677 144 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.852.911278423

609 145 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.784.911254975

655 146 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.830.911271109

713 147 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.888.911303583

745 148 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.920.911351611

610 149 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.785.911255151

656 150 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.831.911271281

714 151 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.889.911303583

694 153 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.869.911284185

611 154 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.786.911255465

657 155 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.832.911271459

715 156 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.890.911303933

746 157 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.410.911352141

603 158 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_nologging.778.911252493

612 159 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.787.911255501

658 160 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.833.911271459

649 161 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.824.911267929

716 162 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.891.911304275

707 163 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.882.911299951

747 164 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.411.911352143

613 165 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.788.911255865

659 166 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.834.911271481

739 167 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.914.911348447

604 168 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.779.911252493

650 169 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.825.911267929

717 170 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.892.911306437

748 171 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.412.911353695

614 172 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.789.911257795

660 173 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.835.911273921

718 174 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.893.911306447

763 175 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_archive.1112.911357623

749 176 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_archive.413.911354345

708 177 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.883.911300319

740 178 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.915.911348447

605 179 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.780.911252815

615 180 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.790.911258445

651 181 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.826.911267929

666 182 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.841.911275265

771 183 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.755.911422499

772 184 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.753.911638093

773 185 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.752.912085467

774 186 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.751.912523391

Step 3 IF some files has the values zero then run the Switch data file command

The file path which is stored inside the control_file is wrong we need to use the switch data file command to update the control file from the old path to the new Path the old path is where the path mentioned in the report schema and the new path is the path mentioned in the list copy of database command the physical file will be residing in the path of list copy of database command result

In Rman connect as the Physical standby database as target and run the switch data file command
run
{
Switch datafile '+DATA/omtst/omprod/datafile/APPS_TS_ARCHIVE.1102.911355143' to datafilecopy '+DATA/omtst/datafile/APPS_TS_ARCHIVE.1102.911355143';

}

Prepare a script with the source and destination path for all the files and run in rman the switch data file command should be executed under the run { } command syntax in rman

Once the script complete's you can check by using the report schema now you will find all the filw with the original size's which is equal to the source [Primary database]

Step 4 Issue report schema command to check and verify the size of the data file and issue the switch database to copy

RMAN> report schema;

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name OMTST

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1000 SYSTEM *** +DATA/omtst/datafile/system.806.911262335
2 1000 SYSTEM *** +DATA/omtst/datafile/system.1115.911357993
3 1000 SYSTEM *** +DATA/omtst/datafile/system.910.911310973
4 1000 SYSTEM *** +DATA/omtst/datafile/system.853.911278423
5 1000 SYSTEM *** +DATA/omtst/datafile/system.807.911262345
6 2000 SYSTEM *** +DATA/omtst/datafile/system.907.911310387
7 2000 SYSTEM *** +DATA/omtst/datafile/system.849.911277801
8 2000 SYSTEM *** +DATA/omtst/datafile/system.803.911261643
9 2000 SYSTEM *** +DATA/omtst/datafile/system.1113.911357807
10 1000 SYSTEM *** +DATA/omtst/datafile/system.1116.911358029
11 1000 SYSTEM *** +DATA/omtst/datafile/system.911.911311025
12 200 APPS_TS_IZU_DAT *** +DATA/omtst/datafile/apps_ts_izu_dat.1117.911358163
13 4000 APPS_TS_ARCHIVE *** +DATA/omtst/datafile/apps_ts_archive.904.911309895
14 14000 APPS_TS_INTERFACE *** +DATA/omtst/datafile/apps_ts_interface.811.911262669
15 14000 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.812.911262669
16 8500 APPS_TS_NOLOGGING *** +DATA/omtst/datafile/apps_ts_nologging.1101.911354973
17 6000 APPS_TS_QUEUES *** +DATA/omtst/datafile/apps_ts_queues.840.911275265
18 5000 APPS_TS_QUEUES *** +DATA/omtst/datafile/apps_ts_queues.845.911277123
19 1500 APPS_TS_SEED *** +DATA/omtst/datafile/apps_ts_seed.909.911310941
20 2000 APPS_TS_SEED *** +DATA/omtst/datafile/apps_ts_seed.908.911310925
21 18500 APPS_TS_SUMMARY *** +DATA/omtst/datafile/apps_ts_summary.857.911278681
22 12500 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.768.911247503
23 12000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.875.911295151
24 12500 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.861.911278685
25 7500 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.897.911307251
26 9000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.896.911307149
27 8000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.793.911258823
28 10000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.836.911274599
29 12000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.419.911247503
30 100 CTXD *** +DATA/omtst/datafile/ctxd.809.911262553
31 100 ODM *** +DATA/omtst/datafile/odm.855.911278599
32 100 OLAP *** +DATA/omtst/datafile/olap.1119.911358175
33 10 OWAPUB *** +DATA/omtst/datafile/owapub.810.911262553
34 100 PORTAL *** +DATA/omtst/datafile/portal.856.911278599
35 2000 SYSAUX *** +DATA/omtst/datafile/sysaux.850.911278095
36 9500 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.792.911258635
37 512 APPS_TS_CUSTM_IDX *** +DATA/omtst/datafile/apps_ts_custm_idx.854.911278589
38 3000 SYSAUX *** +DATA/omtst/datafile/sysaux.802.911261641
39 4000 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.800.911261379
40 13500 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.814.911262671
41 8000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.839.911275115
42 14000 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.771.911247499
43 100 ORABPEL *** +DATA/omtst/datafile/orabpel.913.911311065
44 200 APPS_TS_IZU_IDX *** +DATA/omtst/datafile/apps_ts_izu_idx.1118.911358169
45 500 APPS_TS_TOOLS *** +DATA/omtst/datafile/apps_ts_tools.808.911262553
46 4500 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.846.911277279
47 4000 UNDOTBS2 *** +DATA/omtst/datafile/undotbs2.905.911309895
48 4000 APPS_TS_ARCHIVE *** +DATA/omtst/datafile/apps_ts_archive.847.911277643
49 2000 SYSAUX *** +DATA/omtst/datafile/sysaux.804.911261715
50 12000 APPS_TS_INTERFACE *** +DATA/omtst/datafile/apps_ts_interface.816.911262671
51 10000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.894.911306493
52 14000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.858.911278683
53 10000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.1099.911354347
54 4000 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.801.911261379
55 6500 UNDOTBS2 *** +DATA/omtst/datafile/undotbs2.898.911307481
56 10000 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.837.911274599
57 12000 APPS_TS_INTERFACE *** +DATA/omtst/datafile/apps_ts_interface.874.911295151
58 14000 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.813.911262669
59 4000 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.1110.911357433
60 8000 APPS_TS_ARCHIVE *** +DATA/omtst/datafile/apps_ts_archive.1102.911355143
61 13000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.767.911247501
62 2000 SYSAUX *** +DATA/omtst/datafile/sysaux.1114.911357895
63 10000 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.791.911258447
64 4500 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.1109.911357283
65 12000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.862.911278685
66 14000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.418.911247501
67 13000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.860.911278685
68 10000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.895.911307147
69 15000 APPS_TS_SUMMARY *** +DATA/omtst/datafile/apps_ts_summary.772.911247499
70 13000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.876.911295149
71 12000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.770.911247503
72 1024 SYSAUX *** +DATA/omtst/datafile/sysaux.851.911278367
73 7000 APPS_TS_NOLOGGING *** +DATA/omtst/datafile/apps_ts_nologging.794.911259193
74 6000 APPS_TS_QUEUES *** +DATA/omtst/datafile/apps_ts_queues.1103.911355439
75 10000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.1100.911354831
76 14000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.859.911278683
77 14000 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.870.911295149
78 10000 APPS_TS_NOLOGGING *** +DATA/omtst/datafile/apps_ts_nologging.838.911274961
79 3072 SYSAUX *** +DATA/omtst/datafile/sysaux.906.911310071
80 2048 APPS_TS_TOOLS *** +DATA/omtst/datafile/apps_ts_tools.1111.911357433
81 13000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.815.911262671
82 12000 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.817.911262673
83 200 INTERIM *** +DATA/omtst/datafile/interim.912.911311025
84 5120 UNDOTBS2 *** +DATA/omtst/datafile/undotbs2.1104.911355441
85 5120 UNDOTBS2 *** +DATA/omtst/datafile/undotbs2.899.911307789
86 5120 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.795.911259193
87 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.873.911295151
88 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.863.911278687
89 10240 APPS_TS_CUSTM_IDX *** +DATA/omtst/datafile/apps_ts_custm_idx.769.911247505
90 5120 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.842.911275271
91 5120 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.1105.911356719
92 10204 APPS_TS_NOLOGGING *** +DATA/omtst/datafile/apps_ts_nologging.884.911300681
93 5120 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.900.911309439
94 5120 APPS_TS_INTERFACE *** +DATA/omtst/datafile/apps_ts_interface.796.911259557
95 5120 APPS_TS_QUEUES *** +DATA/omtst/datafile/apps_ts_queues.843.911276821
96 5120 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.1106.911356887
97 5120 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.901.911309571
98 5120 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.797.911260813
99 5120 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.844.911276843
100 5120 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.1107.911357121
101 5120 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.902.911309679
102 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.818.911262673
103 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.872.911295153
104 3072 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.848.911277801
105 10240 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.864.911278687
106 10240 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.773.911251135
107 10240 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.819.911266667
108 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.877.911295153
109 10204 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.916.911350069
110 10204 APPS_TS_SUMMARY *** +DATA/omtst/datafile/apps_ts_summary.781.911254385
111 10204 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.827.911270197
112 10204 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.885.911303003
113 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.917.911350779
114 10240 SYSAUX *** +DATA/omtst/datafile/sysaux.865.911283137
115 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.774.911251781
116 10240 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.820.911267235
117 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.878.911299341
118 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.782.911254843
119 32767 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.871.911295147
120 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.828.911270773
121 10204 APPS_TS_QUEUES *** +DATA/omtst/datafile/apps_ts_queues.886.911303003
122 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.866.911283137
123 10240 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.775.911251783
124 10240 APPS_TS_NOLOGGING *** +DATA/omtst/datafile/apps_ts_nologging.821.911267235
125 10240 SYSTEM *** +DATA/omtst/datafile/system.879.911299341
126 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.867.911283807
127 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.776.911251971
128 10240 SYSTEM *** +DATA/omtst/datafile/system.822.911267587
129 10204 SYSTEM *** +DATA/omtst/datafile/system.918.911350781
130 10240 SYSTEM *** +DATA/omtst/datafile/system.880.911299341
131 10240 SYSTEM *** +DATA/omtst/datafile/system.868.911283997
132 10204 SYSTEM *** +DATA/omtst/datafile/system.783.911254843
133 5024 SYSTEM *** +DATA/omtst/datafile/system.798.911261103
134 10204 SYSTEM *** +DATA/omtst/datafile/system.829.911270775
135 10240 AUDIT_TS *** +DATA/omtst/datafile/audit_ts.777.911252157
136 10204 AUDIT_TS *** +DATA/omtst/datafile/audit_ts.887.911303003
137 10204 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.919.911351415
138 1024 CTXD *** +DATA/omtst/datafile/ctxd.805.911262279
139 10240 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.823.911267759
140 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.881.911299949
141 5000 SYSTEM *** +DATA/omtst/datafile/system.1108.911357185
142 5000 SYSTEM *** +DATA/omtst/datafile/system.903.911309827
143 5000 SYSTEM *** +DATA/omtst/datafile/system.799.911261205
144 1024 SYSAUX *** +DATA/omtst/datafile/sysaux.852.911278423
145 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.784.911254975
146 10204 SYSAUX *** +DATA/omtst/datafile/sysaux.830.911271109
147 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.888.911303583
148 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.920.911351611
149 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.785.911255151
150 10204 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.831.911271281
151 10204 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.889.911303583
152 10204 XXLAAPPS_TS_PGC *** +DATA/omtst/omprod/datafile/xxlaapps_ts_pgc.dbf
153 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.869.911284185
154 10204 SYSAUX *** +DATA/omtst/datafile/sysaux.786.911255465
155 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.832.911271459
156 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.890.911303933
157 10204 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.410.911352141
158 10240 APPS_TS_NOLOGGING *** +DATA/omtst/datafile/apps_ts_nologging.778.911252493
159 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.787.911255501
160 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.833.911271459
161 10240 SYSAUX *** +DATA/omtst/datafile/sysaux.824.911267929
162 10204 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.891.911304275
163 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.882.911299951
164 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.411.911352143
165 10204 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.788.911255865
166 10204 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.834.911271481
167 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.914.911348447
168 10240 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.779.911252493
169 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.825.911267929
170 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.892.911306437
171 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.412.911353695
172 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.789.911257795
173 10204 SYSAUX *** +DATA/omtst/datafile/sysaux.835.911273921
174 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.893.911306447
175 2048 APPS_TS_ARCHIVE *** +DATA/omtst/datafile/apps_ts_archive.1112.911357623
176 10204 APPS_TS_ARCHIVE *** +DATA/omtst/datafile/apps_ts_archive.413.911354345
177 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.883.911300319
178 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.915.911348447
179 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.780.911252815
180 10204 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.790.911258445
181 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.826.911267929
182 5124 SYSAUX *** +DATA/omtst/datafile/sysaux.841.911275265
183 10240 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.755.911422499
184 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.753.911638093
185 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.752.912085467
186 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.751.912523391

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20460 TMP 20460 +DATA/omtst/tempfile/tmp.454.912764621

RMAN>

Saturday, October 8, 2016

Step-by-Step Guide to Setting Up and Upgrading Oracle CCB Database with Patching and Schema Enhancements

Step 1 : Check that the Spatial and Oracle Text have been installed with the Database.

Step 2 Create Tablespace for CCB Schema

Step 3 Create the User 's for CCB

CIS_USER – Limited Privilege User

Step 4: Apply CCB related Database Patches

Provide Patch Parameters:

Step 5 CCB Schema Install and Upgrade in the database

Wednesday, June 15, 2016

keytool error: java.lang.Exception: Cannot derive signature algorithm" When Creating a Keystore with AES

Steps for Creating a Full Public Key Infrastructure (PKI)

Step 1: Generate an AES Secret Key (Symmetric Key)

Step 2: Create an RSA Public/Private Key Pair for SSL

Step 3: Generate a CSR (Certificate Signing Request)

Step 4: Sign the CSR Using OpenSSL (as CA)

Step 5: Import the CA Root Certificate into the Keystore

Step 6: Import the Signed Certificate Back to the Keystore

Wednesday, June 1, 2016

EXIM

Managing and Clearing the Exim Mail Queue on a cPanel Server

Step 1: Viewing the Exim Mail Queue

Step 2: Removing Messages from the Queue

Step 3: Verifying the Mail Queue is Cleared

Step 4: Removing Specific Locked Messages

Conclusion

Thursday, May 26, 2016

ORA-19909: datafile 1 belongs to an orphan incarnation

Recovery Slave PR00 previously exited with exception 19909 Step 1 Recovery Slave PR00 previously exited with exception 19909

RMAN-03002: failure of switch to copy command

RMAN-06571: datafile 1 does not have recoverable copy

`CIS_USER` – Limited Privilege User

Recovery Slave PR00 previously exited with exception 19909
Step 1 Recovery Slave PR00 previously exited with exception 19909