EBS - Step by Step Oracle Apps Cloning 12.2 with 19c Database using RMAN Step by Step

EBS - Step by Step Oracle Apps Cloning 12.2 with 19c Database using RMAN Step by Step

SOURCE Instance:

ORACLE_SID=FUAT

EBS: 12.2.10

AD/TXK: Delta 12

DB Version: 19.10

Container DB Name : funcdb

Pluggable Database =FUAT

OS Version: OEL 7.9

Datafile: on ASM (NON-RAC)

Target Instance:

ORACLE_SID=BEE

EBS: 12.2.10

AD/TXK: Delta 12

DB Version: 19.10

Container DB Name : beecdb

Pluggable Database=BEE

OS Version: OEL 7.9

Datafile: on ASM (NON-RAC)

Let's DO it..

Note: I am creating a shared folder between my source and target server so that I can use it for taking all backup and restoring from same.

/media/sf_19c_EBS12210_Backup

1. RUN AD PRE-CLONE UTILITY on DB and APPS Nodes

a) Make sure the cdb listener and database (CDB and PDB) is running

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE

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

FUNCDB    READ WRITE

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 FUAT                           READ WRITE NO

b) Make sure etcc folder is present in Oracle home/appsutil

/oraapps122/DATABASE/FUAT/19c/appsutil/etcc

If it is not present

mkdir -p /oraapps122/DATABASE/FUAT/19c/appsutil/etcc

Download patch 17537119(latest) from My Oracle Support, unzip it under /oraapps122/DATABASE/FUAT/19c/appsutil/etcc and run /oraapps122/DATABASE/FUAT/19c/appsutil/etcc/checkDBpatch.sh to avoid ADOP related issues.

Before running /oraapps122/DATABASE/FUAT/19c/appsutil/etcc/checkDBpatch.sh  source the pluggable database (PDB) environment file.

Multitenant identified.

 - Container database (CDB) identified via s_cdb_name is funcdb

 - Pluggable database (PDB) identified via s_pdb_name is FUAT

c) Run the following commands to source the pluggable database (PDB) environment file on the database node at $ORACLE_HOME

cd $ORACLE_HOME

. <PDB_NAME>_hostname.env

cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

perl adpreclone.pl dbTier

[oracle@funebs122 ~]$ . FUAT_funebs122.env

[oracle@funebs122 ~]$ cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

[oracle@funebs122 FUAT_funebs122]$ perl adpreclone.pl dbTier

                     Copyright (c) 2011, 2014 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adpreclone Version 120.31.12020000.25

Enter the APPS User Password:

Verifying if Database Patch checker (ETCC) exists in /oraapps122/DATABASE/FUAT/19c/appsutil/etcc

Running:

perl /oraapps122/DATABASE/FUAT/19c/appsutil/bin/adclone.pl java=/oraapps122/DATABASE/FUAT/19c/appsutil/jre mode=stage stage=/oraapps122/DATABASE/FUAT/19c/appsutil/clone component=dbTier method=CUSTOM dbctx=/oraapps122/DATABASE/FUAT/19c/appsutil/FUAT_funebs122.xml showProgress

Beginning database tier Stage - Sat Apr  2 11:35:10 2022

/oraapps122/DATABASE/FUAT/19c/appsutil/jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oraapps122/DATABASE/FUAT/19c/oui -classpath /oraapps122/DATABASE/FUAT/19c/lib/xmlparserv2.jar:/oraapps122/DATABASE/FUAT/19c/jdbc/lib/ojdbc8.jar:/oraapps122/DATABASE/FUAT/19c/appsutil/java:/oraapps122/DATABASE/FUAT/19c/oui/jlib/OraInstaller.jar:/oraapps122/DATABASE/FUAT/19c/oui/jlib/ewt3.jar:/oraapps122/DATABASE/FUAT/19c/oui/jlib/share.jar:/oraapps122/DATABASE/FUAT/19c/oui/jlib/srvm.jar:/oraapps122/DATABASE/FUAT/19c/jlib/ojmisc.jar   oracle.apps.ad.clone.StageDBTier -e /oraapps122/DATABASE/FUAT/19c/appsutil/FUAT_funebs122.xml -stage /oraapps122/DATABASE/FUAT/19c/appsutil/clone -tmp /tmp -method CUSTOM    -showProgress

APPS Password :

Log file located at /oraapps122/DATABASE/FUAT/19c/appsutil/log/FUAT_funebs122/StageDBTier_04021135.log

  |     75% completed

Completed Stage...

Sat Apr  2 11:36:08 2022

This is a CDB instance. Hence not checking duplicate data files.

d) Run the following commands on the application node:

Note: At least Weblogic Admin server should be up while doing this.

Source Run filesystem

. EBSApps run

cd $ADMIN_SCRIPTS_HOME

perl adpreclone.pl appsTier

[applmgr@funebs122 ~]$ . EBSapps.env run

  E-Business Suite Environment Information

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

  RUN File System           : /oraapps122/APPS/FUAT/fs2/EBSapps/appl

  PATCH File System         : /oraapps122/APPS/FUAT/fs1/EBSapps/appl

  Non-Editioned File System : /oraapps122/APPS/FUAT/fs_ne

  DB Host: funebs122.lab  Service/SID: FUAT

  Sourcing the RUN File System ...

[applmgr@funebs122 ~]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@funebs122 scripts]$ perl adpreclone.pl appsTier

                     Copyright (c) 2011, 2014 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adpreclone Version 120.31.12020000.25

Enter the APPS User Password:

Enter the Weblogic AdminServer password :

 Checking the status of the Oracle WebLogic Administration Server....

 Running perl /oraapps122/APPS/FUAT/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/oraapps122/APPS/FUAT/fs2/inst/apps/FUAT_funebs122/appl/admin/FUAT_funebs122.xml -servername=AdminServer -promptmsg=hide

The Oracle WebLogic Administration Server is up.

wlsDomainName: EBS_domain

WLS Domain Name is VALID.

Running:

perl /oraapps122/APPS/FUAT/fs2/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/oraapps122/APPS/FUAT/fs2/EBSapps/comn/util/jdk64 mode=stage stage=/oraapps122/APPS/FUAT/fs2/EBSapps/comn/clone component=appsTier method= appctx=/oraapps122/APPS/FUAT/fs2/inst/apps/FUAT_funebs122/appl/admin/FUAT_funebs122.xml showProgress

 Setting the wls environment

Beginning application tier Stage - Sat Apr  2 11:47:27 2022

/oraapps122/APPS/FUAT/fs2/EBSapps/comn/util/jdk64/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /oraapps122/APPS/FUAT/fs2/FMW_Home/webtier/lib/xmlparserv2.jar:/oraapps122/APPS/FUAT/fs2/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/oraapps122/APPS/FUAT/fs2/EBSapps/comn/java/classes:/oraapps122/APPS/FUAT/fs2/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/oraapps122/APPS/FUAT/fs2/FMW_Home/webtier/oui/jlib/ewt3.jar:/oraapps122/APPS/FUAT/fs2/FMW_Home/webtier/oui/jlib/share.jar:/oraapps122/APPS/FUAT/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/oraapps122/APPS/FUAT/fs2/FMW_Home/webtier/jlib/ojmisc.jar:/oraapps122/APPS/FUAT/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/oraapps122/APPS/FUAT/fs2/FMW_Home/oracle_common/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.StageAppsTier -e /oraapps122/APPS/FUAT/fs2/inst/apps/FUAT_funebs122/appl/admin/FUAT_funebs122.xml -stage /oraapps122/APPS/FUAT/fs2/EBSapps/comn/clone -tmp /tmp -method CUSTOM   -showProgress -nopromptmsg

Log file located at /oraapps122/APPS/FUAT/fs2/inst/apps/FUAT_funebs122/admin/log/clone/StageAppsTier_04021147.log

  |     20% completed

Completed Stage...

Sat Apr  2 12:10:18 2022

2. Take the RMAN Backup of CDB Database

Back up the full CDB database with archives by using RMAN Hot backup and copy it to the target node.

Make sure CDB database is in archive mode.

Source CDB environment file

cd $ORACLE_HOME

. <CDB_NAME>_hostname.env

rman target /

run {

 allocate channel c1 type disk;

 allocate channel c2 type disk;

 BACKUP as compressed backupset FULL FILESPERSET 10 FORMAT '/media/sf_19c_EBS12210_Backup/FUAT_D_%s_%p_%t.bak' DATABASE;

 BACKUP as compressed backupset filesperset 10 FORMAT '/media/sf_19c_EBS12210_Backup/FUAT_A_%s_%p_%t.bak' ARCHIVELOG ALL skip inaccessible;

 BACKUP FORMAT '/media/sf_19c_EBS12210_Backup/FUAT_C_%s_%p_%t.bak' CURRENT CONTROLFILE;

  RELEASE CHANNEL c1;

 RELEASE CHANNEL c2;

}

[oracle@funebs122 backup]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sat Apr 2 13:52:55 2022

Version 19.10.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: FUNCDB (DBID=3473472359)

RMAN> run {

 allocate channel c1 type disk;

 allocate channel c2 type disk;

 BACKUP as compressed backupset FULL FILESPERSET 10 FORMAT '/media/sf_19c_EBS12210_Backup/FUAT_D_%s_%p_%t.bak' DATABASE;

 BACKUP as compressed backupset filesperset 10 FORMAT '/media/sf_19c_EBS12210_Backup/FUAT_A_%s_%p_%t.bak' ARCHIVELOG ALL skip inaccessible;

 BACKUP FORMAT '/media/sf_19c_EBS12210_Backup/FUAT_C_%s_%p_%t.bak' CURRENT CONTROLFILE;

  RELEASE CHANNEL c1;

 RELEASE CHANNEL c2;

}2> 3> 4> 5> 6> 7> 8> 9>

using target database control file instead of recovery catalog

allocated channel: c1

channel c1: SID=41 device type=DISK

allocated channel: c2

channel c2: SID=42 device type=DISK

Starting backup at 02-APR-22

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00039 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_tx_data.260.1096979491

input datafile file number=00025 name=+EBS_DATA/FUAT/DATAFILE/system.271.1096980051

input datafile file number=00052 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_seed.276.1096980259

input datafile file number=00041 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_tx_data.284.1096980625

input datafile file number=00033 name=+EBS_DATA/FUAT/DATAFILE/system.290.1096980849

input datafile file number=00056 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_interface.295.1096980987

input datafile file number=00013 name=+EBS_DATA/FUAT/DATAFILE/system.301.1096981141

input datafile file number=00049 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_seed.308.1096981299

input datafile file number=00067 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_tools.310.1096981331

channel c1: starting piece 1 at 02-APR-22

channel c2: starting compressed full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00016 name=+EBS_DATA/FUAT/DATAFILE/system.262.1096979661

input datafile file number=00019 name=+EBS_DATA/FUAT/DATAFILE/system.265.1096979789

input datafile file number=00023 name=+EBS_DATA/FUAT/DATAFILE/system.269.1096979971

input datafile file number=00050 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_seed.274.1096980179

input datafile file number=00047 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_tx_idx.281.1096980489

input datafile file number=00053 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_seed.288.1096980777

input datafile file number=00043 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_tx_idx.294.1096980951

input datafile file number=00009 name=+EBS_DATA/FUAT/DATAFILE/system.297.1096981037

input datafile file number=00066 name=+EBS_DATA/FUAT/DATAFILE/sysaux.303.1096981191

input datafile file number=00061 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_queues.311.1096981345

channel c2: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_3_1_1100958796.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:26:46

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00037 name=+EBS_DATA/FUAT/DATAFILE/apps_undots1.304.1096981217

