Cloning EBS RAC ASM to single with RMAN

Clone Database

[devmgr@bedirisendiri ~]$ . ./DB.env

[devmgr@bedirisendiri ~]$ export ORACLE_SID=+ASM

[devmgr@bedirisendiri ~]$ ls

appsDEV_131212.tar.gz  APPS.env  DB.env

[devmgr@bedirisendiri ~]$ asmcmd

ASMCMD> cd DEV/

ASMCMD> mkdir data

ASMCMD> cd data/

ASMCMD> pwd

+DEV/data

ASMCMD>

[devmgr@bedirisendiri bin]$ pwd

/u01/oracle/db/tech_st/10.2.0/appsutil/clone/bin

[devmgr@bedirisendiri bin]$ perl adcfgclone.pl dbTechStack

                     Copyright (c) 2002 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.20.12000000.18

Enter the APPS password :

Running:

/u01/oracle/db/tech_st/10.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /u01/oracle/db/tech_st/10.2.0/appsutil/clone/jlib/java:/u01/oracle/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/oracle/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /u01/oracle/db/tech_st/10.2.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_2974.lst -stage /u01/oracle/db/tech_st/10.2.0/appsutil/clone -dbTechStack 2> /tmp/adcfgclone_2974.err; echo $? > /tmp/adcfgclone_2974.res

Log file located at /u01/oracle/db/tech_st/10.2.0/appsutil/clone/bin/CloneContext_1220210044.log

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

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

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

Target System Database SID : DEV

Target System Base Directory : /u01/oracle

Target System utl_file_dir Directory List : /usr/tmp

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

Target System DATA_TOP Directory 1 : +DEV/data

Target System RDBMS ORACLE_HOME Directory [/u01/oracle/db/tech_st/10.2.0] :

Do you want to preserve the Display [hqhcmdb1:0.0] (y/n)  : n

Target System Display [bedirisendiri:0.0] :

Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 20

Checking the port pool 20

done: Port Pool 20 is free

Report file located at /u01/oracle/db/tech_st/10.2.0/appsutil/out/portpool.lst

Complete port information available at /u01/oracle/db/tech_st/10.2.0/appsutil/out/portpool.lst

Backing up /u01/oracle/db/tech_st/10.2.0/appsutil/DEV_bedirisendiri.xml to /u01/oracle/db/tech_st/10.2.0/appsutil/DEV_bedirisendiri.xml0.bak

Creating the new Database Context file from :

  /u01/oracle/db/tech_st/10.2.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :

  /u01/oracle/db/tech_st/10.2.0/appsutil/DEV_bedirisendiri.xml

Log file located at /u01/oracle/db/tech_st/10.2.0/appsutil/clone/bin/CloneContext_1220210044.log

Check Clone Context logfile /u01/oracle/db/tech_st/10.2.0/appsutil/clone/bin/CloneContext_1220210044.log for details.

Running Rapid Clone with command:

perl /u01/oracle/db/tech_st/10.2.0/appsutil/clone/bin/adclone.pl java=/u01/oracle/db/tech_st/10.2.0/appsutil/clone/bin/../jre mode=apply stage=/u01/oracle/db/tech_st/10.2.0/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/u01/oracle/db/tech_st/10.2.0/appsutil/DEV_bedirisendiri.xml showProgress contextValidated=true

Running:

perl /u01/oracle/db/tech_st/10.2.0/appsutil/clone/bin/adclone.pl java=/u01/oracle/db/tech_st/10.2.0/appsutil/clone/bin/../jre mode=apply stage=/u01/oracle/db/tech_st/10.2.0/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/u01/oracle/db/tech_st/10.2.0/appsutil/DEV_bedirisendiri.xml showProgress contextValidated=true

APPS Password :

Beginning rdbms home Apply - Thu Dec 20 21:06:06 2012

/u01/oracle/db/tech_st/10.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/u01/oracle/db/tech_st/10.2.0/oui -classpath /u01/oracle/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/oracle/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar:/u01/oracle/db/tech_st/10.2.0/appsutil/clone/jlib/java:/u01/oracle/db/tech_st/10.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/oracle/db/tech_st/10.2.0/appsutil/clone/jlib/oui/ewt3.jar:/u01/oracle/db/tech_st/10.2.0/appsutil/clone/jlib/oui/share.jar:/u01/oracle/db/tech_st/10.2.0/appsutil/clone/jlib/oui/srvm.jar:/u01/oracle/db/tech_st/10.2.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTechStack -e /u01/oracle/db/tech_st/10.2.0/appsutil/DEV_bedirisendiri.xml -stage /u01/oracle/db/tech_st/10.2.0/appsutil/clone   -showProgress

APPS Password : Log file located at /u01/oracle/db/tech_st/10.2.0/appsutil/log/DEV_bedirisendiri/ApplyDBTechStack_12202106.log

  -      4% completed

Completed Apply...

Thu Dec 20 21:09:16 2012

Starting database listener for DEV:

Running:

/u01/oracle/db/tech_st/10.2.0/appsutil/scripts/DEV_bedirisendiri/addlnctl.sh start DEV

You are running addlnctl.sh version 120.1

Logfile: /u01/oracle/db/tech_st/10.2.0/appsutil/log/DEV_bedirisendiri/addlnctl.txt

Starting listener process DEV ...

addlnctl.sh: exiting with status 0

[devmgr@bedirisendiri bin]$

[devmgr@bedirisendiri ~]$ . ./DB.env

[devmgr@bedirisendiri ~]$ rman target /

Recovery Manager: Release 10.2.0.2.0 - Production on Thu Dec 20 21:24:53 2012

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

connected to target database (not started)

RMAN> startup nomount

Oracle instance started

Total System Global Area    1077936128 bytes

Fixed Size                     2076584 bytes

Variable Size                427819096 bytes

Database Buffers             633339904 bytes

Redo Buffers                  14700544 bytes

RMAN> restore controlfile from '/u01/oracle/backupPROD/PROD_CTL_20121220_uintbqvd_1_1.bkp';

Starting restore at 20-DEC-12

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=596 devtype=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:07

output filename=+DEV/data/cntrl01.dbf

output filename=+DEV/data/cntrl02.dbf

output filename=+DEV/data/cntrl03.dbf

Finished restore at 20-DEC-12

RMAN>

RMAN> alter database mount;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of alter db command at 12/20/2012 21:27:27

ORA-01103: database name 'PROD' in control file is not 'DEV'

RMAN> quit

Recovery Manager complete.

[devmgr@bedirisendiri ~]$ cd $ORACLE_HOME

[devmgr@bedirisendiri 10.2.0]$ cd dbs/

[devmgr@bedirisendiri dbs]$ pwd

/u01/oracle/db/tech_st/10.2.0/dbs

[devmgr@bedirisendiri dbs]$ vi initDEV.ora                    #### rubah db_name jadi PROD

[devmgr@bedirisendiri dbs]$ cd

[devmgr@bedirisendiri ~]$ rman target /

Recovery Manager: Release 10.2.0.2.0 - Production on Thu Dec 20 21:28:49 2012

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

connected to target database: DEV (not mounted)

RMAN> shutdown immediate

using target database control file instead of recovery catalog

Oracle instance shut down

RMAN> startup nomount

connected to target database (not started)

Oracle instance started

Total System Global Area    1077936128 bytes

Fixed Size                     2076584 bytes

Variable Size                427819096 bytes

Database Buffers             633339904 bytes

Redo Buffers                  14700544 bytes

RMAN> alter database mount;

database mounted

RMAN> catalog START WITH '/u01/oracle/backupPROD';

searching for all files that match the pattern /u01/oracle/backupPROD

List of Files Unknown to the Database

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

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s7ntbjl9_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_tintbmlu_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_ARC_20121220_uentbphj_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_santbkc8_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_t4ntbm2m_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u0ntbn96_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_tnntbmrn_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s6ntbjes_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s5ntbj4n_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u9ntbolk_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_srntblmq_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s3ntbimu_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u3ntbnhk_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_ucntbpb1_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s8ntbjt8_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s9ntbk57_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_sgntbl4v_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u5ntbnsj_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_tfntbmhn_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u4ntbnmp_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_udntbpgg_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_scntbko5_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u2ntbncf_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_ubntbp4k_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_tantbmav_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_ARC_20121220_ufntbpv8_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_suntblrb_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_ARC_20121220_ugntbqcs_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u6ntbo56_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u8ntbofh_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_sbntbki2_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_CTL_20121220_uintbqvd_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u7ntbo9n_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_ARC_20121220_uhntbqps_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s4ntbiut_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_slntbleq_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_uantbouh_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_sdntbkus_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_tsntbn08_1_1.bkp

Do you really want to catalog the above files (enter YES or NO)? YES

cataloging files...

cataloging done

List of Cataloged Files

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

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s7ntbjl9_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_tintbmlu_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_ARC_20121220_uentbphj_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_santbkc8_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_t4ntbm2m_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u0ntbn96_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_tnntbmrn_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s6ntbjes_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s5ntbj4n_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u9ntbolk_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_srntblmq_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s3ntbimu_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u3ntbnhk_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_ucntbpb1_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s8ntbjt8_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s9ntbk57_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_sgntbl4v_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u5ntbnsj_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_tfntbmhn_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u4ntbnmp_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_udntbpgg_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_scntbko5_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u2ntbncf_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_ubntbp4k_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_tantbmav_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_ARC_20121220_ufntbpv8_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_suntblrb_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_ARC_20121220_ugntbqcs_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u6ntbo56_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u8ntbofh_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_sbntbki2_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_CTL_20121220_uintbqvd_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_u7ntbo9n_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_ARC_20121220_uhntbqps_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_s4ntbiut_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_slntbleq_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_uantbouh_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_sdntbkus_1_1.bkp

File Name: /u01/oracle/backupPROD/PROD_DB_20121220_tsntbn08_1_1.bkp

RMAN>

RMAN> quit

Recovery Manager complete.

