Rman restoration linux to window server

D:\>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jun 9 17:12:43 2019

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

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 8.2678E+10 bytes
Fixed Size                  7774968 bytes
Variable Size            1.2885E+10 bytes
Database Buffers         6.9525E+10 bytes
Redo Buffers              260657152 bytes
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

D:\>rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Sun Jun 9 17:14:26 2019

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

connected to target database: SMRPRODB (not mounted)

RMAN> restore controlfile from 'D:\rman_backup_smrprodb\control_63_SMRPRODB_20190609_cf_D-SMRPRODB_id-3201394995_bqu3lhl7.bak';

Starting restore at 09-JUN-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=430 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\CONTROL01.CTL
output file name=D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\CONTROL02.CTL
Finished restore at 09-JUN-19

RMAN> alter database mount;

Statement processed
released channel: ORA_DISK_1

RMAN> catalog start with 'D:\rman_backup_smrprodb\';

Starting implicit crosscheck backup at 09-JUN-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=430 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=456 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=469 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=482 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=495 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=508 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=521 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=534 device type=DISK
allocated channel: ORA_DISK_9
channel ORA_DISK_9: SID=547 device type=DISK
allocated channel: ORA_DISK_10
channel ORA_DISK_10: SID=560 device type=DISK
allocated channel: ORA_DISK_11
channel ORA_DISK_11: SID=573 device type=DISK
allocated channel: ORA_DISK_12
channel ORA_DISK_12: SID=586 device type=DISK
allocated channel: ORA_DISK_13
channel ORA_DISK_13: SID=599 device type=DISK
allocated channel: ORA_DISK_14
channel ORA_DISK_14: SID=612 device type=DISK
allocated channel: ORA_DISK_15
channel ORA_DISK_15: SID=625 device type=DISK
allocated channel: ORA_DISK_16
channel ORA_DISK_16: SID=638 device type=DISK
allocated channel: ORA_DISK_17
channel ORA_DISK_17: SID=651 device type=DISK
allocated channel: ORA_DISK_18
channel ORA_DISK_18: SID=664 device type=DISK
allocated channel: ORA_DISK_19
channel ORA_DISK_19: SID=677 device type=DISK
allocated channel: ORA_DISK_20
channel ORA_DISK_20: SID=690 device type=DISK
Crosschecked 28 objects
Finished implicit crosscheck backup at 09-JUN-19

Starting implicit crosscheck copy at 09-JUN-19
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
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
Finished implicit crosscheck copy at 09-JUN-19

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_13_GBGGMS1R_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_14_GBGGMS83_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_15_GBGGN5CL_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_16_GBGNCNB6_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_10_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_11_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_12_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_13_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_14_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_15_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_16_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_17_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_18_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_19_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_1_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_20_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_21_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_22_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_23_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_24_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_25_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_26_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_27_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_28_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_29_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_2_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_3_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_4_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_5_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_6_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_7_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_8_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_9_1005460847.ARC

searching for all files that match the pattern D:\rman_backup_smrprodb\

List of Files Unknown to the Database
=====================================
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B0U3KRVL_8544_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B1U3KRVL_8545_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B2U3KRVL_8546_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B3U3KRVM_8547_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B4U3KRVP_8548_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BBU3KS00_8555_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BEU3LHKP_8558_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BFU3LHKP_8559_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BGU3LHKP_8560_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BHU3LHKP_8561_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BIU3LHKS_8562_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BPU3LHL5_8569_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190609_CF_D-SMRPRODB_ID-3201394995_BQU3LHL7.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\RMAN_SMRPRODB_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B5U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B6U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B7U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B8U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BAU3KRVR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BJU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BKU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BLU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BMU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BNU3LHKU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BOU3LHKU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190609_BDU3KS02_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190609_BRU3LHL8_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_T8U20MM0_8104_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_T9U20MM1_8105_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_TAU20MM1_8106_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_TBU20MM1_8107_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_TCU20MMI_8108_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\CONTROL_63_SMRPRODB_20190520_CF_D-SMRPRODB_ID-3201394995_TIU20MNQ.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TDU20MML_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TEU20MML_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TFU20MML_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TGU20MMM_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_THU20MMT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\STANDBYCONTROL_SMRPRODB_20190520_TJU20MNR_1_1.CTL

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