input datafile file number=00048 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_tx_idx.278.1096980351

input datafile file number=00062 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_media.283.1096980579

input datafile file number=00042 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_tx_data.289.1096980813

input datafile file number=00028 name=+EBS_DATA/FUAT/DATAFILE/system.296.1096981011

input datafile file number=00065 name=+EBS_DATA/FUAT/DATAFILE/sysaux.302.1096981165

input datafile file number=00034 name=+EBS_DATA/FUAT/DATAFILE/ctxd.314.1096981369

input datafile file number=00064 name=+EBS_DATA/FUAT/DATAFILE/olap.316.1096981379

input datafile file number=00035 name=+EBS_DATA/FUAT/DATAFILE/owapub.319.1096981387

input datafile file number=00060 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_queues.309.1096981315

channel c1: starting piece 1 at 02-APR-22

channel c2: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_4_1_1100958796.bak tag=TAG20220402T135313 comment=NONE

channel c2: backup set complete, elapsed time: 00:37:13

channel c2: starting compressed full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00015 name=+EBS_DATA/FUAT/DATAFILE/system.261.1096979615

input datafile file number=00018 name=+EBS_DATA/FUAT/DATAFILE/system.264.1096979753

input datafile file number=00022 name=+EBS_DATA/FUAT/DATAFILE/system.268.1096979925

input datafile file number=00027 name=+EBS_DATA/FUAT/DATAFILE/system.273.1096980133

input datafile file number=00040 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_tx_data.280.1096980443

input datafile file number=00031 name=+EBS_DATA/FUAT/DATAFILE/system.287.1096980731

input datafile file number=00044 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_tx_idx.293.1096980925

input datafile file number=00010 name=+EBS_DATA/FUAT/DATAFILE/system.298.1096981063

input datafile file number=00059 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_archive.305.1096981243

input datafile file number=00063 name=+EBS_DATA/FUAT/DATAFILE/odm.318.1096981385

channel c2: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_5_1_1100960404.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:28:14

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00038 name=+EBS_DATA/FUAT/DATAFILE/apps_undots1.277.1096980295

input datafile file number=00021 name=+EBS_DATA/FUAT/DATAFILE/system.267.1096979879

input datafile file number=00026 name=+EBS_DATA/FUAT/DATAFILE/system.272.1096980097

input datafile file number=00032 name=+EBS_DATA/FUAT/DATAFILE/system.279.1096980397

input datafile file number=00045 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_tx_idx.286.1096980697

input datafile file number=00057 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_summary.292.1096980899

input datafile file number=00011 name=+EBS_DATA/FUAT/DATAFILE/system.299.1096981089

input datafile file number=00029 name=+EBS_DATA/FUAT/DATAFILE/system.306.1096981267

input datafile file number=00036 name=+EBS_DATA/FUAT/DATAFILE/portal.312.1096981361

input datafile file number=00055 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_interface.317.1096981383

channel c1: starting piece 1 at 02-APR-22

channel c2: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_6_1_1100961031.bak tag=TAG20220402T135313 comment=NONE

channel c2: backup set complete, elapsed time: 00:38:23

channel c2: starting compressed full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00017 name=+EBS_DATA/FUAT/DATAFILE/system.263.1096979707

input datafile file number=00020 name=+EBS_DATA/FUAT/DATAFILE/system.266.1096979833

input datafile file number=00024 name=+EBS_DATA/FUAT/DATAFILE/system.270.1096980017

input datafile file number=00051 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_seed.275.1096980215

input datafile file number=00046 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_tx_idx.282.1096980543

input datafile file number=00014 name=+EBS_DATA/FUAT/DATAFILE/system.285.1096980661

input datafile file number=00054 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_seed.291.1096980873

input datafile file number=00012 name=+EBS_DATA/FUAT/DATAFILE/system.300.1096981115

input datafile file number=00030 name=+EBS_DATA/FUAT/DATAFILE/system.307.1096981283

input datafile file number=00058 name=+EBS_DATA/FUAT/DATAFILE/apps_ts_nologging.313.1096981365

channel c2: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_7_1_1100962099.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:35:53

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00001 name=+EBS_DATA/FUNCDB/system01.dbf

input datafile file number=00003 name=+EBS_DATA/FUNCDB/sysaux01.dbf

channel c1: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_9_1_1100964254.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:08:05

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00004 name=+EBS_DATA/FUNCDB/undotbs01.dbf

input datafile file number=00007 name=+EBS_DATA/FUNCDB/users01.dbf

channel c1: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_10_1_1100964740.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:03

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00005 name=+EBS_DATA/FUNCDB/pdbseed/system01.dbf

input datafile file number=00008 name=+EBS_DATA/FUNCDB/pdbseed/undotbs01.dbf

channel c1: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_11_1_1100964744.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:03:45

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00006 name=+EBS_DATA/FUNCDB/pdbseed/sysaux01.dbf

channel c1: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_12_1_1100964970.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:55

channel c2: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_8_1_1100963337.bak tag=TAG20220402T135313 comment=NONE

channel c2: backup set complete, elapsed time: 00:36:58

Finished backup at 02-APR-22

Starting backup at 02-APR-22

current log archived

channel c1: starting compressed archived log backup set

channel c1: specifying archived log(s) in backup set

input archived log thread=1 sequence=6 RECID=2 STAMP=1100958116

channel c1: starting piece 1 at 02-APR-22

channel c2: starting compressed archived log backup set

channel c2: specifying archived log(s) in backup set

input archived log thread=1 sequence=9 RECID=4 STAMP=1100965556

channel c2: starting piece 1 at 02-APR-22

channel c2: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_A_14_1_1100965558.bak tag=TAG20220402T154557 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:07

channel c2: starting compressed archived log backup set

channel c2: specifying archived log(s) in backup set

input archived log thread=1 sequence=7 RECID=1 STAMP=1100958110

input archived log thread=1 sequence=8 RECID=3 STAMP=1100958117

channel c2: starting piece 1 at 02-APR-22

channel c2: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_A_15_1_1100965566.bak tag=TAG20220402T154557 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_A_13_1_1100965558.bak tag=TAG20220402T154557 comment=NONE

channel c1: backup set complete, elapsed time: 00:01:53

Finished backup at 02-APR-22

Starting backup at 02-APR-22

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

including current control file in backup set

channel c1: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FUAT_C_16_1_1100965672.bak tag=TAG20220402T154751 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:01

Finished backup at 02-APR-22

Starting Control File and SPFILE Autobackup at 02-APR-22

piece handle=/oraapps122/DATABASE/FUAT/19c/dbs/c-3473472359-20220402-00 comment=NONE

Finished Control File and SPFILE Autobackup at 02-APR-22

released channel: c1

released channel: c2

After completing the backup, copy the backup to target server. In my case I am using shared file system so no need for any copy.

Note: if you have more CPU threads you can increase number or channels.

3.  Copy the Source binaries to Target

Perform the following steps to copy the source application binaries and database binaries to the target node.

a) On the source database node, tar 19.0.0(19c) binaries 

I will tar backup and copy on /media/sf_19c_EBS12210_Backup

 tar -zcvf /media/sf_19c_EBS12210_Backup/19c_home.tar.gz 19c

 

 

b) On the application node, tar only the EBSapps directory of RUN FS(fs2 in my case) from the source file system.

tar -zcvf /media/sf_19c_EBS12210_Backup/EBSapps_fs2_run.tar.gz EBSapps

4. Prepare Target Server

Clean up the target database and application node if it already exists

Make sure all pre-reqs are installed on target server and respective directories are present.

Untar the Source system tar file on Target system

From Oracle user:

mkdir -p /oraapps122/DATABASE/BEE

Copy the Oracle Home tar from source to target and untar.

[oracle@funebs122 DATABASE]$ cd /oraapps122/DATABASE/BEE

[oracle@funebs122 BEE]$ cp /media/sf_19c_EBS12210_Backup/19c_home.tar.gz .

[oracle@funebs122 BEE]$ tar -zxvf 19c_home.tar.gz

Once Untar is done remove the tar file

rm -rf 19c_home.tar.gz

From applmgr user 

mkdir -p /oraapps122/APPS/BEE

[applmgr@funebs122 BEE]$ cd /oraapps122/APPS/BEE

[applmgr@funebs122 BEE]$ mkdir fs1 fs2 fs_ne

[applmgr@funebs122 fs2]$ cd /oraapps122/APPS/BEE/fs2

cp /media/sf_19c_EBS12210_Backup/EBSapps_fs2_run.tar.gz  .

untar the EBSapps.

tar -zxvf EBSapps_fs2_run.tar.gz 

rm -rf  EBSapps_fs2_run.tar.gz 

I am copy in fs2 as in my source fs2 was the run file system

5. Configure Oracle Home on the target database node.

Before running adcfgclone.pl to configure $Oracle_Home, clean up the oraInventory directory. 

a) Create pairsfile.txt File (I am not doing this)

Create a <NEW_ORACLE_HOME>/appsutil/clone/pairsfile.txt text file.

New Oracle Home = /oraapps122/DATABASE/BEE/19c

For single-node database, if you want to generate the context file non-interactively, you can use the following content:

s_undo_tablespace=<Source (PDB) system undo tablespace name>

s_db_oh=<Location of new ORACLE_HOME>

s_dbhost=<Target hostname>

s_dbSid=<Target PDB name>

s_pdb_name=<Target PDB name>

s_cdb_name=<Target CDB SID>

s_base=<Base directory for DB Oracle Home>

s_dbuser=<DB User>

s_dbgroup=<DB group> (Not applicable on Windows)

s_dbhome1=<Data directory>

s_display=<Display>

s_dbCluster=false

s_isDBCluster=n

s_dbport=<DB port>

s_port_pool=<Port pool number>

Note: If there are data tops other than the one defined in s_dbhome1, you should define them by adding the context variables s_dbhome2, s_dbhome3 and s_dbhome4.

b) Create the DB context file:

$ cd <NEW ORACLE_HOME>/appsutil/clone/bin

$ perl adclonectx.pl \

contextfile=<Source database context file>\

template=<NEW ORACLE_HOME>/appsutil/template/adxdbctx.tmp \

[pairsfile=<if Pairs file generated in above step>

[oracle@funebs122 appsutil]$ cd /oraapps122/DATABASE/BEE/19c/appsutil/clone/bin

[oracle@funebs122 bin]$ perl adclonectx.pl contextfile=/oraapps122/DATABASE/BEE/19c/appsutil/FUAT_funebs122.xml template=/oraapps122/DATABASE/BEE/19c/appsutil/template/adxdbctx.tmp

                     Copyright (c) 2011, 2015 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adclonectx Version 120.30.12020000.22

Running:

/oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -classpath /oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/../jlib/ojdbc8.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/../jlib/xmlparserv2.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/../jlib/java: oracle.apps.ad.context.CloneContext  -e /oraapps122/DATABASE/BEE/19c/appsutil/FUAT_funebs122.xml -tmpl /oraapps122/DATABASE/BEE/19c/appsutil/template/adxdbctx.tmp

Enter the APPS password :

Log file located at /oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/CloneContext_0403155929.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [funebs122] :

It is recommended that your inputs are validated by the program.

However you might choose not to validate them under following circumstances:

        -If cloning a context on source system for a remote system.

        -If cloning a context on a machine where the ports are taken and

         you do not want to shutdown the services at this point.

        -If cloning a context but the database it needs to connect is not available.

Do you want the inputs to be validated (y/n) [n] ? : n

Target System Base Directory : /oraapps122/DATABASE/BEE

Target Instance is RAC (y/n) [n] : n

Target System CDB Name : BEECDB

Target System PDB Name : BEE

Oracle OS User [oracle] :

Oracle OS Group [dba] :

Role separation is supported y/n [n] ? : n

Number of DATA_TOP's on the Target System [3] : 1

Target System DATA_TOP Directory 1 : +EBS_DATA  (In case you are using file_system give filesystem path)

Specify value for OSBACKUPDBA group [dba] :

Specify value for OSDGDBA group [dba] :

Specify value for OSKMDBA group [dba] :

Specify value for OSRACDBA group [dba] :

Target System RDBMS ORACLE_HOME Directory [/oraapps122/DATABASE/BEE/19.0.0] : /oraapps122/DATABASE/BEE/19c

Do you want to preserve the Display [localhost:10.0] (y/n)  : n

Target System Display [funebs122:0.0] :

Target System Port Pool [0-99] : 30  (This will be container port number 1521+30=1551)

Report file located at /oraapps122/DATABASE/BEE/19c/appsutil/temp/portpool.lst

New context path and file name [/oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml] :

The new database context file has been created :

  /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml

contextfile=/oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml

Check Clone Context logfile /oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/CloneContext_0403155929.log for details.

c) Configure the database technology stack or Oracle Home on target