[devmgr@bedirisendiri ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Dec 20 21:33:17 2012

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> select 'set newname for datafile '||file#||' to '''||name||''';' from v$datafile;

set newname for datafile 1 to '+DATA/prod/datafile/system01.dbf';

set newname for datafile 2 to '+DATA/prod/datafile/system02.dbf';

set newname for datafile 3 to '+DATA/prod/datafile/system03.dbf';

set newname for datafile 4 to '+DATA/prod/datafile/system04.dbf';

set newname for datafile 5 to '+DATA/prod/datafile/system05.dbf';

set newname for datafile 6 to '+DATA/prod/datafile/ctxd01.dbf';

set newname for datafile 7 to '+DATA/prod/datafile/owad01.dbf';

set newname for datafile 8 to '+DATA/prod/datafile/a_queue02.dbf';

set newname for datafile 9 to '+DATA/prod/datafile/odm.dbf';

set newname for datafile 10 to '+DATA/prod/datafile/olap.dbf';

set newname for datafile 11 to '+DATA/prod/datafile/sysaux01.dbf';

set newname for datafile 12 to '+DATA/prod/datafile/apps_ts_tools01.dbf';

set newname for datafile 13 to '+DATA/prod/datafile/system12.dbf';

set newname for datafile 14 to '+DATA/prod/datafile/a_txn_data04.dbf';

set newname for datafile 15 to '+DATA/prod/datafile/a_txn_ind06.dbf';

set newname for datafile 16 to '+DATA/prod/datafile/a_ref03.dbf';

set newname for datafile 17 to '+DATA/prod/datafile/a_int02.dbf';

set newname for datafile 18 to '+DATA/prod/datafile/sysaux02.dbf';

set newname for datafile 19 to '+DATA/prod/datafile/idpayd01.dbf';

set newname for datafile 20 to '+DATA/prod/datafile/idpayx01.dbf';

set newname for datafile 21 to '+DATA/prod/datafile/a_txn_data05.dbf';

set newname for datafile 22 to '+DATA/prod/datafile/a_txn_ind07.dbf';

set newname for datafile 23 to '+DATA/prod/datafile/a_txn_ind08.dbf';

set newname for datafile 24 to '+DATA/prod/datafile/idpayd02.dbf';

set newname for datafile 25 to '+DATA/prod/datafile/a_archive02.dbf';

set newname for datafile 26 to '+DATA/prod/datafile/a_txn_data06.dbf';

set newname for datafile 27 to '+DATA/prod/datafile/a_txn_ind09.dbf';

set newname for datafile 28 to '+DATA/prod/datafile/sysaux03.dbf';

set newname for datafile 29 to '+DATA/prod/datafile/sysaux04.dbf';

set newname for datafile 30 to '+DATA/prod/datafile/a_int03.dbf';

set newname for datafile 31 to '+DATA/prod/datafile/a_media02.dbf';

set newname for datafile 32 to '+DATA/prod/datafile/a_nolog02.dbf';

set newname for datafile 33 to '+DATA/prod/datafile/a_queue03.dbf';

set newname for datafile 34 to '+DATA/prod/datafile/a_ref04.dbf';

set newname for datafile 35 to '+DATA/prod/datafile/a_summ02.dbf';

set newname for datafile 36 to '+DATA/prod/datafile/apps_ts_tools02.dbf';

set newname for datafile 37 to '+DATA/prod/datafile/undo02.dbf';

set newname for datafile 38 to '+DATA/prod/datafile/ctxd02.dbf';

set newname for datafile 39 to '+DATA/prod/datafile/idpayd03.dbf';

set newname for datafile 40 to '+DATA/prod/datafile/idpayx02.dbf';

set newname for datafile 41 to '+DATA/prod/datafile/system13.dbf';

set newname for datafile 42 to '+DATA/prod/datafile/sysaux05.dbf';

set newname for datafile 43 to '+DATA/prod/datafile/odm01.dbf';

set newname for datafile 44 to '+DATA/prod/datafile/a_txn_ind10.dbf';

set newname for datafile 45 to '+DATA/prod/datafile/a_txn_data07.dbf';

set newname for datafile 46 to '+DATA/prod/datafile/a_txn_ind21.dbf';

set newname for datafile 47 to '+DATA/prod/datafile/a_txn_ind11.dbf';

set newname for datafile 48 to '+DATA/prod/datafile/a_txn_data08.dbf';

set newname for datafile 49 to '+DATA/prod/datafile/sysaux06.dbf';

set newname for datafile 50 to '+DATA/prod/datafile/a_txn_data09.dbf';

set newname for datafile 51 to '+DATA/prod/datafile/a_txn_ind12.dbf';

set newname for datafile 52 to '+DATA/prod/datafile/system14.dbf';

set newname for datafile 53 to '+DATA/prod/datafile/a_txn_ind13.dbf';

set newname for datafile 54 to '+DATA/prod/datafile/apps_txn_data10.dbf';

set newname for datafile 55 to '+DATA/prod/datafile/idpayd04.dbf';

set newname for datafile 56 to '+DATA/prod/datafile/sysaux07.dbf';

set newname for datafile 57 to '+DATA/prod/datafile/a_txn_ind14.dbf';

set newname for datafile 58 to '+DATA/prod/datafile/a_txn_data10.dbf';

set newname for datafile 59 to '+DATA/prod/datafile/a_txn_ind15.dbf';

set newname for datafile 60 to '+DATA/prod/datafile/a_txn_ind16.dbf';

set newname for datafile 61 to '+DATA/prod/datafile/a_txn_data11.dbf';

set newname for datafile 62 to '+DATA/prod/datafile/undo03.dbf';

set newname for datafile 63 to '+DATA/prod/datafile/a_txn_ind17.dbf';

set newname for datafile 64 to '+DATA/prod/datafile/a_txn_ind18.dbf';

set newname for datafile 65 to '+DATA/prod/datafile/idpayd05.dbf';

set newname for datafile 66 to '+DATA/prod/datafile/a_txn_data12.dbf';

set newname for datafile 67 to '+DATA/prod/datafile/a_txn_ind19.dbf';

set newname for datafile 68 to '+DATA/prod/datafile/ctxd03.dbf';

set newname for datafile 69 to '+DATA/prod/datafile/a_txn_data13.dbf';

set newname for datafile 70 to '+DATA/prod/datafile/a_txn_ind20.dbf';

set newname for datafile 71 to '+DATA/prod/datafile/a_txn_data14.dbf';

set newname for datafile 72 to '+DATA/prod/datafile/apps_undots2_01.dbf';

set newname for datafile 73 to '+DATA/prod/datafile/a_txn_ind22.dbf';

set newname for datafile 74 to '+DATA/prod/datafile/idpayd06.dbf';

set newname for datafile 75 to '+DATA/prod/datafile/undo04.dbf';

set newname for datafile 76 to '+DATA/prod/datafile/a_archive03.dbf';

set newname for datafile 77 to '+DATA/prod/datafile/undo05.dbf';

set newname for datafile 78 to '+DATA/prod/datafile/a_txn_ind23.dbf';

set newname for datafile 79 to '+DATA/prod/datafile/a_txn_data15.dbf';

set newname for datafile 80 to '+DATA/prod/datafile/a_txn_data16.dbf';

set newname for datafile 81 to '+DATA/prod/datafile/a_txn_ind24.dbf';

set newname for datafile 82 to '+DATA/prod/datafile/undo06.dbf';

set newname for datafile 83 to '+DATA/prod/datafile/a_txn_ind25.dbf';

set newname for datafile 84 to '+DATA/prod/datafile/a_txn_ind26.dbf';

set newname for datafile 85 to '+DATA/prod/datafile/a_txn_data17.dbf';

set newname for datafile 86 to '+DATA/prod/datafile/apps_undots2_02.dbf';

set newname for datafile 87 to '+DATA/prod/datafile/apps_undots2_04.dbf';

set newname for datafile 88 to '+DATA/prod/datafile/apps_undots2_03.dbf';

set newname for datafile 89 to '+DATA/prod/datafile/apps_undots2_08.dbf';

set newname for datafile 90 to '+DATA/prod/datafile/apps_undots2_07.dbf';

set newname for datafile 91 to '+DATA/prod/datafile/apps_undots2_06.dbf';

set newname for datafile 92 to '+DATA/prod/datafile/apps_undots2_05.dbf';

set newname for datafile 93 to '+DATA/prod/datafile/a_txn_data18.dbf';

set newname for datafile 94 to '+DATA/prod/datafile/a_txn_ind27.dbf';

set newname for datafile 95 to '+DATA/prod/datafile/a_txn_ind28.dbf';

set newname for datafile 96 to '+DATA/prod/datafile/a_txn_data19.dbf';

set newname for datafile 97 to '+DATA/prod/datafile/a_txn_ind29.dbf';

set newname for datafile 98 to '+DATA/prod/datafile/a_media03.dbf';

set newname for datafile 99 to '+DATA/prod/datafile/a_txn_data20.dbf';

set newname for datafile 100 to '+DATA/prod/datafile/a_txn_ind30.dbf';

set newname for datafile 101 to '+DATA/prod/datafile/a_txn_data21.dbf';

set newname for datafile 102 to '+DATA/prod/datafile/a_txn_ind31.dbf';

set newname for datafile 103 to '+DATA/prod/datafile/a_txn_ind32.dbf';

set newname for datafile 104 to '+DATA/prod/datafile/a_txn_data22.dbf';

set newname for datafile 105 to '+DATA/prod/datafile/a_txn_ind33.dbf';

set newname for datafile 106 to '+DATA/prod/datafile/a_txn_ind34.dbf';

set newname for datafile 107 to '+DATA/prod/datafile/undo07.dbf';

set newname for datafile 108 to '+DATA/prod/datafile/undo08.dbf';

set newname for datafile 109 to '+DATA/prod/datafile/a_txn_data23.dbf';

set newname for datafile 110 to '+DATA/prod/datafile/a_txn_ind35.dbf';

set newname for datafile 111 to '+DATA/prod/datafile/a_txn_ind36.dbf';

set newname for datafile 112 to '+DATA/prod/datafile/a_txn_data24.dbf';

set newname for datafile 113 to '+DATA/prod/datafile/a_txn_ind37.dbf';

set newname for datafile 114 to '+DATA/prod/datafile/a_txn_data25.dbf';

set newname for datafile 115 to '+DATA/prod/datafile/a_txn_ind38.dbf';

set newname for datafile 116 to '+DATA/prod/datafile/sysaux08.dbf';

set newname for datafile 117 to '+DATA/prod/datafile/a_txn_data26.dbf';

set newname for datafile 118 to '+DATA/prod/datafile/a_txn_ind39.dbf';

set newname for datafile 119 to '+DATA/prod/datafile/a_txn_ind40.dbf';

set newname for datafile 120 to '+DATA/prod/datafile/users_data.dbf';

set newname for datafile 121 to '+DATA/prod/datafile/users_idx.dbf';

set newname for datafile 122 to '+DATA/prod/datafile/a_txn_data27.dbf';

set newname for datafile 123 to '+DATA/prod/datafile/a_txn_ind41.dbf';

set newname for datafile 124 to '+DATA/prod/datafile/a_txn_data28.dbf';

set newname for datafile 125 to '+DATA/prod/datafile/a_txn_ind42.dbf';

set newname for datafile 126 to '+DATA/prod/datafile/undo09.dbf';

set newname for datafile 127 to '+DATA/prod/datafile/undo10.dbf';

set newname for datafile 128 to '+DATA/prod/datafile/a_txn_ind43.dbf';

set newname for datafile 129 to '+DATA/prod/datafile/a_queue04.dbf';

set newname for datafile 130 to '+DATA/prod/datafile/a_archive04.dbf';

set newname for datafile 131 to '+DATA/prod/datafile/a_txn_data29.dbf';

set newname for datafile 132 to '+DATA/prod/datafile/a_txn_ind44.dbf';

set newname for datafile 133 to '+DATA/prod/datafile/a_txn_data30.dbf';

set newname for datafile 134 to '+DATA/prod/datafile/a_txn_ind45.dbf';

set newname for datafile 135 to '+DATA/prod/datafile/a_media04.dbf';

set newname for datafile 136 to '+DATA/prod/datafile/a_txn_ind46.dbf';

set newname for datafile 137 to '+DATA/prod/datafile/a_txn_data31.dbf';

set newname for datafile 138 to '+DATA/prod/datafile/a_txn_ind47.dbf';

set newname for datafile 139 to '+DATA/prod/datafile/a_txn_data32.dbf';

set newname for datafile 140 to '+DATA/prod/datafile/a_txn_ind48.dbf';

set newname for datafile 288 to '+DATA/prod/datafile/system10.dbf';

set newname for datafile 295 to '+DATA/prod/datafile/system06.dbf';

set newname for datafile 314 to '+DATA/prod/datafile/portal01.dbf';

set newname for datafile 351 to '+DATA/prod/datafile/system07.dbf';

set newname for datafile 352 to '+DATA/prod/datafile/system09.dbf';

set newname for datafile 353 to '+DATA/prod/datafile/system08.dbf';

set newname for datafile 354 to '+DATA/prod/datafile/system11.dbf';

set newname for datafile 379 to '+DATA/prod/datafile/undo01.dbf';

set newname for datafile 392 to '+DATA/prod/datafile/a_txn_data01.dbf';

set newname for datafile 393 to '+DATA/prod/datafile/a_txn_ind01.dbf';

set newname for datafile 394 to '+DATA/prod/datafile/a_ref01.dbf';

set newname for datafile 395 to '+DATA/prod/datafile/a_int01.dbf';

set newname for datafile 396 to '+DATA/prod/datafile/a_summ01.dbf';

set newname for datafile 397 to '+DATA/prod/datafile/a_nolog01.dbf';

set newname for datafile 398 to '+DATA/prod/datafile/a_archive01.dbf';

set newname for datafile 399 to '+DATA/prod/datafile/a_queue01.dbf';

set newname for datafile 400 to '+DATA/prod/datafile/a_media01.dbf';

set newname for datafile 401 to '+DATA/prod/datafile/a_txn_data02.dbf';

set newname for datafile 402 to '+DATA/prod/datafile/a_txn_data03.dbf';

set newname for datafile 403 to '+DATA/prod/datafile/a_txn_ind02.dbf';

set newname for datafile 404 to '+DATA/prod/datafile/a_txn_ind03.dbf';

set newname for datafile 405 to '+DATA/prod/datafile/a_txn_ind04.dbf';

set newname for datafile 406 to '+DATA/prod/datafile/a_txn_ind05.dbf';

set newname for datafile 407 to '+DATA/prod/datafile/a_ref02.dbf';

#### rubah +DATA/prod/datafile menjadi +DEV/data

[devmgr@bedirisendiri ~]$ rman target /

Recovery Manager: Release 10.2.0.2.0 - Production on Thu Dec 20 21:47:20 2012

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

connected to target database: PROD (DBID=57144503, not open)

RMAN> run{

2> set newname for datafile 1 to '+DEV/data/system01.dbf';

3> set newname for datafile 2 to '+DEV/data/system02.dbf';

4> set newname for datafile 3 to '+DEV/data/system03.dbf';

5> set newname for datafile 4 to '+DEV/data/system04.dbf';

6> set newname for datafile 5 to '+DEV/data/system05.dbf';

7> set newname for datafile 6 to '+DEV/data/ctxd01.dbf';

8> set newname for datafile 7 to '+DEV/data/owad01.dbf';

9> set newname for datafile 8 to '+DEV/data/a_queue02.dbf';

10> set newname for datafile 9 to '+DEV/data/odm.dbf';

11> set newname for datafile 10 to '+DEV/data/olap.dbf';

12> set newname for datafile 11 to '+DEV/data/sysaux01.dbf';

13> set newname for datafile 12 to '+DEV/data/apps_ts_tools01.dbf';

14> set newname for datafile 13 to '+DEV/data/system12.dbf';

15> set newname for datafile 14 to '+DEV/data/a_txn_data04.dbf';

16> set newname for datafile 15 to '+DEV/data/a_txn_ind06.dbf';

17> set newname for datafile 16 to '+DEV/data/a_ref03.dbf';

18> set newname for datafile 17 to '+DEV/data/a_int02.dbf';

19> set newname for datafile 18 to '+DEV/data/sysaux02.dbf';

20> set newname for datafile 19 to '+DEV/data/idpayd01.dbf';

21> set newname for datafile 20 to '+DEV/data/idpayx01.dbf';

22> set newname for datafile 21 to '+DEV/data/a_txn_data05.dbf';

23> set newname for datafile 22 to '+DEV/data/a_txn_ind07.dbf';

24> set newname for datafile 23 to '+DEV/data/a_txn_ind08.dbf';

25> set newname for datafile 24 to '+DEV/data/idpayd02.dbf';

26> set newname for datafile 25 to '+DEV/data/a_archive02.dbf';

27> set newname for datafile 26 to '+DEV/data/a_txn_data06.dbf';

28> set newname for datafile 27 to '+DEV/data/a_txn_ind09.dbf';

29> set newname for datafile 28 to '+DEV/data/sysaux03.dbf';

30> set newname for datafile 29 to '+DEV/data/sysaux04.dbf';

31> set newname for datafile 30 to '+DEV/data/a_int03.dbf';

32> set newname for datafile 31 to '+DEV/data/a_media02.dbf';

33> set newname for datafile 32 to '+DEV/data/a_nolog02.dbf';

34> set newname for datafile 33 to '+DEV/data/a_queue03.dbf';

35> set newname for datafile 34 to '+DEV/data/a_ref04.dbf';

36> set newname for datafile 35 to '+DEV/data/a_summ02.dbf';

37> set newname for datafile 36 to '+DEV/data/apps_ts_tools02.dbf';

38> set newname for datafile 37 to '+DEV/data/undo02.dbf';

39> set newname for datafile 38 to '+DEV/data/ctxd02.dbf';

40> set newname for datafile 39 to '+DEV/data/idpayd03.dbf';

41> set newname for datafile 40 to '+DEV/data/idpayx02.dbf';

42> set newname for datafile 41 to '+DEV/data/system13.dbf';

43> set newname for datafile 42 to '+DEV/data/sysaux05.dbf';

44> set newname for datafile 43 to '+DEV/data/odm01.dbf';

45> set newname for datafile 44 to '+DEV/data/a_txn_ind10.dbf';

46> set newname for datafile 45 to '+DEV/data/a_txn_data07.dbf';

47> set newname for datafile 46 to '+DEV/data/a_txn_ind21.dbf';

48> set newname for datafile 47 to '+DEV/data/a_txn_ind11.dbf';

49> set newname for datafile 48 to '+DEV/data/a_txn_data08.dbf';

50> set newname for datafile 49 to '+DEV/data/sysaux06.dbf';

51> set newname for datafile 50 to '+DEV/data/a_txn_data09.dbf';

52> set newname for datafile 51 to '+DEV/data/a_txn_ind12.dbf';

53> set newname for datafile 52 to '+DEV/data/system14.dbf';

54> set newname for datafile 53 to '+DEV/data/a_txn_ind13.dbf';

55> set newname for datafile 54 to '+DEV/data/apps_txn_data10.dbf';

56> set newname for datafile 55 to '+DEV/data/idpayd04.dbf';

57> set newname for datafile 56 to '+DEV/data/sysaux07.dbf';

58> set newname for datafile 57 to '+DEV/data/a_txn_ind14.dbf';

59> set newname for datafile 58 to '+DEV/data/a_txn_data10.dbf';

60> set newname for datafile 59 to '+DEV/data/a_txn_ind15.dbf';

61> set newname for datafile 60 to '+DEV/data/a_txn_ind16.dbf';

62> set newname for datafile 61 to '+DEV/data/a_txn_data11.dbf';

63> set newname for datafile 62 to '+DEV/data/undo03.dbf';

64> set newname for datafile 63 to '+DEV/data/a_txn_ind17.dbf';

65> set newname for datafile 64 to '+DEV/data/a_txn_ind18.dbf';

66> set newname for datafile 65 to '+DEV/data/idpayd05.dbf';

67> set newname for datafile 66 to '+DEV/data/a_txn_data12.dbf';

68> set newname for datafile 67 to '+DEV/data/a_txn_ind19.dbf';

69> set newname for datafile 68 to '+DEV/data/ctxd03.dbf';

70> set newname for datafile 69 to '+DEV/data/a_txn_data13.dbf';

71> set newname for datafile 70 to '+DEV/data/a_txn_ind20.dbf';

72> set newname for datafile 71 to '+DEV/data/a_txn_data14.dbf';

73> set newname for datafile 72 to '+DEV/data/apps_undots2_01.dbf';

74> set newname for datafile 73 to '+DEV/data/a_txn_ind22.dbf';

75> set newname for datafile 74 to '+DEV/data/idpayd06.dbf';

76> set newname for datafile 75 to '+DEV/data/undo04.dbf';

77> set newname for datafile 76 to '+DEV/data/a_archive03.dbf';

78> set newname for datafile 77 to '+DEV/data/undo05.dbf';

79> set newname for datafile 78 to '+DEV/data/a_txn_ind23.dbf';

80> set newname for datafile 79 to '+DEV/data/a_txn_data15.dbf';

81> set newname for datafile 80 to '+DEV/data/a_txn_data16.dbf';

82> set newname for datafile 81 to '+DEV/data/a_txn_ind24.dbf';

83> set newname for datafile 82 to '+DEV/data/undo06.dbf';

84> set newname for datafile 83 to '+DEV/data/a_txn_ind25.dbf';

85> set newname for datafile 84 to '+DEV/data/a_txn_ind26.dbf';

86> set newname for datafile 85 to '+DEV/data/a_txn_data17.dbf';

87> set newname for datafile 86 to '+DEV/data/apps_undots2_02.dbf';

88> set newname for datafile 87 to '+DEV/data/apps_undots2_04.dbf';

89> set newname for datafile 88 to '+DEV/data/apps_undots2_03.dbf';

90> set newname for datafile 89 to '+DEV/data/apps_undots2_08.dbf';

91> set newname for datafile 90 to '+DEV/data/apps_undots2_07.dbf';

92> set newname for datafile 91 to '+DEV/data/apps_undots2_06.dbf';

93> set newname for datafile 92 to '+DEV/data/apps_undots2_05.dbf';

94> set newname for datafile 93 to '+DEV/data/a_txn_data18.dbf';

95> set newname for datafile 94 to '+DEV/data/a_txn_ind27.dbf';

96> set newname for datafile 95 to '+DEV/data/a_txn_ind28.dbf';

97> set newname for datafile 96 to '+DEV/data/a_txn_data19.dbf';

98> set newname for datafile 97 to '+DEV/data/a_txn_ind29.dbf';

99> set newname for datafile 98 to '+DEV/data/a_media03.dbf';

100> set newname for datafile 99 to '+DEV/data/a_txn_data20.dbf';

101> set newname for datafile 100 to '+DEV/data/a_txn_ind30.dbf';

102> set newname for datafile 101 to '+DEV/data/a_txn_data21.dbf';

103> set newname for datafile 102 to '+DEV/data/a_txn_ind31.dbf';

104> set newname for datafile 103 to '+DEV/data/a_txn_ind32.dbf';

105> set newname for datafile 104 to '+DEV/data/a_txn_data22.dbf';

106> set newname for datafile 105 to '+DEV/data/a_txn_ind33.dbf';

107> set newname for datafile 106 to '+DEV/data/a_txn_ind34.dbf';

108> set newname for datafile 107 to '+DEV/data/undo07.dbf';

109> set newname for datafile 108 to '+DEV/data/undo08.dbf';

110> set newname for datafile 109 to '+DEV/data/a_txn_data23.dbf';

111> set newname for datafile 110 to '+DEV/data/a_txn_ind35.dbf';

112> set newname for datafile 111 to '+DEV/data/a_txn_ind36.dbf';

113> set newname for datafile 112 to '+DEV/data/a_txn_data24.dbf';

114> set newname for datafile 113 to '+DEV/data/a_txn_ind37.dbf';

115> set newname for datafile 114 to '+DEV/data/a_txn_data25.dbf';

116> set newname for datafile 115 to '+DEV/data/a_txn_ind38.dbf';

117> set newname for datafile 116 to '+DEV/data/sysaux08.dbf';

118> set newname for datafile 117 to '+DEV/data/a_txn_data26.dbf';

119> set newname for datafile 118 to '+DEV/data/a_txn_ind39.dbf';

120> set newname for datafile 119 to '+DEV/data/a_txn_ind40.dbf';

121> set newname for datafile 120 to '+DEV/data/users_data.dbf';

122> set newname for datafile 121 to '+DEV/data/users_idx.dbf';

123> set newname for datafile 122 to '+DEV/data/a_txn_data27.dbf';

124> set newname for datafile 123 to '+DEV/data/a_txn_ind41.dbf';

125> set newname for datafile 124 to '+DEV/data/a_txn_data28.dbf';

126> set newname for datafile 125 to '+DEV/data/a_txn_ind42.dbf';

127> set newname for datafile 126 to '+DEV/data/undo09.dbf';

128> set newname for datafile 127 to '+DEV/data/undo10.dbf';

129> set newname for datafile 128 to '+DEV/data/a_txn_ind43.dbf';

130> set newname for datafile 129 to '+DEV/data/a_queue04.dbf';

131> set newname for datafile 130 to '+DEV/data/a_archive04.dbf';

132> set newname for datafile 131 to '+DEV/data/a_txn_data29.dbf';

133> set newname for datafile 132 to '+DEV/data/a_txn_ind44.dbf';

134> set newname for datafile 133 to '+DEV/data/a_txn_data30.dbf';

135> set newname for datafile 134 to '+DEV/data/a_txn_ind45.dbf';

136> set newname for datafile 135 to '+DEV/data/a_media04.dbf';

137> set newname for datafile 136 to '+DEV/data/a_txn_ind46.dbf';

138> set newname for datafile 137 to '+DEV/data/a_txn_data31.dbf';

139> set newname for datafile 138 to '+DEV/data/a_txn_ind47.dbf';

140> set newname for datafile 139 to '+DEV/data/a_txn_data32.dbf';

141> set newname for datafile 140 to '+DEV/data/a_txn_ind48.dbf';

142> set newname for datafile 288 to '+DEV/data/system10.dbf';

143> set newname for datafile 295 to '+DEV/data/system06.dbf';

144> set newname for datafile 314 to '+DEV/data/portal01.dbf';

145> set newname for datafile 351 to '+DEV/data/system07.dbf';

146> set newname for datafile 352 to '+DEV/data/system09.dbf';

147> set newname for datafile 353 to '+DEV/data/system08.dbf';

148> set newname for datafile 354 to '+DEV/data/system11.dbf';

149> set newname for datafile 379 to '+DEV/data/undo01.dbf';

150> set newname for datafile 392 to '+DEV/data/a_txn_data01.dbf';

151> set newname for datafile 393 to '+DEV/data/a_txn_ind01.dbf';

152> set newname for datafile 394 to '+DEV/data/a_ref01.dbf';

153> set newname for datafile 395 to '+DEV/data/a_int01.dbf';

154> set newname for datafile 396 to '+DEV/data/a_summ01.dbf';

155> set newname for datafile 397 to '+DEV/data/a_nolog01.dbf';

156> set newname for datafile 398 to '+DEV/data/a_archive01.dbf';

157> set newname for datafile 399 to '+DEV/data/a_queue01.dbf';

158> set newname for datafile 400 to '+DEV/data/a_media01.dbf';

159> set newname for datafile 401 to '+DEV/data/a_txn_data02.dbf';

160> set newname for datafile 402 to '+DEV/data/a_txn_data03.dbf';

161> set newname for datafile 403 to '+DEV/data/a_txn_ind02.dbf';

162> set newname for datafile 404 to '+DEV/data/a_txn_ind03.dbf';

163> set newname for datafile 405 to '+DEV/data/a_txn_ind04.dbf';

164> set newname for datafile 406 to '+DEV/data/a_txn_ind05.dbf';

165> set newname for datafile 407 to '+DEV/data/a_ref02.dbf';

166> restore database;

167> switch datafile all;

168> recover database;

169>}

executing command: SET NEWNAME

using target database control file instead of recovery catalog

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

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

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 20-DEC-12

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=596 devtype=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: sid=592 devtype=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: sid=591 devtype=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: sid=590 devtype=DISK

allocated channel: ORA_DISK_5

channel ORA_DISK_5: sid=589 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore

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

restoring datafile 00008 to +DEV/data/a_queue02.dbf

restoring datafile 00018 to +DEV/data/sysaux02.dbf

restoring datafile 00021 to +DEV/data/a_txn_data05.dbf

restoring datafile 00070 to +DEV/data/a_txn_ind20.dbf

restoring datafile 00111 to +DEV/data/a_txn_ind36.dbf

restoring datafile 00394 to +DEV/data/a_ref01.dbf

channel ORA_DISK_1: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_s3ntbimu_1_1.bkp

channel ORA_DISK_3: starting datafile backupset restore

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

restoring datafile 00025 to +DEV/data/a_archive02.dbf

restoring datafile 00093 to +DEV/data/a_txn_data18.dbf

restoring datafile 00400 to +DEV/data/a_media01.dbf

channel ORA_DISK_3: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_s5ntbj4n_1_1.bkp

channel ORA_DISK_4: starting datafile backupset restore

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

restoring datafile 00011 to +DEV/data/sysaux01.dbf

restoring datafile 00022 to +DEV/data/a_txn_ind07.dbf

restoring datafile 00045 to +DEV/data/a_txn_data07.dbf

restoring datafile 00101 to +DEV/data/a_txn_data21.dbf

restoring datafile 00134 to +DEV/data/a_txn_ind45.dbf

channel ORA_DISK_4: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_s6ntbjes_1_1.bkp

channel ORA_DISK_5: starting datafile backupset restore

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

restoring datafile 00094 to +DEV/data/a_txn_ind27.dbf

restoring datafile 00398 to +DEV/data/a_archive01.dbf

restoring datafile 00403 to +DEV/data/a_txn_ind02.dbf

channel ORA_DISK_5: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_s7ntbjl9_1_1.bkp

channel ORA_DISK_2: starting datafile backupset restore

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

restoring datafile 00005 to +DEV/data/system05.dbf

restoring datafile 00016 to +DEV/data/a_ref03.dbf

restoring datafile 00026 to +DEV/data/a_txn_data06.dbf

restoring datafile 00100 to +DEV/data/a_txn_ind30.dbf

restoring datafile 00133 to +DEV/data/a_txn_data30.dbf

channel ORA_DISK_2: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_s4ntbiut_1_1.bkp

channel ORA_DISK_2: restore complete, elapsed time: 00:15:17

channel ORA_DISK_2: starting datafile backupset restore

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

restoring datafile 00080 to +DEV/data/a_txn_data16.dbf

restoring datafile 00082 to +DEV/data/undo06.dbf

restoring datafile 00127 to +DEV/data/undo10.dbf

restoring datafile 00402 to +DEV/data/a_txn_data03.dbf

restoring datafile 00404 to +DEV/data/a_txn_ind03.dbf

channel ORA_DISK_2: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_s9ntbk57_1_1.bkp

channel ORA_DISK_4: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_s6ntbjes_1_1.bkp tag=TAG20121220T155053

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

channel ORA_DISK_4: starting datafile backupset restore

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

restoring datafile 00003 to +DEV/data/system03.dbf

restoring datafile 00062 to +DEV/data/undo03.dbf

restoring datafile 00090 to +DEV/data/apps_undots2_07.dbf

restoring datafile 00117 to +DEV/data/a_txn_data26.dbf

restoring datafile 00399 to +DEV/data/a_queue01.dbf

restoring datafile 00406 to +DEV/data/a_txn_ind05.dbf

channel ORA_DISK_4: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_santbkc8_1_1.bkp

channel ORA_DISK_5: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_s7ntbjl9_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_5: restore complete, elapsed time: 00:18:09

channel ORA_DISK_5: starting datafile backupset restore

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

restoring datafile 00002 to +DEV/data/system02.dbf

restoring datafile 00034 to +DEV/data/a_ref04.dbf

restoring datafile 00067 to +DEV/data/a_txn_ind19.dbf

restoring datafile 00112 to +DEV/data/a_txn_data24.dbf

restoring datafile 00126 to +DEV/data/undo09.dbf

restoring datafile 00129 to +DEV/data/a_queue04.dbf

channel ORA_DISK_5: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_sbntbki2_1_1.bkp

channel ORA_DISK_3: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_s5ntbj4n_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_3: restore complete, elapsed time: 00:19:26

channel ORA_DISK_3: starting datafile backupset restore

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

restoring datafile 00001 to +DEV/data/system01.dbf

restoring datafile 00064 to +DEV/data/a_txn_ind18.dbf

restoring datafile 00065 to +DEV/data/idpayd05.dbf

restoring datafile 00108 to +DEV/data/undo08.dbf

restoring datafile 00113 to +DEV/data/a_txn_ind37.dbf

restoring datafile 00401 to +DEV/data/a_txn_data02.dbf

channel ORA_DISK_3: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_scntbko5_1_1.bkp

channel ORA_DISK_4: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_santbkc8_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_4: restore complete, elapsed time: 00:13:49

channel ORA_DISK_4: starting datafile backupset restore

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

restoring datafile 00031 to +DEV/data/a_media02.dbf

restoring datafile 00074 to +DEV/data/idpayd06.dbf

restoring datafile 00351 to +DEV/data/system07.dbf

channel ORA_DISK_4: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_sdntbkus_1_1.bkp

channel ORA_DISK_2: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_s9ntbk57_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_2: restore complete, elapsed time: 00:15:50

channel ORA_DISK_2: starting datafile backupset restore

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

restoring datafile 00046 to +DEV/data/a_txn_ind21.dbf

restoring datafile 00085 to +DEV/data/a_txn_data17.dbf

restoring datafile 00295 to +DEV/data/system06.dbf

channel ORA_DISK_2: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_sgntbl4v_1_1.bkp

channel ORA_DISK_1: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_s8ntbjt8_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_1: restore complete, elapsed time: 00:17:07

channel ORA_DISK_1: starting datafile backupset restore

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

restoring datafile 00084 to +DEV/data/a_txn_ind26.dbf

restoring datafile 00135 to +DEV/data/a_media04.dbf

restoring datafile 00314 to +DEV/data/portal01.dbf

restoring datafile 00352 to +DEV/data/system09.dbf

channel ORA_DISK_1: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_slntbleq_1_1.bkp

channel ORA_DISK_5: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_sbntbki2_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_5: restore complete, elapsed time: 00:15:19

channel ORA_DISK_5: starting datafile backupset restore

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

restoring datafile 00056 to +DEV/data/sysaux07.dbf

restoring datafile 00122 to +DEV/data/a_txn_data27.dbf

restoring datafile 00354 to +DEV/data/system11.dbf

restoring datafile 00392 to +DEV/data/a_txn_data01.dbf

channel ORA_DISK_5: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_srntblmq_1_1.bkp

channel ORA_DISK_3: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_scntbko5_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_3: restore complete, elapsed time: 00:14:48

channel ORA_DISK_3: starting datafile backupset restore

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

restoring datafile 00033 to +DEV/data/a_queue03.dbf

restoring datafile 00058 to +DEV/data/a_txn_data10.dbf

restoring datafile 00066 to +DEV/data/a_txn_data12.dbf

restoring datafile 00103 to +DEV/data/a_txn_ind32.dbf

restoring datafile 00107 to +DEV/data/undo07.dbf

restoring datafile 00114 to +DEV/data/a_txn_data25.dbf

restoring datafile 00121 to +DEV/data/users_idx.dbf

channel ORA_DISK_3: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_suntblrb_1_1.bkp

channel ORA_DISK_4: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_sdntbkus_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_4: restore complete, elapsed time: 00:14:39

channel ORA_DISK_4: starting datafile backupset restore

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

restoring datafile 00057 to +DEV/data/a_txn_ind14.dbf

restoring datafile 00095 to +DEV/data/a_txn_ind28.dbf

restoring datafile 00405 to +DEV/data/a_txn_ind04.dbf

channel ORA_DISK_4: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_t4ntbm2m_1_1.bkp

channel ORA_DISK_5: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_srntblmq_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_5: restore complete, elapsed time: 00:13:09

channel ORA_DISK_5: starting datafile backupset restore

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

restoring datafile 00053 to +DEV/data/a_txn_ind13.dbf

restoring datafile 00059 to +DEV/data/a_txn_ind15.dbf

restoring datafile 00068 to +DEV/data/ctxd03.dbf

restoring datafile 00096 to +DEV/data/a_txn_data19.dbf

restoring datafile 00128 to +DEV/data/a_txn_ind43.dbf

channel ORA_DISK_5: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_tantbmav_1_1.bkp

channel ORA_DISK_1: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_slntbleq_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_1: restore complete, elapsed time: 00:18:29

channel ORA_DISK_1: starting datafile backupset restore

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

restoring datafile 00012 to +DEV/data/apps_ts_tools01.dbf

restoring datafile 00061 to +DEV/data/a_txn_data11.dbf

restoring datafile 00077 to +DEV/data/undo05.dbf

restoring datafile 00088 to +DEV/data/apps_undots2_03.dbf

restoring datafile 00092 to +DEV/data/apps_undots2_05.dbf

restoring datafile 00119 to +DEV/data/a_txn_ind40.dbf

restoring datafile 00120 to +DEV/data/users_data.dbf

channel ORA_DISK_1: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_tfntbmhn_1_1.bkp

channel ORA_DISK_2: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_sgntbl4v_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_2: restore complete, elapsed time: 00:19:46

channel ORA_DISK_2: starting datafile backupset restore

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

restoring datafile 00014 to +DEV/data/a_txn_data04.dbf

restoring datafile 00023 to +DEV/data/a_txn_ind08.dbf

restoring datafile 00048 to +DEV/data/a_txn_data08.dbf

restoring datafile 00102 to +DEV/data/a_txn_ind31.dbf

restoring datafile 00136 to +DEV/data/a_txn_ind46.dbf

channel ORA_DISK_2: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_tintbmlu_1_1.bkp

channel ORA_DISK_3: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_suntblrb_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_3: restore complete, elapsed time: 00:16:42

channel ORA_DISK_3: starting datafile backupset restore

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

restoring datafile 00019 to +DEV/data/idpayd01.dbf

restoring datafile 00029 to +DEV/data/sysaux04.dbf

restoring datafile 00072 to +DEV/data/apps_undots2_01.dbf

restoring datafile 00105 to +DEV/data/a_txn_ind33.dbf

restoring datafile 00138 to +DEV/data/a_txn_ind47.dbf

restoring datafile 00397 to +DEV/data/a_nolog01.dbf

channel ORA_DISK_3: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_tnntbmrn_1_1.bkp

channel ORA_DISK_4: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_t4ntbm2m_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_4: restore complete, elapsed time: 00:18:12

channel ORA_DISK_4: starting datafile backupset restore

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

restoring datafile 00055 to +DEV/data/idpayd04.dbf

restoring datafile 00071 to +DEV/data/a_txn_data14.dbf

restoring datafile 00393 to +DEV/data/a_txn_ind01.dbf

channel ORA_DISK_4: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_tsntbn08_1_1.bkp

channel ORA_DISK_1: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_tfntbmhn_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_1: restore complete, elapsed time: 00:12:56

channel ORA_DISK_5: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_tantbmav_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_5: restore complete, elapsed time: 00:17:12

channel ORA_DISK_1: starting datafile backupset restore

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

restoring datafile 00032 to +DEV/data/a_nolog02.dbf

restoring datafile 00036 to +DEV/data/apps_ts_tools02.dbf

restoring datafile 00052 to +DEV/data/system14.dbf

restoring datafile 00075 to +DEV/data/undo04.dbf

restoring datafile 00091 to +DEV/data/apps_undots2_06.dbf

restoring datafile 00118 to +DEV/data/a_txn_ind39.dbf

restoring datafile 00130 to +DEV/data/a_archive04.dbf

channel ORA_DISK_1: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_u0ntbn96_1_1.bkp

channel ORA_DISK_5: starting datafile backupset restore

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

restoring datafile 00004 to +DEV/data/system04.dbf

restoring datafile 00028 to +DEV/data/sysaux03.dbf

restoring datafile 00037 to +DEV/data/undo02.dbf

restoring datafile 00089 to +DEV/data/apps_undots2_08.dbf

restoring datafile 00115 to +DEV/data/a_txn_ind38.dbf

restoring datafile 00353 to +DEV/data/system08.dbf

channel ORA_DISK_5: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_u2ntbncf_1_1.bkp

channel ORA_DISK_3: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_tnntbmrn_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_3: restore complete, elapsed time: 00:14:08

channel ORA_DISK_3: starting datafile backupset restore

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

restoring datafile 00013 to +DEV/data/system12.dbf

restoring datafile 00020 to +DEV/data/idpayx01.dbf

restoring datafile 00042 to +DEV/data/sysaux05.dbf

restoring datafile 00076 to +DEV/data/a_archive03.dbf

restoring datafile 00106 to +DEV/data/a_txn_ind34.dbf

restoring datafile 00139 to +DEV/data/a_txn_data32.dbf

channel ORA_DISK_3: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_u3ntbnhk_1_1.bkp

channel ORA_DISK_2: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_tintbmlu_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_2: restore complete, elapsed time: 00:14:48

channel ORA_DISK_2: starting datafile backupset restore

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

restoring datafile 00078 to +DEV/data/a_txn_ind23.dbf

restoring datafile 00116 to +DEV/data/sysaux08.dbf

restoring datafile 00123 to +DEV/data/a_txn_ind41.dbf

restoring datafile 00407 to +DEV/data/a_ref02.dbf

channel ORA_DISK_2: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_u4ntbnmp_1_1.bkp

channel ORA_DISK_1: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_u0ntbn96_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_1: restore complete, elapsed time: 00:12:38

channel ORA_DISK_1: starting datafile backupset restore

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

restoring datafile 00017 to +DEV/data/a_int02.dbf

restoring datafile 00041 to +DEV/data/system13.dbf

restoring datafile 00083 to +DEV/data/a_txn_ind25.dbf

restoring datafile 00098 to +DEV/data/a_media03.dbf

restoring datafile 00288 to +DEV/data/system10.dbf

channel ORA_DISK_1: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_u5ntbnsj_1_1.bkp

channel ORA_DISK_5: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_u2ntbncf_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_5: restore complete, elapsed time: 00:14:14

channel ORA_DISK_5: starting datafile backupset restore

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

restoring datafile 00010 to +DEV/data/olap.dbf

restoring datafile 00024 to +DEV/data/idpayd02.dbf

restoring datafile 00043 to +DEV/data/odm01.dbf

restoring datafile 00044 to +DEV/data/a_txn_ind10.dbf

restoring datafile 00086 to +DEV/data/apps_undots2_02.dbf

restoring datafile 00109 to +DEV/data/a_txn_data23.dbf

restoring datafile 00140 to +DEV/data/a_txn_ind48.dbf

channel ORA_DISK_5: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_u6ntbo56_1_1.bkp

channel ORA_DISK_3: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_u3ntbnhk_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_3: restore complete, elapsed time: 00:15:03

channel ORA_DISK_3: starting datafile backupset restore

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

restoring datafile 00006 to +DEV/data/ctxd01.dbf

restoring datafile 00009 to +DEV/data/odm.dbf

restoring datafile 00030 to +DEV/data/a_int03.dbf

restoring datafile 00039 to +DEV/data/idpayd03.dbf

restoring datafile 00047 to +DEV/data/a_txn_ind11.dbf

restoring datafile 00097 to +DEV/data/a_txn_ind29.dbf

restoring datafile 00131 to +DEV/data/a_txn_data29.dbf

channel ORA_DISK_3: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_u7ntbo9n_1_1.bkp

channel ORA_DISK_2: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_u4ntbnmp_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_2: restore complete, elapsed time: 00:15:33

channel ORA_DISK_2: starting datafile backupset restore

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

restoring datafile 00007 to +DEV/data/owad01.dbf

restoring datafile 00038 to +DEV/data/ctxd02.dbf

restoring datafile 00040 to +DEV/data/idpayx02.dbf

restoring datafile 00050 to +DEV/data/a_txn_data09.dbf

restoring datafile 00099 to +DEV/data/a_txn_data20.dbf

restoring datafile 00132 to +DEV/data/a_txn_ind44.dbf

restoring datafile 00395 to +DEV/data/a_int01.dbf

channel ORA_DISK_2: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_u8ntbofh_1_1.bkp

channel ORA_DISK_4: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_tsntbn08_1_1.bkp tag=TAG20121220T155053

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

channel ORA_DISK_4: starting datafile backupset restore

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

restoring datafile 00049 to +DEV/data/sysaux06.dbf

restoring datafile 00051 to +DEV/data/a_txn_ind12.dbf

restoring datafile 00069 to +DEV/data/a_txn_data13.dbf

restoring datafile 00087 to +DEV/data/apps_undots2_04.dbf

restoring datafile 00110 to +DEV/data/a_txn_ind35.dbf

restoring datafile 00379 to +DEV/data/undo01.dbf

channel ORA_DISK_4: reading from backup piece /bktmp/backupPROD/PROD_DB_20121220_u9ntbolk_1_1.bkp

channel ORA_DISK_2: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_u8ntbofh_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_2: restore complete, elapsed time: 00:16:21

channel ORA_DISK_4: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_u9ntbolk_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_4: restore complete, elapsed time: 00:18:20

channel ORA_DISK_5: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_uantbouh_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_5: restore complete, elapsed time: 00:13:50

channel ORA_DISK_1: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_ucntbpb1_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_1: restore complete, elapsed time: 00:11:42

channel ORA_DISK_3: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_DB_20121220_ubntbp4k_1_1.bkp tag=TAG20121220T155053

channel ORA_DISK_3: restore complete, elapsed time: 00:13:04

Finished restore at 20-DEC-12

datafile 1 switched to datafile copy

input datafile copy recid=456 stamp=802568349 filename=+DEV/data/system01.dbf

datafile 2 switched to datafile copy

input datafile copy recid=457 stamp=802568350 filename=+DEV/data/system02.dbf

datafile 3 switched to datafile copy

input datafile copy recid=458 stamp=802568350 filename=+DEV/data/system03.dbf

datafile 4 switched to datafile copy

input datafile copy recid=459 stamp=802568351 filename=+DEV/data/system04.dbf

datafile 5 switched to datafile copy

input datafile copy recid=460 stamp=802568352 filename=+DEV/data/system05.dbf

datafile 6 switched to datafile copy

input datafile copy recid=461 stamp=802568352 filename=+DEV/data/ctxd01.dbf

datafile 7 switched to datafile copy

input datafile copy recid=462 stamp=802568353 filename=+DEV/data/owad01.dbf

datafile 8 switched to datafile copy

input datafile copy recid=463 stamp=802568354 filename=+DEV/data/a_queue02.dbf

datafile 9 switched to datafile copy

input datafile copy recid=464 stamp=802568354 filename=+DEV/data/odm.dbf

datafile 10 switched to datafile copy

input datafile copy recid=465 stamp=802568355 filename=+DEV/data/olap.dbf

datafile 11 switched to datafile copy

input datafile copy recid=466 stamp=802568356 filename=+DEV/data/sysaux01.dbf

datafile 12 switched to datafile copy

input datafile copy recid=467 stamp=802568356 filename=+DEV/data/apps_ts_tools01.dbf

datafile 13 switched to datafile copy

input datafile copy recid=468 stamp=802568357 filename=+DEV/data/system12.dbf

datafile 14 switched to datafile copy

input datafile copy recid=469 stamp=802568358 filename=+DEV/data/a_txn_data04.dbf

datafile 15 switched to datafile copy

input datafile copy recid=470 stamp=802568358 filename=+DEV/data/a_txn_ind06.dbf

datafile 16 switched to datafile copy

input datafile copy recid=471 stamp=802568359 filename=+DEV/data/a_ref03.dbf

datafile 17 switched to datafile copy

input datafile copy recid=472 stamp=802568359 filename=+DEV/data/a_int02.dbf

datafile 18 switched to datafile copy

input datafile copy recid=473 stamp=802568360 filename=+DEV/data/sysaux02.dbf

datafile 19 switched to datafile copy

input datafile copy recid=474 stamp=802568361 filename=+DEV/data/idpayd01.dbf

datafile 20 switched to datafile copy

input datafile copy recid=475 stamp=802568361 filename=+DEV/data/idpayx01.dbf

datafile 21 switched to datafile copy

input datafile copy recid=476 stamp=802568362 filename=+DEV/data/a_txn_data05.dbf

datafile 22 switched to datafile copy

input datafile copy recid=477 stamp=802568363 filename=+DEV/data/a_txn_ind07.dbf

datafile 23 switched to datafile copy

input datafile copy recid=478 stamp=802568364 filename=+DEV/data/a_txn_ind08.dbf

datafile 24 switched to datafile copy

input datafile copy recid=479 stamp=802568364 filename=+DEV/data/idpayd02.dbf

datafile 25 switched to datafile copy

input datafile copy recid=480 stamp=802568365 filename=+DEV/data/a_archive02.dbf

datafile 26 switched to datafile copy

input datafile copy recid=481 stamp=802568366 filename=+DEV/data/a_txn_data06.dbf

datafile 27 switched to datafile copy

input datafile copy recid=482 stamp=802568366 filename=+DEV/data/a_txn_ind09.dbf

datafile 28 switched to datafile copy

input datafile copy recid=483 stamp=802568367 filename=+DEV/data/sysaux03.dbf

datafile 29 switched to datafile copy

input datafile copy recid=484 stamp=802568368 filename=+DEV/data/sysaux04.dbf

datafile 30 switched to datafile copy

input datafile copy recid=485 stamp=802568368 filename=+DEV/data/a_int03.dbf

datafile 31 switched to datafile copy

input datafile copy recid=486 stamp=802568369 filename=+DEV/data/a_media02.dbf

datafile 32 switched to datafile copy

input datafile copy recid=487 stamp=802568370 filename=+DEV/data/a_nolog02.dbf

datafile 33 switched to datafile copy

input datafile copy recid=488 stamp=802568370 filename=+DEV/data/a_queue03.dbf

datafile 34 switched to datafile copy

input datafile copy recid=489 stamp=802568371 filename=+DEV/data/a_ref04.dbf

datafile 35 switched to datafile copy

input datafile copy recid=490 stamp=802568372 filename=+DEV/data/a_summ02.dbf

datafile 36 switched to datafile copy

input datafile copy recid=491 stamp=802568372 filename=+DEV/data/apps_ts_tools02.dbf

datafile 37 switched to datafile copy

input datafile copy recid=492 stamp=802568373 filename=+DEV/data/undo02.dbf

datafile 38 switched to datafile copy

input datafile copy recid=493 stamp=802568374 filename=+DEV/data/ctxd02.dbf

datafile 39 switched to datafile copy

input datafile copy recid=494 stamp=802568374 filename=+DEV/data/idpayd03.dbf

datafile 40 switched to datafile copy

input datafile copy recid=495 stamp=802568375 filename=+DEV/data/idpayx02.dbf

datafile 41 switched to datafile copy

input datafile copy recid=496 stamp=802568376 filename=+DEV/data/system13.dbf

datafile 42 switched to datafile copy

input datafile copy recid=497 stamp=802568376 filename=+DEV/data/sysaux05.dbf

datafile 43 switched to datafile copy

input datafile copy recid=498 stamp=802568377 filename=+DEV/data/odm01.dbf

datafile 44 switched to datafile copy

input datafile copy recid=499 stamp=802568378 filename=+DEV/data/a_txn_ind10.dbf

datafile 45 switched to datafile copy

input datafile copy recid=500 stamp=802568378 filename=+DEV/data/a_txn_data07.dbf

datafile 46 switched to datafile copy

input datafile copy recid=501 stamp=802568379 filename=+DEV/data/a_txn_ind21.dbf

datafile 47 switched to datafile copy

input datafile copy recid=502 stamp=802568380 filename=+DEV/data/a_txn_ind11.dbf

datafile 48 switched to datafile copy

input datafile copy recid=503 stamp=802568380 filename=+DEV/data/a_txn_data08.dbf

datafile 49 switched to datafile copy

input datafile copy recid=504 stamp=802568381 filename=+DEV/data/sysaux06.dbf

datafile 50 switched to datafile copy

input datafile copy recid=505 stamp=802568382 filename=+DEV/data/a_txn_data09.dbf

datafile 51 switched to datafile copy

input datafile copy recid=506 stamp=802568382 filename=+DEV/data/a_txn_ind12.dbf

datafile 52 switched to datafile copy

input datafile copy recid=507 stamp=802568383 filename=+DEV/data/system14.dbf

datafile 53 switched to datafile copy

input datafile copy recid=508 stamp=802568384 filename=+DEV/data/a_txn_ind13.dbf

datafile 54 switched to datafile copy

input datafile copy recid=509 stamp=802568384 filename=+DEV/data/apps_txn_data10.dbf

datafile 55 switched to datafile copy

input datafile copy recid=510 stamp=802568385 filename=+DEV/data/idpayd04.dbf

datafile 56 switched to datafile copy

input datafile copy recid=511 stamp=802568385 filename=+DEV/data/sysaux07.dbf

datafile 57 switched to datafile copy

input datafile copy recid=512 stamp=802568386 filename=+DEV/data/a_txn_ind14.dbf

datafile 58 switched to datafile copy

input datafile copy recid=513 stamp=802568387 filename=+DEV/data/a_txn_data10.dbf

datafile 59 switched to datafile copy

input datafile copy recid=514 stamp=802568387 filename=+DEV/data/a_txn_ind15.dbf

datafile 60 switched to datafile copy

input datafile copy recid=515 stamp=802568388 filename=+DEV/data/a_txn_ind16.dbf

datafile 61 switched to datafile copy

input datafile copy recid=516 stamp=802568389 filename=+DEV/data/a_txn_data11.dbf

datafile 62 switched to datafile copy

input datafile copy recid=517 stamp=802568389 filename=+DEV/data/undo03.dbf

datafile 63 switched to datafile copy

input datafile copy recid=518 stamp=802568390 filename=+DEV/data/a_txn_ind17.dbf

datafile 64 switched to datafile copy

input datafile copy recid=519 stamp=802568391 filename=+DEV/data/a_txn_ind18.dbf

datafile 65 switched to datafile copy

input datafile copy recid=520 stamp=802568391 filename=+DEV/data/idpayd05.dbf

datafile 66 switched to datafile copy

input datafile copy recid=521 stamp=802568392 filename=+DEV/data/a_txn_data12.dbf

datafile 67 switched to datafile copy

input datafile copy recid=522 stamp=802568393 filename=+DEV/data/a_txn_ind19.dbf

datafile 68 switched to datafile copy

input datafile copy recid=523 stamp=802568393 filename=+DEV/data/ctxd03.dbf

datafile 69 switched to datafile copy

input datafile copy recid=524 stamp=802568394 filename=+DEV/data/a_txn_data13.dbf

datafile 70 switched to datafile copy

input datafile copy recid=525 stamp=802568394 filename=+DEV/data/a_txn_ind20.dbf

datafile 71 switched to datafile copy

input datafile copy recid=526 stamp=802568395 filename=+DEV/data/a_txn_data14.dbf

datafile 72 switched to datafile copy

input datafile copy recid=527 stamp=802568396 filename=+DEV/data/apps_undots2_01.dbf

datafile 73 switched to datafile copy

input datafile copy recid=528 stamp=802568396 filename=+DEV/data/a_txn_ind22.dbf

datafile 74 switched to datafile copy

input datafile copy recid=529 stamp=802568397 filename=+DEV/data/idpayd06.dbf

datafile 75 switched to datafile copy

input datafile copy recid=530 stamp=802568398 filename=+DEV/data/undo04.dbf

datafile 76 switched to datafile copy

input datafile copy recid=531 stamp=802568399 filename=+DEV/data/a_archive03.dbf

datafile 77 switched to datafile copy

input datafile copy recid=532 stamp=802568399 filename=+DEV/data/undo05.dbf

datafile 78 switched to datafile copy

input datafile copy recid=533 stamp=802568400 filename=+DEV/data/a_txn_ind23.dbf

datafile 79 switched to datafile copy

input datafile copy recid=534 stamp=802568400 filename=+DEV/data/a_txn_data15.dbf

datafile 80 switched to datafile copy

input datafile copy recid=535 stamp=802568401 filename=+DEV/data/a_txn_data16.dbf

datafile 81 switched to datafile copy

input datafile copy recid=536 stamp=802568402 filename=+DEV/data/a_txn_ind24.dbf

datafile 82 switched to datafile copy

input datafile copy recid=537 stamp=802568402 filename=+DEV/data/undo06.dbf

datafile 83 switched to datafile copy

input datafile copy recid=538 stamp=802568403 filename=+DEV/data/a_txn_ind25.dbf

datafile 84 switched to datafile copy

input datafile copy recid=539 stamp=802568404 filename=+DEV/data/a_txn_ind26.dbf

datafile 85 switched to datafile copy

input datafile copy recid=540 stamp=802568404 filename=+DEV/data/a_txn_data17.dbf

datafile 86 switched to datafile copy

input datafile copy recid=541 stamp=802568405 filename=+DEV/data/apps_undots2_02.dbf

datafile 87 switched to datafile copy

input datafile copy recid=542 stamp=802568406 filename=+DEV/data/apps_undots2_04.dbf

datafile 88 switched to datafile copy

input datafile copy recid=543 stamp=802568406 filename=+DEV/data/apps_undots2_03.dbf

datafile 89 switched to datafile copy

input datafile copy recid=544 stamp=802568407 filename=+DEV/data/apps_undots2_08.dbf

datafile 90 switched to datafile copy

input datafile copy recid=545 stamp=802568407 filename=+DEV/data/apps_undots2_07.dbf

datafile 91 switched to datafile copy

input datafile copy recid=546 stamp=802568408 filename=+DEV/data/apps_undots2_06.dbf

datafile 92 switched to datafile copy

input datafile copy recid=547 stamp=802568409 filename=+DEV/data/apps_undots2_05.dbf

datafile 93 switched to datafile copy

input datafile copy recid=548 stamp=802568409 filename=+DEV/data/a_txn_data18.dbf

datafile 94 switched to datafile copy

input datafile copy recid=549 stamp=802568410 filename=+DEV/data/a_txn_ind27.dbf

datafile 95 switched to datafile copy

input datafile copy recid=550 stamp=802568411 filename=+DEV/data/a_txn_ind28.dbf

datafile 96 switched to datafile copy

input datafile copy recid=551 stamp=802568411 filename=+DEV/data/a_txn_data19.dbf

datafile 97 switched to datafile copy

input datafile copy recid=552 stamp=802568412 filename=+DEV/data/a_txn_ind29.dbf

datafile 98 switched to datafile copy

input datafile copy recid=553 stamp=802568413 filename=+DEV/data/a_media03.dbf

datafile 99 switched to datafile copy

input datafile copy recid=554 stamp=802568414 filename=+DEV/data/a_txn_data20.dbf

datafile 100 switched to datafile copy

input datafile copy recid=555 stamp=802568414 filename=+DEV/data/a_txn_ind30.dbf

datafile 101 switched to datafile copy

input datafile copy recid=556 stamp=802568415 filename=+DEV/data/a_txn_data21.dbf

datafile 102 switched to datafile copy

input datafile copy recid=557 stamp=802568416 filename=+DEV/data/a_txn_ind31.dbf

datafile 103 switched to datafile copy

input datafile copy recid=558 stamp=802568416 filename=+DEV/data/a_txn_ind32.dbf

datafile 104 switched to datafile copy

input datafile copy recid=559 stamp=802568417 filename=+DEV/data/a_txn_data22.dbf

datafile 105 switched to datafile copy

input datafile copy recid=560 stamp=802568418 filename=+DEV/data/a_txn_ind33.dbf

datafile 106 switched to datafile copy

input datafile copy recid=561 stamp=802568419 filename=+DEV/data/a_txn_ind34.dbf

datafile 107 switched to datafile copy

input datafile copy recid=562 stamp=802568419 filename=+DEV/data/undo07.dbf

datafile 108 switched to datafile copy

input datafile copy recid=563 stamp=802568420 filename=+DEV/data/undo08.dbf

datafile 109 switched to datafile copy

input datafile copy recid=564 stamp=802568421 filename=+DEV/data/a_txn_data23.dbf

datafile 110 switched to datafile copy

input datafile copy recid=565 stamp=802568421 filename=+DEV/data/a_txn_ind35.dbf

datafile 111 switched to datafile copy

input datafile copy recid=566 stamp=802568422 filename=+DEV/data/a_txn_ind36.dbf

datafile 112 switched to datafile copy

input datafile copy recid=567 stamp=802568423 filename=+DEV/data/a_txn_data24.dbf

datafile 113 switched to datafile copy

input datafile copy recid=568 stamp=802568424 filename=+DEV/data/a_txn_ind37.dbf

datafile 114 switched to datafile copy

input datafile copy recid=569 stamp=802568424 filename=+DEV/data/a_txn_data25.dbf

datafile 115 switched to datafile copy

input datafile copy recid=570 stamp=802568425 filename=+DEV/data/a_txn_ind38.dbf

datafile 116 switched to datafile copy

input datafile copy recid=571 stamp=802568426 filename=+DEV/data/sysaux08.dbf

datafile 117 switched to datafile copy

input datafile copy recid=572 stamp=802568426 filename=+DEV/data/a_txn_data26.dbf

datafile 118 switched to datafile copy

input datafile copy recid=573 stamp=802568427 filename=+DEV/data/a_txn_ind39.dbf

datafile 119 switched to datafile copy

input datafile copy recid=574 stamp=802568428 filename=+DEV/data/a_txn_ind40.dbf

datafile 120 switched to datafile copy

input datafile copy recid=575 stamp=802568429 filename=+DEV/data/users_data.dbf

datafile 121 switched to datafile copy

input datafile copy recid=576 stamp=802568429 filename=+DEV/data/users_idx.dbf

datafile 122 switched to datafile copy

input datafile copy recid=577 stamp=802568430 filename=+DEV/data/a_txn_data27.dbf

datafile 123 switched to datafile copy

input datafile copy recid=578 stamp=802568431 filename=+DEV/data/a_txn_ind41.dbf

datafile 124 switched to datafile copy

input datafile copy recid=579 stamp=802568431 filename=+DEV/data/a_txn_data28.dbf

datafile 125 switched to datafile copy

input datafile copy recid=580 stamp=802568432 filename=+DEV/data/a_txn_ind42.dbf

datafile 126 switched to datafile copy

input datafile copy recid=581 stamp=802568433 filename=+DEV/data/undo09.dbf

datafile 127 switched to datafile copy

input datafile copy recid=582 stamp=802568433 filename=+DEV/data/undo10.dbf

datafile 128 switched to datafile copy

input datafile copy recid=583 stamp=802568434 filename=+DEV/data/a_txn_ind43.dbf

datafile 129 switched to datafile copy

input datafile copy recid=584 stamp=802568435 filename=+DEV/data/a_queue04.dbf

datafile 130 switched to datafile copy

input datafile copy recid=585 stamp=802568436 filename=+DEV/data/a_archive04.dbf

datafile 131 switched to datafile copy

input datafile copy recid=586 stamp=802568436 filename=+DEV/data/a_txn_data29.dbf

datafile 132 switched to datafile copy

input datafile copy recid=587 stamp=802568437 filename=+DEV/data/a_txn_ind44.dbf

datafile 133 switched to datafile copy

input datafile copy recid=588 stamp=802568438 filename=+DEV/data/a_txn_data30.dbf

datafile 134 switched to datafile copy

input datafile copy recid=589 stamp=802568438 filename=+DEV/data/a_txn_ind45.dbf

datafile 135 switched to datafile copy

input datafile copy recid=590 stamp=802568439 filename=+DEV/data/a_media04.dbf

datafile 136 switched to datafile copy

input datafile copy recid=591 stamp=802568440 filename=+DEV/data/a_txn_ind46.dbf

datafile 137 switched to datafile copy

input datafile copy recid=592 stamp=802568441 filename=+DEV/data/a_txn_data31.dbf

datafile 138 switched to datafile copy

input datafile copy recid=593 stamp=802568441 filename=+DEV/data/a_txn_ind47.dbf

datafile 139 switched to datafile copy

input datafile copy recid=594 stamp=802568442 filename=+DEV/data/a_txn_data32.dbf

datafile 140 switched to datafile copy

input datafile copy recid=595 stamp=802568443 filename=+DEV/data/a_txn_ind48.dbf

datafile 288 switched to datafile copy

input datafile copy recid=596 stamp=802568444 filename=+DEV/data/system10.dbf

datafile 295 switched to datafile copy

input datafile copy recid=597 stamp=802568444 filename=+DEV/data/system06.dbf

datafile 314 switched to datafile copy

input datafile copy recid=598 stamp=802568445 filename=+DEV/data/portal01.dbf

datafile 351 switched to datafile copy

input datafile copy recid=599 stamp=802568446 filename=+DEV/data/system07.dbf

datafile 352 switched to datafile copy

input datafile copy recid=600 stamp=802568447 filename=+DEV/data/system09.dbf

datafile 353 switched to datafile copy

input datafile copy recid=601 stamp=802568447 filename=+DEV/data/system08.dbf

datafile 354 switched to datafile copy

input datafile copy recid=602 stamp=802568448 filename=+DEV/data/system11.dbf

datafile 379 switched to datafile copy

input datafile copy recid=603 stamp=802568449 filename=+DEV/data/undo01.dbf

datafile 392 switched to datafile copy

input datafile copy recid=604 stamp=802568449 filename=+DEV/data/a_txn_data01.dbf

datafile 393 switched to datafile copy

input datafile copy recid=605 stamp=802568450 filename=+DEV/data/a_txn_ind01.dbf

datafile 394 switched to datafile copy

input datafile copy recid=606 stamp=802568451 filename=+DEV/data/a_ref01.dbf

datafile 395 switched to datafile copy

input datafile copy recid=607 stamp=802568452 filename=+DEV/data/a_int01.dbf

datafile 396 switched to datafile copy

input datafile copy recid=608 stamp=802568452 filename=+DEV/data/a_summ01.dbf

datafile 397 switched to datafile copy

input datafile copy recid=609 stamp=802568453 filename=+DEV/data/a_nolog01.dbf

datafile 398 switched to datafile copy

input datafile copy recid=610 stamp=802568454 filename=+DEV/data/a_archive01.dbf

datafile 399 switched to datafile copy

input datafile copy recid=611 stamp=802568454 filename=+DEV/data/a_queue01.dbf

datafile 400 switched to datafile copy

input datafile copy recid=612 stamp=802568455 filename=+DEV/data/a_media01.dbf

datafile 401 switched to datafile copy

input datafile copy recid=613 stamp=802568456 filename=+DEV/data/a_txn_data02.dbf

datafile 402 switched to datafile copy

input datafile copy recid=614 stamp=802568457 filename=+DEV/data/a_txn_data03.dbf

datafile 403 switched to datafile copy

input datafile copy recid=615 stamp=802568457 filename=+DEV/data/a_txn_ind02.dbf

datafile 404 switched to datafile copy

input datafile copy recid=616 stamp=802568458 filename=+DEV/data/a_txn_ind03.dbf

datafile 405 switched to datafile copy

input datafile copy recid=617 stamp=802568459 filename=+DEV/data/a_txn_ind04.dbf

datafile 406 switched to datafile copy

input datafile copy recid=618 stamp=802568459 filename=+DEV/data/a_txn_ind05.dbf

datafile 407 switched to datafile copy

input datafile copy recid=619 stamp=802568460 filename=+DEV/data/a_ref02.dbf

Starting recover at 20-DEC-12

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

starting media recovery

channel ORA_DISK_1: starting archive log restore to default destination

channel ORA_DISK_2: starting archive log restore to default destination

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=4026

channel ORA_DISK_2: restoring archive log

archive log thread=2 sequence=2681

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=4027

channel ORA_DISK_2: restoring archive log

archive log thread=2 sequence=2682

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=4028

channel ORA_DISK_2: restoring archive log

archive log thread=2 sequence=2683

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=4029

channel ORA_DISK_1: reading from backup piece /bktmp/backupPROD/PROD_ARC_20121220_uentbphj_1_1.bkp

channel ORA_DISK_2: restoring archive log

archive log thread=2 sequence=2684

channel ORA_DISK_2: reading from backup piece /bktmp/backupPROD/PROD_ARC_20121220_uhntbqps_1_1.bkp

channel ORA_DISK_2: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_ARC_20121220_uhntbqps_1_1.bkp tag=TAG20121220T174725

channel ORA_DISK_2: restore complete, elapsed time: 00:03:06

channel ORA_DISK_2: restore complete, elapsed time: 00:03:06

channel ORA_DISK_1: restored backup piece 1

failover to piece handle=/u01/oracle/backupPROD/PROD_ARC_20121220_uentbphj_1_1.bkp tag=TAG20121220T174725

channel ORA_DISK_1: restore complete, elapsed time: 00:13:11

archive log filename=/u01/oracle/db/tech_st/10.2.0/dbs/arch1_4026_697647449.dbf thread=1 sequence=4026

archive log filename=/u01/oracle/db/tech_st/10.2.0/dbs/arch2_2681_697647449.dbf thread=2 sequence=2681

archive log filename=/u01/oracle/db/tech_st/10.2.0/dbs/arch2_2682_697647449.dbf thread=2 sequence=2682

archive log filename=/u01/oracle/db/tech_st/10.2.0/dbs/arch1_4027_697647449.dbf thread=1 sequence=4027

archive log filename=/u01/oracle/db/tech_st/10.2.0/dbs/arch1_4028_697647449.dbf thread=1 sequence=4028

archive log filename=/u01/oracle/db/tech_st/10.2.0/dbs/arch2_2683_697647449.dbf thread=2 sequence=2683

archive log filename=/u01/oracle/db/tech_st/10.2.0/dbs/arch1_4029_697647449.dbf thread=1 sequence=4029

archive log filename=/u01/oracle/db/tech_st/10.2.0/dbs/arch2_2684_697647449.dbf thread=2 sequence=2684

unable to find archive log

archive log thread=1 sequence=4030

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 12/20/2012 23:55:14

RMAN-06054: media recovery requesting unknown log: thread 1 seq 4030 lowscn 5976525563250

RMAN> quit

Recovery Manager complete.

[devmgr@bedirisendiri ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Dec 21 00:01:45 2012

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> alter database backup controlfile to trace as '/home/devmgr/ctl.trc';

Database altered.

SQL> exit

[devmgr@bedirisendiri ~]$ cp ctl.trc ctl.sql

[devmgr@bedirisendiri ~]$ vi ctl.sql            ## edit menjadi di bawah

[devmgr@bedirisendiri ~]$ more ctl.sql

CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS ARCHIVELOG

    MAXLOGFILES 32

    MAXLOGMEMBERS 5

    MAXDATAFILES 512

    MAXINSTANCES 8

    MAXLOGHISTORY 14607

LOGFILE

  GROUP 1 (

    '+DEV/data/log01a.dbf',

    '+DEV/data/log01b.dbf'

  ) SIZE 1000M,

  GROUP 2 (

    '+DEV/data/log02a.dbf',

    '+DEV/data/log02b.dbf'

  ) SIZE 1000M,

  GROUP 3 (

    '+DEV/data/log03a.dbf',

    '+DEV/data/onlinelog/log03b.dbf'

  ) SIZE 1000M

DATAFILE

  '+DEV/data/system01.dbf',

  '+DEV/data/system02.dbf',

  '+DEV/data/system03.dbf',

  '+DEV/data/system04.dbf',

  '+DEV/data/system05.dbf',

  '+DEV/data/ctxd01.dbf',

  '+DEV/data/owad01.dbf',

  '+DEV/data/a_queue02.dbf',

  '+DEV/data/odm.dbf',

  '+DEV/data/olap.dbf',

  '+DEV/data/sysaux01.dbf',

  '+DEV/data/apps_ts_tools01.dbf',

  '+DEV/data/system12.dbf',

  '+DEV/data/a_txn_data04.dbf',

  '+DEV/data/a_txn_ind06.dbf',

  '+DEV/data/a_ref03.dbf',

  '+DEV/data/a_int02.dbf',

  '+DEV/data/sysaux02.dbf',

  '+DEV/data/idpayd01.dbf',

  '+DEV/data/idpayx01.dbf',

  '+DEV/data/a_txn_data05.dbf',

  '+DEV/data/a_txn_ind07.dbf',

  '+DEV/data/a_txn_ind08.dbf',

  '+DEV/data/idpayd02.dbf',

  '+DEV/data/a_archive02.dbf',

  '+DEV/data/a_txn_data06.dbf',

  '+DEV/data/a_txn_ind09.dbf',

  '+DEV/data/sysaux03.dbf',

  '+DEV/data/sysaux04.dbf',

  '+DEV/data/a_int03.dbf',

  '+DEV/data/a_media02.dbf',

  '+DEV/data/a_nolog02.dbf',

  '+DEV/data/a_queue03.dbf',

  '+DEV/data/a_ref04.dbf',

  '+DEV/data/a_summ02.dbf',

  '+DEV/data/apps_ts_tools02.dbf',

  '+DEV/data/undo02.dbf',

  '+DEV/data/ctxd02.dbf',

  '+DEV/data/idpayd03.dbf',

  '+DEV/data/idpayx02.dbf',

  '+DEV/data/system13.dbf',

  '+DEV/data/sysaux05.dbf',

  '+DEV/data/odm01.dbf',

  '+DEV/data/a_txn_ind10.dbf',

  '+DEV/data/a_txn_data07.dbf',

  '+DEV/data/a_txn_ind21.dbf',

  '+DEV/data/a_txn_ind11.dbf',

  '+DEV/data/a_txn_data08.dbf',

  '+DEV/data/sysaux06.dbf',

  '+DEV/data/a_txn_data09.dbf',

  '+DEV/data/a_txn_ind12.dbf',

  '+DEV/data/system14.dbf',

  '+DEV/data/a_txn_ind13.dbf',

  '+DEV/data/apps_txn_data10.dbf',

  '+DEV/data/idpayd04.dbf',

  '+DEV/data/sysaux07.dbf',

  '+DEV/data/a_txn_ind14.dbf',

  '+DEV/data/a_txn_data10.dbf',

  '+DEV/data/a_txn_ind15.dbf',

  '+DEV/data/a_txn_ind16.dbf',

  '+DEV/data/a_txn_data11.dbf',

  '+DEV/data/undo03.dbf',

  '+DEV/data/a_txn_ind17.dbf',

  '+DEV/data/a_txn_ind18.dbf',

  '+DEV/data/idpayd05.dbf',

  '+DEV/data/a_txn_data12.dbf',

  '+DEV/data/a_txn_ind19.dbf',

  '+DEV/data/ctxd03.dbf',

  '+DEV/data/a_txn_data13.dbf',

  '+DEV/data/a_txn_ind20.dbf',

  '+DEV/data/a_txn_data14.dbf',

  '+DEV/data/apps_undots2_01.dbf',

  '+DEV/data/a_txn_ind22.dbf',

  '+DEV/data/idpayd06.dbf',

  '+DEV/data/undo04.dbf',

  '+DEV/data/a_archive03.dbf',

  '+DEV/data/undo05.dbf',

  '+DEV/data/a_txn_ind23.dbf',

  '+DEV/data/a_txn_data15.dbf',

  '+DEV/data/a_txn_data16.dbf',

  '+DEV/data/a_txn_ind24.dbf',

  '+DEV/data/undo06.dbf',

  '+DEV/data/a_txn_ind25.dbf',

  '+DEV/data/a_txn_ind26.dbf',

  '+DEV/data/a_txn_data17.dbf',

  '+DEV/data/apps_undots2_02.dbf',

  '+DEV/data/apps_undots2_04.dbf',

  '+DEV/data/apps_undots2_03.dbf',

  '+DEV/data/apps_undots2_08.dbf',

  '+DEV/data/apps_undots2_07.dbf',

  '+DEV/data/apps_undots2_06.dbf',

  '+DEV/data/apps_undots2_05.dbf',

  '+DEV/data/a_txn_data18.dbf',

  '+DEV/data/a_txn_ind27.dbf',

  '+DEV/data/a_txn_ind28.dbf',

  '+DEV/data/a_txn_data19.dbf',

  '+DEV/data/a_txn_ind29.dbf',

  '+DEV/data/a_media03.dbf',

  '+DEV/data/a_txn_data20.dbf',

  '+DEV/data/a_txn_ind30.dbf',

  '+DEV/data/a_txn_data21.dbf',

  '+DEV/data/a_txn_ind31.dbf',

  '+DEV/data/a_txn_ind32.dbf',

  '+DEV/data/a_txn_data22.dbf',

  '+DEV/data/a_txn_ind33.dbf',

  '+DEV/data/a_txn_ind34.dbf',

  '+DEV/data/undo07.dbf',

  '+DEV/data/undo08.dbf',

  '+DEV/data/a_txn_data23.dbf',

  '+DEV/data/a_txn_ind35.dbf',

  '+DEV/data/a_txn_ind36.dbf',

  '+DEV/data/a_txn_data24.dbf',

  '+DEV/data/a_txn_ind37.dbf',

  '+DEV/data/a_txn_data25.dbf',

  '+DEV/data/a_txn_ind38.dbf',

  '+DEV/data/sysaux08.dbf',

  '+DEV/data/a_txn_data26.dbf',

  '+DEV/data/a_txn_ind39.dbf',

  '+DEV/data/a_txn_ind40.dbf',

  '+DEV/data/users_data.dbf',

  '+DEV/data/users_idx.dbf',

  '+DEV/data/a_txn_data27.dbf',

  '+DEV/data/a_txn_ind41.dbf',

  '+DEV/data/a_txn_data28.dbf',

  '+DEV/data/a_txn_ind42.dbf',

  '+DEV/data/undo09.dbf',

  '+DEV/data/undo10.dbf',

  '+DEV/data/a_txn_ind43.dbf',

  '+DEV/data/a_queue04.dbf',

  '+DEV/data/a_archive04.dbf',

  '+DEV/data/a_txn_data29.dbf',

  '+DEV/data/a_txn_ind44.dbf',

  '+DEV/data/a_txn_data30.dbf',

  '+DEV/data/a_txn_ind45.dbf',

  '+DEV/data/a_media04.dbf',

  '+DEV/data/a_txn_ind46.dbf',

  '+DEV/data/a_txn_data31.dbf',

  '+DEV/data/a_txn_ind47.dbf',

  '+DEV/data/a_txn_data32.dbf',

  '+DEV/data/a_txn_ind48.dbf',

  '+DEV/data/system10.dbf',

  '+DEV/data/system06.dbf',

  '+DEV/data/portal01.dbf',

  '+DEV/data/system07.dbf',

  '+DEV/data/system09.dbf',

  '+DEV/data/system08.dbf',

  '+DEV/data/system11.dbf',

  '+DEV/data/undo01.dbf',

  '+DEV/data/a_txn_data01.dbf',

  '+DEV/data/a_txn_ind01.dbf',

  '+DEV/data/a_ref01.dbf',

  '+DEV/data/a_int01.dbf',

  '+DEV/data/a_summ01.dbf',

  '+DEV/data/a_nolog01.dbf',

  '+DEV/data/a_archive01.dbf',

  '+DEV/data/a_queue01.dbf',

  '+DEV/data/a_media01.dbf',

  '+DEV/data/a_txn_data02.dbf',

  '+DEV/data/a_txn_data03.dbf',

  '+DEV/data/a_txn_ind02.dbf',

  '+DEV/data/a_txn_ind03.dbf',

  '+DEV/data/a_txn_ind04.dbf',

  '+DEV/data/a_txn_ind05.dbf',

  '+DEV/data/a_ref02.dbf'

CHARACTER SET US7ASCII

;

[devmgr@bedirisendiri dbs]$ vi initDEV.ora                    #### rubah db_name jadi DEV

[devmgr@bedirisendiri ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Dec 21 00:22:46 2012

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1077936128 bytes

Fixed Size                  2076584 bytes

Variable Size             427819096 bytes

Database Buffers          633339904 bytes

Redo Buffers               14700544 bytes

SQL> @ctl.sql

Control file created.

SQL> alter database open resetlogs;

Database altered.

SQL> CREATE temporary TABLESPACE TEMP01 TEMPFILE '+DEV/data/temp01.dbf' size 1024M;

Tablespace created.

SQL> alter database default temporary tablespace temp01;

Database altered.

SQL> select node_name from fnd_nodes;

select node_name from fnd_nodes

                      *

ERROR at line 1:

ORA-00942: table or view does not exist

SQL>  select node_name from apps.fnd_nodes;

NODE_NAME

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

AUTHENTICATION

PRODCMAPP

PRODDB1

PRODDB2

6 rows selected.

SQL> exec fnd_conc_clone.setup_clean;

BEGIN fnd_conc_clone.setup_clean; END;

      *

ERROR at line 1:

ORA-06550: line 1, column 7:

PLS-00201: identifier 'FND_CONC_CLONE.SETUP_CLEAN' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

SQL> conn apps/appshris2010

Connected.

SQL> exec fnd_conc_clone.setup_clean;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL> select node_name from apps.fnd_nodes;

no rows selected

SQL>

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1077936128 bytes

Fixed Size                  2076584 bytes

Variable Size             427819096 bytes

Database Buffers          633339904 bytes

Redo Buffers               14700544 bytes

Database mounted.

Database opened.

SQL> exit

[devmgr@bedirisendiri ~]$ cd /u01/oracle/db/tech_st/10.2.0/appsutil/scripts/DEV_bedirisendiri

[devmgr@bedirisendiri DEV_bedirisendiri]$ ls

adautocfg.sh  addbctl.sh   adexecsql.pl  adpreclone.pl  adstrtdb.sql

adchknls.pl   addlnctl.sh  adlsnodes.sh  adstopdb.sql

[devmgr@bedirisendiri DEV_bedirisendiri]$ sh adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /u01/oracle/db/tech_st/10.2.0/appsutil/log/DEV_bedirisendiri/12210055/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

        Using ORACLE_HOME location : /u01/oracle/db/tech_st/10.2.0

        Classpath                   : :/u01/oracle/db/tech_st/10.2.0/jdbc/lib/ojdbc14.jar:/u01/oracle/db/tech_st/10.2.0/appsutil/java/xmlparserv2.jar:/u01/oracle/db/tech_st/10.2.0/appsutil/java:/u01/oracle/db/tech_st/10.2.0/jlib/netcfg.jar:/u01/oracle/db/tech_st/10.2.0/jlib/ldapjclnt10.jar

        Using Context file          : /u01/oracle/db/tech_st/10.2.0/appsutil/DEV_bedirisendiri.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 db102

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

[devmgr@bedirisendiri DEV_bedirisendiri]$

[devmgr@bedirisendiri DEV_bedirisendiri]$ ps -ef | grep pmon

devmgr     867     1  0 00:28 ?        00:00:00 asm_pmon_+ASM

devmgr    1803     1  0 00:53 ?        00:00:00 ora_pmon_DEV

devmgr    2768 16144  0 01:08 pts/3    00:00:00 grep pmon

[devmgr@bedirisendiri DEV_bedirisendiri]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Dec 21 01:09:18 2012

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> select status from v$instance;

STATUS

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

OPEN

SQL>

#### cloning database done ####

Clone Application

[devmgr@bedirisendiri ~]$ cd /u01/oracle/apps/apps_st/comn/clone/bin

[devmgr@bedirisendiri bin]$ perl adcfgclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.20.12000000.18

Enter the APPS password :

Running:

/u01/oracle/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/oracle/apps/apps_st/comn/clone/jlib/java:/u01/oracle/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /u01/oracle/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_11179.lst -stage /u01/oracle/apps/apps_st/comn/clone  2> /tmp/adcfgclone_11179.err; echo $? > /tmp/adcfgclone_11179.res

Log file located at /u01/oracle/apps/apps_st/comn/clone/bin/CloneContext_1221012836.log

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

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

Target System Database SID : DEV

Target System Database Server Node [bedirisendiri] : bedirisendiri.bedirisendiri.co.id

Target System Base Directory : /u01/oracle

Target System Tools ORACLE_HOME Directory [/u01/oracle/apps/tech_st/10.1.2] :

Target System Web ORACLE_HOME Directory [/u01/oracle/apps/tech_st/10.1.3] :

Target System APPL_TOP Directory [/u01/oracle/apps/apps_st/appl] :

Target System COMMON_TOP Directory [/u01/oracle/apps/apps_st/comn] :

Target System Instance Home Directory [/u01/oracle/inst] :

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] :

Do you want to preserve the Display [hqhcmapp:0.0] (y/n)  : n

Target System Display [bedirisendiri:0.0] :

RC-00217: Warning: Configuration home directory (s_config_home) evaluates to /u01/oracle/inst/apps/DEV_bedirisendiri. A directory with this name already exists and is not empty.

Do you want to continue (y/n)   : y

Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 20

Checking the port pool 20

done: Port Pool 20 is free

Report file located at /u01/oracle/inst/apps/DEV_bedirisendiri/temp/portpool.lst

Complete port information available at /u01/oracle/inst/apps/DEV_bedirisendiri/temp/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp

2. /usr/tmp

3. /u01/oracle/db/tech_st/10.2.0/appsutil/outbound/DEV_bedirisendiri

4. /usr/tmp

Choose a value which will be set as APPLPTMP value on the target node [1] : 1

Backing up /u01/oracle/inst/apps/DEV_bedirisendiri/appl/admin/DEV_bedirisendiri.xml to /u01/oracle/inst/apps/DEV_bedirisendiri/appl/admin/DEV_bedirisendiri.xml.bak

Creating the new APPL_TOP Context file from :

  /u01/oracle/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :

  /u01/oracle/inst/apps/DEV_bedirisendiri/appl/admin/DEV_bedirisendiri.xml

Log file located at /u01/oracle/apps/apps_st/comn/clone/bin/CloneContext_1221012836.log

Check Clone Context logfile /u01/oracle/apps/apps_st/comn/clone/bin/CloneContext_1221012836.log for details.

Running Rapid Clone with command:

perl /u01/oracle/apps/apps_st/comn/clone/bin/adclone.pl java=/u01/oracle/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/u01/oracle/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/oracle/inst/apps/DEV_bedirisendiri/appl/admin/DEV_bedirisendiri.xml showProgress contextValidated=true

Running:

perl /u01/oracle/apps/apps_st/comn/clone/bin/adclone.pl java=/u01/oracle/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/u01/oracle/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/oracle/inst/apps/DEV_bedirisendiri/appl/admin/DEV_bedirisendiri.xml showProgress contextValidated=true

APPS Password :

Beginning application tier Apply - Fri Dec 21 01:29:55 2012

/u01/oracle/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/u01/oracle/apps/apps_st/comn/clone/jlib/java:/u01/oracle/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/u01/oracle/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/u01/oracle/apps/apps_st/comn/clone/jlib/oui/share.jar:/u01/oracle/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/u01/oracle/apps/apps_st/comn/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyAppsTier -e /u01/oracle/inst/apps/DEV_bedirisendiri/appl/admin/DEV_bedirisendiri.xml -stage /u01/oracle/apps/apps_st/comn/clone    -showProgress

APPS Password : Log file located at /u01/oracle/inst/apps/DEV_bedirisendiri/admin/log/ApplyAppsTier_12210129.log

  |     73% completed

ERROR while running Apply...

Fri Dec 21 02:36:09 2012

 ERROR: Failed to execute /u01/oracle/apps/apps_st/comn/clone/bin/adclone.pl

 Please check logfile.

[devmgr@bedirisendiri bin]$ tail -f /u01/oracle/inst/apps/DEV_bedirisendiri/admin/log/12210951/adconfig.log

   Result                  : Successfully uploaded the Context information template file to the DataBase

###Solution Error

[devmgr@bedirisendiri ~]$ . ./APPS.env

[devmgr@bedirisendiri ~]$ cd $ADMIN_SCRIPTS_HOME

[devmgr@bedirisendiri scripts]$ ls

adalnctl.sh   adcmctl.sh     adformsrvctl.sh  adopmnctl.sh   adstrtal.sh  java.sh      mwactlwrpr.sh

adapcctl.sh   adexecsql.pl   adoacorectl.sh   adpreclone.pl  gsmstart.sh  jtffmctl.sh

adautocfg.sh  adformsctl.sh  adoafmctl.sh     adstpall.sh    ieo          mwactl.sh

[devmgr@bedirisendiri scripts]$ sh adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /u01/oracle/inst/apps/DEV_bedirisendiri/admin/log/12210951/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.

        Using CONFIG_HOME location     : /u01/oracle/inst/apps/DEV_bedirisendiri

        Classpath                   : /u01/oracle/apps/apps_st/comn/java/lib/appsborg2.zip:/u01/oracle/apps/apps_st/comn/java/classes

        Using Context file          : /u01/oracle/inst/apps/DEV_bedirisendiri/appl/admin/DEV_bedirisendiri.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

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

Configuring templates from all of the product tops...

        Configuring AD_TOP........COMPLETED

        Configuring FND_TOP.......COMPLETED

        Configuring ICX_TOP.......COMPLETED

        Configuring IEO_TOP.......COMPLETED

        Configuring BIS_TOP.......COMPLETED

        Configuring AMS_TOP.......COMPLETED

        Configuring CCT_TOP.......COMPLETED

        Configuring WSH_TOP.......COMPLETED

        Configuring CLN_TOP.......COMPLETED

        Configuring OKE_TOP.......COMPLETED

        Configuring OKL_TOP.......COMPLETED

        Configuring OKS_TOP.......COMPLETED

        Configuring CSF_TOP.......COMPLETED

        Configuring IGS_TOP.......COMPLETED

        Configuring IBY_TOP.......COMPLETED

        Configuring JTF_TOP.......COMPLETED

        Configuring MWA_TOP.......COMPLETED

        Configuring CN_TOP........COMPLETED

        Configuring CSI_TOP.......COMPLETED

        Configuring WIP_TOP.......COMPLETED

        Configuring CSE_TOP.......COMPLETED

        Configuring EAM_TOP.......COMPLETED

        Configuring FTE_TOP.......COMPLETED

        Configuring ONT_TOP.......COMPLETED

        Configuring AR_TOP........COMPLETED

        Configuring AHL_TOP.......COMPLETED

        Configuring OZF_TOP.......COMPLETED

        Configuring IES_TOP.......COMPLETED

        Configuring CSD_TOP.......COMPLETED

        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.

### edit enviroment customer

[devmgr@bedirisendiri scripts]$ cd $APPL_TOP

[devmgr@bedirisendiri appl]$ ls *.env

APPSDEV_bedirisendiri.env   APPSPRODprim_hqhcmapp.env    PROD_hqhcmapp1.env

APPSPROD_hqhcmapp1.env  customPRODprim_hqhcmapp.env  PROD_hqhcmapp.env

APPSPROD_hqhcmapp.env   DEV_bedirisendiri.env            PRODprim_hqhcmapp.env

[devmgr@bedirisendiri appl]$ vi customPRODprim_hqhcmapp.env

[devmgr@bedirisendiri appl]$ more customPRODprim_hqhcmapp.env

IDPAY_TOP="/u01/oracle/apps/apps_st/appl/idpay/12.0.0"        #### rubah path nya sesuai path dev

export IDPAY_TOP

[devmgr@bedirisendiri appl]$

[devmgr@bedirisendiri scripts]$ sh adstrtal.sh apps/appshris2010

You are running adstrtal.sh version 120.13.12000000.4

The logfile for this session is located at /u01/oracle/inst/apps/DEV_bedirisendiri/logs/appl/admin/log/adstrtal.log

Executing service control script:

/u01/oracle/inst/apps/DEV_bedirisendiri/admin/scripts/adopmnctl.sh start

script returned:

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

You are running adopmnctl.sh version 120.4.12000000.3

Starting Oracle Process Manager (OPMN) ...

opmnctl: opmn started.

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u01/oracle/inst/apps/DEV_bedirisendiri/logs/appl/admin/log/adopmnctl.txt for more information ...

.end std out.

.end err out.

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

Executing service control script:

/u01/oracle/inst/apps/DEV_bedirisendiri/admin/scripts/adalnctl.sh start

script returned:

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

adalnctl.sh version 120.3

Checking for FNDFS executable.

Starting listener process APPS_DEV.

adalnctl.sh: exiting with status 0

adalnctl.sh: check the logfile /u01/oracle/inst/apps/DEV_bedirisendiri/logs/appl/admin/log/adalnctl.txt for more information ...

.end std out.

.end err out.

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

Executing service control script:

/u01/oracle/inst/apps/DEV_bedirisendiri/admin/scripts/adapcctl.sh start

script returned:

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

You are running adapcctl.sh version 120.6.12000000.4

Starting OPMN managed Oracle HTTP Server (OHS) instance ...

opmnctl: opmn is already running.

opmnctl: starting opmn managed processes...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /u01/oracle/inst/apps/DEV_bedirisendiri/logs/appl/admin/log/adapcctl.txt for more information ...

.end std out.

.end err out.

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

Executing service control script:

/u01/oracle/inst/apps/DEV_bedirisendiri/admin/scripts/adoacorectl.sh start

script returned:

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

You are running adoacorectl.sh version 120.11.12000000.3

Starting OPMN managed OACORE OC4J instance  ...

adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /u01/oracle/inst/apps/DEV_bedirisendiri/logs/appl/admin/log/adoacorectl.txt for more information ...

.end std out.

.end err out.

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

Executing service control script:

/u01/oracle/inst/apps/DEV_bedirisendiri/admin/scripts/adformsctl.sh start

script returned:

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

You are running adformsctl.sh  version 120.12.12000000.6

Starting OPMN managed FORMS OC4J instance  ...

Calling txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is deployed...

Program : /u01/oracle/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl started @ Fri Dec 21 10:15:35 2012

*** Log File = /u01/oracle/inst/apps/DEV_bedirisendiri/logs/appl/rgf/TXK/txkChkFormsDeployment_Fri_Dec_21_10_15_35_2012/txkChkFormsDeployment_Fri_Dec_21_10_15_35_2012.log

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

*** Latest formsapp.ear has been deployed ***

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

Program : /u01/oracle/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Fri Dec 21 10:15:35 2012

Perl script txkChkFormsDeployment.pl got executed successfully

adformsctl.sh: exiting with status 0

adformsctl.sh: check the logfile /u01/oracle/inst/apps/DEV_bedirisendiri/logs/appl/admin/log/adformsctl.txt for more information ...

.end std out.

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /u01/oracle/inst/apps/DEV_bedirisendiri/logs/appl/rgf/TXK/txkChkFormsDeployment_Fri_Dec_21_10_15_35_2012/txkChkFormsDeployment_Fri_Dec_21_10_15_35_2012.log

.end err out.

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

Executing service control script:

/u01/oracle/inst/apps/DEV_bedirisendiri/admin/scripts/adoafmctl.sh start

script returned:

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

You are running adoafmctl.sh version 120.6.12000000.3

Starting OPMN managed OAFM OC4J instance  ...

adoafmctl.sh: exiting with status 0

adoafmctl.sh: check the logfile /u01/oracle/inst/apps/DEV_bedirisendiri/logs/appl/admin/log/adoafmctl.txt for more information ...

.end std out.

.end err out.

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

Executing service control script:

/u01/oracle/inst/apps/DEV_bedirisendiri/admin/scripts/adcmctl.sh start

script returned:

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

You are running adcmctl.sh version 120.14.12000000.4

Starting concurrent manager for DEV ...

Starting DEV_1221@DEV Internal Concurrent Manager

Default printer is noprint

adcmctl.sh: exiting with status 0

adcmctl.sh: check the logfile /u01/oracle/inst/apps/DEV_bedirisendiri/logs/appl/admin/log/adcmctl.txt for more information ...

.end std out.

.end err out.

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

Executing service control script:

/u01/oracle/inst/apps/DEV_bedirisendiri/admin/scripts/jtffmctl.sh start

script returned:

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

You are running jtffmctl.sh version 120.3

Validating Fulfillment patch level via /u01/oracle/apps/apps_st/comn/java/classes

Fulfillment patch level validated.

Starting Fulfillment Server for DEV on port 9320 ...

jtffmctl.sh: exiting with status 0

.end std out.

.end err out.

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

All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /u01/oracle/inst/apps/DEV_bedirisendiri/logs/appl/admin/log/adstrtal.log for more information ...

[devmgr@bedirisendiri scripts]$

### cek service

[devmgr@bedirisendiri scripts]$ sh adopmnctl.sh status

You are running adopmnctl.sh version 120.4.12000000.3

Checking status of OPMN managed processes...

Processes in Instance: DEV_bedirisendiri.bedirisendiri.bedirisendiri.co.id

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

ias-component      | process-type       |     pid | status

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

default_group      | oafm               |   31961 | Alive

default_group      | forms              |   31819 | Alive

default_group      | forms              |   31818 | Alive

default_group      | forms              |   31817 | Alive

default_group      | oacore             |   31660 | Alive

default_group      | oacore             |   31659 | Alive

default_group      | oacore             |   31661 | Alive

HTTP_Server        | HTTP_Server        |   31602 | Alive

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u01/oracle/inst/apps/DEV_bedirisendiri/logs/appl/admin/log/adopmnctl.txt for more information ...