Oracle 2 node RAC database Upgrade 12.1 to 12.2
################## Install Database Software Only ##################################
- Create directory on both nodes /u01/app/oracle/product/12.2.0/db_1
- chown -R oracle:oinstall /u01/app/oracle/product/12.2.0/db_1
- chmod -R 775 /u01/app/oracle/product/12.2.0/db_1
- Set Oracle home and execute ./runInstaller
export ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1
./runInstaller
- Run the configuration scripts as root on srv1 then on srv2.
######################## DBUA ###############################
Pre -requestories
- Run the Pre-Upgrade Information Tool (preupgrade.jar) by by executing command on putty or command prompt on local node.
- /u01/app/oracle/product/12.1.0/db_1/jdk/bin/java -jar /u01/app/oracle/product/12.2.0/db_1/rdbms/admin/preupgrade.jar FILE TEXT DIR /home/oracle/scripts
- Preupgrade generated files:
/home/oracle/scripts/preupgrade.log
/home/oracle/scripts/preupgrade_fixups.sql
/home/oracle/scripts/postupgrade_fixups.sql
- Examine and follow the instruction in preupgrade.log file.
- We will take full Rman backup during dbua GUI execution.
Report generated by Oracle Database Pre-Upgrade Information Tool Version
12.2.0.1.0
Upgrade-To version: 12.2.0.1.0
=======================================
Status of the database prior to upgrade
=======================================
Database Name: RAC
Container Name: RAC
Container ID: 0
Version: 12.1.0.2.0
Compatible: 12.1.0.2.0
Blocksize: 8192
Platform: Linux x86 64-bit
Timezone File: 18
Database log mode: ARCHIVELOG
Readonly: FALSE
Edition: EE
Oracle Component Upgrade Action Current Status
---------------- -------------- --------------
Oracle Server [to be upgraded] VALID
JServer JAVA Virtual Machine [to be upgraded] VALID
Oracle XDK for Java [to be upgraded] VALID
Real Application Clusters [to be upgraded] VALID
Oracle Workspace Manager [to be upgraded] VALID
OLAP Analytic Workspace [to be upgraded] VALID
Oracle Label Security [to be upgraded] VALID
Oracle Database Vault [to be upgraded] VALID
Oracle Text [to be upgraded] VALID
Oracle XML Database [to be upgraded] VALID
Oracle Java Packages [to be upgraded] VALID
Oracle Multimedia [to be upgraded] VALID
Oracle Spatial [to be upgraded] VALID
Oracle Application Express [to be upgraded] VALID
Oracle OLAP API [to be upgraded] VALID
==============
BEFORE UPGRADE
==============
Run <preupgradeLogDirPath>/preupgrade_fixups.sql to complete all
of the BEFORE UPGRADE action items below marked with '(AUTOFIXUP)'.
REQUIRED ACTIONS
================
+ Adjust TABLESPACE SIZES as needed.
Auto 12.2.0.1.0
Tablespace Size Extend Min Size Action
---------- ---------- -------- ---------- ------
SYSAUX 810 MB ENABLED 1705 MB None
SYSTEM 790 MB ENABLED 1293 MB None
TEMP 203 MB DISABLED 150 MB None
UNDOTBS1 145 MB ENABLED 400 MB None
Note that 12.2.0.1.0 minimum sizes are estimates.
If you plan to upgrade multiple pluggable databases concurrently,
then you must ensure that the UNDO tablespace size is equal to at least
the number of pluggable databases that you upgrade concurrently,
multiplied by that minimum. Failing to allocate sufficient space can
cause the upgrade to fail.
+ Set DB_RECOVERY_FILE_DEST_SIZE initialization parameter to at least 6083
MB. Check alert log during the upgrade to ensure there is remaining
free space available in the recovery area.
DB_RECOVERY_FILE_DEST_SIZE is set at 4785 MB. There is currently 4100
MB of free space remaining, which may not be adequate for the upgrade.
Currently:
Fast recovery area : +FRA
Limit : 4785 MB
Used : 685 MB
Available : 4100 MB
The database has archivelog mode enabled, and the upgrade process will
need free space to generate archived logs to the recovery area specified
by initialization parameter DB_RECOVERY_FILE_DEST. The logs generated
must not overflow the limit set by DB_RECOVERY_FILE_DEST_SIZE, as the
upgrade may not proceed if the database stops responding.
RECOMMENDED ACTIONS
===================
+ (AUTOFIXUP) Gather stale data dictionary statistics prior to database
upgrade in off-peak time using:
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
Dictionary statistics do not exist or are stale (not up-to-date).
Dictionary statistics help the Oracle optimizer find efficient SQL
execution plans and are essential for proper upgrade timing. Oracle
recommends gathering dictionary statistics in the last 24 hours before
database upgrade.
For information on managing optimizer statistics, refer to the 12.1.0.2
Oracle Database SQL Tuning Guide.
INFORMATION ONLY
================
+ Consider upgrading APEX manually, before the database upgrade.
The database contains APEX version 4.2.5.00.08 and will need to be
upgraded to at least version 5.0.4.00.12.
To reduce database upgrade time, you can upgrade APEX manually before
the database upgrade. Refer to My Oracle Support Note 1088970.1 for
information on APEX installation upgrades.
=============
AFTER UPGRADE
=============
Run <preupgradeLogDirPath>/postupgrade_fixups.sql to complete all
of the AFTER UPGRADE action items below marked with '(AUTOFIXUP)'.
REQUIRED ACTIONS
================
None
RECOMMENDED ACTIONS
===================
+ Upgrade the database time zone version using the DBMS_DST package.
The database is using timezone datafile version 18 and the target
12.2.0.1.0 database ships with timezone datafile version 26.
Oracle recommends using the most recent timezone data. For further
information, refer to My Oracle Support Note 1585343.1.
+ (AUTOFIXUP) Gather dictionary statistics after the upgrade using the
command:
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
Oracle recommends gathering dictionary statistics after upgrade.
Dictionary statistics provide essential information to the Oracle
optimizer to help it find efficient SQL execution plans. After a
database upgrade, statistics need to be re-gathered as there can now be
tables that have significantly changed during the upgrade or new tables
that do not have statistics gathered yet.
[oracle@srv1 admin]$
[oracle@srv1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 15 13:36:37 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> @/home/oracle/scripts/preupgrade_fixups.sql
Executing Oracle PRE-Upgrade Fixup Script
Auto-Generated by: Oracle Preupgrade Script
Version: 12.2.0.1.0 Build: 1
Generated on: 2020-07-15 13:22:01
For Source Database: RAC
Source Database Version: 12.1.0.2.0
For Upgrade to Version: 12.2.0.1.0
Fixup
Check Name Status Further DBA Action
---------- ------ ------------------
min_recovery_area_size Passed None
dictionary_stats Passed None
apex_upgrade_msg Failed Manual fixup recommended.
PL/SQL procedure successfully completed.
SQL> EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
PL/SQL procedure successfully completed.
SQL> SELECT OWNER, OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS='INVALID';
no rows selected
SQL> SELECT OWNER, OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE LIKE '%MATERIA%';
no rows selected
SQL> PURGE DBA_RECYCLEBIN;
DBA Recyclebin purged.
SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON (Value should beset to TRUE )
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
SQL> exit
- Upgrading Oracle RAC Database
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
cd $ORACLE_HOME/bin
cd $ORACLE_HOME/bin
./dbua
CDB RAC DBUA Screenshot (This is different upgrade only for reference)
- Post-upgrade Tasks
- Change oracle home and grid home on .bash_profile on both the node using oracle and grid user .bash_profile .
- Copy tnsnames.ora file from old location to new db location.(cp /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/*.ora /u01/app/oracle/product/12.2.0/db_1/network/admin)
- Delete archivelog from rman generated during upgradation
- Execute postupgrade_fixups.sql script
[oracle@srv1 ~]$ . oraenv
ORACLE_SID = [rac1] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srv1 ~]$ export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1
[oracle@srv1 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@srv1 ~]$ rman target /
Recovery Manager: Release 12.2.0.1.0 - Production on Wed Jul 15 20:29:30 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: RAC (DBID=2631155449)
RMAN> delete archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=68 instance=rac1 device type=DISK
List of Archived Log Copies for database with db_unique_name RAC
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
63 1 38 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_38.323.1045322661
65 1 39 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_39.325.1045328511
68 1 40 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_40.328.1045329577
69 1 41 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_41.329.1045329581
71 1 42 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_42.331.1045334199
73 1 43 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_43.333.1045334211
74 1 44 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_44.335.1045764749
76 1 45 A 14-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_45.336.1045764775
78 1 46 A 14-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_46.338.1045769549
79 1 47 A 14-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_47.339.1045769549
80 1 48 A 14-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_48.340.1045829415
83 1 49 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_49.343.1045834081
84 1 50 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_50.344.1045835241
86 1 51 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_51.346.1045836399
87 1 52 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_52.347.1045836483
88 1 53 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_53.348.1045836591
89 1 54 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_54.349.1045836697
90 1 55 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_55.350.1045836779
91 1 56 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_56.351.1045836903
92 1 57 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_57.352.1045836991
93 1 58 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_58.353.1045837059
94 1 59 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_59.354.1045837113
95 1 60 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_60.355.1045837215
96 1 61 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_61.356.1045837291
97 1 62 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_62.357.1045837365
98 1 63 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_63.358.1045837413
99 1 64 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_64.359.1045837463
100 1 65 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_65.360.1045837499
101 1 66 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_66.361.1045837553
102 1 67 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_67.362.1045837611
103 1 68 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_68.363.1045837691
104 1 69 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_69.364.1045837765
105 1 70 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_70.365.1045838075
106 1 71 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_71.366.1045838485
107 1 72 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_72.367.1045838809
108 1 73 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_73.368.1045838889
109 1 74 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_74.369.1045839025
110 1 75 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_75.370.1045839181
111 1 76 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_76.261.1045839231
112 1 77 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_77.262.1045839535
113 1 78 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_78.263.1045842871
114 1 79 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_79.264.1045843019
115 1 80 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_80.265.1045843361
116 1 81 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_81.266.1045843599
117 1 82 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_82.267.1045843757
118 1 83 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_83.268.1045843893
119 1 84 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_84.269.1045844039
120 1 85 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_85.270.1045844087
121 1 86 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_86.271.1045844111
122 1 87 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_87.272.1045844137
123 1 88 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_88.273.1045844161
124 1 89 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_89.274.1045844189
125 1 90 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_90.275.1045844219
126 1 91 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_91.276.1045844249
127 1 92 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_92.277.1045844275
128 1 93 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_93.278.1045844379
129 1 94 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_94.279.1045844575
130 1 95 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_95.280.1045844727
131 1 96 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_96.281.1045844883
132 1 97 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_97.282.1045845035
133 1 98 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_98.283.1045845139
134 1 99 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_99.284.1045845187
135 1 100 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_100.285.1045845335
136 1 101 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_101.286.1045845411
137 1 102 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_102.287.1045845537
138 1 103 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_103.288.1045845659
139 1 104 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_104.289.1045845925
140 1 105 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_105.290.1045846117
141 1 106 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_106.291.1045846325
142 1 107 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_107.292.1045847171
143 1 108 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_108.293.1045847333
144 1 109 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_109.294.1045847383
145 1 110 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_110.295.1045847493
146 1 111 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_111.296.1045847599
147 1 112 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_112.297.1045847707
148 1 113 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_113.298.1045847795
149 1 114 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_114.299.1045847895
150 1 115 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_115.300.1045848003
151 1 116 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_116.301.1045848049
152 1 117 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_117.302.1045848119
153 1 118 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_118.303.1045848159
154 1 119 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_119.304.1045848205
155 1 120 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_120.305.1045848271
156 1 121 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_121.306.1045848337
157 1 122 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_122.307.1045848439
158 1 123 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_123.308.1045848603
159 1 124 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_124.309.1045848649
160 1 125 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_125.310.1045848747
161 1 126 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_126.311.1045848793
162 1 127 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_127.312.1045848861
163 1 128 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_128.313.1045848901
164 1 129 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_129.314.1045848957
165 1 130 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_130.315.1045849015
166 1 131 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_131.316.1045849221
167 1 132 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_132.317.1045849399
168 1 133 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_133.318.1045849507
169 1 134 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_134.319.1045849571
170 1 135 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_135.320.1045849659
171 1 136 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_136.371.1045849717
172 1 137 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_137.372.1045849923
173 1 138 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_138.373.1045850181
174 1 139 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_139.374.1045850309
175 1 140 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_140.375.1045850443
176 1 141 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_141.376.1045850473
177 1 142 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_142.377.1045850493
178 1 143 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_143.378.1045850575
179 1 144 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_144.379.1045850675
180 1 145 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_145.380.1045850709
181 1 146 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_146.381.1045850891
182 1 147 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_147.382.1045850929
183 1 148 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_148.383.1045850961
184 1 149 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_149.384.1045850991
185 1 150 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_150.385.1045851265
186 1 151 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_151.386.1045851515
187 1 152 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_152.387.1045851901
188 1 153 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_153.388.1045852173
189 1 154 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_154.389.1045852475
190 1 155 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_155.390.1045852775
191 1 156 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_156.391.1045853067
192 1 157 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_157.392.1045853473
193 1 158 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_158.393.1045853507
194 1 159 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_159.394.1045853531
195 1 160 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_160.395.1045854085
196 1 161 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_161.396.1045854153
197 1 162 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_162.397.1045854187
198 1 163 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_163.398.1045854275
199 1 164 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_164.399.1045854291
200 1 165 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_165.400.1045854373
201 1 166 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_166.401.1045854709
202 1 167 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_167.402.1045854967
203 1 168 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_168.403.1045855659
204 1 169 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_169.404.1045855781
205 1 170 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_170.405.1045855905
206 1 171 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_171.406.1045856163
207 1 172 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_172.407.1045856297
208 1 173 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_173.408.1045856383
209 1 174 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_174.409.1045856475
210 1 175 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_175.410.1045856641
211 1 176 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_176.411.1045856863
212 1 177 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_177.412.1045857027
213 1 178 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_178.413.1045857253
214 1 179 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_179.414.1045857517
215 1 180 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_180.415.1045857755
61 2 32 A 06-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_32.321.1045309215
62 2 33 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_33.322.1045310807
64 2 34 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_34.324.1045322671
66 2 35 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_35.326.1045328531
67 2 36 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_36.327.1045328539
70 2 37 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_37.330.1045330819
72 2 38 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_38.332.1045334201
75 2 39 A 09-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_14/thread_2_seq_39.334.1045764743
77 2 40 A 14-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_14/thread_2_seq_40.337.1045769547
81 2 41 A 14-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_2_seq_41.341.1045829427
82 2 42 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_2_seq_42.342.1045829431
85 2 43 A 15-JUL-20
Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_2_seq_43.345.1045835981
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_38.323.1045322661 RECID=63 STAMP=1045322665
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_39.325.1045328511 RECID=65 STAMP=1045328524
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_40.328.1045329577 RECID=68 STAMP=1045329579
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_41.329.1045329581 RECID=69 STAMP=1045329581
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_42.331.1045334199 RECID=71 STAMP=1045334204
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_43.333.1045334211 RECID=73 STAMP=1045334212
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_44.335.1045764749 RECID=74 STAMP=1045764758
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_45.336.1045764775 RECID=76 STAMP=1045764778
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_46.338.1045769549 RECID=78 STAMP=1045769548
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_47.339.1045769549 RECID=79 STAMP=1045769549
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_48.340.1045829415 RECID=80 STAMP=1045829422
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_49.343.1045834081 RECID=83 STAMP=1045834083
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_50.344.1045835241 RECID=84 STAMP=1045835242
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_51.346.1045836399 RECID=86 STAMP=1045836402
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_52.347.1045836483 RECID=87 STAMP=1045836485
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_53.348.1045836591 RECID=88 STAMP=1045836595
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_54.349.1045836697 RECID=89 STAMP=1045836700
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_55.350.1045836779 RECID=90 STAMP=1045836781
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_56.351.1045836903 RECID=91 STAMP=1045836905
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_57.352.1045836991 RECID=92 STAMP=1045836993
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_58.353.1045837059 RECID=93 STAMP=1045837061
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_59.354.1045837113 RECID=94 STAMP=1045837115
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_60.355.1045837215 RECID=95 STAMP=1045837218
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_61.356.1045837291 RECID=96 STAMP=1045837294
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_62.357.1045837365 RECID=97 STAMP=1045837369
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_63.358.1045837413 RECID=98 STAMP=1045837417
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_64.359.1045837463 RECID=99 STAMP=1045837469
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_65.360.1045837499 RECID=100 STAMP=1045837503
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_66.361.1045837553 RECID=101 STAMP=1045837559
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_67.362.1045837611 RECID=102 STAMP=1045837615
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_68.363.1045837691 RECID=103 STAMP=1045837694
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_69.364.1045837765 RECID=104 STAMP=1045837767
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_70.365.1045838075 RECID=105 STAMP=1045838078
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_71.366.1045838485 RECID=106 STAMP=1045838488
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_72.367.1045838809 RECID=107 STAMP=1045838813
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_73.368.1045838889 RECID=108 STAMP=1045838890
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_74.369.1045839025 RECID=109 STAMP=1045839026
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_75.370.1045839181 RECID=110 STAMP=1045839185
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_76.261.1045839231 RECID=111 STAMP=1045839237
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_77.262.1045839535 RECID=112 STAMP=1045839537
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_78.263.1045842871 RECID=113 STAMP=1045842873
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_79.264.1045843019 RECID=114 STAMP=1045843021
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_80.265.1045843361 RECID=115 STAMP=1045843369
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_81.266.1045843599 RECID=116 STAMP=1045843602
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_82.267.1045843757 RECID=117 STAMP=1045843759
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_83.268.1045843893 RECID=118 STAMP=1045843895
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_84.269.1045844039 RECID=119 STAMP=1045844041
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_85.270.1045844087 RECID=120 STAMP=1045844101
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_86.271.1045844111 RECID=121 STAMP=1045844120
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_87.272.1045844137 RECID=122 STAMP=1045844144
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_88.273.1045844161 RECID=123 STAMP=1045844175
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_89.274.1045844189 RECID=124 STAMP=1045844193
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_90.275.1045844219 RECID=125 STAMP=1045844232
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_91.276.1045844249 RECID=126 STAMP=1045844255
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_92.277.1045844275 RECID=127 STAMP=1045844281
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_93.278.1045844379 RECID=128 STAMP=1045844382
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_94.279.1045844575 RECID=129 STAMP=1045844576
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_95.280.1045844727 RECID=130 STAMP=1045844730
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_96.281.1045844883 RECID=131 STAMP=1045844885
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_97.282.1045845035 RECID=132 STAMP=1045845038
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_98.283.1045845139 RECID=133 STAMP=1045845142
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_99.284.1045845187 RECID=134 STAMP=1045845190
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_100.285.1045845335 RECID=135 STAMP=1045845337
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_101.286.1045845411 RECID=136 STAMP=1045845413
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_102.287.1045845537 RECID=137 STAMP=1045845540
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_103.288.1045845659 RECID=138 STAMP=1045845664
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_104.289.1045845925 RECID=139 STAMP=1045845928
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_105.290.1045846117 RECID=140 STAMP=1045846119
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_106.291.1045846325 RECID=141 STAMP=1045846328
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_107.292.1045847171 RECID=142 STAMP=1045847173
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_108.293.1045847333 RECID=143 STAMP=1045847342
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_109.294.1045847383 RECID=144 STAMP=1045847392
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_110.295.1045847493 RECID=145 STAMP=1045847496
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_111.296.1045847599 RECID=146 STAMP=1045847602
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_112.297.1045847707 RECID=147 STAMP=1045847710
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_113.298.1045847795 RECID=148 STAMP=1045847798
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_114.299.1045847895 RECID=149 STAMP=1045847898
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_115.300.1045848003 RECID=150 STAMP=1045848006
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_116.301.1045848049 RECID=151 STAMP=1045848050
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_117.302.1045848119 RECID=152 STAMP=1045848122
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_118.303.1045848159 RECID=153 STAMP=1045848163
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_119.304.1045848205 RECID=154 STAMP=1045848207
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_120.305.1045848271 RECID=155 STAMP=1045848274
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_121.306.1045848337 RECID=156 STAMP=1045848339
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_122.307.1045848439 RECID=157 STAMP=1045848447
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_123.308.1045848603 RECID=158 STAMP=1045848605
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_124.309.1045848649 RECID=159 STAMP=1045848650
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_125.310.1045848747 RECID=160 STAMP=1045848752
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_126.311.1045848793 RECID=161 STAMP=1045848797
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_127.312.1045848861 RECID=162 STAMP=1045848864
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_128.313.1045848901 RECID=163 STAMP=1045848904
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_129.314.1045848957 RECID=164 STAMP=1045848959
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_130.315.1045849015 RECID=165 STAMP=1045849019
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_131.316.1045849221 RECID=166 STAMP=1045849222
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_132.317.1045849399 RECID=167 STAMP=1045849401
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_133.318.1045849507 RECID=168 STAMP=1045849510
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_134.319.1045849571 RECID=169 STAMP=1045849575
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_135.320.1045849659 RECID=170 STAMP=1045849661
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_136.371.1045849717 RECID=171 STAMP=1045849721
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_137.372.1045849923 RECID=172 STAMP=1045849924
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_138.373.1045850181 RECID=173 STAMP=1045850183
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_139.374.1045850309 RECID=174 STAMP=1045850311
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_140.375.1045850443 RECID=175 STAMP=1045850445
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_141.376.1045850473 RECID=176 STAMP=1045850477
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_142.377.1045850493 RECID=177 STAMP=1045850496
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_143.378.1045850575 RECID=178 STAMP=1045850577
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_144.379.1045850675 RECID=179 STAMP=1045850678
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_145.380.1045850709 RECID=180 STAMP=1045850710
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_146.381.1045850891 RECID=181 STAMP=1045850897
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_147.382.1045850929 RECID=182 STAMP=1045850934
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_148.383.1045850961 RECID=183 STAMP=1045850965
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_149.384.1045850991 RECID=184 STAMP=1045850997
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_150.385.1045851265 RECID=185 STAMP=1045851266
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_151.386.1045851515 RECID=186 STAMP=1045851517
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_152.387.1045851901 RECID=187 STAMP=1045851903
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_153.388.1045852173 RECID=188 STAMP=1045852175
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_154.389.1045852475 RECID=189 STAMP=1045852476
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_155.390.1045852775 RECID=190 STAMP=1045852778
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_156.391.1045853067 RECID=191 STAMP=1045853069
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_157.392.1045853473 RECID=192 STAMP=1045853475
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_158.393.1045853507 RECID=193 STAMP=1045853510
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_159.394.1045853531 RECID=194 STAMP=1045853533
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_160.395.1045854085 RECID=195 STAMP=1045854087
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_161.396.1045854153 RECID=196 STAMP=1045854161
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_162.397.1045854187 RECID=197 STAMP=1045854193
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_163.398.1045854275 RECID=198 STAMP=1045854281
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_164.399.1045854291 RECID=199 STAMP=1045854294
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_165.400.1045854373 RECID=200 STAMP=1045854375
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_166.401.1045854709 RECID=201 STAMP=1045854712
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_167.402.1045854967 RECID=202 STAMP=1045854969
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_168.403.1045855659 RECID=203 STAMP=1045855661
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_169.404.1045855781 RECID=204 STAMP=1045855787
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_170.405.1045855905 RECID=205 STAMP=1045855906
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_171.406.1045856163 RECID=206 STAMP=1045856164
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_172.407.1045856297 RECID=207 STAMP=1045856300
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_173.408.1045856383 RECID=208 STAMP=1045856385
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_174.409.1045856475 RECID=209 STAMP=1045856478
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_175.410.1045856641 RECID=210 STAMP=1045856642
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_176.411.1045856863 RECID=211 STAMP=1045856865
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_177.412.1045857027 RECID=212 STAMP=1045857029
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_178.413.1045857253 RECID=213 STAMP=1045857254
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_179.414.1045857517 RECID=214 STAMP=1045857519
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_180.415.1045857755 RECID=215 STAMP=1045857756
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_32.321.1045309215 RECID=61 STAMP=1045309221
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_33.322.1045310807 RECID=62 STAMP=1045310812
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_34.324.1045322671 RECID=64 STAMP=1045322679
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_35.326.1045328531 RECID=66 STAMP=1045328534
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_36.327.1045328539 RECID=67 STAMP=1045328541
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_37.330.1045330819 RECID=70 STAMP=1045330821
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_38.332.1045334201 RECID=72 STAMP=1045334205
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_14/thread_2_seq_39.334.1045764743 RECID=75 STAMP=1045764768
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_14/thread_2_seq_40.337.1045769547 RECID=77 STAMP=1045769546
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_2_seq_41.341.1045829427 RECID=81 STAMP=1045829429
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_2_seq_42.342.1045829431 RECID=82 STAMP=1045829431
deleted archived log
archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_2_seq_43.345.1045835981 RECID=85 STAMP=1045835982
Deleted 155 objects
RMAN> exit
Recovery Manager complete.
[oracle@srv1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Jul 15 20:35:21 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> @/home/oracle/scripts/postupgrade_fixups.sql
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Package created.
No errors.
Package body created.
No errors.
Package created.
No errors.
Package body created.
No errors.
Executing Oracle POST-Upgrade Fixup Script
Auto-Generated by: Oracle Preupgrade Script
Version: 12.2.0.1.0 Build: 1
Generated on: 2020-07-15 13:22:15
For Source Database: RAC
Source Database Version: 12.1.0.2.0
For Upgrade to Version: 12.2.0.1.0
Fixup
Check Name Status Further DBA Action
---------- ------ ------------------
old_time_zones_exist Passed None
post_dictionary Passed None
PL/SQL procedure successfully completed.
Session altered.
SQL>
- Check the status of clusterware and database
[grid@srv2 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMIBNETLSNR_ASM.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.CRS.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.DATA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.FRA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE OFFLINE srv2 STABLE
ora.chad
ONLINE OFFLINE srv1 STABLE
ONLINE OFFLINE srv2 STABLE
ora.net1.network
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.ons
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.proxy_advm
OFFLINE OFFLINE srv1 STABLE
OFFLINE OFFLINE srv2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE srv1 169.254.224.241 192.
168.10.1,STABLE
ora.asm
1 ONLINE ONLINE srv1 Started,STABLE
2 ONLINE ONLINE srv2 Started,STABLE
ora.cvu
1 ONLINE ONLINE srv1 STABLE
ora.mgmtdb
1 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.qosmserver
1 ONLINE ONLINE srv1 STABLE
ora.rac.db
1 ONLINE ONLINE srv1 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
2 ONLINE ONLINE srv2 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan2.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan3.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv1.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv2.vip
1 ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
[grid@srv2 ~]$ srvctl status database -d rac
Instance rac1 is running on node srv1
Instance rac2 is running on node srv2
[grid@srv2 ~]$
No comments:
Post a Comment