Navigate to <ORACLE_HOME>/appsutil/clone/bin and run Rapid Clone (adcfgclone.pl utility) with the following parameters to configure the database technology stack:

$ perl adcfgclone.pl dbTechStack <Complete path to the target context file>

[oracle@funebs122 bin]$ cd /oraapps122/DATABASE/BEE/19c/appsutil/clone/bin

[oracle@funebs122 bin]$ perl adcfgclone.pl dbTechStack /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml

                     Copyright (c) 2002, 2015 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.65

Enter the APPS password :

Running Rapid Clone with command:

Running:

perl /oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/adclone.pl java=/oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/../jre mode=apply stage=/oraapps122/DATABASE/BEE/19c/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml showProgress contextValidated=false

Beginning rdbms home Apply - Sun Apr  3 16:02:38 2022

/oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oraapps122/DATABASE/BEE/19c/oui -classpath /oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/xmlparserv2.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/ojdbc8.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/java:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/oui/OraInstaller.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/oui/ewt3.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/oui/share.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/oui/srvm.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTechStack -e /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml -stage /oraapps122/DATABASE/BEE/19c/appsutil/clone   -showProgress

APPS Password : Log file located at /oraapps122/DATABASE/BEE/19c/appsutil/log/BEE_funebs122/ApplyDBTechStack_04031602.log

  |      0% completed

Log file located at /oraapps122/DATABASE/BEE/19c/appsutil/log/BEE_funebs122/ApplyDBTechStack_04031602.log

  |      0% completed

Completed Apply...

Sun Apr  3 16:15:25 2022

Running ETCC to check status of DB technology patches...

 +===============================================================+

 |    Copyright (c) 2005, 2020 Oracle and/or its affiliates.     |

 |                     All rights reserved.                      |

 |             Oracle E-Business Suite Release 12.2              |

 |          Database EBS Technology Codelevel Checker            |

 +===============================================================+

Validating context file: /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml

Using context file from command line argument:

/oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml

Starting Database EBS Technology Codelevel Checker, Version 120.82

Sun Apr  3 16:15:26 IST 2022

Log file for this session : /oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/log/checkDBpatch_22050.log

Identifying database release.

Database release set to 19.10.0.0.

Multitenant identified.

 - Container database (CDB) identified via s_cdb_name is BEECDB

 - Pluggable database (PDB) identified via s_pdb_name is BEE

Connecting to database.

+-----------------------------------------------------------------------------+

[WARNING] DB-ETCC: Could not connect to database, so unable to check:

  - Whether database is in READ-WRITE mode.

  - Existence of table needed to store DB-ETCC results.

  - Enablement of database In-Memory option.

    If this feature is enabled, additional fixes need to be verified.

Resolve the database connectivity issue, and then rerun DB-ETCC.

+-----------------------------------------------------------------------------+

Bugfix file /oraapps122/DATABASE/BEE/19c/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.57

This file will be used for identifying missing bugfixes.

Mapping file /oraapps122/DATABASE/BEE/19c/appsutil/etcc/db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.32

This file will be used for mapping bugfixes to patches.

[WARNING] DB-ETCC: Bugfix XML file (/oraapps122/DATABASE/BEE/19c/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml) is more than 30 days old.

 Check if a newer version is available in patch 17537119.

Checking Bugfix XML file for 19.10.0.0_RU

Could not get list of bugfixes from /oraapps122/DATABASE/BEE/19c/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml for Database version 19.10.0.0_RU.

Verify correct XML file is being used and then retry.

WARNING: ETCC did not run successfully. Run the command '/oraapps122/DATABASE/BEE/19c/appsutil/etcc/checkDBpatch.sh contextfile=/oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml' from commandline and make sure it completes successfully. Failure to do so might result in ADOP related issues.

Ignore the ETCC warning.

d) Create listener.ora and tnsnames.ora files:

Set below before running

export ORACLE_HOME=/oraapps122/DATABASE/BEE/19c

export PATH=$ORACLE_HOME/perl/bin:$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib

export PERL5LIB=$ORACLE_HOME/perl/lib/5.28.1:$ORACLE_HOME/perl/site_perl/5.28.1:$ORACLE_HOME/appsutil/perl

export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH

cd $ORACLE_HOME/appsutil

./txkSetCfgCDB.env -dboraclehome=<ORACLE_HOME>

$ cd <ORACLE_HOME>/appsutil/bin

$ perl txkGenCDBTnsAdmin.pl -dboraclehome=<ORACLE_HOME> -cdbname=<Name of the target container database> \

-cdbsid=<SID of the target container database> -dbport=<Target DB port> -outdir=$ORACLE_HOME/appsutil/log \

-israc=<yes/no> [-virtualhostname=<virtual hostname>]

[oracle@funebs122 ~]$ export ORACLE_HOME=/oraapps122/DATABASE/BEE/19c

[oracle@funebs122 ~]$ export PATH=$ORACLE_HOME/perl/bin:$ORACLE_HOME/bin:$PATH

[oracle@funebs122 ~]$ export LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib

[oracle@funebs122 ~]$ export PERL5LIB=$ORACLE_HOME/perl/lib/5.28.1:$ORACLE_HOME/perl/site_perl/5.28.1:$ORACLE_HOME/appsutil/perl

[oracle@funebs122 ~]$ export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH

[oracle@funebs122 ~]$ cd /oraapps122/DATABASE/BEE/19c/appsutil

[oracle@funebs122 bin]$ chmod 755 txkSetCfgCDB.env

[oracle@funebs122 appsutil]$ ./txkSetCfgCDB.env -dboraclehome=/oraapps122/DATABASE/BEE/19c

Oracle Home being passed: /oraapps122/DATABASE/BEE/19c

[oracle@funebs122 bin]$ cd /oraapps122/DATABASE/BEE/19c/appsutil/bin

[oracle@funebs122 bin]$ perl txkGenCDBTnsAdmin.pl -dboraclehome=/oraapps122/DATABASE/BEE/19c -cdbname=BEECDB -cdbsid=BEECDB -dbport=1551 -outdir=/oraapps122/DATABASE/BEE/19c/appsutil/log -israc=no

Script Name    : txkGenCDBTnsAdmin.pl

Script Version : 120.0.12020000.9

Started        : Sun Apr  3 16:37:04 IST 2022

Log File       : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Sun_Apr_3_16_37_04_2022/txkGenCDBTnsAdmin.log

-----------

Values used

-----------

Database Oracle Home    : /oraapps122/DATABASE/BEE/19c

CDB NAME                : BEECDB

CDB SID                 : BEECDB

Database port           : 1551

OUT Directory           : /oraapps122/DATABASE/BEE/19c/appsutil/log

Is RAC?                 : no

Virtual Hostname        :

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

Validating oracle home...

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

Oracle Home: /oraapps122/DATABASE/BEE/19c exists.

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

Validating out directory...

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

Out directory: /oraapps122/DATABASE/BEE/19c/appsutil/log exists.

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

Inside getDBHostDetails()...

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

DB Hostname : funebs122

DB Domain   : lab

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

Inside getDBPort()...

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

DB Port passed as an argument, using the same.

DB Port: 1551

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

Inside generateCDBTNSAdminContent()...

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

Creating the directory: /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Sun_Apr_3_16_37_04_2022/tns_admin_cdb_bkp

Creating the directory: /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Sun_Apr_3_16_37_04_2022/tns_admin_cdb_temp

listener_template: listener_ora_cdb_db19.tmp

sqlnet_template: sqlnet_ora_cdb_db19.tmp

Copying the file

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

SOURCE : /oraapps122/DATABASE/BEE/19c/appsutil/template/listener_ora_cdb_db19.tmp

TARGET : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Sun_Apr_3_16_37_04_2022/tns_admin_cdb_temp/listener.ora

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

Inside replaceContextVariables()...

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

Copying the file

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

SOURCE : /oraapps122/DATABASE/BEE/19c/network/admin/listener.ora

TARGET : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Sun_Apr_3_16_37_04_2022/tns_admin_cdb_bkp/listener.ora

Copying the file

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

SOURCE : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Sun_Apr_3_16_37_04_2022/tns_admin_cdb_temp/listener.ora

TARGET : /oraapps122/DATABASE/BEE/19c/network/admin/listener.ora

Copying the file

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

SOURCE : /oraapps122/DATABASE/BEE/19c/appsutil/template/tnsnames_ora_cdb_db121.tmp

TARGET : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Sun_Apr_3_16_37_04_2022/tns_admin_cdb_temp/tnsnames.ora

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

Inside replaceContextVariables()...

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

Copying the file

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

SOURCE : /oraapps122/DATABASE/BEE/19c/network/admin/tnsnames.ora

TARGET : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Sun_Apr_3_16_37_04_2022/tns_admin_cdb_bkp/tnsnames.ora

Copying the file

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

SOURCE : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Sun_Apr_3_16_37_04_2022/tns_admin_cdb_temp/tnsnames.ora

TARGET : /oraapps122/DATABASE/BEE/19c/network/admin/tnsnames.ora

Copying the file

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

SOURCE : /oraapps122/DATABASE/BEE/19c/appsutil/template/sqlnet_ora_cdb_db19.tmp

TARGET : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Sun_Apr_3_16_37_04_2022/tns_admin_cdb_temp/sqlnet.ora

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

Inside replaceContextVariables()...

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

Copying the file

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

SOURCE : /oraapps122/DATABASE/BEE/19c/network/admin/sqlnet.ora

TARGET : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Sun_Apr_3_16_37_04_2022/tns_admin_cdb_bkp/sqlnet.ora

Copying the file

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

SOURCE : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Sun_Apr_3_16_37_04_2022/tns_admin_cdb_temp/sqlnet.ora

TARGET : /oraapps122/DATABASE/BEE/19c/network/admin/sqlnet.ora

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

Inside updateCDBSqlNetOra()...

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

Updating the IFILE entry...

Exiting from the script.

Ended: Sun Apr  3 16:37:04 IST 2022

e) If this is a repeated cloned instance, use the CONTEXT_FILE backup to configure the target database binaries(Not Needed as I am doing on new Server):

cd <RDBMS ORACLE_HOME>/appsutil/clone/bin

perl adcfgclone.pl dbTechStack <Full Path of CONTEXT_FILE backup location>

f) If this is a repeated cloned instance, revert the dbs and TNS files so that all configuration files and init parameters are intact after configuration(Not Needed as I am doing on new Server).