List of Cataloged Files
=======================
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B0U3KRVL_8544_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B1U3KRVL_8545_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B2U3KRVL_8546_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B3U3KRVM_8547_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B4U3KRVP_8548_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BBU3KS00_8555_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BEU3LHKP_8558_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BFU3LHKP_8559_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BGU3LHKP_8560_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BHU3LHKP_8561_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BIU3LHKS_8562_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BPU3LHL5_8569_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190609_CF_D-SMRPRODB_ID-3201394995_BQU3LHL7.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B5U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B6U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B7U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B8U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BAU3KRVR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BJU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BKU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BLU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BMU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BNU3LHKU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BOU3LHKU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190609_BDU3KS02_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190609_BRU3LHL8_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_T8U20MM0_8104_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_T9U20MM1_8105_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_TAU20MM1_8106_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_TBU20MM1_8107_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_TCU20MMI_8108_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\CONTROL_63_SMRPRODB_20190520_CF_D-SMRPRODB_ID-3201394995_TIU20MNQ.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TDU20MML_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TEU20MML_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TFU20MML_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TGU20MMM_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_THU20MMT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\STANDBYCONTROL_SMRPRODB_20190520_TJU20MNR_1_1.CTL

List of Files Which Were Not Cataloged
=======================================
File Name: D:\RMAN_BACKUP_SMRPRODB\RMAN_SMRPRODB_FULL.LOG
  RMAN-07517: Reason: The file header is corrupted

RMAN> RUN
2> {
3> set newname for datafile 1 to "D:\app\plmadmin\oradata\smrprodb\system01.dbf";
4> set newname for datafile 2 to "D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf";
5> set newname for datafile 3 to "D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf";
6> set newname for datafile 4 to "D:\app\plmadmin\oradata\smrprodb\idata01.dbf";
7> set newname for datafile 5 to "D:\app\plmadmin\oradata\smrprodb\ilog01.dbf";
8> set newname for datafile 6 to "D:\app\plmadmin\oradata\smrprodb\indx01.dbf";
9> set newname for datafile 7 to "D:\app\plmadmin\oradata\smrprodb\idata02.dbf";
10> set newname for tempfile 1 to "D:\app\plmadmin\oradata\smrprodb\temp01.dbf";
11> RESTORE DATABASE;
12> SWITCH DATAFILE ALL;
13> SWITCH TEMPFILE ALL;
14> }

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 09-JUN-19
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
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00006 to D:\app\plmadmin\oradata\smrprodb\indx01.dbf
channel ORA_DISK_1: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BMU3LHKT_1_1.BCKP
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00001 to D:\app\plmadmin\oradata\smrprodb\system01.dbf
channel ORA_DISK_2: restoring datafile 00005 to D:\app\plmadmin\oradata\smrprodb\ilog01.dbf
channel ORA_DISK_2: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BKU3LHKT_1_1.BCKP
channel ORA_DISK_3: starting datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_DISK_3: restoring datafile 00002 to D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf
channel ORA_DISK_3: restoring datafile 00007 to D:\app\plmadmin\oradata\smrprodb\idata02.dbf
channel ORA_DISK_3: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BLU3LHKT_1_1.BCKP
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00004 to D:\app\plmadmin\oradata\smrprodb\idata01.dbf
channel ORA_DISK_4: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BJU3LHKT_1_1.BCKP
channel ORA_DISK_1: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BMU3LHKT_1_1.BCKP tag=TAG20190609T101453
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_2: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BKU3LHKT_1_1.BCKP tag=TAG20190609T101453
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:45
channel ORA_DISK_3: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BLU3LHKT_1_1.BCKP tag=TAG20190609T101453
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:00:45
channel ORA_DISK_4: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BJU3LHKT_1_1.BCKP tag=TAG20190609T101453
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:01:15
Finished restore at 09-JUN-19

datafile 1 switched to datafile copy
input datafile copy RECID=594 STAMP=1010510407 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=595 STAMP=1010510407 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=596 STAMP=1010510407 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=597 STAMP=1010510408 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=598 STAMP=1010510408 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\ILOG01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=599 STAMP=1010510408 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\INDX01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=600 STAMP=1010510408 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA02.DBF

renamed tempfile 1 to D:\app\plmadmin\oradata\smrprodb\temp01.dbf in control file

RMAN>

RMAN>

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo01a.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo01a.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo01a.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo01a.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo02a.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo02a.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo02a.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo02a.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo03a.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo03a.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo03a.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo03a.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo01b.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo01b.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo01c.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo01c.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo02b.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo02b.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo02c.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo02c.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo03b.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo03b.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo03c.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo03c.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo04.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo04.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo04.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo04.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_05.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo_05.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_05.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo_05.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_06.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo_06.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_06.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo_06.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_07.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo_07.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_07.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo_07.log''

RMAN>

RMAN>

RMAN>

