SOLCONV CLONE FROM PROD Using Rman
=====================================
Source servers : PRD
DB Node : bpuqqrkd005.corp.equifax.com
APP 1 Node : bpuqqrrka003.corp.equifax.com
APP 2 Node : bpuqqrrka004.corp.equifax.com
External Node : bpuqqrrka006.corp.equifax.com
Target severs: SOLCONV
DB Node : bpuqqrkd007.corp.equifax.com
APP Node : bpuqqrkd007.corp.equifax.com
Backup Location :
Rman pieces backup loc : /bu1/PRD_BKP_010117(target node )
apps node backup loc :/bu/PRD_APPS_BKP
db binaries backup loc: /bu1/DB_HOME_BKP
Copying RMAN Pieces to Target Location:
++++++++++++++++++++++++++++++++++++++++
[oraprd@bpuqqrkd005 PRD]$ ls -ltr
total 2150632244
-rw-r----- 1 oraprd dba 34099683328 Feb 7 18:39 INC0_0207171830_df_PRD_35244_935346731
-rw-r----- 1 oraprd dba 30203305984 Feb 7 18:40 INC0_0207171830_df_PRD_35249_935346732
-rw-r----- 1 oraprd dba 44291514368 Feb 7 18:44 INC0_0207171830_df_PRD_35245_935346732
-rw-r----- 1 oraprd dba 43919450112 Feb 7 18:45 INC0_0207171830_df_PRD_35250_935346732
-rw-r----- 1 oraprd dba 42313187328 Feb 7 18:46 INC0_0207171830_df_PRD_35246_935346732
-rw-r----- 1 oraprd dba 39935221760 Feb 7 18:47 INC0_0207171830_df_PRD_35248_935346732
-rw-r----- 1 oraprd dba 49589854208 Feb 7 18:50 INC0_0207171830_df_PRD_35247_935346732
-rw-r----- 1 oraprd dba 42277822464 Feb 7 18:52 INC0_0207171830_df_PRD_35252_935347263
-rw-r----- 1 oraprd dba 31194161152 Feb 7 18:54 INC0_0207171830_df_PRD_35253_935347509
-rw-r----- 1 oraprd dba 44396756992 Feb 7 18:56 INC0_0207171830_df_PRD_35251_935347188
-rw-r----- 1 oraprd dba 42748739584 Feb 7 19:03 INC0_0207171830_df_PRD_35255_935347609
-rw-r----- 1 oraprd dba 28293537792 Feb 7 19:04 INC0_0207171830_df_PRD_35260_935348197
-rw-r----- 1 oraprd dba 46263992320 Feb 7 19:04 INC0_0207171830_df_PRD_35254_935347544
-rw-r----- 1 oraprd dba 48763125760 Feb 7 19:06 INC0_0207171830_df_PRD_35256_935347695
-rw-r----- 1 oraprd dba 44881518592 Feb 7 19:06 INC0_0207171830_df_PRD_35257_935347850
-rw-r----- 1 oraprd dba 33902477312 Feb 7 19:07 INC0_0207171830_df_PRD_35259_935348091
-rw-r----- 1 oraprd dba 40259395584 Feb 7 19:09 INC0_0207171830_df_PRD_35258_935347976
-rw-r----- 1 oraprd dba 32084336640 Feb 7 19:15 INC0_0207171830_df_PRD_35265_935348823
-rw-r----- 1 oraprd dba 35065200640 Feb 7 19:15 INC0_0207171830_df_PRD_35263_935348692
-rw-r----- 1 oraprd dba 39484260352 Feb 7 19:18 INC0_0207171830_df_PRD_35266_935348849
-rw-r----- 1 oraprd dba 45613465600 Feb 7 19:18 INC0_0207171830_df_PRD_35262_935348688
-rw-r----- 1 oraprd dba 48626982912 Feb 7 19:19 INC0_0207171830_df_PRD_35261_935348612
-rw-r----- 1 oraprd dba 3046858752 Feb 7 19:20 INC0_0207171830_df_PRD_35271_935349556
-rw-r----- 1 oraprd dba 47448113152 Feb 7 19:21 INC0_0207171830_df_PRD_35267_935348964
-rw-r----- 1 oraprd dba 43957215232 Feb 7 19:21 INC0_0207171830_df_PRD_35264_935348807
-rw-r----- 1 oraprd dba 39167156224 Feb 7 19:23 INC0_0207171830_df_PRD_35269_935349345
-rw-r----- 1 oraprd dba 35991216128 Feb 7 19:23 INC0_0207171830_df_PRD_35268_935349330
-rw-r----- 1 oraprd dba 39308689408 Feb 7 19:26 INC0_0207171830_df_PRD_35270_935349521
-rw-r----- 1 oraprd dba 34143584256 Feb 8 18:39 INC0_0208171830_df_PRD_35285_935433130
-rw-r----- 1 oraprd dba 30264131584 Feb 8 18:40 INC0_0208171830_df_PRD_35290_935433130
-rw-r----- 1 oraprd dba 44388696064 Feb 8 18:44 INC0_0208171830_df_PRD_35286_935433130
-rw-r----- 1 oraprd dba 43705876480 Feb 8 18:44 INC0_0208171830_df_PRD_35291_935433130
-rw-r----- 1 oraprd dba 39958159360 Feb 8 18:45 INC0_0208171830_df_PRD_35289_935433130
-rw-r----- 1 oraprd dba 42331013120 Feb 8 18:46 INC0_0208171830_df_PRD_35287_935433130
-rw-r----- 1 oraprd dba 49589854208 Feb 8 18:49 INC0_0208171830_df_PRD_35288_935433130
-rw-r----- 1 oraprd dba 42314915840 Feb 8 18:50 INC0_0208171830_df_PRD_35293_935433661
-rw-r----- 1 oraprd dba 30992736256 Feb 8 18:52 INC0_0208171830_df_PRD_35294_935433867
-rw-r----- 1 oraprd dba 44431360000 Feb 8 18:55 INC0_0208171830_df_PRD_35292_935433606
-rw-r----- 1 oraprd dba 48785104896 Feb 8 19:01 INC0_0208171830_df_PRD_35297_935433983
-rw-r----- 1 oraprd dba 42748739584 Feb 8 19:01 INC0_0208171830_df_PRD_35296_935433957
-rw-r----- 1 oraprd dba 46263992320 Feb 8 19:02 INC0_0208171830_df_PRD_35295_935433912
-rw-r----- 1 oraprd dba 27983716352 Feb 8 19:02 INC0_0208171830_df_PRD_35301_935434535
-rw-r----- 1 oraprd dba 33936580608 Feb 8 19:03 INC0_0208171830_df_PRD_35300_935434350
-rw-r----- 1 oraprd dba 44883247104 Feb 8 19:04 INC0_0208171830_df_PRD_35298_935434178
-rw-r----- 1 oraprd dba 40095506432 Feb 8 19:05 INC0_0208171830_df_PRD_35299_935434234
-rw-r----- 1 oraprd dba 32096165888 Feb 8 19:11 INC0_0208171830_df_PRD_35306_935435022
-rw-r----- 1 oraprd dba 35065356288 Feb 8 19:12 INC0_0208171830_df_PRD_35304_935434977
-rw-r----- 1 oraprd dba 39551287296 Feb 8 19:14 INC0_0208171830_df_PRD_35307_935435068
-rw-r----- 1 oraprd dba 45631602688 Feb 8 19:15 INC0_0208171830_df_PRD_35303_935434921
-rw-r----- 1 oraprd dba 3046858752 Feb 8 19:16 INC0_0208171830_df_PRD_35312_935435725
drwxr-xr-x 2 oraprd dba 61440 Feb 8 19:16 snapshot
-rw-r----- 1 oraprd dba 48626982912 Feb 8 19:16 INC0_0208171830_df_PRD_35302_935434921
-rw-r----- 1 oraprd dba 43961802752 Feb 8 19:16 INC0_0208171830_df_PRD_35305_935434977
-rw-r----- 1 oraprd dba 47448113152 Feb 8 19:18 INC0_0208171830_df_PRD_35308_935435173
-rw-r----- 1 oraprd dba 35991584768 Feb 8 19:20 INC0_0208171830_df_PRD_35309_935435508
-rw-r----- 1 oraprd dba 39184056320 Feb 8 19:20 INC0_0208171830_df_PRD_35310_935435574
-rw-r----- 1 oraprd dba 39451852800 Feb 8 19:20 INC0_0208171830_df_PRD_35311_935435679
drwxr-xr-x 2 oraprd dba 4096 Feb 8 19:23 log
drwxr-xr-x 2 oraprd dba 4096 Feb 8 19:24 archive
drwxr-xr-x 2 oraprd dba 4096 Feb 8 19:24 control
Generate Copy Script
+++++++++++++++++++++
find /bu1/backup/PRD -name '*0208171830*' -print | while read line; do echo "scp ${line} oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817"; done
[oraprd@bpuqqrkd005 DB_HOME_BKP]$ find /bu1/backup/PRD -name '*0208171830*' -print | while read line; do echo "scp ${line} oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817"; done
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33760_932149933 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33757_932149933 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33761_932150549 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33755_932149933 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33777_932152101 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33756_932149933 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33763_932150670 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/archive/INC0_0208171830_redo_PRD_932153125_33784 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/archive/INC0_0208171830_redo_PRD_932153180_33790 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/archive/INC0_0208171830_redo_PRD_932153125_33786 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/archive/INC0_0208171830_redo_PRD_932153125_33789 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/archive/INC0_0208171830_redo_PRD_932153125_33788 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/archive/INC0_0208171830_redo_PRD_932153125_33783 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/archive/INC0_0208171830_redo_PRD_932153125_33787 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/archive/INC0_0208171830_redo_PRD_932153125_33785 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33766_932150856 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33772_932151550 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33771_932151485 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33765_932150751 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33776_932152093 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33774_932151931 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33759_932149933 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/snapshot/snapcf_PRD_0208171830.ctl oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33769_932151163 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33780_932152488 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33773_932151566 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33779_932152193 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33767_932151072 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33762_932150595 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/control/PRD_0208171830_cf_c-1907593454-20170101-02 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/control/PRD_0208171830_cf_c-1907593454-20170101-01 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33754_932149933 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33778_932152137 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33764_932150716 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33768_932151128 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33770_932151359 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/log/backup_database.sh.PRD.0208171830.report oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/log/backup_database.sh.PRD.0208171830.log oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33775_932152067 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
scp /bu1/backup/PRD/INC0_0208171830_df_PRD_33758_932149933 oraproj3@aord1rkd003.corp.equifax.com:/bu1/PRD_BKP_020817
[oraprd@bpuqqrkd005 DB_HOME_BKP]$
[oraprd@bpuqqrkd005 SOLCONV]$ cat file_copy.lst|wc -l
40
[oraprd@bpuqqrkd005 SOLCONV]$ split -6 file_copy.lst
[oraprd@bpuqqrkd005 SOLCONV]$ pwd
/tmp/SOLCONV
[oraprd@bpuqqrkd005 SOLCONV]$ ls -lrt
total 36
-rw-r--r-- 1 oraprd dba 4709 Jan 1 20:40 file_copy.lst
-rw-r--r-- 1 oraprd dba 469 Jan 1 20:41 xag
-rw-r--r-- 1 oraprd dba 702 Jan 1 20:41 xaf
-rw-r--r-- 1 oraprd dba 702 Jan 1 20:41 xae
-rw-r--r-- 1 oraprd dba 686 Jan 1 20:41 xad
-rw-r--r-- 1 oraprd dba 720 Jan 1 20:41 xac
-rw-r--r-- 1 oraprd dba 740 Jan 1 20:41 xab
-rw-r--r-- 1 oraprd dba 690 Jan 1 20:41 xaa
[oraprd@bpuqqrkd005 SOLCONV]$ chmod u+x xa*
[oraprd@bpuqqrkd005 SOLCONV]$ ls -lrt
total 36
-rw-r--r-- 1 oraprd dba 4709 Jan 1 20:40 file_copy.lst
-rwxr--r-- 1 oraprd dba 469 Jan 1 20:41 xag
-rwxr--r-- 1 oraprd dba 702 Jan 1 20:41 xaf
-rwxr--r-- 1 oraprd dba 702 Jan 1 20:41 xae
-rwxr--r-- 1 oraprd dba 686 Jan 1 20:41 xad
-rwxr--r-- 1 oraprd dba 720 Jan 1 20:41 xac
-rwxr--r-- 1 oraprd dba 740 Jan 1 20:41 xab
-rwxr--r-- 1 oraprd dba 690 Jan 1 20:41 xaa
[oraprd@bpuqqrkd005 SOLCONV]$ vi file_copy.sh
[oraprd@bpuqqrkd005 SOLCONV]$ cat file_copy.sh
/tmp/SOLCONV/xaa 1>/tmp/SOLCONV/xaa.log 2>/tmp/SOLCONV/xaa.err &
/tmp/SOLCONV/xab 1>/tmp/SOLCONV/xab.log 2>/tmp/SOLCONV/xab.err &
/tmp/SOLCONV/xac 1>/tmp/SOLCONV/xac.log 2>/tmp/SOLCONV/xac.err &
/tmp/SOLCONV/xad 1>/tmp/SOLCONV/xad.log 2>/tmp/SOLCONV/xad.err &
/tmp/SOLCONV/xae 1>/tmp/SOLCONV/xae.log 2>/tmp/SOLCONV/xae.err &
/tmp/SOLCONV/xaf 1>/tmp/SOLCONV/xaf.log 2>/tmp/SOLCONV/xaf.err &
/tmp/SOLCONV/xag 1>/tmp/SOLCONV/xag.log 2>/tmp/SOLCONV/xag.err &
wait
mailx -s "File Copy Complete" muralidharan.m@equifax.com <<EOF
File Copy Complete
EOF
[oraprd@bpuqqrkd005 SOLCONV]$ chmod 755 file_copy.sh
[oraprd@bpuqqrkd005 SOLCONV]$ ls -lrt
total 40
-rw-r--r-- 1 oraprd dba 4709 Jan 1 20:56 file_copy.lst
-rwxr--r-- 1 oraprd dba 469 Jan 1 20:57 xag
-rwxr--r-- 1 oraprd dba 702 Jan 1 20:57 xaf
-rwxr--r-- 1 oraprd dba 702 Jan 1 20:57 xae
-rwxr--r-- 1 oraprd dba 686 Jan 1 20:57 xad
-rwxr--r-- 1 oraprd dba 720 Jan 1 20:57 xac
-rwxr--r-- 1 oraprd dba 740 Jan 1 20:57 xab
-rwxr--r-- 1 oraprd dba 690 Jan 1 20:57 xaa
-rwxr-xr-x 1 oraprd dba 461 Jan 1 20:57 file_copy.sh
[oraprd@bpuqqrkd005 SOLCONV]$ cat file_copy.sh
/tmp/SOLCONV/xaa 1>/tmp/SOLCONV/xaa.log 2>/tmp/SOLCONV/xaa.err &
/tmp/SOLCONV/xab 1>/tmp/SOLCONV/xab.log 2>/tmp/SOLCONV/xab.err &
/tmp/SOLCONV/xac 1>/tmp/SOLCONV/xac.log 2>/tmp/SOLCONV/xac.err &
/tmp/SOLCONV/xad 1>/tmp/SOLCONV/xad.log 2>/tmp/SOLCONV/xad.err &
/tmp/SOLCONV/xae 1>/tmp/SOLCONV/xae.log 2>/tmp/SOLCONV/xae.err &
/tmp/SOLCONV/xaf 1>/tmp/SOLCONV/xaf.log 2>/tmp/SOLCONV/xaf.err &
/tmp/SOLCONV/xag 1>/tmp/SOLCONV/xag.log 2>/tmp/SOLCONV/xag.err &
wait
mailx -s "File Copy Complete" gcpappsdbas@equifax.com <<EOF
File Copy Complete
EOF
[oraprd@bpuqqrkd005 SOLCONV]$ chmod 755 file_copy.sh
[oraprd@bpuqqrkd005 SOLCONV]$ vi file_copy.lst
[oraprd@bpuqqrkd005 SOLCONV]$ cat file_copy.lst|wc -l
40
[oraprd@bpuqqrkd005 SOLCONV]$ split -6 file_copy.lst
[oraprd@bpuqqrkd005 SOLCONV]$ ls -lrt
total 36
-rw-r--r-- 1 oraprd dba 4789 Jan 1 22:48 file_copy.lst
-rw-r--r-- 1 oraprd dba 477 Jan 1 22:48 xag
-rw-r--r-- 1 oraprd dba 714 Jan 1 22:48 xaf
-rw-r--r-- 1 oraprd dba 714 Jan 1 22:48 xae
-rw-r--r-- 1 oraprd dba 698 Jan 1 22:48 xad
-rw-r--r-- 1 oraprd dba 732 Jan 1 22:48 xac
-rw-r--r-- 1 oraprd dba 752 Jan 1 22:48 xab
-rw-r--r-- 1 oraprd dba 702 Jan 1 22:48 xaa
[oraprd@bpuqqrkd005 SOLCONV]$ chmod u+x xa*
[oraprd@bpuqqrkd005 SOLCONV]$ cat file_copy.sh
cat: file_copy.sh: No such file or directory
[oraprd@bpuqqrkd005 SOLCONV]$ vi file_copy.sh
[oraprd@bpuqqrkd005 SOLCONV]$ cat file_copy.sh
/tmp/SOLCONV/xaa 1>/tmp/SOLCONV/xaa.log 2>/tmp/SOLCONV/xaa.err &
/tmp/SOLCONV/xab 1>/tmp/SOLCONV/xab.log 2>/tmp/SOLCONV/xab.err &
/tmp/SOLCONV/xac 1>/tmp/SOLCONV/xac.log 2>/tmp/SOLCONV/xac.err &
/tmp/SOLCONV/xad 1>/tmp/SOLCONV/xad.log 2>/tmp/SOLCONV/xad.err &
/tmp/SOLCONV/xae 1>/tmp/SOLCONV/xae.log 2>/tmp/SOLCONV/xae.err &
/tmp/SOLCONV/xaf 1>/tmp/SOLCONV/xaf.log 2>/tmp/SOLCONV/xaf.err &
/tmp/SOLCONV/xag 1>/tmp/SOLCONV/xag.log 2>/tmp/SOLCONV/xag.err &
wait
mailx -s "File Copy Complete" gcpappsdbas@equifax.com <<EOF
File Copy Complete
EOF
[oraprd@bpuqqrkd005 SOLCONV]$ chmod 755 file_copy.sh
[oraprd@bpuqqrkd005 SOLCONV]$ nohup ./file_copy.sh 1>file_copy.sh.log 2>file_copy.sh.err &
[1] 7526
[oraprd@bpuqqrkd005 SOLCONV]$ ps -ef|grep 7526
oraprd 7526 8295 0 22:50 pts/5 00:00:00 /bin/sh ./file_copy.sh
oraprd 7527 7526 0 22:50 pts/5 00:00:00 /bin/sh ./file_copy.sh
oraprd 7528 7526 0 22:50 pts/5 00:00:00 /bin/sh ./file_copy.sh
oraprd 7529 7526 0 22:50 pts/5 00:00:00 /bin/sh ./file_copy.sh
oraprd 7530 7526 0 22:50 pts/5 00:00:00 /bin/sh ./file_copy.sh
oraprd 7532 7526 0 22:50 pts/5 00:00:00 /bin/sh ./file_copy.sh
oraprd 7534 7526 0 22:50 pts/5 00:00:00 /bin/sh ./file_copy.sh
oraprd 7537 7526 0 22:50 pts/5 00:00:00 /bin/sh ./file_copy.sh
oraprd 7583 8295 0 22:50 pts/5 00:00:00 grep 7526
[oraprd@bpuqqrkd005 SOLCONV]$
DB bineries copy: Run adpreclone before copying
++++++++++++++++++++++++++++++++++++++
[oraprd@bpuqqrkd005 SOLCONV]$ cd /bu1/backup/DB_HOME_BKP
[oraprd@bpuqqrkd005 DB_HOME_BKP]$ ls -lrt
total 4457724
-rw-r--r-- 1 oraprd dba 4564702728 Dec 31 17:31 prddb123116.tar.gz
[oraprd@bpuqqrkd005 DB_HOME_BKP]$ scp -rp prddb123116.tar.gz sxn145@aord1rkd003.corp.equifax.com:/bu1/DB_HOME_BKP/
sxn145@aord1rkd003.corp.equifax.com's password:
prddb123116.tar.gz 100% 4353MB 6.5MB/s 11:06
[oraprd@bpuqqrkd005 DB_HOME_BKP]$
APPS binaries copy : Run adpreclone before copying
+++++++++++++++++++++++++++++++++++++++++
/bu/APPL_BKP
You have new mail in /var/spool/mail/applprd
-bash-3.2$ scp /bu/APPL_BKP/prdapps123116.tar.gz sxn145@bpuqqrka001.corp.equifax.com:/bu/PRD_APPS_BKP
sxn145@bpuqqrka001.corp.equifax.com's password:
copy part is completed as of now.....
---------------------------------------------------------------------------------------------------------------------------
Fetch the datafile information from Target server
+++++++++++++++++++++++++++++++++++++++++++++++++
SQL> select name from V$database;
NAME
---------
SOLCONV
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
/tdxdbd4/SOLCONV/data/system03.dbf
/tdxdbd4/SOLCONV/data/system09.dbf
/tdxdbd4/SOLCONV/data/system08.dbf
/tdxdbd4/SOLCONV/data/system11.dbf
/tdxdbd4/SOLCONV/data/system07.dbf
/tdxdbd4/SOLCONV/data/system06.dbf
/tdxdbd4/SOLCONV/data/system10.dbf
/tdxdbd4/SOLCONV/data/system01.dbf
/tdxdbd4/SOLCONV/data/system02.dbf
/tdxdbd4/SOLCONV/data/system05.dbf
/tdxdbd4/SOLCONV/data/system04.dbf
FILE_NAME
--------------------------------------------------------------------------------
/tdxdbd4/SOLCONV/data/sysaux_01.dbf
/tdxdbd4/SOLCONV/data/sysaux_02.dbf
/tdxdbd4/SOLCONV/data/undo01.dbf
/tdxdbd4/SOLCONV/data/undo02.dbf
/tdxdbd4/SOLCONV/data/undo03.dbf
/tdxdbd4/SOLCONV/data/undo04.dbf
/tdxdbd4/SOLCONV/data/undo05.dbf
/tdxdbd4/SOLCONV/data/a_archive04.dbf
/tdxdbd4/SOLCONV/data/a_txn_ind14.dbf
/tdxdbd4/SOLCONV/data/a_txn_ind06.dbf
/tdxdbd4/SOLCONV/data/a_archive01.dbf
.....
.....
.....
.....
.....
FILE_NAME
--------------------------------------------------------------------------------
/tdxdbd4/SOLCONV/data/xxaudit_01.dbf
/tdxdbd4/SOLCONV/data/efx_index_20.dbf
/tdxdbd4/SOLCONV/data/a_media38.dbf
/tdxdbd4/SOLCONV/data/xxa_txn_data05.dbf
/tdxdbd4/SOLCONV/data/PRD_biplatform.dbf
/tdxdbd4/SOLCONV/data/PRD_mds.dbf
/tdxdbd4/SOLCONV/data/obieep01.dbf
/tdxdbd4/SOLCONV/data/a_txn_data42.dbf
/tdxdbd4/SOLCONV/data/sysaux_03.dbf
/tdxdbd4/SOLCONV/data/a_txn_ind27.dbf
/tdxdbd4/SOLCONV/data/a_txn_data43.dbf
220 rows selected.
Bring down application, database and listener of target instance
+++++++++++++++++++++++++++++++++++++++++++++++++
[appltdx4@bpuqqrkd007 ~]$ . APPSSOLCONV_bpuqqrkd007.env
[appltdx4@bpuqqrkd007 ~]$ cd $ADMIN_SCRIPTS_HOME
[appltdx4@bpuqqrkd007 scripts]$ pwd
/tdxap4/SOLCONV/inst/apps/SOLCONV_bpuqqrkd007/admin/scripts
[appltdx4@bpuqqrkd007 scripts] sh adstpall.sh apps/appssolconv
[appltdx4@bpuqqrkd007 scripts]$ ps -ux | grep SOLCONV
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.7/FAQ
appltdx4 12183 0.0 0.0 61220 764 pts/7 S+ 01:58 0:00 grep SOLCONV
You have new mail in /var/spool/mail/appltdx4
[oratdx4@bpuqqrkd007 ~]$ . SOLCONV_bpuqqrkd007.env
[oratdx4@bpuqqrkd007 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 1 01:56:49 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name from v$database;
NAME
---------
SOLCONV
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
[oratdx4@bpuqqrkd007 ~]$ lsnrctl stop SOLCONV
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 01-FEB-2017 01:57:57
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bpuqqrkd007.corp.equifax.com)(PORT=1548)))
The command completed successfully
Backup Database Important Files
++++++++++++++++++++++++++++++++
[oratdx4@bpuqqrkd007 ~]$ mkdir CLONE_SAVE
[oratdx4@bpuqqrkd007 ~]$ cd CLONE_SAVE
[oratdx4@bpuqqrkd007 CLONE_SAVE]$ ls -ltr
total 0
[oratdx4@bpuqqrkd007 CLONE_SAVE]$ cp $ORACLE_HOME/*.env .
[oratdx4@bpuqqrkd007 CLONE_SAVE]$ cp $ORACLE_HOME/appsutil/*.xml .
[oratdx4@bpuqqrkd007 CLONE_SAVE]$ cp $ORACLE_HOME/dbs/*.ora .
[oratdx4@bpuqqrkd007 CLONE_SAVE]$ cp $TNS_ADMIN/*.ora .
[oratdx4@bpuqqrkd007 CLONE_SAVE]$ cp $ORACLE_HOME/sysman/lib/env_emagent.mk .
[oratdx4@bpuqqrkd007 CLONE_SAVE]$ cp $ORACLE_HOME/appsutil/install/adlnkoh.sh .
[oratdx4@bpuqqrkd007 CLONE_SAVE]$ ls -ltr
total 672
-rw-r--r-- 1 oratdx4 appid 4246 Feb 1 02:00 PRD_bpuqqrkd005.env
-rw-r--r-- 1 oratdx4 appid 4085 Feb 1 02:00 SOLCONV_bpuqqrkd007.env
-rw-r--r-- 1 oratdx4 appid 14004 Feb 1 02:00 PRD_bpuqqrkd005.xml
-rw-r--r-- 1 oratdx4 appid 13343 Feb 1 02:00 SOLCONV_bpuqqrkd007.xml
-rw-r--r-- 1 oratdx4 appid 2851 Feb 1 02:00 init.ora
-rw-r--r-- 1 oratdx4 appid 3481 Feb 1 02:00 initPRD_event.ora
-rw-r--r-- 1 oratdx4 appid 3461 Feb 1 02:00 initPRD_noaq.ora
-rw-r--r-- 1 oratdx4 appid 3415 Feb 1 02:00 initPRD.ora
-rw-r--r-- 1 oratdx4 appid 2517 Feb 1 02:00 initSOLCONV.ora
-rw-r--r-- 1 oratdx4 appid 2563 Feb 1 02:00 initSOLCONV_noaq.ora
-rw-r--r-- 1 oratdx4 appid 0 Feb 1 02:00 SOLCONV_bpuqqrkd007_ifile.ora
-rw-r--r-- 1 oratdx4 appid 0 Feb 1 02:00 PRD_bpuqqrkd005_ifile.ora
-rw-r----- 1 oratdx4 appid 8704 Feb 1 02:00 spfilePRD.ora
-rw-r--r-- 1 oratdx4 appid 2 Feb 1 02:00 listener_ifile.ora
-rw-r--r-- 1 oratdx4 appid 1454 Feb 1 02:00 listener.ora
-rw-r--r-- 1 oratdx4 appid 2 Feb 1 02:00 sqlnet_ifile.ora
-rw-r--r-- 1 oratdx4 appid 843 Feb 1 02:00 sqlnet.ora
-rw-r--r-- 1 oratdx4 appid 2045 Feb 1 02:00 tnsnames.ora
-rw-r----- 1 oratdx4 appid 114866 Feb 1 02:01 env_emagent.mk
-rwx------ 1 oratdx4 appid 31212 Feb 1 02:01 adlnkoh.sh
[oratdx4@bpuqqrkd007 CLONE_SAVE]$ ls -ltr | wc -l
21
Backup APPS server Important Files:
++++++++++++++++++++++++++++++++++++
[appltdx4@bpuqqrkd007 ~]$ mkdir CLONE_SAVE
[appltdx4@bpuqqrkd007 ~]$ cd CLONE_SAVE/
[appltdx4@bpuqqrkd007 CLONE_SAVE]$ pwd
/export/home/appltdx4/CLONE_SAVE
[appltdx4@bpuqqrkd007 CLONE_SAVE]$ cp $APPL_TOP/*.env .
[appltdx4@bpuqqrkd007 CLONE_SAVE]$ cp $CONTEXT_FILE .
[appltdx4@bpuqqrkd007 CLONE_SAVE]$ cp $APPL_TOP/admin/adovars.env .
[appltdx4@bpuqqrkd007 CLONE_SAVE]$ ls -ltr
total 384
-rw-r--r-- 1 appltdx4 appid 1072 Feb 1 02:02 APPSPRD_bpuqqrrka003.env
-rw-r--r-- 1 appltdx4 appid 1072 Feb 1 02:02 APPSPRD_bpuqqrrka004.env
-rw-r--r-- 1 appltdx4 appid 1093 Feb 1 02:02 APPSSOLCONV_bpuqqrkd007.env
-rw-r--r-- 1 appltdx4 appid 580 Feb 1 02:02 customPRD_bpuqqrrka003.env
-rw-r--r-- 1 appltdx4 appid 580 Feb 1 02:02 customPRD_bpuqqrrka004.env
-rw-r--r-- 1 appltdx4 appid 16331 Feb 1 02:02 PRD_bpuqqrrka003.env
-rw-r--r-- 1 appltdx4 appid 16331 Feb 1 02:02 PRD_bpuqqrrka004.env
-rw-r--r-- 1 appltdx4 appid 16560 Feb 1 02:02 SOLCONV_bpuqqrkd007.env
-rw-r--r-- 1 appltdx4 appid 97702 Feb 1 02:03 SOLCONV_bpuqqrkd007.xml
-rw-r--r-- 1 appltdx4 appid 11818 Feb 1 02:03 adovars.env
[appltdx4@bpuqqrkd007 CLONE_SAVE]$ ls -ltr | wc -l
11
Drop Target database
+++++++++++++++++++++
[oratdx4@bpuqqrkd007 CLONE_SAVE]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 1 02:04:04 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount restrict;
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2235208 bytes
Variable Size 687867064 bytes
Database Buffers 3573547008 bytes
Redo Buffers 12132352 bytes
Database mounted.
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
SOLCONV MOUNTED
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
untar db binaries
++++++++++++++++++
[oratdx4@bpuqqrkd007 SOLCONV]$ pwd
/tdxdbb4/SOLCONV
[oratdx4@bpuqqrkd007 SOLCONV]$ mv db_1 db_1_bkp1Feb17
[oratdx4@bpuqqrkd007 SOLCONV]$ mkdir db_1
[oratdx4@bpuqqrkd007 DB_HOME_bkp]$ cd /tdxdbb4/SOLCONV/db_1
[oratdx4@bpuqqrkd007 db_1]$ ls -ltr
total 0
[oratdx4@bpuqqrkd007 db_1]$ nohup tar -xvzf /backup1/DB_HOME_bkp/prddb012817.tar.gz &
[1] 5198
[oratdx4@bpuqqrkd007 db_1]$ nohup: appending output to `nohup.out'
oratdx4 15287 8153 0 02:17 pts/8 00:00:00 grep 5198
[1]+ Done nohup tar -xvzf /backup1/DB_HOME_bkp/prddb012817.tar.gz
[oratdx4@bpuqqrkd007 db_1]$
restore initSOLCONV.ora from backup folder
+++++++++++++++++++++++++++++++++++++++
[oratdx4@bpuqqrkd007 dbs]$ pwd
/tdxdbb4/SOLCONV/db_1/dbs
[oratdx4@bpuqqrkd007 dbs]$ cp -Rf /export/home/oratdx4/CLONE_SAVE/initSOLCONV.ora .
[oratdx4@bpuqqrkd007 dbs]$ pwd
/tdxdbb4/SOLCONV/db_1/dbs
[oratdx4@bpuqqrkd007 dbs]$ ls -ltr initSOLCONV.ora
-rw-r--r-- 1 oratdx4 appid 2517 Feb 1 02:32 initSOLCONV.ora
[oratdx4@bpuqqrkd007 dbs]$ grep control* initSOLCONV.ora
*.control_files='/tdxdbd4/SOLCONV/data/cntrl01.dbf','/tdxdbd4/SOLCONV/data/cntrl02.dbf','/tdxdbd4/SOLCONV/data/cntrl03.dbf'
[oratdx4@bpuqqrkd007 dbs]$ grep db_name initSOLCONV.ora
*.db_name='SOLCONV'
[oratdx4@bpuqqrkd007 dbs]$ vi initSOLCONV.ora
[oratdx4@bpuqqrkd007 dbs]$ grep db_name initSOLCONV.ora
*.db_name='PRD'
If local_listener is available, comment the same.
Rman Restore
+++++++++++++
Adjusting space
Primary mount point
Location : /tdxdbd4/SOLCONV/data
[oratdx4@bpuqqrkd007 data]$ df -h .
Filesystem Size Used Avail Use% Mounted on
/SOLCONV/mapper/tdxvg-tdxdbd4
1.3T 198M 1.3T 1% /tdxdbd4
Secondary mount point
Location : /SOLCONVdata/solconv/data
[oratdx4@bpuqqrkd007 data]$ df -h .
Filesystem Size Used Avail Use% Mounted on
/SOLCONV/mapper/SOLCONVdata-SOLCONVdata
1.6T 1.3T 251G 84% /SOLCONVdata
[oratdx4@bpuqqrkd007 ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Feb 1 03:45:05 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> STARTUP NOMOUNT;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 02/01/2017 03:45:13
RMAN-04014: startup failed: ORA-48108: invalid value given for the diagnostic_dest init.ora parameter
ORA-48140: the specified ADR Base directory does not exist [/tdxdbb4/SOLCONV/db_1/admin/SOLCONV_bpuqqrkd007]
ORA-48187: specified directory does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> exit
Recovery Manager complete.
[oratdx4@bpuqqrkd007 ~]$ cd /tdxdbb4/SOLCONV/db_1/admin/SOLCONV_bpuqqrkd007
-bash: cd: /tdxdbb4/SOLCONV/db_1/admin/SOLCONV_bpuqqrkd007: No such file or directory
[oratdx4@bpuqqrkd007 ~]$ mkdir /tdxdbb4/SOLCONV/db_1/admin/SOLCONV_bpuqqrkd007
[oratdx4@bpuqqrkd007 ~]$ cd /tdxdbb4/SOLCONV/db_1/admin/SOLCONV_bpuqqrkd007
[oratdx4@bpuqqrkd007 SOLCONV_bpuqqrkd007]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Feb 1 03:45:39 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> STARTUP NOMOUNT;
Oracle instance started
Total System Global Area 4275781632 bytes
Fixed Size 2235208 bytes
Variable Size 687867064 bytes
Database Buffers 3573547008 bytes
Redo Buffers 12132352 bytes
RMAN> RESTORE CONTROLFILE FROM '/backup1/PRD_BKP/PRD_0131171830_cf_c-1907593454-20170131-02';
Starting restore at 01-FEB-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1345 SOLCONVice type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/tdxdbd4/SOLCONV/data/cntrl01.dbf
output file name=/tdxdbd4/SOLCONV/data/cntrl02.dbf
output file name=/tdxdbd4/SOLCONV/data/cntrl03.dbf
Finished restore at 01-FEB-17
RMAN> Alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> catalog start with '/backup1/PRD_BKP';
searching for all files that match the pattern /backup1/PRD_BKP
List of Files Unknown to the Database
=====================================
File Name: /backup1/PRD_BKP/PRD_0131171830_cf_c-1907593454-20170131-01
File Name: /backup1/PRD_BKP/snapcf_PRD_0131171830.ctl
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745266_34992
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34958_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34989
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34978_934744169
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34990
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34959_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34973_934743862
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34985
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34982_934744791
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34988
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34976_934743988
File Name: /backup1/PRD_BKP/PRD_0131171830_cf_c-1907593454-20170131-02
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34965_934742789
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34956_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34962_934742392
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34969_934743160
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34967_934742909
File Name: /backup1/PRD_BKP/backup_database.sh.PRD.0131171830.report
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34966_934742824
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34971_934743461
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34961_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34974_934743918
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34970_934743265
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34979_934744465
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34955_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34964_934742723
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34987
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34975_934743933
File Name: /backup1/PRD_BKP/backup_database.sh.PRD.0131171830.log
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34968_934743115
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34957_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34963_934742427
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34972_934743806
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34991
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34960_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34986
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34981_934744746
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34980_934744590
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34977_934744114
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /backup1/PRD_BKP/PRD_0131171830_cf_c-1907593454-20170131-01
File Name: /backup1/PRD_BKP/snapcf_PRD_0131171830.ctl
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745266_34992
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34958_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34989
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34978_934744169
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34990
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34959_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34973_934743862
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34985
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34982_934744791
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34988
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34976_934743988
File Name: /backup1/PRD_BKP/PRD_0131171830_cf_c-1907593454-20170131-02
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34965_934742789
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34956_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34962_934742392
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34969_934743160
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34967_934742909
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34966_934742824
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34971_934743461
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34961_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34974_934743918
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34970_934743265
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34979_934744465
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34955_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34964_934742723
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34987
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34975_934743933
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34968_934743115
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34957_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34963_934742427
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34972_934743806
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34991
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34960_934741926
File Name: /backup1/PRD_BKP/INC0_0131171830_redo_PRD_934745211_34986
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34981_934744746
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34980_934744590
File Name: /backup1/PRD_BKP/INC0_0131171830_df_PRD_34977_934744114
List of Files Which Where Not Cataloged
=======================================
File Name: /backup1/PRD_BKP/backup_database.sh.PRD.0131171830.report
RMAN-07517: Reason: The file header is corrupted
File Name: /backup1/PRD_BKP/backup_database.sh.PRD.0131171830.log
RMAN-07517: Reason: The file header is corrupted
[mxm510@bpuqqrkd007 ~]$ screen -S restore
[mxm510@bpuqqrkd007 ~]$ sudo su - oratdx4
[oratdx4@bpuqqrkd007 ~]$ ls -ltr *.env
-rw-r--r-- 1 oratdx4 appid 4085 Jun 18 2015 SOLCONV_bpuqqrkd007.env
-rw-r--r-- 1 oratdx4 appid 4188 Jul 4 2015 SOLSOLCONV_bpuqqrkd007.env
[oratdx4@bpuqqrkd007 ~]$ . SOLCONV_bpuqqrkd007.env
run
{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
allocate channel c5 device type disk;
allocate channel c6 device type disk;
allocate channel c7 device type disk;
allocate channel c8 device type disk;
set newname for database to '/r12devd/DEV/data/%b';
restore database;
switch datafile all;
recover database;
}
{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
allocate channel c5 device type disk;
allocate channel c6 device type disk;
allocate channel c7 device type disk;
allocate channel c8 device type disk;
set newname for database to '/r12devd/DEV/data/%b';
restore database;
switch datafile all;
recover database;
}
....
....
....
....
released channel: c1
released channel: c2
released channel: c3
released channel: c4
released channel: c5
released channel: c6
released channel: c7
released channel: c8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/01/2017 04:35:27
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 145459 and starting SCN of 13067011972709
run
{
set until logseq=145459 thread=1;
recover database;
}
RMAN> run
{
set until logseq=145459 thread=1;
recover database;
}2> 3> 4> 5>
executing command: SET until clause
Starting recover at 01-FEB-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1345 SOLCONVice type=DISK
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 01-FEB-17
[oratdx4@bpuqqrkd007 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 1 04:43:35 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> col member for a50
SQL> set pagesize 200
SQL> set linesize 200
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
1 ONLINE /prddbd/PRD/data/log1a.dbf NO
1 ONLINE /prddbd/PRD/data/log1b.dbf NO
2 ONLINE /prddbd/PRD/data/log2a.dbf NO
2 ONLINE /prddbd/PRD/data/log2b.dbf NO
3 ONLINE /prddbd/PRD/data/log3a.dbf NO
3 ONLINE /prddbd/PRD/data/log3b.dbf NO
4 ONLINE /prddbd/PRD/data/log4a.dbf NO
4 ONLINE /prddbd/PRD/data/log4b.dbf NO
5 ONLINE /prddbd/PRD/data/log5a.dbf NO
5 ONLINE /prddbd/PRD/data/log5b.dbf NO
10 STANDBY /prddbd/PRD/data/log10a.dbf NO
10 STANDBY /prddbd/PRD/data/log10b.dbf NO
11 STANDBY /prddbd/PRD/data/log11a.dbf NO
11 STANDBY /prddbd/PRD/data/log11b.dbf NO
12 STANDBY /prddbd/PRD/data/log12a.dbf NO
12 STANDBY /prddbd/PRD/data/log12b.dbf NO
13 STANDBY /prddbd/PRD/data/log13a.dbf NO
13 STANDBY /prddbd/PRD/data/log13b.dbf NO
14 STANDBY /prddbd/PRD/data/log14a.dbf NO
14 STANDBY /prddbd/PRD/data/log14b.dbf NO
15 STANDBY /prddbd/PRD/data/log15a.dbf NO
15 STANDBY /prddbd/PRD/data/log15b.dbf NO
22 rows selected.
SQL> alter database rename file '/prddbd/PRD/data/log1a.dbf' to '/tdxdbd4/SOLCONV/data/log1a.dbf';
alter database rename file '/prddbd/PRD/data/log1b.dbf' to '/tdxdbd4/SOLCONV/data/log1b.dbf';
alter database rename file '/prddbd/PRD/data/log2a.dbf' to '/tdxdbd4/SOLCONV/data/log2a.dbf';
alter database rename file '/prddbd/PRD/data/log2b.dbf' to '/tdxdbd4/SOLCONV/data/log2b.dbf';
alter database rename file '/prddbd/PRD/data/log3a.dbf' to '/tdxdbd4/SOLCONV/data/log3a.dbf';
alter database rename file '/prddbd/PRD/data/log3b.dbf' to '/tdxdbd4/SOLCONV/data/log3b.dbf';
alter database rename file '/prddbd/PRD/data/log4a.dbf' to '/tdxdbd4/SOLCONV/data/log4a.dbf';
alter database rename file '/prddbd/PRD/data/log4b.dbf' to '/tdxdbd4/SOLCONV/data/log4b.dbf';
alter database rename file '/prddbd/PRD/data/log5a.dbf' to '/tdxdbd4/SOLCONV/data/log5a.dbf';
alter database rename file '/prddbd/PRD/data/log5b.dbf' to '/tdxdbd4/SOLCONV/data/log5b.dbf';
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL> alter database drop standby logfile group 10;
alter database drop standby logfile group 11;
alter database drop standby logfile group 12;
alter database drop standby logfile group 13;
alter database drop standby logfile group 14;
alter database drop standby logfile group 15;
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL> select status from v$log;
STATUS
----------------
INACTIVE
CURRENT
ACTIVE
ACTIVE
ACTIVE
SQL> alter database open resetlogs;
Database altered.
SQL> select distinct status from v$datafile;
STATUS
-------
ONLINE
SYSTEM
SQL> select distinct status from dba_data_files;
STATUS
---------
AVAILABLE
SQL> select * from V$RECOVER_FILE;
no rows selected
SQL> DROP TABLESPACE TEMP2 including contents and datafiles;
Tablespace dropped.
SQL> DROP TABLESPACE PRD_IAS_TEMP including contents and datafiles;
Tablespace dropped.
SQL> CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/tdxdbd4/SOLCONV/data/temp1_01.dbf' SIZE 2048M,'/tdxdbd4/SOLCONV/data/temp1_02.dbf' SIZE 2048M,'/tdxdbd4/SOLCONV/data/temp1_03.dbf' SIZE 2048M autoextend off;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1;
Database altered.
SQL> DROP TABLESPACE TEMP including contents and datafiles;
Tablespace dropped.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2235208 bytes
Variable Size 687867064 bytes
Database Buffers 3573547008 bytes
Redo Buffers 12132352 bytes
Database mounted.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /tdxdbd4/SOLCONV/data/archive
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1
SQL> alter database noarchivelog;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oratdx4@bpuqqrkd007 ~]$ nid target=/ DBNAME=SOLCONV
DBNEWID: Release 11.2.0.3.0 - Production on Wed Feb 1 04:57:35 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to database PRD (DBID=1907593454)
Connected to server version 11.2.0
Control Files in database:
/tdxdbd4/SOLCONV/data/cntrl01.dbf
/tdxdbd4/SOLCONV/data/cntrl02.dbf
/tdxdbd4/SOLCONV/data/cntrl03.dbf
Change database ID and database name PRD to SOLCONV? (Y/[N]) => Y
....
....
....
Datafile /tdxdbd4/SOLCONV/data/efx_index_20.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/a_media38.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/xxa_txn_data05.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/PRD_biplatform.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/PRD_mds.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/obieep01.db - dbid changed, wrote new name
Datafile /SOLCONVdata/solconv/data/a_txn_data42.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/sysaux_03.db - dbid changed, wrote new name
Datafile /SOLCONVdata/solconv/data/a_txn_ind27.db - dbid changed, wrote new name
Datafile /SOLCONVdata/solconv/data/a_txn_data43.db - dbid changed, wrote new name
Datafile /SOLCONVdata/solconv/data/a_media39.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/efx_data_20.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/ffield1.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/efx_index_21.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/a_media40.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/a_media41.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/a_media42.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/temp1_01.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/temp1_02.db - dbid changed, wrote new name
Datafile /tdxdbd4/SOLCONV/data/temp1_03.db - dbid changed, wrote new name
Control File /tdxdbd4/SOLCONV/data/cntrl01.dbf - dbid changed, wrote new name
Control File /tdxdbd4/SOLCONV/data/cntrl02.dbf - dbid changed, wrote new name
Control File /tdxdbd4/SOLCONV/data/cntrl03.dbf - dbid changed, wrote new name
Instance shut down
Database name changed to SOLCONV.
Modify parameter file and generate a new password file before restarting.
Database ID for database SOLCONV changed to 928008896.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
[oratdx4@bpuqqrkd007 dbs]$ grep db_name initSOLCONV.ora
*.db_name='PRD'
[oratdx4@bpuqqrkd007 dbs]$ vi initSOLCONV.ora
[oratdx4@bpuqqrkd007 dbs]$ grep db_name initSOLCONV.ora
*.db_name='SOLCONV'
SQL> startup mount;
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2235208 bytes
Variable Size 687867064 bytes
Database Buffers 3573547008 bytes
Redo Buffers 12132352 bytes
Database mounted.
SQL> alter database open resetlogs;
Database altered.
SQL> Select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
SOLCONV READ WRITE
SQL> conn apps
Enter password:
Connected.
SQL> sho user;
USER is "APPS"
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
[oratdx4@bpuqqrkd007 dbs]$ grep SOLCONV /etc/oraInst.loc | grep -v '#'
inventory_loc=/tdxdbb4/SOLCONV/oraInventory
[oratdx4@bpuqqrkd007 dbs]$ cd $ORACLE_HOME/sysman/lib
[oratdx4@bpuqqrkd007 lib]$ ls -ltr env_emagent.mk
-rw-r--r-- 1 oratdx4 appid 114870 Apr 2 2014 env_emagent.mk
[oratdx4@bpuqqrkd007 lib]$ mv env_emagent.mk env_emagent.mk_bkp
[oratdx4@bpuqqrkd007 lib]$ cp -Rf /export/home/oratdx4/CLONE_SAVE/env_emagent.mk .
[oratdx4@bpuqqrkd007 lib]$ ls -ltr env_emagent.mk
-rw-r----- 1 oratdx4 appid 114866 Feb 1 05:06 env_emagent.mk
[oratdx4@bpuqqrkd007 lib]$ cd $ORACLE_HOME/appsutil/install
[oratdx4@bpuqqrkd007 install]$ ls -ltr adlnkoh.sh
-rwx------ 1 oratdx4 appid 31216 Oct 17 2015 adlnkoh.sh
[oratdx4@bpuqqrkd007 install]$ mv adlnkoh.sh adlnkoh.sh_bkp
[oratdx4@bpuqqrkd007 install]$ cp -Rf /export/home/oratdx4/CLONE_SAVE/adlnkoh.sh .
[oratdx4@bpuqqrkd007 install]$ ls -ltr adlnkoh.sh
-rwx------ 1 oratdx4 appid 31212 Feb 1 05:08 adlnkoh.sh
[oratdx4@bpuqqrkd007 bin]$ pwd
/tdxdbb4/SOLCONV/db_1/appsutil/clone/bin
[oratdx4@bpuqqrkd007 bin]$ perl adcfgclone.pl dbTechStack /export/home/oratdx4/CLONE_SAVE/SOLCONV_bpuqqrkd007.xml
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.12
Enter the APPS password :
Running Rapid Clone with command:
perl /tdxdbb4/SOLCONV/db_1/appsutil/clone/bin/adclone.pl java=/tdxdbb4/SOLCONV/db_1/appsutil/clone/bin/../jre mode=apply st age=/tdxdbb4/SOLCONV/db_1/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/export/home/oratdx4/CLONE_SAVE/SOLCON V_bpuqqrkd007.xml showProgress contextValidated=false
Running:
perl /tdxdbb4/SOLCONV/db_1/appsutil/clone/bin/adclone.pl java=/tdxdbb4/SOLCONV/db_1/appsutil/clone/bin/../jre mode=apply st age=/tdxdbb4/SOLCONV/db_1/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/export/home/oratdx4/CLONE_SAVE/SOLCON V_bpuqqrkd007.xml showProgress contextValidated=false
APPS Password :
Beginning rdbms home Apply - Wed Feb 1 05:14:16 2017
/tdxdbb4/SOLCONV/db_1/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/td xdbb4/SOLCONV/db_1/oui -classpath /tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/xmlparserv2.jar:/tdxdbb4/SOLCONV/db_1/appsutil/ clone/jlib/ojdbc5.jar:/tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/java:/tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/oui/OraInsta ller.jar:/tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/oui/ewt3.jar:/tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/oui/share.jar:/td xdbb4/SOLCONV/db_1/appsutil/clone/jlib/oui/srvm.jar:/tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.c lone.ApplyDBTechStack -e /export/home/oratdx4/CLONE_SAVE/SOLCONV_bpuqqrkd007.xml -stage /tdxdbb4/SOLCONV/db_1/appsutil/clon e -showProgress
APPS Password : Log file located at /tdxdbb4/SOLCONV/db_1/appsutil/log/SOLCONV_bpuqqrkd007/ApplyDBTechStack_02010514.log
| 0% completed
Log file located at /tdxdbb4/SOLCONV/db_1/appsutil/log/SOLCONV_bpuqqrkd007/ApplyDBTechStack_02010514.log
\ 0% completed
Completed Apply...
Wed Feb 1 05:15:31 2017
Starting database listener for SOLCONV:
Running:
/tdxdbb4/SOLCONV/db_1/appsutil/scripts/SOLCONV_bpuqqrkd007/addlnctl.sh start SOLCONV
Logfile: /tdxdbb4/SOLCONV/db_1/appsutil/log/SOLCONV_bpuqqrkd007/addlnctl.txt
You are running addlnctl.sh version 120.1.12010000.4
Starting listener process SOLCONV ...
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 01-FEB-2017 05:15:32
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /tdxdbb4/SOLCONV/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /tdxdbb4/SOLCONV/db_1/network/admin/SOLCONV_bpuqqrkd007/listener.ora
Log messages written to /tdxdbb4/SOLCONV/db_1/admin/SOLCONV_bpuqqrkd007/diag/tnslsnr/bpuqqrkd007/solconv/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bpuqqrkd007.corp.equifax.com)(PORT=1548)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bpuqqrkd007.corp.equifax.com)(PORT=1548)))
STATUS of the LISTENER
------------------------
Alias SOLCONV
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 01-FEB-2017 05:15:32
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /tdxdbb4/SOLCONV/db_1/network/admin/SOLCONV_bpuqqrkd007/listener.ora
Listener Log File /tdxdbb4/SOLCONV/db_1/admin/SOLCONV_bpuqqrkd007/diag/tnslsnr/bpuqqrkd007/solconv/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bpuqqrkd007.corp.equifax.com)(PORT=1548)))
Services Summary...
Service "SOLCONV" has 1 instance(s).
Instance "SOLCONV", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /tdxdbb4/SOLCONV/db_1/appsutil/log/SOLCONV_bpuqqrkd007/addlnctl.txt for more information ...
[oratdx4@bpuqqrkd007 bin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 1 05:19:12 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @$ORACLE_HOME/appsutil/install/$CONTEXT_NAME/adupdlib.sql so;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
[oratdx4@bpuqqrkd007 bin]$ pwd
/tdxdbb4/SOLCONV/db_1/appsutil/clone/bin
[oratdx4@bpuqqrkd007 bin]$ perl adcfgclone.pl dbconfig $CONTEXT_FILE
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.12
Enter the APPS password :
Running Rapid Clone with command:
perl /tdxdbb4/SOLCONV/db_1/appsutil/clone/bin/adclone.pl java=/tdxdbb4/SOLCONV/db_1/appsutil/clone/bin/../jre mode=apply stage=/tdxdbb4/SOLCONV/db_1/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/tdxdbb4/SOLCONV/db_1/appsutil/SOLCONV_bpuqqrkd007.xml showProgress contextValidated=false
Running:
perl /tdxdbb4/SOLCONV/db_1/appsutil/clone/bin/adclone.pl java=/tdxdbb4/SOLCONV/db_1/appsutil/clone/bin/../jre mode=apply stage=/tdxdbb4/SOLCONV/db_1/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/tdxdbb4/SOLCONV/db_1/appsutil/SOLCONV_bpuqqrkd007.xml showProgress contextValidated=false
APPS Password :
Beginning dbconfig Apply - Wed Feb 1 05:20:20 2017
/tdxdbb4/SOLCONV/db_1/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/tdxdbb4/SOLCONV/db_1/oui -classpath /tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/xmlparserv2.jar:/tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/ojdbc5.jar:/tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/java:/tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/oui/OraInstaller.jar:/tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/oui/ewt3.jar:/tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/oui/share.jar:/tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/oui/srvm.jar:/tdxdbb4/SOLCONV/db_1/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDatabase -e /tdxdbb4/SOLCONV/db_1/appsutil/SOLCONV_bpuqqrkd007.xml -stage /tdxdbb4/SOLCONV/db_1/appsutil/clone -showProgress -noRmanRecovery yes -checkDBConnection
APPS Password : Log file located at /tdxdbb4/SOLCONV/db_1/appsutil/log/SOLCONV_bpuqqrkd007/ApplyDatabase_02010520.log
| 0% completed
Log file located at /tdxdbb4/SOLCONV/db_1/appsutil/log/SOLCONV_bpuqqrkd007/ApplyDatabase_02010520.log
- 30% completed
Completed Apply...
Wed Feb 1 05:21:28 2017
Starting database listener for SOLCONV:
Running:
/tdxdbb4/SOLCONV/db_1/appsutil/scripts/SOLCONV_bpuqqrkd007/addlnctl.sh start SOLCONV
Logfile: /tdxdbb4/SOLCONV/db_1/appsutil/log/SOLCONV_bpuqqrkd007/addlnctl.txt
You are running addlnctl.sh version 120.1.12010000.4
Starting listener process SOLCONV ...
Listener SOLCONV has already been started.
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /tdxdbb4/SOLCONV/db_1/appsutil/log/SOLCONV_bpuqqrkd007/addlnctl.txt for more information ...
[oratdx4@bpuqqrkd007 SOLCONV_bpuqqrkd007]$ pwd
/tdxdbb4/SOLCONV/db_1/appsutil/scripts/SOLCONV_bpuqqrkd007
[oratdx4@bpuqqrkd007 SOLCONV_bpuqqrkd007]$ sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /tdxdbb4/SOLCONV/db_1/appsutil/log/SOLCONV_bpuqqrkd007/02010523/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /tdxdbb4/SOLCONV/db_1
Classpath : :/tdxdbb4/SOLCONV/db_1/jdbc/lib/ojdbc5.jar:/tdxdbb4/SOLCONV/db_1/appsutil/java/xmlparserv2.jar:/tdxdbb4/SOLCONV/db_1/appsutil/java:/tdxdbb4/SOLCONV/db_1/jlib/netcfg.jar:/tdxdbb4/SOLCONV/db_1/jlib/ldapjclnt11.jar
Using Context file : /tdxdbb4/SOLCONV/db_1/appsutil/SOLCONV_bpuqqrkd007.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 db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Application Clone ++++++++++++++++++++++++++++++++++++++++++++=+=++++++++++++++++
[appltdx4@bpuqqrkd007 SOLCONV]$ nohup tar -xvzf /backup1/prdapps013117.tar.gz &
[1] 25585
[appltdx4@bpuqqrkd007 SOLCONV]$ nohup: appending output to `nohup.out'
appltdx4 10711 2658 0 05:25 pts/7 00:00:00 grep 25585
[1]+ Done nohup tar -xvzf /backup1/prdapps013117.tar.gz
[appltdx4@bpuqqrkd007 bin]$ pwd
/tdxap4/SOLCONV/apps/apps_st/comn/clone/bin
[appltdx4@bpuqqrkd007 bin]$ ls -ltr
total 136
-rwxr-xr-x 1 appltdx4 appid 55747 Feb 14 2015 adclone.pl
-rwxr-xr-x 1 appltdx4 appid 27277 Feb 14 2015 adclonectx.pl
-rwxr-xr-x 1 appltdx4 appid 5108 Feb 14 2015 adchkutl.sh
-rwxr-xr-x 1 appltdx4 appid 33401 Feb 14 2015 adcfgclone.pl
-rwxr-xr-x 1 appltdx4 appid 7413 Feb 14 2015 adaddnode.pl
[appltdx4@bpuqqrkd007 bin]$ perl adcfgclone.pl appsTier /export/home/appltdx4/CLONE_SAVE/SOLCONV_bpuqqrkd007.xml
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.12
Enter the APPS password :
Running Rapid Clone with command:
perl /tdxap4/SOLCONV/apps/apps_st/comn/clone/bin/adclone.pl java=/tdxap4/SOLCONV/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/tdxap4/SOLCONV/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/export/home/appltdx4/CLONE_SAVE/SOLCONV_bpuqqrkd007.xml showProgress contextValidated=false
Running:
perl /tdxap4/SOLCONV/apps/apps_st/comn/clone/bin/adclone.pl java=/tdxap4/SOLCONV/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/tdxap4/SOLCONV/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/export/home/appltdx4/CLONE_SAVE/SOLCONV_bpuqqrkd007.xml showProgress contextValidated=false
APPS Password :
Beginning application tier Apply - Wed Feb 1 05:27:24 2017
/tdxap4/SOLCONV/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /tdxap4/SOLCONV/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/tdxap4/SOLCONV/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/tdxap4/SOLCONV/apps/apps_st/comn/clone/jlib/java:/tdxap4/SOLCONV/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/tdxap4/SOLCONV/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/tdxap4/SOLCONV/apps/apps_st/comn/clone/jlib/oui/share.jar:/tdxap4/SOLCONV/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/tdxap4/SOLCONV/apps/apps_st/comn/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyAppsTier -e /export/home/appltdx4/CLONE_SAVE/SOLCONV_bpuqqrkd007.xml -stage /tdxap4/SOLCONV/apps/apps_st/comn/clone -showProgress
APPS Password : Log file located at /tdxap4/SOLCONV/inst/apps/SOLCONV_bpuqqrkd007/admin/log/ApplyAppsTier_02010527.log
| 0% completed
Log file located at /tdxap4/SOLCONV/inst/apps/SOLCONV_bpuqqrkd007/admin/log/ApplyAppsTier_02010527.log
- 89% completed
Completed Apply...
Wed Feb 1 05:37:10 2017
Do you want to startup the Application Services for SOLCONV? (y/n) [y] : n
Services not started
Post Directory Custom directory Creation Steps
+++++++++++++++++++++++++++++++++++++
Create directory /share_R12_SOLCONV/<TARGET_INSTANCE_NAME>/appl and APPLPTMP directory
E.g.
mkdir –p /share_R12_SOLCONV/SOLCONV/appl
mkdir –p /share_R12_SOLCONV/SOLCONV/ATLASSOLCONV_TEMP
chmod 777 /share_R12_SOLCONV/SOLCONV/SOLCONV_TEMP
[appltdx4@bpuqqrkd007 appl]$ cd /share_R12_SOLCONV/SOLCONV/
[appltdx4@bpuqqrkd007 SOLCONV]$ mv appl appl_1Feb17
[appltdx4@bpuqqrkd007 SOLCONV]$ mkdir appl
[appltdx4@bpuqqrkd007 SOLCONV]$ cd appl
[appltdx4@bpuqqrkd007 appl]$ pwd
/share_R12_SOLCONV/SOLCONV/appl
[appltdx4@bpuqqrkd007 appl]$ cp -Rf $APPL_TOP/xx* .
[appltdx4@bpuqqrkd007 appl]$ ls -ltr
total 44
drwxr-xr-x 3 appltdx4 appid 4096 Feb 1 05:42 xxap
drwxr-xr-x 3 appltdx4 appid 4096 Feb 1 05:42 xxar
drwxr-xr-x 3 appltdx4 appid 4096 Feb 1 05:42 xxce
drwxr-xr-x 3 appltdx4 appid 4096 Feb 1 05:43 xxefx
drwxr-xr-x 3 appltdx4 appid 4096 Feb 1 05:43 xxfa
drwxr-xr-x 4 appltdx4 appid 4096 Feb 1 05:43 xxfn
drwxr-xr-x 3 appltdx4 appid 4096 Feb 1 05:43 xxgl
drwxr-xr-x 3 appltdx4 appid 4096 Feb 1 05:43 xxotl
drwxr-xr-x 3 appltdx4 appid 4096 Feb 1 05:43 xxpa
drwxr-xr-x 3 appltdx4 appid 4096 Feb 1 05:43 xxpo
drwxr-xr-x 3 appltdx4 appid 4096 Feb 1 05:43 xxxla
Create custom top data directory structure on target server : PRD/Source Instance
[mxm510@bpuqqrrka003 ~]$ sudo su - applprd
-bash-3.2$ cd $APPL_TOP
-bash-3.2$ find xx*/12.0.0/data -type d -print | while read line; do echo "mkdir -p '${line}'"; done
mkdir -p 'xxap/12.0.0/data'
mkdir -p 'xxap/12.0.0/data/error'
mkdir -p 'xxap/12.0.0/data/inbound'
mkdir -p 'xxap/12.0.0/data/inbound/bkup_09162014'
mkdir -p 'xxap/12.0.0/data/inbound/BKP'
mkdir -p 'xxap/12.0.0/data/inbound/meera'
mkdir -p 'xxap/12.0.0/data/inbound/bad'
mkdir -p 'xxap/12.0.0/data/inbound/log'
mkdir -p 'xxap/12.0.0/data/inbound/04-SEP-2014'
mkdir -p 'xxap/12.0.0/data/inbound/Upload'
mkdir -p 'xxap/12.0.0/data/inbound/Workday'
mkdir -p 'xxap/12.0.0/data/inbound/vn5416'
mkdir -p 'xxap/12.0.0/data/ESS_DATAFILES'
mkdir -p 'xxap/12.0.0/data/processed'
mkdir -p 'xxap/12.0.0/data/invoices'
mkdir -p 'xxap/12.0.0/data/invoices/log'
mkdir -p 'xxap/12.0.0/data/outbound'
mkdir -p 'xxap/12.0.0/data/outbound/nov20'
mkdir -p 'xxap/12.0.0/data/outbound/trans'
mkdir -p 'xxap/12.0.0/data/outbound/trans/archive'
mkdir -p 'xxap/12.0.0/data/suppliers'
mkdir -p 'xxap/12.0.0/data/archive_outbound'
mkdir -p 'xxap/12.0.0/data/archive_processed'
mkdir -p 'xxar/12.0.0/data'
mkdir -p 'xxar/12.0.0/data/error'
mkdir -p 'xxar/12.0.0/data/backup'
mkdir -p 'xxar/12.0.0/data/inbound'
mkdir -p 'xxar/12.0.0/data/inbound/bkup_09162014'
mkdir -p 'xxar/12.0.0/data/inbound/BKP'
mkdir -p 'xxar/12.0.0/data/inbound/AR_Datafiles'
mkdir -p 'xxar/12.0.0/data/inbound/ESS_AR_datafiles'
mkdir -p 'xxar/12.0.0/data/inbound/bad'
mkdir -p 'xxar/12.0.0/data/inbound/11-APR-2014'
mkdir -p 'xxar/12.0.0/data/inbound/log'
mkdir -p 'xxar/12.0.0/data/inbound/04-SEP-2014'
mkdir -p 'xxar/12.0.0/data/inbound/05-SEP-2014'
mkdir -p 'xxar/12.0.0/data/inbound/06-SEP-2014'
mkdir -p 'xxar/12.0.0/data/inbound/08-SEP-2014'
mkdir -p 'xxar/12.0.0/data/inbound/09-SEP-2014'
mkdir -p 'xxar/12.0.0/data/inbound/1'
mkdir -p 'xxar/12.0.0/data/inbound/1/home'
mkdir -p 'xxar/12.0.0/data/inbound/1/home/applprd'
mkdir -p 'xxar/12.0.0/data/inbound/1/home/applprd/temp'
mkdir -p 'xxar/12.0.0/data/inbound/1/home/applprd/temp/xxar'
mkdir -p 'xxar/12.0.0/data/inbound/backup_vxn'
mkdir -p 'xxar/12.0.0/data/processed'
mkdir -p 'xxar/12.0.0/data/processed/lockbox'
mkdir -p 'xxar/12.0.0/data/archive_processed'
mkdir -p 'xxar/12.0.0/data/archive_inbound'
mkdir -p 'xxar/12.0.0/data/archive_inbound/log'
mkdir -p 'xxar/12.0.0/data/outbound'
mkdir -p 'xxar/12.0.0/data/outbound/LN_AR_BKP'
mkdir -p 'xxar/12.0.0/data/outbound/BKP_MANUAL'
mkdir -p 'xxar/12.0.0/data/archive_outbound'
mkdir -p 'xxar/12.0.0/data/comm_bill'
mkdir -p 'xxar/12.0.0/data/comm_bill/new'
mkdir -p 'xxar/12.0.0/data/comm_bill/processed'
mkdir -p 'xxar/12.0.0/data/cons_bill'
mkdir -p 'xxar/12.0.0/data/cons_bill/new'
mkdir -p 'xxar/12.0.0/data/cons_bill/processed'
mkdir -p 'xxar/12.0.0/data/bkp4solmn'
mkdir -p 'xxar/12.0.0/data/EWS_CO_BKP'
mkdir -p 'xxce/12.0.0/data'
mkdir -p 'xxce/12.0.0/data/error'
mkdir -p 'xxce/12.0.0/data/inbound'
mkdir -p 'xxce/12.0.0/data/inbound/BKP'
mkdir -p 'xxce/12.0.0/data/inbound/bad'
mkdir -p 'xxce/12.0.0/data/inbound/bkup_09162014'
mkdir -p 'xxce/12.0.0/data/inbound/log'
mkdir -p 'xxce/12.0.0/data/inbound/BAC_CR_SV_HN'
mkdir -p 'xxce/12.0.0/data/processed'
mkdir -p 'xxce/12.0.0/data/outbound'
mkdir -p 'xxce/12.0.0/data/16Oct15_inbound'
mkdir -p 'xxce/12.0.0/data/16Oct15_outbound'
mkdir -p 'xxce/12.0.0/data/23oct15_inbound'
mkdir -p 'xxce/12.0.0/data/23oct15_outbound'
mkdir -p 'xxce/12.0.0/data/22Jan16_inbound'
mkdir -p 'xxce/12.0.0/data/22Jan16_outbound'
mkdir -p 'xxfa/12.0.0/data'
mkdir -p 'xxfa/12.0.0/data/error'
mkdir -p 'xxfa/12.0.0/data/inbound'
mkdir -p 'xxfa/12.0.0/data/inbound/bad'
mkdir -p 'xxfa/12.0.0/data/inbound/log'
mkdir -p 'xxfa/12.0.0/data/inbound/bkup_09162014'
mkdir -p 'xxfa/12.0.0/data/processed'
mkdir -p 'xxfa/12.0.0/data/outbound'
mkdir -p 'xxfn/12.0.0/data'
mkdir -p 'xxfn/12.0.0/data/error'
mkdir -p 'xxfn/12.0.0/data/inbound'
mkdir -p 'xxfn/12.0.0/data/inbound/bad'
mkdir -p 'xxfn/12.0.0/data/inbound/log'
mkdir -p 'xxfn/12.0.0/data/inbound/bkup_09162014'
mkdir -p 'xxfn/12.0.0/data/processed'
mkdir -p 'xxfn/12.0.0/data/outbound'
mkdir -p 'xxgl/12.0.0/data'
mkdir -p 'xxgl/12.0.0/data/error'
mkdir -p 'xxgl/12.0.0/data/inbound'
mkdir -p 'xxgl/12.0.0/data/inbound/log'
mkdir -p 'xxgl/12.0.0/data/processed'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201510:59'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:12'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:19'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/BKP'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/bad'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/09-APR-2014'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/bkup_09162014'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/log'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/log/files'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/08-APR-2014'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/15-APR-2014'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/16-APR-2014'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/04-SEP-2014'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/05-SEP-2014'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/06-SEP-2014'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201511:58/08-SEP-2014'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201512:19'
mkdir -p 'xxgl/12.0.0/data/processed/08-Jan-201512:30'
mkdir -p 'xxgl/12.0.0/data/concur'
mkdir -p 'xxgl/12.0.0/data/concur/error'
mkdir -p 'xxgl/12.0.0/data/concur/inbound'
mkdir -p 'xxgl/12.0.0/data/concur/inbound/04-APR-2014'
mkdir -p 'xxgl/12.0.0/data/concur/inbound/BKP'
mkdir -p 'xxgl/12.0.0/data/concur/inbound/05-APR-2014'
mkdir -p 'xxgl/12.0.0/data/concur/inbound/log'
mkdir -p 'xxgl/12.0.0/data/concur/inbound/backup'
mkdir -p 'xxgl/12.0.0/data/concur/inbound/03-APR-2014'
mkdir -p 'xxgl/12.0.0/data/concur/processed'
mkdir -p 'xxgl/12.0.0/data/outbound'
mkdir -p 'xxgl/12.0.0/data/outbound/HFM'
mkdir -p 'xxgl/12.0.0/data/outbound/Backup'
mkdir -p 'xxgl/12.0.0/data/archive_processed'
mkdir -p 'xxgl/12.0.0/data/gl_coa'
mkdir -p 'xxgl/12.0.0/data/solomon_gl'
mkdir -p 'xxpo/12.0.0/data'
mkdir -p 'xxpo/12.0.0/data/error'
mkdir -p 'xxpo/12.0.0/data/inbound'
mkdir -p 'xxpo/12.0.0/data/inbound/bad'
mkdir -p 'xxpo/12.0.0/data/inbound/04-APR-2014'
mkdir -p 'xxpo/12.0.0/data/inbound/05-APR-2014'
mkdir -p 'xxpo/12.0.0/data/inbound/log'
mkdir -p 'xxpo/12.0.0/data/inbound/03-APR-2014'
mkdir -p 'xxpo/12.0.0/data/inbound/bkup_09162014'
mkdir -p 'xxpo/12.0.0/data/processed'
mkdir -p 'xxpo/12.0.0/data/outbound'
mkdir -p 'xxxla/12.0.0/data'
mkdir -p 'xxxla/12.0.0/data/error'
mkdir -p 'xxxla/12.0.0/data/inbound'
mkdir -p 'xxxla/12.0.0/data/inbound/bad'
mkdir -p 'xxxla/12.0.0/data/inbound/log'
mkdir -p 'xxxla/12.0.0/data/processed'
mkdir -p 'xxxla/12.0.0/data/outbound'
Target Instance:
[appltdx4@bpuqqrkd007 appl]$ vi create_dir.sh
[appltdx4@bpuqqrkd007 appl]$ sh create_dir.sh
[appltdx4@bpuqqrkd007 appl]$ chmod -Rf 777 xx*/12.0.0/data
Apply 19127427 patch for coredump issue from 1932120.1 in target instance
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Enable Maintenance Mode
[appltdx4@bpuqqrkd007 outbound]$ cd /export/home/corp_tech/19127427_S
[appltdx4@bpuqqrkd007 19127427_S]$ ls -lrt
total 96
drwxrwxrwx 5 corp_tech dba 2048 Jan 30 05:52 19127427
drwxrwxrwx 3 corp_tech dba 2048 Jan 30 05:59 19127427_E
drwxrwxrwx 3 corp_tech dba 2048 Jan 30 06:02 19127427_ESA
Apply all 3 patches
u19127427.drv
Disable Maintenance Mode
POST CLONE AUTOMATION SCRIPT
++++++++++++++++++++++++++++++++
To update the FND_USER password with default password : ChangeMe@123
[appltdx4@bpuqqrkd007 autoclone]$ cat Change_password_SOLCONV.sh
function Change_fnd_user_password
{
cat /SOLCONV/null > password_failure.txt
sqlplus -s apps/appssolconv << EOF
set lines 300 pages 0 feedback off
spool fnd_user.lst
select 'FNDCPASS apps/appssolconv 0 Y system/systemsolconv USER "'||USER_NAME||'" ChangeMe@123 || echo "Err while changing password for user - ' || user_name || '" >> password_failure.txt' from fnd_user where user_name not in ('APPSMGR','ASADMIN','INDUSTRY DATA','GUEST','SYSADMIN') and (user_name not like 'ORACLE%') and user_name not like 'APP%';
spool off;
EOF
#sed -e 1,+1d fnd_user.lst > fnd_user_2.lst
sh fnd_user.lst
if [ `wc -l password_failure.txt | awk '{print $1}'` -gt 0 ]
then
echo 'Following errors occured while changing Application User Passwords'
cat password_failure.txt
rm L*.log
else
echo "All the passwords of Application users got changed successfully to 'ChangeMe@123' "
rm L*.log
rm password_failure.txt
fi
}
Change_fnd_user_password
[appltdx4@bpuqqrkd007 autoclone]$ nohup sh Change_password_SOLCONV.sh &
[1] 24731
[appltdx4@bpuqqrkd007 autoclone]$ nohup: appending output to `nohup.out'
Start the application
Update below profile options to appropriate target values
FND: SMTP Host --> postoffice.equifax.com
IBY: XML Publisher Delivery Manager Configuration File Absolute Directory path ($XDO_TOP/resource/xdodelivery.cfg)
Clone Completed on both database and application nodes
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Post clone verification steps :
SQL> select name from v$database;
NAME
---------
SOLCONV
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir string /share_R12_SOLCONV/SOLCONV/SOLCONV
_TEMP, /tdxdbb4/SOLCONV/db_1/a
ppsutil/outbound/SOLCONV_bpuqq
rkd007, /usr/tmp
[oratdx4@bpuqqrkd007 SOLCONV_bpuqqrkd007]$ diff sqlnet.ora sqlnet.ora_bkp
13c13
< SQLNET.EXPIRE_TIME= 1
---
> SQLNET.EXPIRE_TIME= 10
20c20
< IFILE=/tdxdbb4/SOLCONV/db_1/network/admin/SOLCONV_bpuqqrkd007/sqlnet_ifile.ora
---
> IFILE=/tdxdbb4/SOLCONV/db_1/network/admin/SOLCONV_bpuqqrkd007/sqlnet_ifile.ora
\ No newline at end of file
[appltdx4@bpuqqrkd007 SOLCONV_TEMP]$ echo $APPLPTMP
/share_R12_SOLCONV/SOLCONV/SOLCONV_TEMP
[appltdx4@bpuqqrkd007 SOLCONV_TEMP]$ echo $APPLTMP
/share_R12_SOLCONV/SOLCONV/SOLCONV_TEMP
[appltdx4@bpuqqrkd007 SOLCONV_TEMP]$ cd $XXAP_TOP
[appltdx4@bpuqqrkd007 12.0.0]$ ls -tr
sql log patches ldt oldsql admin mesg out forms ddl wf INVUPL_VERCUITY032514.dat reports data bin
[appltdx4@bpuqqrkd007 12.0.0]$ cd data/
[appltdx4@bpuqqrkd007 data]$ ls -ltr
total 36
drwxrwxrwx 2 appltdx4 appid 4096 Feb 1 05:52 error
drwxrwxrwx 11 appltdx4 appid 4096 Feb 1 05:52 inbound
drwxrwxrwx 2 appltdx4 appid 4096 Feb 1 05:52 ESS_DATAFILES
drwxrwxrwx 2 appltdx4 appid 4096 Feb 1 05:52 processed
drwxrwxrwx 3 appltdx4 appid 4096 Feb 1 05:52 invoices
drwxrwxrwx 4 appltdx4 appid 4096 Feb 1 05:52 outbound
drwxrwxrwx 2 appltdx4 appid 4096 Feb 1 05:52 suppliers
drwxrwxrwx 2 appltdx4 appid 4096 Feb 1 05:52 archive_outbound
drwxrwxrwx 2 appltdx4 appid 4096 Feb 1 05:52 archive_processed
[appltdx4@bpuqqrkd007 autoclone]$ cd /share_R12_SOLCONV/SOLCONV/appl
[appltdx4@bpuqqrkd007 appl]$ find xx* -type l | while read line
> do
> echo "rm ${line}"
> echo "ln -s `which fndcpesr` ${line}"
> done
rm xxap/12.0.0/bin/copy_EFX_BITFACT_ECU_INT
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxap/12.0.0/bin/copy_EFX_BITFACT_ECU_INT
rm xxap/12.0.0/bin/xxap_tdxhsbc_sftp_trans
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxap/12.0.0/bin/xxap_tdxhsbc_sftp_trans
rm xxap/12.0.0/bin/xxap_latamplace
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxap/12.0.0/bin/xxap_latamplace
rm xxar/12.0.0/bin/copy_EFX_AR_PE_INVBAL_UPD
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxar/12.0.0/bin/copy_EFX_AR_PE_INVBAL_UPD
rm xxar/12.0.0/bin/XXAR_MERGE_SFTP_CASHAPP_SH
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxar/12.0.0/bin/XXAR_MERGE_SFTP_CASHAPP_SH
rm xxar/12.0.0/bin/XXCE_CONCATENATE_FILE_12Nov
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxar/12.0.0/bin/XXCE_CONCATENATE_FILE_12Nov
rm xxar/12.0.0/bin/XXCE_CONCATENATE_FILE
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxar/12.0.0/bin/XXCE_CONCATENATE_FILE
rm xxar/12.0.0/bin/XXAR_HSBC_BANK_FILE
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxar/12.0.0/bin/XXAR_HSBC_BANK_FILE
rm xxar/12.0.0/bin/XXAR_MOVE_UK_DD_FILE
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxar/12.0.0/bin/XXAR_MOVE_UK_DD_FILE
rm xxar/12.0.0/bin/XXAR_MOVE_BANK_FILE
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxar/12.0.0/bin/XXAR_MOVE_BANK_FILE
rm xxar/12.0.0/bin/XXAR_MOVE_FILE_PROCESS
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxar/12.0.0/bin/XXAR_MOVE_FILE_PROCESS
rm xxar/12.0.0/bin/EFX_CONSCOMM_BILL_INTERFACE01
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxar/12.0.0/bin/EFX_CONSCOMM_BILL_INTERFACE01
rm xxce/12.0.0/bin/XXCE_CRC_DAV
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxce/12.0.0/bin/XXCE_CRC_DAV
rm xxce/12.0.0/bin/XXCE_MEX_BBVA
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxce/12.0.0/bin/XXCE_MEX_BBVA
rm xxce/12.0.0/bin/XXCETRANSFILES1
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxce/12.0.0/bin/XXCETRANSFILES1
rm xxfn/12.0.0/bin/XXFNHOARR
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxfn/12.0.0/bin/XXFNHOARR
rm xxgl/12.0.0/bin/account_analysis_spain
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxgl/12.0.0/bin/account_analysis_spain
rm xxgl/12.0.0/bin/account_analysis1
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxgl/12.0.0/bin/account_analysis1
rm xxgl/12.0.0/bin/EFXABC1E
ln -s /tdxap4/SOLCONV/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr xxgl/12.0.0/bin/EFXABC1E
[appltdx4@bpuqqrkd007 appl]$ ls -ltre
ls: invalid option -- e
Try `ls --help' for more information.
[appltdx4@bpuqqrkd007 appl]$ ls -ltr
total 52
drwxrwxrwx 3 appltdx4 appid 4096 Feb 1 05:42 xxap
drwxrwxrwx 3 appltdx4 appid 4096 Feb 1 05:42 xxar
drwxrwxrwx 3 appltdx4 appid 4096 Feb 1 05:42 xxce
drwxrwxrwx 3 appltdx4 appid 4096 Feb 1 05:43 xxefx
drwxrwxrwx 3 appltdx4 appid 4096 Feb 1 05:43 xxfa
drwxrwxrwx 4 appltdx4 appid 4096 Feb 1 05:43 xxfn
drwxrwxrwx 3 appltdx4 appid 4096 Feb 1 05:43 xxgl
drwxrwxrwx 3 appltdx4 appid 4096 Feb 1 05:43 xxotl
drwxrwxrwx 3 appltdx4 appid 4096 Feb 1 05:43 xxpa
drwxrwxrwx 3 appltdx4 appid 4096 Feb 1 05:43 xxpo
drwxrwxrwx 3 appltdx4 appid 4096 Feb 1 05:43 xxxla
-rwxrwxrwx 1 appltdx4 appid 6711 Feb 1 05:51 create_dir.sh
[appltdx4@bpuqqrkd007 appl]$ vi softlink.sh
[appltdx4@bpuqqrkd007 appl]$
[appltdx4@bpuqqrkd007 appl]$ sh softlink.sh
Active user concurrent request no. : 30076875
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Cloning Completed Successfully with the verification's
No comments:
Post a Comment