g) Start the listener.

$ cd <ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>

$ ./adcdblnctl.sh start <CDB SID>

[oracle@funebs122 scripts]$ cd $ORACLE_HOME/appsutil/scripts/BEE_funebs122

[oracle@funebs122 BEE_funebs122]$ ls

adautocfg.sh  adcdblnctl.sh  addbctl.sh   adexecsql.pl   adstopcdb.sql  adstrtcdb.sql

adcdbctl.sh   adchknls.pl    addlnctl.sh  adpreclone.pl  adstopdb.sql   adstrtdb.sql

[oracle@funebs122 BEE_funebs122]$ ./addlnctl.sh start BEECDB

Logfile: /oraapps122/DATABASE/BEE/19c/appsutil/log/BEE_funebs122/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process BEECDB ...

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 03-APR-2022 16:45:16

Copyright (c) 1991, 2020, Oracle.  All rights reserved.

Starting /oraapps122/DATABASE/BEE/19c/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production

System parameter file is /oraapps122/DATABASE/BEE/19c/network/admin/BEE_funebs122/listener.ora

Log messages written to /oraapps122/DATABASE/BEE/19c/admin/BEE_funebs122/diag/tnslsnr/funebs122/beecdb/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=funebs122.lab)(PORT=1551)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=funebs122.lab)(PORT=1551)))

STATUS of the LISTENER

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

Alias                     BEECDB

Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date                03-APR-2022 16:45:17

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /oraapps122/DATABASE/BEE/19c/network/admin/BEE_funebs122/listener.ora

Listener Log File         /oraapps122/DATABASE/BEE/19c/admin/BEE_funebs122/diag/tnslsnr/funebs122/beecdb/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=funebs122.lab)(PORT=1551)))

Services Summary...

Service "BEE" has 1 instance(s).

  Instance "BEE", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /oraapps122/DATABASE/BEE/19c/appsutil/log/BEE_funebs122/addlnctl.txt for more information ...

Note: If the source Oracle E-Business Suite instance is at the R12.TXK.C.DELTA.12 codelevel, the above commands may exit with status 1, waiting for the PDB service to start. This error can be ignored as the database is not yet restored.

6. Restore and Recover the database

After you configure $Oracle_Home, start the target database restore by using that backup that you took earlier:

a) Before restoring, check that the following parameters are correct in the target node.

db_file_name_convert

log_file_name_convert

I will copy the source cdb pfile and use it for target

[oracle@funebs122 dbs]$ cp initfuncdb.ora initBEECDB.ora

cd $ORACLE_HOME/dbs

vi initBEECDB.ora

add below lines

DB_FILE_NAME_CONVERT=(+EBS_DATA,+EBS_DATA)

LOG_FILE_NAME_CONVERT=(+EBS_DATA,+EBS_DATA)

*.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=funebs122.lab)(PORT=1551)))'

*.db_name='BEECDB'   

Replace funcdb with beecdb

and FUNCDB with BEECDB

mkdir -p /oraapps122/DATABASE/admin/beecdb/adump

b) Start the target database in a nomount state and run the following RMAN command to restore the database:

cd /oraapps122/DATABASE/BEE/19c

Source CDB environment file

. BEECDB_funebs122.env

sqlplus '/as sysdba'

startup nomount pfile='/oraapps122/DATABASE/BEE/19c/dbs/initBEECDB.ora'

rman auxiliary /

run

{

   allocate auxiliary channel c1 device type disk;

   allocate auxiliary channel c2 device type disk;

   duplicate database to '<CDB NAME>' backup location '<RMAN backup     location>' nofilenamecheck;

   release channel c1;

   release channel c2;

}

[oracle@funebs122 dbs]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Apr 3 17:08:02 2022

Version 19.10.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: BEECDB (not mounted)

RMAN> exit

Recovery Manager complete.

[oracle@funebs122 dbs]$ rman auxiliary /

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Apr 3 17:08:15 2022

Version 19.10.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to auxiliary database: BEECDB (not mounted)

RMAN> run

{

   allocate auxiliary channel c1 device type disk;

   allocate auxiliary channel c2 device type disk;

   duplicate database to 'BEECDB' backup location '/media/sf_19c_EBS12210_Backup' nofilenamecheck;

   release channel c1;

   release channel c2;

}2> 3> 4> 5> 6> 7> 8>

allocated channel: c1

channel c1: SID=223 device type=DISK

allocated channel: c2

channel c2: SID=23 device type=DISK

Starting Duplicate Db at 03-APR-22

searching for database ID

found backup of database ID 3473472359

contents of Memory Script:

{

   sql clone "create spfile from memory";

}

executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:

{

   shutdown clone immediate;

   startup clone nomount;

}

executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area    2147482136 bytes

Fixed Size                     9136664 bytes

Variable Size                436207616 bytes

Database Buffers            1677721600 bytes

Redo Buffers                  24416256 bytes

allocated channel: c1

channel c1: SID=4 device type=DISK

allocated channel: c2

channel c2: SID=24 device type=DISK

contents of Memory Script:

{

   sql clone "alter system set  db_name =

 ''FUNCDB'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   sql clone "alter system set  db_unique_name =

 ''beecdb'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   shutdown clone immediate;

   startup clone force nomount

   restore clone primary controlfile from  '/media/sf_19c_EBS12210_Backup/FUAT_C_16_1_1100965672.bak';

   alter clone database mount;

}

executing Memory Script

sql statement: alter system set  db_name =  ''FUNCDB'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''beecdb'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area    2147482136 bytes

Fixed Size                     9136664 bytes

Variable Size                436207616 bytes

Database Buffers            1677721600 bytes

Redo Buffers                  24416256 bytes

allocated channel: c1

channel c1: SID=4 device type=DISK

allocated channel: c2

channel c2: SID=22 device type=DISK

Starting restore at 03-APR-22

channel c2: skipped, AUTOBACKUP already found

channel c1: restoring control file

channel c1: restore complete, elapsed time: 00:00:10

output file name=+EBS_DATA/BEECDB/control01.ctl

output file name=+EBS_DATA/BEECDB/control02.ctl

Finished restore at 03-APR-22

database mounted

RMAN-05529: warning: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.

contents of Memory Script:

{

   set until scn  5965174432198;

   set newname for datafile  1 to

 "+EBS_DATA/funcdb/system01.dbf";

   set newname for datafile  3 to

 "+EBS_DATA/funcdb/sysaux01.dbf";

   set newname for datafile  4 to

 "+EBS_DATA/funcdb/undotbs01.dbf";

   set newname for datafile  5 to

 "+EBS_DATA/funcdb/pdbseed/system01.dbf";

   set newname for datafile  6 to

 "+EBS_DATA/funcdb/pdbseed/sysaux01.dbf";

   set newname for datafile  7 to

 "+EBS_DATA/funcdb/users01.dbf";

   set newname for datafile  8 to

 "+EBS_DATA/funcdb/pdbseed/undotbs01.dbf";

   set newname for datafile  9 to

 "+EBS_DATA";

   set newname for datafile  10 to

 "+EBS_DATA";

   set newname for datafile  11 to

 "+EBS_DATA";

   set newname for datafile  12 to

 "+EBS_DATA";

   set newname for datafile  13 to

 "+EBS_DATA";

   set newname for datafile  14 to

 "+EBS_DATA";

   set newname for datafile  15 to

 "+EBS_DATA";

   set newname for datafile  16 to

 "+EBS_DATA";

   set newname for datafile  17 to

 "+EBS_DATA";

   set newname for datafile  18 to

 "+EBS_DATA";

   set newname for datafile  19 to

 "+EBS_DATA";

   set newname for datafile  20 to

 "+EBS_DATA";

   set newname for datafile  21 to

 "+EBS_DATA";

   set newname for datafile  22 to

 "+EBS_DATA";

   set newname for datafile  23 to

 "+EBS_DATA";

   set newname for datafile  24 to

 "+EBS_DATA";

   set newname for datafile  25 to

 "+EBS_DATA";

   set newname for datafile  26 to

 "+EBS_DATA";

   set newname for datafile  27 to

 "+EBS_DATA";

   set newname for datafile  28 to

 "+EBS_DATA";

   set newname for datafile  29 to

 "+EBS_DATA";

   set newname for datafile  30 to

 "+EBS_DATA";

   set newname for datafile  31 to

 "+EBS_DATA";

   set newname for datafile  32 to

 "+EBS_DATA";

   set newname for datafile  33 to

 "+EBS_DATA";

   set newname for datafile  34 to

 "+EBS_DATA";

   set newname for datafile  35 to

 "+EBS_DATA";

   set newname for datafile  36 to

 "+EBS_DATA";

   set newname for datafile  37 to

 "+EBS_DATA";

   set newname for datafile  38 to

 "+EBS_DATA";

   set newname for datafile  39 to

 "+EBS_DATA";

   set newname for datafile  40 to

 "+EBS_DATA";

   set newname for datafile  41 to

 "+EBS_DATA";

   set newname for datafile  42 to

 "+EBS_DATA";

   set newname for datafile  43 to

 "+EBS_DATA";

   set newname for datafile  44 to

 "+EBS_DATA";

   set newname for datafile  45 to

 "+EBS_DATA";

   set newname for datafile  46 to

 "+EBS_DATA";

   set newname for datafile  47 to

 "+EBS_DATA";

   set newname for datafile  48 to

 "+EBS_DATA";

   set newname for datafile  49 to

 "+EBS_DATA";

   set newname for datafile  50 to

 "+EBS_DATA";

   set newname for datafile  51 to

 "+EBS_DATA";

   set newname for datafile  52 to

 "+EBS_DATA";

   set newname for datafile  53 to

 "+EBS_DATA";

   set newname for datafile  54 to

 "+EBS_DATA";

   set newname for datafile  55 to

 "+EBS_DATA";

   set newname for datafile  56 to

 "+EBS_DATA";

   set newname for datafile  57 to

 "+EBS_DATA";

   set newname for datafile  58 to

 "+EBS_DATA";

   set newname for datafile  59 to

 "+EBS_DATA";

   set newname for datafile  60 to

 "+EBS_DATA";

   set newname for datafile  61 to

 "+EBS_DATA";

   set newname for datafile  62 to

 "+EBS_DATA";

   set newname for datafile  63 to

 "+EBS_DATA";

   set newname for datafile  64 to

 "+EBS_DATA";

   set newname for datafile  65 to

 "+EBS_DATA";

   set newname for datafile  66 to

 "+EBS_DATA";

   set newname for datafile  67 to

 "+EBS_DATA";

   restore

   clone database

   ;

}

executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 03-APR-22

channel c1: starting datafile backup set restore

channel c1: specifying datafile(s) to restore from backup set

channel c1: restoring datafile 00001 to +EBS_DATA/funcdb/system01.dbf

channel c1: restoring datafile 00003 to +EBS_DATA/funcdb/sysaux01.dbf

channel c1: reading from backup piece /media/sf_19c_EBS12210_Backup/FUAT_D_9_1_1100964254.bak

channel c2: starting datafile backup set restore

channel c2: specifying datafile(s) to restore from backup set

channel c2: restoring datafile 00011 to +EBS_DATA

channel c2: restoring datafile 00021 to +EBS_DATA

channel c2: restoring datafile 00026 to +EBS_DATA

channel c2: restoring datafile 00029 to +EBS_DATA

channel c2: restoring datafile 00032 to +EBS_DATA

channel c2: restoring datafile 00036 to +EBS_DATA

channel c2: restoring datafile 00038 to +EBS_DATA

channel c2: restoring datafile 00045 to +EBS_DATA