RMAN>

RMAN> recover database noredo;

Starting recover at 09-JUN-19
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
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20

Finished recover at 09-JUN-19

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/09/2019 17:21:49
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSTEM01.DBF'

RMAN> recover database;

Starting recover at 09-JUN-19
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
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=3776
channel ORA_DISK_1: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BPU3LHL5_8569_1_20190609
channel ORA_DISK_1: piece handle=D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BPU3LHL5_8569_1_20190609 tag=TAG20190609T101501
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000003776_1008055157.0001 thread=1 sequence=3776
unable to find archived log
archived log thread=1 sequence=3777
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/09/2019 17:22:06
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 3777 and starting SCN of 469371778

RMAN> alter database open resetlogs;

Statement processed

RMAN>

opatchauto apply -analyze Check error

opatchauto apply -analyze

Grid version 12.1.0.2.0

• Here we are having two example one who got succeed and another show error for anlyzing patch..

Grid Patch number : p28980120_121020_Linux-x86-64.zip

Always use analyze before applying grid patch

• srv1:/u01/24412235 # opatchauto apply -analyze

OPatchauto session is initiated at Wed Apr  7 13:21:45 2021

System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2021-04-07_01-21-53PM.log.

Session log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2021-04-07_01-22-36PM.log

The id for this session is 9TIB

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_1

Patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

Patch applicability verified successfully on home /u01/app/12.1.0/grid

Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_1

SQL patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:srv1

RAC Home:/u01/app/oracle/product/12.1.0/dbhome_1

Version:12.1.0.2.0

==Following patches were SKIPPED:

Patch: /u01/24412235/21436941

Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /u01/24412235/24007012

Reason: This patch is not applicable to this specified target type - "rac_database"

==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /u01/24412235/23854735

Log: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-23-07PM_1.log

Patch: /u01/24412235/24006101

Log: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-23-07PM_1.log

Host:srv1

CRS Home:/u01/app/12.1.0/grid

Version:12.1.0.2.0

==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /u01/24412235/21436941

Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-23-04PM_1.log

Patch: /u01/24412235/23854735

Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-23-04PM_1.log

Patch: /u01/24412235/24006101

Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-23-04PM_1.log

Patch: /u01/24412235/24007012

Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-23-04PM_1.log

OPatchauto session completed at Wed Apr  7 13:24:05 2021

Time taken to complete the session 2 minutes, 21 seconds

srv1:/u01/24412235 #

srv1:/u01/24412235 # opatchauto apply

OPatchauto session is initiated at Wed Apr  7 13:55:27 2021

System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2021-04-07_01-55-31PM.log.

Session log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2021-04-07_01-56-01PM.log

The id for this session is U9F8

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_1

Patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

Patch applicability verified successfully on home /u01/app/12.1.0/grid

Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_1

SQL patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

Preparing to bring down database service on home /u01/app/oracle/product/12.1.0/dbhome_1

Successfully prepared home /u01/app/oracle/product/12.1.0/dbhome_1 to bring down database service

Bringing down CRS service on home /u01/app/12.1.0/grid

Prepatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_srv1_2021-04-07_01-57-26PM.log

CRS service brought down successfully on home /u01/app/12.1.0/grid

Performing prepatch operation on home /u01/app/oracle/product/12.1.0/dbhome_1

Perpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

Start applying binary patch on home /u01/app/oracle/product/12.1.0/dbhome_1

Binary patch applied successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

Performing postpatch operation on home /u01/app/oracle/product/12.1.0/dbhome_1

Postpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

Start applying binary patch on home /u01/app/12.1.0/grid

Binary patch applied successfully on home /u01/app/12.1.0/grid

Starting CRS service on home /u01/app/12.1.0/grid

Postpatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_srv1_2021-04-07_02-15-49PM.log

CRS service started successfully on home /u01/app/12.1.0/grid

Preparing home /u01/app/oracle/product/12.1.0/dbhome_1 after database service restarted

No step execution required.........

Trying to apply SQL patch on home /u01/app/oracle/product/12.1.0/dbhome_1

SQL patch applied successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:srv1

RAC Home:/u01/app/oracle/product/12.1.0/dbhome_1

Version:12.1.0.2.0

Summary:

==Following patches were SKIPPED:

Patch: /u01/24412235/21436941

Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /u01/24412235/24007012

Reason: This patch is not applicable to this specified target type - "rac_database"

==Following patches were SUCCESSFULLY applied:

Patch: /u01/24412235/23854735

Log: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-59-52PM_1.log

Patch: /u01/24412235/24006101

Log: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-59-52PM_1.log