channel c2: restoring datafile 00055 to +EBS_DATA

channel c2: restoring datafile 00057 to +EBS_DATA

channel c2: reading from backup piece /media/sf_19c_EBS12210_Backup/FUAT_D_7_1_1100962099.bak

channel c1: piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_9_1_1100964254.bak tag=TAG20220402T135313

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:04:16

channel c1: starting datafile backup set restore

channel c1: specifying datafile(s) to restore from backup set

channel c1: restoring datafile 00012 to +EBS_DATA

channel c1: restoring datafile 00014 to +EBS_DATA

channel c1: restoring datafile 00017 to +EBS_DATA

channel c1: restoring datafile 00020 to +EBS_DATA

channel c1: restoring datafile 00024 to +EBS_DATA

channel c1: restoring datafile 00030 to +EBS_DATA

channel c1: restoring datafile 00046 to +EBS_DATA

channel c1: restoring datafile 00051 to +EBS_DATA

channel c1: restoring datafile 00054 to +EBS_DATA

channel c1: restoring datafile 00058 to +EBS_DATA

channel c1: reading from backup piece /media/sf_19c_EBS12210_Backup/FUAT_D_8_1_1100963337.bak

channel c2: piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_7_1_1100962099.bak tag=TAG20220402T135313

channel c2: restored backup piece 1

channel c2: restore complete, elapsed time: 00:22:13

channel c2: starting datafile backup set restore

channel c2: specifying datafile(s) to restore from backup set

channel c2: restoring datafile 00010 to +EBS_DATA

channel c2: restoring datafile 00015 to +EBS_DATA

channel c2: restoring datafile 00018 to +EBS_DATA

channel c2: restoring datafile 00022 to +EBS_DATA

channel c2: restoring datafile 00027 to +EBS_DATA

channel c2: restoring datafile 00031 to +EBS_DATA

channel c2: restoring datafile 00040 to +EBS_DATA

channel c2: restoring datafile 00044 to +EBS_DATA

channel c2: restoring datafile 00059 to +EBS_DATA

channel c2: restoring datafile 00063 to +EBS_DATA

channel c2: reading from backup piece /media/sf_19c_EBS12210_Backup/FUAT_D_6_1_1100961031.bak

channel c1: piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_8_1_1100963337.bak tag=TAG20220402T135313

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:23:13

channel c1: starting datafile backup set restore

channel c1: specifying datafile(s) to restore from backup set

channel c1: restoring datafile 00028 to +EBS_DATA

channel c1: restoring datafile 00034 to +EBS_DATA

channel c1: restoring datafile 00035 to +EBS_DATA

channel c1: restoring datafile 00037 to +EBS_DATA

channel c1: restoring datafile 00042 to +EBS_DATA

channel c1: restoring datafile 00048 to +EBS_DATA

channel c1: restoring datafile 00060 to +EBS_DATA

channel c1: restoring datafile 00062 to +EBS_DATA

channel c1: restoring datafile 00064 to +EBS_DATA

channel c1: restoring datafile 00065 to +EBS_DATA

channel c1: reading from backup piece /media/sf_19c_EBS12210_Backup/FUAT_D_5_1_1100960404.bak

channel c2: piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_6_1_1100961031.bak tag=TAG20220402T135313

channel c2: restored backup piece 1

channel c2: restore complete, elapsed time: 00:22:53

channel c2: starting datafile backup set restore

channel c2: specifying datafile(s) to restore from backup set

channel c2: restoring datafile 00005 to +EBS_DATA/funcdb/pdbseed/system01.dbf

channel c2: restoring datafile 00008 to +EBS_DATA/funcdb/pdbseed/undotbs01.dbf

channel c2: reading from backup piece /media/sf_19c_EBS12210_Backup/FUAT_D_11_1_1100964744.bak

channel c1: piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_5_1_1100960404.bak tag=TAG20220402T135313

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:18:01

channel c1: starting datafile backup set restore

channel c1: specifying datafile(s) to restore from backup set

channel c1: restoring datafile 00006 to +EBS_DATA/funcdb/pdbseed/sysaux01.dbf

channel c1: reading from backup piece /media/sf_19c_EBS12210_Backup/FUAT_D_12_1_1100964970.bak

channel c1: piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_12_1_1100964970.bak tag=TAG20220402T135313

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:00:46

channel c1: starting datafile backup set restore

channel c1: specifying datafile(s) to restore from backup set

channel c1: restoring datafile 00009 to +EBS_DATA

channel c1: restoring datafile 00016 to +EBS_DATA

channel c1: restoring datafile 00019 to +EBS_DATA

channel c1: restoring datafile 00023 to +EBS_DATA

channel c1: restoring datafile 00043 to +EBS_DATA

channel c1: restoring datafile 00047 to +EBS_DATA

channel c1: restoring datafile 00050 to +EBS_DATA

channel c1: restoring datafile 00053 to +EBS_DATA

channel c1: restoring datafile 00061 to +EBS_DATA

channel c1: restoring datafile 00066 to +EBS_DATA

channel c1: reading from backup piece /media/sf_19c_EBS12210_Backup/FUAT_D_4_1_1100958796.bak

channel c2: piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_11_1_1100964744.bak tag=TAG20220402T135313

channel c2: restored backup piece 1

channel c2: restore complete, elapsed time: 00:01:27

channel c2: starting datafile backup set restore

channel c2: specifying datafile(s) to restore from backup set

channel c2: restoring datafile 00013 to +EBS_DATA

channel c2: restoring datafile 00025 to +EBS_DATA

channel c2: restoring datafile 00033 to +EBS_DATA

channel c2: restoring datafile 00039 to +EBS_DATA

channel c2: restoring datafile 00041 to +EBS_DATA

channel c2: restoring datafile 00049 to +EBS_DATA

channel c2: restoring datafile 00052 to +EBS_DATA

channel c2: restoring datafile 00056 to +EBS_DATA

channel c2: restoring datafile 00067 to +EBS_DATA

channel c2: reading from backup piece /media/sf_19c_EBS12210_Backup/FUAT_D_3_1_1100958796.bak

channel c2: piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_3_1_1100958796.bak tag=TAG20220402T135313

channel c2: restored backup piece 1

channel c2: restore complete, elapsed time: 00:19:57

channel c2: starting datafile backup set restore

channel c2: specifying datafile(s) to restore from backup set

channel c2: restoring datafile 00004 to +EBS_DATA/funcdb/undotbs01.dbf

channel c2: restoring datafile 00007 to +EBS_DATA/funcdb/users01.dbf

channel c2: reading from backup piece /media/sf_19c_EBS12210_Backup/FUAT_D_10_1_1100964740.bak

channel c2: piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_10_1_1100964740.bak tag=TAG20220402T135313

channel c2: restored backup piece 1

channel c2: restore complete, elapsed time: 00:00:25

channel c1: piece handle=/media/sf_19c_EBS12210_Backup/FUAT_D_4_1_1100958796.bak tag=TAG20220402T135313

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:22:38

Finished restore at 03-APR-22

contents of Memory Script:

{

   switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=67 STAMP=1101061183 file name=+EBS_DATA/funcdb/system01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=68 STAMP=1101061183 file name=+EBS_DATA/funcdb/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=69 STAMP=1101061183 file name=+EBS_DATA/funcdb/undotbs01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=70 STAMP=1101061183 file name=+EBS_DATA/funcdb/pdbseed/system01.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=71 STAMP=1101061184 file name=+EBS_DATA/funcdb/pdbseed/sysaux01.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=72 STAMP=1101061184 file name=+EBS_DATA/funcdb/users01.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=73 STAMP=1101061184 file name=+EBS_DATA/funcdb/pdbseed/undotbs01.dbf

datafile 9 switched to datafile copy

input datafile copy RECID=74 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.273.1101059827

datafile 10 switched to datafile copy

input datafile copy RECID=75 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.286.1101058383

datafile 11 switched to datafile copy

input datafile copy RECID=76 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.342.1101057051

datafile 12 switched to datafile copy

input datafile copy RECID=77 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.322.1101057307

datafile 13 switched to datafile copy

input datafile copy RECID=78 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.266.1101059843

datafile 14 switched to datafile copy

input datafile copy RECID=79 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.321.1101057307

datafile 15 switched to datafile copy

input datafile copy RECID=80 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.324.1101058383

datafile 16 switched to datafile copy

input datafile copy RECID=81 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.312.1101059825

datafile 17 switched to datafile copy

input datafile copy RECID=82 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.333.1101057305

datafile 18 switched to datafile copy

input datafile copy RECID=83 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.327.1101058383

datafile 19 switched to datafile copy

input datafile copy RECID=84 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.306.1101059825

datafile 20 switched to datafile copy

input datafile copy RECID=85 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.332.1101057305

datafile 21 switched to datafile copy

input datafile copy RECID=86 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.339.1101057049

datafile 22 switched to datafile copy

input datafile copy RECID=87 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.326.1101058383

datafile 23 switched to datafile copy

input datafile copy RECID=88 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.296.1101059825

datafile 24 switched to datafile copy

input datafile copy RECID=89 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.331.1101057305

datafile 25 switched to datafile copy

input datafile copy RECID=90 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.271.1101059841

datafile 26 switched to datafile copy

input datafile copy RECID=91 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.338.1101057049

datafile 27 switched to datafile copy

input datafile copy RECID=92 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.291.1101058383

datafile 28 switched to datafile copy

input datafile copy RECID=93 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.313.1101058699

datafile 29 switched to datafile copy

input datafile copy RECID=94 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.341.1101057053

datafile 30 switched to datafile copy

input datafile copy RECID=95 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.257.1101057621

datafile 31 switched to datafile copy

input datafile copy RECID=96 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.281.1101058383

datafile 32 switched to datafile copy

input datafile copy RECID=97 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.337.1101057051

datafile 33 switched to datafile copy

input datafile copy RECID=98 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.268.1101059843

datafile 34 switched to datafile copy

input datafile copy RECID=99 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/ctxd.288.1101058699

datafile 35 switched to datafile copy

input datafile copy RECID=100 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/owapub.280.1101058733

datafile 36 switched to datafile copy

input datafile copy RECID=101 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/portal.258.1101057827

datafile 37 switched to datafile copy

input datafile copy RECID=102 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.284.1101697

datafile 38 switched to datafile copy

input datafile copy RECID=103 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.340.1101047

datafile 39 switched to datafile copy

input datafile copy RECID=104 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.272.1059841

datafile 40 switched to datafile copy

input datafile copy RECID=105 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.278.1058383

datafile 41 switched to datafile copy

input datafile copy RECID=106 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.269.1059843

datafile 42 switched to datafile copy

input datafile copy RECID=107 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.305.1058699

datafile 43 switched to datafile copy

input datafile copy RECID=108 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.274.1159827

datafile 44 switched to datafile copy

input datafile copy RECID=109 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.282.1158383

datafile 45 switched to datafile copy

input datafile copy RECID=110 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.343.1157051

datafile 46 switched to datafile copy

input datafile copy RECID=111 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.259.1157307

datafile 47 switched to datafile copy

input datafile copy RECID=112 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.276.1159827

datafile 48 switched to datafile copy

input datafile copy RECID=113 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.283.1158699

datafile 49 switched to datafile copy

input datafile copy RECID=114 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.265.1101843

datafile 50 switched to datafile copy

input datafile copy RECID=115 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.304.1101825

datafile 51 switched to datafile copy

input datafile copy RECID=116 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.330.1101307

datafile 52 switched to datafile copy

input datafile copy RECID=117 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.270.1101841

datafile 53 switched to datafile copy

input datafile copy RECID=118 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.275.1101827

datafile 54 switched to datafile copy

input datafile copy RECID=119 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.323.1101307

datafile 55 switched to datafile copy

input datafile copy RECID=120 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.32501057899

datafile 56 switched to datafile copy

input datafile copy RECID=121 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.26701059843

datafile 57 switched to datafile copy

input datafile copy RECID=122 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_summary.334.1057051

datafile 58 switched to datafile copy

input datafile copy RECID=123 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_nologging.28901058433

datafile 59 switched to datafile copy

input datafile copy RECID=124 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_archive.277.1059415

datafile 60 switched to datafile copy

input datafile copy RECID=125 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.295.1158699

datafile 61 switched to datafile copy

input datafile copy RECID=126 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.262.1160667

datafile 62 switched to datafile copy

input datafile copy RECID=127 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_media.311.1108699

datafile 63 switched to datafile copy

input datafile copy RECID=128 STAMP=1101061190 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/odm.290.1101059469

datafile 64 switched to datafile copy

input datafile copy RECID=129 STAMP=1101061190 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/olap.293.1101058717

datafile 65 switched to datafile copy

input datafile copy RECID=130 STAMP=1101061190 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.292.1101058699

datafile 66 switched to datafile copy

input datafile copy RECID=131 STAMP=1101061190 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.263.1101060239

datafile 67 switched to datafile copy

input datafile copy RECID=132 STAMP=1101061190 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tools.264.1100127

contents of Memory Script:

{

   set until scn  5965174432198;

   recover

   clone database

    delete archivelog

   ;

}

executing Memory Script

executing command: SET until clause

Starting recover at 03-APR-22

starting media recovery

channel c1: starting archived log restore to default destination

channel c1: restoring archived log

archived log thread=1 sequence=9

channel c1: reading from backup piece /media/sf_19c_EBS12210_Backup/FUAT_A_14_1_1100965558.bak

channel c1: piece handle=/media/sf_19c_EBS12210_Backup/FUAT_A_14_1_1100965558.bak tag=TAG20220402T154557

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:00:03

archived log file name=/oraapps122/DATABASE/BEE/19c/dbs/arch1_9_1099181806.arc thread=1 sequence=9

channel clone_default: deleting archived log(s)

archived log file name=/oraapps122/DATABASE/BEE/19c/dbs/arch1_9_1099181806.arc RECID=1 STAMP=1101061219

media recovery complete, elapsed time: 00:00:07

Finished recover at 03-APR-22

released channel: c1

released channel: c2

Oracle instance started

Total System Global Area    2147482136 bytes

Fixed Size                     9136664 bytes

Variable Size                436207616 bytes

Database Buffers            1677721600 bytes

Redo Buffers                  24416256 bytes

contents of Memory Script:

{

   sql clone "alter system set  db_name =

 ''BEECDB'' comment=

 ''Reset to original value by RMAN'' scope=spfile";

   sql clone "alter system reset  db_unique_name scope=spfile";

}

executing Memory Script

sql statement: alter system set  db_name =  ''BEECDB'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile

Oracle instance started

Total System Global Area    2147482136 bytes

Fixed Size                     9136664 bytes

Variable Size                436207616 bytes

Database Buffers            1677721600 bytes

Redo Buffers                  24416256 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "BEECDB" RESETLOGS ARCHIVELOG

  MAXLOGFILES     16

  MAXLOGMEMBERS      3

  MAXDATAFILES     1024

  MAXINSTANCES     8

  MAXLOGHISTORY      292

 LOGFILE

  GROUP     1 ( '+EBS_DATA/funcdb/redo01.log' ) SIZE 1000 M  REUSE,

  GROUP     2 ( '+EBS_DATA/funcdb/redo02.log' ) SIZE 1000 M  REUSE,

  GROUP     3 ( '+EBS_DATA/funcdb/redo03.log' ) SIZE 1000 M  REUSE

 DATAFILE

  '+EBS_DATA/funcdb/system01.dbf',

  '+EBS_DATA/funcdb/pdbseed/system01.dbf',

  '+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.273.1101059827'

 CHARACTER SET AL32UTF8

contents of Memory Script:

{

   set newname for tempfile  1 to

 "+EBS_DATA/funcdb/temp01.dbf";

   set newname for tempfile  2 to

 "+EBS_DATA/funcdb/pdbseed/temp012022-03-13_01-57-38-003-am.dbf";

   set newname for tempfile  3 to

 "+EBS_DATA";

   set newname for tempfile  4 to

 "+EBS_DATA";

   set newname for tempfile  5 to

 "+EBS_DATA";

   switch clone tempfile all;

   catalog clone datafilecopy  "+EBS_DATA/funcdb/sysaux01.dbf",

 "+EBS_DATA/funcdb/undotbs01.dbf",

 "+EBS_DATA/funcdb/pdbseed/sysaux01.dbf",

 "+EBS_DATA/funcdb/users01.dbf",

 "+EBS_DATA/funcdb/pdbseed/undotbs01.dbf",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.286.1101058383",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.342.1101057051",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.322.1101057307",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.266.1101059843",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.321.1101057307",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.324.1101058383",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.312.1101059825",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.333.1101057305",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.327.1101058383",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.306.1101059825",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.332.1101057305",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.339.1101057049",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.326.1101058383",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.296.1101059825",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.331.1101057305",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.271.1101059841",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.338.1101057049",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.291.1101058383",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.313.1101058699",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.341.1101057053",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.257.1101057621",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.281.1101058383",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.337.1101057051",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.268.1101059843",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/ctxd.288.1101058699",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/owapub.280.1101058733",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/portal.258.1101057827",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.284.1101058697",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.340.1101057047",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.272.1101059841",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.278.1101058383",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.269.1101059843",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.305.1101058699",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.274.1101059827",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.282.1101058383",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.343.1101057051",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.259.1101057307",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.276.1101059827",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.283.1101058699",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.265.1101059843",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.304.1101059825",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.330.1101057307",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.270.1101059841",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.275.1101059827",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.323.1101057307",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.325.1101057899",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.267.1101059843",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_summary.334.1101057051",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_nologging.289.1101058433",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_archive.277.1101059415",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.295.1101058699",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.262.1101060667",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_media.311.1101058699",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/odm.290.1101059469",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/olap.293.1101058717",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.292.1101058699",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.263.1101060239",

 "+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tools.264.1101060127";

   switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to +EBS_DATA/funcdb/temp01.dbf in control file

renamed tempfile 2 to +EBS_DATA/funcdb/pdbseed/temp012022-03-13_01-57-38-003-am.dbf in control file

renamed tempfile 3 to +EBS_DATA in control file

renamed tempfile 4 to +EBS_DATA in control file

renamed tempfile 5 to +EBS_DATA in control file

cataloged datafile copy

datafile copy file name=+EBS_DATA/funcdb/sysaux01.dbf RECID=1 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/funcdb/undotbs01.dbf RECID=2 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/funcdb/pdbseed/sysaux01.dbf RECID=3 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/funcdb/users01.dbf RECID=4 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/funcdb/pdbseed/undotbs01.dbf RECID=5 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.286.1101058383 RECID=6 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.342.1101057051 RECID=7 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.322.1101057307 RECID=8 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.266.1101059843 RECID=9 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.321.1101057307 RECID=10 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.324.1101058383 RECID=11 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.312.1101059825 RECID=12 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.333.1101057305 RECID=13 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.327.1101058383 RECID=14 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.306.1101059825 RECID=15 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.332.1101057305 RECID=16 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.339.1101057049 RECID=17 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.326.1101058383 RECID=18 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.296.1101059825 RECID=19 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.331.1101057305 RECID=20 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.271.1101059841 RECID=21 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.338.1101057049 RECID=22 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.291.1101058383 RECID=23 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.313.1101058699 RECID=24 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.341.1101057053 RECID=25 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.257.1101057621 RECID=26 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.281.1101058383 RECID=27 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.337.1101057051 RECID=28 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.268.1101059843 RECID=29 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/ctxd.288.1101058699 RECID=30 STAMP=1101061299

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/owapub.280.1101058733 RECID=31 STAMP=1101061299

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/portal.258.1101057827 RECID=32 STAMP=1101061299

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.284.1101058697 RECID=33 STAMP=1101061299

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.340.1101057047 RECID=34 STAMP=1101061299

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.272.1101059841 RECID=35 STAMP=11010612

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.278.1101058383 RECID=36 STAMP=11010612

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.269.1101059843 RECID=37 STAMP=11010612

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.305.1101058699 RECID=38 STAMP=11010613

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.274.1101059827 RECID=39 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.282.1101058383 RECID=40 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.343.1101057051 RECID=41 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.259.1101057307 RECID=42 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.276.1101059827 RECID=43 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.283.1101058699 RECID=44 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.265.1101059843 RECID=45 STAMP=1101061300

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.304.1101059825 RECID=46 STAMP=1101061301

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.330.1101057307 RECID=47 STAMP=1101061301

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.270.1101059841 RECID=48 STAMP=1101061301

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.275.1101059827 RECID=49 STAMP=1101061301

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.323.1101057307 RECID=50 STAMP=1101061301

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.325.1101057899 RECID=51 STAMP=1101061

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.267.1101059843 RECID=52 STAMP=1101061

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_summary.334.1101057051 RECID=53 STAMP=11010613

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_nologging.289.1101058433 RECID=54 STAMP=1101062

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_archive.277.1101059415 RECID=55 STAMP=11010613

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.295.1101058699 RECID=56 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.262.1101060667 RECID=57 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_media.311.1101058699 RECID=58 STAMP=1101061302

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/odm.290.1101059469 RECID=59 STAMP=1101061302

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/olap.293.1101058717 RECID=60 STAMP=1101061302

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.292.1101058699 RECID=61 STAMP=1101061303

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.263.1101060239 RECID=62 STAMP=1101061303

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tools.264.1101060127 RECID=63 STAMP=1101061303

datafile 3 switched to datafile copy

input datafile copy RECID=1 STAMP=1101061295 file name=+EBS_DATA/funcdb/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=2 STAMP=1101061295 file name=+EBS_DATA/funcdb/undotbs01.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=3 STAMP=1101061295 file name=+EBS_DATA/funcdb/pdbseed/sysaux01.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=4 STAMP=1101061295 file name=+EBS_DATA/funcdb/users01.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=5 STAMP=1101061295 file name=+EBS_DATA/funcdb/pdbseed/undotbs01.dbf

datafile 10 switched to datafile copy

input datafile copy RECID=6 STAMP=1101061295 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.286.1101058383

datafile 11 switched to datafile copy

input datafile copy RECID=7 STAMP=1101061295 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.342.1101057051

datafile 12 switched to datafile copy

input datafile copy RECID=8 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.322.1101057307

datafile 13 switched to datafile copy

input datafile copy RECID=9 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.266.1101059843

datafile 14 switched to datafile copy

input datafile copy RECID=10 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.321.1101057307

datafile 15 switched to datafile copy

input datafile copy RECID=11 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.324.1101058383

datafile 16 switched to datafile copy

input datafile copy RECID=12 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.312.1101059825

datafile 17 switched to datafile copy

input datafile copy RECID=13 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.333.1101057305

datafile 18 switched to datafile copy

input datafile copy RECID=14 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.327.1101058383

datafile 19 switched to datafile copy

input datafile copy RECID=15 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.306.1101059825

datafile 20 switched to datafile copy

input datafile copy RECID=16 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.332.1101057305

datafile 21 switched to datafile copy

input datafile copy RECID=17 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.339.1101057049

datafile 22 switched to datafile copy

input datafile copy RECID=18 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.326.1101058383

datafile 23 switched to datafile copy

input datafile copy RECID=19 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.296.1101059825

datafile 24 switched to datafile copy

input datafile copy RECID=20 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.331.1101057305

datafile 25 switched to datafile copy

input datafile copy RECID=21 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.271.1101059841

datafile 26 switched to datafile copy

input datafile copy RECID=22 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.338.1101057049

datafile 27 switched to datafile copy

input datafile copy RECID=23 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.291.1101058383

datafile 28 switched to datafile copy

input datafile copy RECID=24 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.313.1101058699

datafile 29 switched to datafile copy

input datafile copy RECID=25 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.341.1101057053

datafile 30 switched to datafile copy

input datafile copy RECID=26 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.257.1101057621

datafile 31 switched to datafile copy

input datafile copy RECID=27 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.281.1101058383

datafile 32 switched to datafile copy

input datafile copy RECID=28 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.337.1101057051

datafile 33 switched to datafile copy

input datafile copy RECID=29 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.268.1101059843

datafile 34 switched to datafile copy

input datafile copy RECID=30 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/ctxd.288.1101058699

datafile 35 switched to datafile copy

input datafile copy RECID=31 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/owapub.280.1101058733

datafile 36 switched to datafile copy

input datafile copy RECID=32 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/portal.258.1101057827

datafile 37 switched to datafile copy

input datafile copy RECID=33 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.284.1101097

datafile 38 switched to datafile copy

input datafile copy RECID=34 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.340.1101047

datafile 39 switched to datafile copy

input datafile copy RECID=35 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.272.1159841

datafile 40 switched to datafile copy

input datafile copy RECID=36 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.278.1158383

datafile 41 switched to datafile copy

input datafile copy RECID=37 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.269.1159843

datafile 42 switched to datafile copy

input datafile copy RECID=38 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.305.1158699

datafile 43 switched to datafile copy

input datafile copy RECID=39 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.274.1109827

datafile 44 switched to datafile copy

input datafile copy RECID=40 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.282.1108383

datafile 45 switched to datafile copy

input datafile copy RECID=41 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.343.1107051

datafile 46 switched to datafile copy

input datafile copy RECID=42 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.259.1107307

datafile 47 switched to datafile copy

input datafile copy RECID=43 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.276.1109827

datafile 48 switched to datafile copy

input datafile copy RECID=44 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.283.1108699

datafile 49 switched to datafile copy

input datafile copy RECID=45 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.265.1101043

datafile 50 switched to datafile copy

input datafile copy RECID=46 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.304.1101025

datafile 51 switched to datafile copy

input datafile copy RECID=47 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.330.1101007

datafile 52 switched to datafile copy

input datafile copy RECID=48 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.270.1101041

datafile 53 switched to datafile copy

input datafile copy RECID=49 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.275.1101027

datafile 54 switched to datafile copy

input datafile copy RECID=50 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.323.1101007

datafile 55 switched to datafile copy

input datafile copy RECID=51 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.325.1057899

datafile 56 switched to datafile copy

input datafile copy RECID=52 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.267.1059843

datafile 57 switched to datafile copy

input datafile copy RECID=53 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_summary.334.1157051

datafile 58 switched to datafile copy

input datafile copy RECID=54 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_nologging.289.1058433

datafile 59 switched to datafile copy

input datafile copy RECID=55 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_archive.277.1159415

datafile 60 switched to datafile copy

input datafile copy RECID=56 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.295.1108699

datafile 61 switched to datafile copy

input datafile copy RECID=57 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.262.1100667

datafile 62 switched to datafile copy

input datafile copy RECID=58 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_media.311.1101699

datafile 63 switched to datafile copy

input datafile copy RECID=59 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/odm.290.1101059469

datafile 64 switched to datafile copy

input datafile copy RECID=60 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/olap.293.1101058717

datafile 65 switched to datafile copy

input datafile copy RECID=61 STAMP=1101061303 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.292.1101058699

datafile 66 switched to datafile copy

input datafile copy RECID=62 STAMP=1101061303 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.263.1101060239

datafile 67 switched to datafile copy

input datafile copy RECID=63 STAMP=1101061303 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tools.264.1101127

contents of Memory Script:

{

   Alter clone database open resetlogs;

}

executing Memory Script

database opened

contents of Memory Script:

{

   sql clone "alter pluggable database all open";

}

executing Memory Script

sql statement: alter pluggable database all open

Cannot remove created server parameter file

Finished Duplicate Db at 03-APR-22

Start the new target CDB in open mode

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE

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

BEECDB    READ WRITE

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 FUAT                           READ WRITE NO

SQL>

7. Target PDB  Steps

export ORACLE_SID=<CDB SID>

If the Target PDB name needs to be changed to a value different from the Source PDB Name, perform the following steps

a) Verify if any service already exists with the Target PDB name.

Run the following commands:

$ sqlplus / as sysdba

SQL> alter session set container="<SOURCE PDB_NAME>";

SQL> select count(*) from cdb_services c, service$ s

where upper(s.name) = upper('<TARGET PDB_NAME>')

and s.deletion_date is null

and s.name = c.name;

[oracle@funebs122 dbs]$ export ORACLE_SID=BEECDB

[oracle@funebs122 dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 3 19:08:59 2022

Version 19.10.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.10.0.0.0

SQL> alter session set container="FUAT";

Session altered.

SQL> select count(*) from cdb_services c, service$ s

where upper(s.name) = upper('<TARGET PDB_NAME>')

and s.deletion_date is null

and s.name = c.name;  2    3    4

  COUNT(*)

----------

         0

b) If any service already exists with the Target PDB name, delete it as follows: (Not needed as no services with SOURCE PDB name exists)

export ORACLE_SID=<CDB SID>

$ sqlplus / as sysdba

SQL> alter session set container="<SOURCE PDB_NAME>";

SQL> dbms_service.delete_service('<TARGET PDB_NAME>');

c) Run the following steps to rename the PDB.