Host:srv1

CRS Home:/u01/app/12.1.0/grid

Version:12.1.0.2.0

Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /u01/24412235/21436941

Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_14-03-48PM_1.log

Patch: /u01/24412235/23854735

Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_14-03-48PM_1.log

Patch: /u01/24412235/24006101

Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_14-03-48PM_1.log

Patch: /u01/24412235/24007012

Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_14-03-48PM_1.log

OPatchauto session completed at Wed Apr  7 14:30:48 2021

Time taken to complete the session 35 minutes, 20 seconds

srv1:/u01/24412235 #

#############################################################################

• Failed Example of opatchauto analyze

[grid@srv1 28813884]$ opatchauto apply -analyze

OPatchauto session is initiated at Thu Jun  6 20:09:05 2019
OPATCHAUTO-72046: Wallet option is not provided.
OPATCHAUTO-72046: Wallet option is required during patching as non-root user.
OPATCHAUTO-72046: Please provide a wallet option or execute as root user.

OPatchauto session completed at Thu Jun  6 20:09:12 2019
Time taken to complete the session 0 minute, 7 seconds

opatchauto bootstrapping failed with error code 255.
[grid@srv1 28813884]$ pwd
/u01/28980120/28813884
[grid@srv1 28813884]$ su root
Password:
[root@srv1 28813884]# export PATH=$PATH:/u01/app/12.1.0/grid/OPatch/
[root@srv1 28813884]# . oraenv
ORACLE_SID = [+ASM1] ?
The Oracle base remains unchanged with value /u01/app/grid

[root@srv1 28813884]# opatchauto apply -analyze

OPatchauto session is initiated at Thu Jun  6 20:09:54 2019

System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2019-06-06_08-10-01PM.log.

Session log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2019-06-06_08-10-52PM.log
The id for this session is BZBD

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_2
Patch applicability verified successfully on home /u01/app/12.1.0/grid

Patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_2


Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_2
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_2

OPatchAuto successful.

--------------------------------Summary--------------------------------

Analysis for applying patches has failed:

Host:srv1
CRS Home:/u01/app/12.1.0/grid
Version:12.1.0.2.0
Analysis for patches has failed.


==Following patches FAILED in analysis for apply:

Patch: /u01/28980120/28813884/26983807
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-06-06_20-11-18PM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(13991.83MB) is not available.]


Patch: /u01/28980120/28813884/28729169
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-06-06_20-11-18PM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(13991.83MB) is not available.]


Patch: /u01/28980120/28813884/28729213
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-06-06_20-11-18PM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(13991.83MB) is not available.]


Patch: /u01/28980120/28813884/28729220
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-06-06_20-11-18PM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(13991.83MB) is not available.]



Host:srv1
RAC Home:/u01/app/oracle/product/12.1.0/dbhome_2
Version:12.1.0.2.0
Analysis for patches has failed.


==Following patches FAILED in analysis for apply:

Patch: /u01/28980120/28813884/28729169
Log: /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatchauto/core/opatch/opatch2019-06-06_20-11-25PM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(3556.51MB) is not available.]


Patch: /u01/28980120/28813884/28729213
Log: /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatchauto/core/opatch/opatch2019-06-06_20-11-25PM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(3556.51MB) is not available.]



==Following patches were SKIPPED:

Patch: /u01/28980120/28813884/26983807
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /u01/28980120/28813884/28729220
Reason: This patch is not applicable to this specified target type - "rac_database"


OPATCHAUTO-72053: Analysis for the patches failed.
OPATCHAUTO-72053: Command execution failed.
OPATCHAUTO-72053: Please check the summary for more details.

OPatchauto session completed at Thu Jun  6 20:13:04 2019
Time taken to complete the session 3 minutes, 10 seconds
[root@srv1 28813884]#

Application Continuity on a Java Application

srvctl add service -db rac -service acsrv -preferred rac1 -available rac2 failovertype TRANSACTION -commit_outcome TRUE -failoverretry 30 -failoverdelay 10 -retention 86400 -replay_init_time 1800 -notification TRUE

srvctl start service -db rac -service acsrv

url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srv-scan)(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=acsrv)))


[oracle@srv1 ac_demo]$ srvctl config service -db rac -s acsrv
Service name: acsrv
Server pool:
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: true
Global: false
Commit Outcome: true
Failover type: TRANSACTION
Failover method:
TAF failover retries: 30
TAF failover delay: 10
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 1800 seconds
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: rac1
Available instances: rac2
[oracle@srv1 ac_demo]$

# test: conn scott/tiger@//srv1:1531/acsrv