export ORACLE_SID=<CDB SID>

$ sqlplus / as sysdba

SQL> alter pluggable database "<SOURCE PDB NAME>" close;

SQL> alter pluggable database "<SOURCE PDB NAME>" unplug into '<ORACLE_HOME>/dbs/<SOURCE PDB NAME>.xml';

SQL> drop pluggable database "<SOURCE PDB NAME>";

SQL>create pluggable database "<NEW PDB NAME>" using '<ORACLE_HOME>/dbs/<SOURCE PDB NAME>.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_<SOURCE PDB NAME>','ebs_<TARGET PDB NAME>','<SOURCE PDB NAME>_ebs_patch','<TARGET PDB NAME>_ebs_patch');

SQL> alter pluggable database "<TARGET PDB NAME>" open read write;

[oracle@funebs122 dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 3 19:11:39 2022

Version 19.10.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.10.0.0.0

SQL> alter pluggable database "FUAT" close;

Pluggable database altered.

SQL> SQL> alter pluggable database "FUAT" unplug into '/oraapps122/DATABASE/BEE/19c/dbs/FUAT.xml';

Pluggable database altered.

SQL> drop pluggable database "FUAT";

Pluggable database dropped.

SQL> create pluggable database "BEE" using '/oraapps122/DATABASE/BEE/19c/dbs/FUAT.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_FUAT','ebs_BEE','FUAT_ebs_patch','BEE_ebs_patch');

Pluggable database created.

SQL> alter pluggable database "BEE" open read write;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         4 BEE                            READ WRITE NO

Note:

The PDB name should not be more than 8 characters.

The PDB should be renamed only using the above approach to retain the case of the PDB name.

d) Startup the PDB and save its state by running the following commands:

export ORACLE_SID=<CDB SID>

$ sqlplus / as sysdba

SQL> alter pluggable database all open; (in case of a single-node database)

SQL> alter pluggable database all open instances=all; (in case of an Oracle RAC database)

SQL> alter pluggable database all save state instances=all;

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> alter pluggable database all save state instances=all;

Pluggable database altered.

e) Run the library update script against the Oracle database.

export ORACLE_SID=<CDB SID>

$ cd <ORACLE_HOME>/appsutil/install/<CONTEXT_NAME>

$ sqlplus / as sysdba @adupdlib.sql <libext>

Where <libext> should be set to sl for HP-UX, so for any other UNIX platform, or dll for Windows.

[oracle@funebs122 dbs]$ cd /oraapps122/DATABASE/BEE/19c/appsutil/install/ [oracle@funebs122 install]$ ls adlnkoh.sh BEE_funebs122 [oracle@funebs122 install]$ cd BEE_funebs122/ [oracle@funebs122 BEE_funebs122]$ sqlplus '/as sysdba' SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 3 19:57:18 2022 Version 19.10.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.10.0.0.0 SQL> @adupdlib.sql so PL/SQL procedure successfully completed.

8) Set the Target UTL_FILE_DIR Values in Oracle Database

Connect CDB databse and set below parameter

alter system reset db_domain scope=spfile;

Restart CDB Listener

Restart DATABASE

Starting with Oracle Database 19c, UTL_FILE_DIR is not a supported database initialization parameter. Therefore, additional steps must be performed to retain the functionality provided by this parameter with Oracle E-Business Suite instance.

Perform the following steps to set the target UTL_FILE_DIR values in the database.

Source the environment file.

$ cd <ORACLE_HOME>

$ source <CONTEXT_NAME>.env

Obtain the existing value for the UTL_FILE_DIR using the following commands:

$ perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> \

-oraclehome=<ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log -mode=getUtlFileDir

This will create a text file <DB_NAME>_utlfiledir.txt under the <ORACLE_HOME>/dbs directory with references to the target Oracle home.

[oracle@funebs122 BEE_funebs122]$ perl /oraapps122/DATABASE/BEE/19c/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml -oraclehome=/oraapps122/DATABASE/BEE/19c -outdir=/oraapps122/DATABASE/BEE/19c/appsutil/log -mode=getUtlFileDir

Enter the APPS Password:

Script Name    : txkCfgUtlfileDir.pl

Script Version : 120.0.12020000.15

Started        : Mon Apr  4 11:14:10 IST 2022

Log File       : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_UTIL_DIR_Mon_Apr_4_11_14_08_2022/txkCfgUtlfileDir.log

Context file: /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml exists.

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

Successfully generated the below file with UTL_FILE_DIR content:

/oraapps122/DATABASE/BEE/19c/dbs/BEE_utlfiledir.txt

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

Completed        : Mon Apr  4 11:14:19 IST 2022

Successfully Completed the script

ERRORCODE = 0 ERRORCODE_END

Review the <DB_NAME>_utlfiledir.txt file and edit the values, if required.

Note: Before proceeding to the next step, ensure to create the physical directories for all directory paths being specified in the <DB_NAME>_utlfiledir.txt file.

cd  $ORACLE_HOME/dbs

cat BEE_utlfiledir.txt

edit BEE_utlfiledir as it would be having source instance details. I will replace FUAT with BEE and create directories. You can set based on your needs.

Now make the directory structures.

mkdir -p /oraapps122/DATABASE/BEE/temp/BEE

mkdir -p /oraapps122/DATABASE/BEE/19c/appsutil/outbound/BEE_funebs122

mkdir -p /oraapps122/DATABASE/BEE/temp/BEE

Run the following command to store the updated values for UTL_FILE_DIR in the database:

$ cd <ORACLE_HOME>/appsutil/bin

$ perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> \

-oraclehome=<ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log \

-mode=setUtlFileDir

This command will validate the directory paths provided in the <DB_NAME>_utlfiledir.txt for existence and will also create directory objects for all the physical directory paths.

[oracle@funebs122 19c]$ . BEE_funebs122.env

[oracle@funebs122 19c]$  cd /oraapps122/DATABASE/BEE/19c/appsutil/bin

[oracle@funebs122 bin]$ perl /oraapps122/DATABASE/BEE/19c/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml \

> -oraclehome=/oraapps122/DATABASE/BEE/19c -outdir=/oraapps122/DATABASE/BEE/19c/appsutil/log \

> -mode=setUtlFileDir

Enter the APPS Password:

Enter the SYSTEM Password:

Script Name    : txkCfgUtlfileDir.pl

Script Version : 120.0.12020000.15

Started        : Mon Apr  4 11:28:59 IST 2022

Log File       : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_UTIL_DIR_Mon_Apr_4_11_28_54_2022/txkCfgUtlfileDir.log

Context file: /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml exists.

Value for s_applptmp on Apps Tier nodes is valid

Completed        : Mon Apr  4 11:29:22 IST 2022

Successfully Completed the script

ERRORCODE = 0 ERRORCODE_END

Run the followind command to create the directory object for the outbound directory (pointed to by the s_outbound_dir context variable in the database tier context file).

$ perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> \

-oraclehome=<ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log -mode=createDirObject

When prompted for the OS path for the directory object to be created, enter the value of the s_outbound_dir context variable in the database tier context file.

source <CONTEXT_NAME>.env

[oracle@funebs122 bin]$ grep -i s_outbound_dir /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml

         <OUTBOUND_DIR oa_var="s_outbound_dir">/oraapps122/DATABASE/BEE/19c/appsutil/outbound/BEE_funebs122</OUTBOUND_DIR>

[oracle@funebs122 bin]$ perl /oraapps122/DATABASE/BEE/19c/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml \

> -oraclehome=/oraapps122/DATABASE/BEE/19c -outdir=/oraapps122/DATABASE/BEE/19c/appsutil/log -mode=createDirObject

Enter the APPS Password:

Enter the SYSTEM Password:

Enter the OS path for which directory object needs to be created: /oraapps122/DATABASE/BEE/19c/appsutil/outbound/BEE_funebs122

Script Name    : txkCfgUtlfileDir.pl

Script Version : 120.0.12020000.15

Started        : Mon Apr  4 11:31:45 IST 2022

Log File       : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_UTIL_DIR_Mon_Apr_4_11_31_31_2022/txkCfgUtlfileDir.log

Context file: /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml exists.

Completed        : Mon Apr  4 11:31:52 IST 2022

Successfully Completed the script

ERRORCODE = 0 ERRORCODE_END

Sync up the value of UTL_FILE_DIR in the database tier context file by running the following command:

$ perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File>  -oraclehome=<ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log -mode=syncUtlFileDir  -skipautoconfig=yes

source <CONTEXT_NAME>.env

[oracle@funebs122 bin]$ perl /oraapps122/DATABASE/BEE/19c/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml \ -oraclehome=/oraapps122/DATABASE/BEE/19c -outdir=/oraapps122/DATABASE/BEE/19c/appsutil/log -mode=syncUtlFileDir \ -skipautoconfig=yes

Enter the full path of Oracle Home: /oraapps122/DATABASE/BEE/19c

Enter the APPS Password:

Script Name    : txkCfgUtlfileDir.pl

Script Version : 120.0.12020000.15

Started        : Mon Apr  4 11:34:01 IST 2022

Log File       : /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_UTIL_DIR_Mon_Apr_4_11_33_48_2022/txkCfgUtlfileDir.log

Context file: /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml exists.

Execute SYSTEM command : /oraapps122/DATABASE/BEE/19c/perl/bin/perl /oraapps122/DATABASE/BEE/19c/appsutil/bin/adconfig.pl -contextfile=/oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml ************** -log=/oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_UTIL_DIR_Mon_Apr_4_11_33_48_2022/acfg_log_Mon_Apr_4_11_33_48_2022.log

The log file for this session is located at: /oraapps122/DATABASE/BEE/19c/appsutil/log/TXK_UTIL_DIR_Mon_Apr_4_11_33_48_2022/acfg_log_Mon_Apr_4_11_33_48_2022.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

        Using ORACLE_HOME location : /oraapps122/DATABASE/BEE/19c

Value of s_dbcset is AL32UTF8

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.

Value of s_dbcset is AL32UTF8

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.

        Classpath                   : :/oraapps122/DATABASE/BEE/19c/jdbc/lib/ojdbc8.jar:/oraapps122/DATABASE/BEE/19c/appsutil/java/xmlparserv2.jar:/oraapps122/DATABASE/BEE/19c/appsutil/java:/oraapps122/DATABASE/BEE/19c/jlib/netcfg.jar:/oraapps122/DATABASE/BEE/19c/jlib/ldapjclnt19.jar:/oraapps122/DATABASE/BEE/19c/jlib/orai18n.jar

        Using Context file          : /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db19

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME ...

AutoConfig completed 

Completed        : Mon Apr  4 12:05:32 IST 2022

Successfully Completed the script

ERRORCODE = 0 ERRORCODE_END

9) Configure the Target Database

Run the adcfgclone utility to configure the target database.

$ cd <ORACLE_HOME>/appsutil/clone/bin

$ perl adcfgclone.pl dbconfig <Target Database context file>

The target database context file is <ORACLE_HOME>/appsutil/<Target context_name>.xml.

Note: The dbconfig option will configure the database with the required settings for the new target, but it will not recreate the control files.

[oracle@funebs122 19c]$ . BEE_funebs122.env

[oracle@funebs122 19c]$ cd /oraapps122/DATABASE/BEE/19c/appsutil/clone/bin

[oracle@funebs122 bin]$ perl adcfgclone.pl dbconfig /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml

                     Copyright (c) 2002, 2015 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.65

Enter the APPS password :

Running Rapid Clone with command:

Running:

perl /oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/adclone.pl java=/oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/../jre mode=apply stage=/oraapps122/DATABASE/BEE/19c/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml showProgress contextValidated=false

Beginning dbconfig Apply - Mon Apr  4 12:19:00 2022

/oraapps122/DATABASE/BEE/19c/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oraapps122/DATABASE/BEE/19c/oui -classpath /oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/xmlparserv2.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/ojdbc8.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/java:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/oui/OraInstaller.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/oui/ewt3.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/oui/share.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/oui/srvm.jar:/oraapps122/DATABASE/BEE/19c/appsutil/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyDatabase -e /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml -stage /oraapps122/DATABASE/BEE/19c/appsutil/clone   -showProgress   -noRmanRecovery yes -checkDBConnection

APPS Password : Log file located at /oraapps122/DATABASE/BEE/19c/appsutil/log/BEE_funebs122/ApplyDatabase_04041219.log

  |      0% completed

Log file located at /oraapps122/DATABASE/BEE/19c/appsutil/log/BEE_funebs122/ApplyDatabase_04041219.log

  -     30% completed

Completed Apply...

Mon Apr  4 12:49:32 2022

10) Configure Target Application Node

Before starting adcfgclone.pl, clean up the PATCH FS, FS_NE, and oraInventory directories if it already a test instance and we are refreshing it. Else in case of new server create these directories.

Run the following commands to configure the application:

cd <COMMON_TOP>/clone/bin

perl ./adcfgclone.pl appsTier dualfs

[applmgr@funebs122 bin]$ cd /oraapps122/APPS/BEE/fs2/EBSapps/comn/clone/bin

[applmgr@funebs122 bin]$ perl ./adcfgclone.pl appsTier dualfs

                     Copyright (c) 2002, 2015 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.65

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] :

Running: Context clone...

Log file located at /oraapps122/APPS/BEE/fs2/EBSapps/comn/clone/bin/CloneContext_0404130014.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [funebs122] :

Target System Database SID : BEE

Target System Database Server Node [funebs122] :

Target System Database Domain Name [lab] :

Target System Base Directory : /oraapps122/APPS/BEE

Target System Base Directory set to /oraapps122/APPS/BEE

Target System Current File System Base set to /oraapps122/APPS/BEE/fs2

Target System Other File System Base set to /oraapps122/APPS/BEE/fs1

Target System Fusion Middleware Home set to /oraapps122/APPS/BEE/fs2/FMW_Home

Target System Other File System Fusion Middleware Home set to /oraapps122/APPS/BEE/fs1/FMW_Home

Target System Web Oracle Home set to /oraapps122/APPS/BEE/fs2/FMW_Home/webtier

Target System Other File System Web Oracle Home set to /oraapps122/APPS/BEE/fs1/FMW_Home/webtier

Target System Appl TOP set to /oraapps122/APPS/BEE/fs2/EBSapps/appl

Target System Other File System Appl TOP set to /oraapps122/APPS/BEE/fs1/EBSapps/appl

Target System COMMON TOP set to /oraapps122/APPS/BEE/fs2/EBSapps/comn

Target System Other File System COMMON TOP set to /oraapps122/APPS/BEE/fs1/EBSapps/comn

Target System Instance Home Directory [/oraapps122/APPS/BEE] :

Target System Current File System Instance Top set to /oraapps122/APPS/BEE/fs2/inst/apps/BEE_funebs122

Do you want to preserve the Display [funebs122:0.0] (y/n)  : n

Target System Display [funebs122:0.0] :

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Target System Port Pool [0-99] : 30

Checking the port pool 30

done: Port Pool 30 is free

Report file located at /oraapps122/APPS/BEE/fs2/inst/apps/BEE_funebs122/admin/out/portpool.lst

Target System proxy port [80] :

UTL_FILE_DIR on database tier consists of the following directories.

1. /oraapps122/DATABASE/BEE/temp/BEE

2. /tmp

3. /oraapps122/DATABASE/BEE/19c/appsutil/outbound/BEE_funebs122

4. /oraapps122/DATABASE/BEE/temp/BEE

Choose a value which will be set as APPLPTMP value on the target node [1] :

The new APPL_TOP context file has been created :

  /oraapps122/APPS/BEE/fs2/inst/apps/BEE_funebs122/appl/admin/BEE_funebs122.xml

Check Clone Context logfile /oraapps122/APPS/BEE/fs2/EBSapps/comn/clone/bin/CloneContext_0404130014.log for details.

Creating Patch file system context file.....

Log file located at /oraapps122/APPS/BEE/fs2/EBSapps/comn/clone/bin/CloneContextPatch_0404130131.log

Target System Other File System Instance Top set to /oraapps122/APPS/BEE/fs1/inst/apps/BEE_funebs122

Target System Port Pool [0-99] : 40

Checking the port pool 40

done: Port Pool 40 is free

Report file located at /oraapps122/APPS/BEE/fs1/inst/apps/BEE_funebs122/admin/out/portpool.lst

The new APPL_TOP context file has been created :

  /oraapps122/APPS/BEE/fs1/inst/apps/BEE_funebs122/appl/admin/BEE_funebs122.xml

Check Clone Context logfile /oraapps122/APPS/BEE/fs2/EBSapps/comn/clone/bin/CloneContextPatch_0404130131.log for details.

FMW Pre-requisite check log file location : /oraapps122/APPS/BEE/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: FMW pre-req check...

Configuring: Run file system....

LogFile located at /oraapps122/APPS/BEE/fs2/inst/apps/BEE_funebs122/admin/log/clone/run/RCloneApplyAppstier_04041302.log

If this is a repeated cloning instance, you can also use the backup of a CONTEXT_FILE. Run the following command:

perl ./adcfgclone.pl appsTier <location of CONTEXT_FILE backup> dualfs

11) Start Application Services and Validate

You can now start all application services of the target clone instance validate the services.

Reference:

Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1)

If you like please follow and comment