19c autoupgrade prechecks fails with error DISK_SPACE_FOR_RECOVERY_AREA
Issue:
19c autoupgrade prechecks fails with error DISK_SPACE_FOR_RECOVERY_AREA
Error Message:
Check failed for UAT1, manual intervention needed for the below checks
[DISK_SPACE_FOR_RECOVERY_AREA]
Cause:
1. Enough Physical space is not available for FRA location either of at OS file system level or at ASM diskgroup level
2. Does not have enough FRA free space inside the database
Fix:
1. Make enough physical space is available for FRA location either OS file system or ASM diskgroups
2. Increase the FRA free space inside the database
Error Logs and commands output:
1. Create config file using auto-upgrade jar file.
[oracle@oraclelab1 19c-autoupg]$ env |grep ORA
ORACLE_SID=UAT1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/dbhome_1
[oracle@oraclelab1 19c-autoupg]$ /u01/app/oracle/product/19.0.0.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/admin/autoupgrade.jar -create_sample_file config
Created sample configuration file /u01/patches/19c-autoupg/sample_config.cfg
[oracle@oraclelab1 19c-autoupg]$
2. Modify the config file according to the target database which are planning to upgrade
[oracle@oraclelab1 19c-autoupg]$ cp sample_config.cfg UAT_config.cfg
[oracle@oraclelab1 19c-autoupg]$ vi UAT_config.cfg
3. Run the auto-upgrade prechks in ANALYZE mode which reported the failure
[oracle@oraclelab1 19c-autoupg]$ /u01/app/oracle/product/19.0.0.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/admin/autoupgrade.jar -config UAT_config.cfg -mode ANALYZE
AutoUpgrade 24.8.241119 launched with default internal options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 Non-CDB(s) will be analyzed
Type 'help' to list console commands
upg> upg> upg>
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------------------+
| 100| UAT1|PRECHECKS|EXECUTING|RUNNING| 10:28:06| 2s ago|Loading database information|
+----+-------+---------+---------+-------+----------+-------+----------------------------+
Total jobs 1
upg>
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 100| UAT1|PRECHECKS|EXECUTING|RUNNING| 10:28:06| 0s ago|Executing Checks|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> Job 100 completed
------------------- Final Summary --------------------
Number of databases [ 1 ]
Jobs finished [1]
Jobs failed [0]
Please check the summary report at:
/u01/patches/19c-autoupg/cfgtoollogs/upgrade/auto/status/status.html
/u01/patches/19c-autoupg/cfgtoollogs/upgrade/auto/status/status.log
[oracle@oraclelab1 19c-autoupg]$
4. Error message reported on the prechecks log
[oracle@oraclelab1 19c-autoupg]$ more /u01/patches/19c-autoupg/cfgtoollogs/upgrade/auto/status/status.log
==========================================
Autoupgrade Summary Report
==========================================
[Date] Thu May 08 10:28:43 IST 2025
[Number of Jobs] 1
==========================================
[Job ID] 100
==========================================
[DB Name] UAT
[Version Before Upgrade] 12.2.0.1.0
[Version After Upgrade] 19.17.0.0.0
------------------------------------------
[Stage Name] PRECHECKS
[Status] FAILURE
[Start Time] 2025-05-08 10:28:06
[Duration] 0:00:36
[Log Directory] /u01/patches/19c-autoupg/UAT/UAT1/100/prechecks
[Detail] /u01/patches/19c-autoupg/UAT/UAT1/100/prechecks/uat_preupgrade.log
Check failed for UAT1, manual intervention needed for the below checks
[DISK_SPACE_FOR_RECOVERY_AREA]
Cause:The following checks have ERROR severity and no auto fixup is available or
the fixup failed to resolve the issue. Fix them before continuing:
UAT1 DISK_SPACE_FOR_RECOVERY_AREA
Reason:Database Checks has Failed details in /u01/patches/19c-autoupg/UAT/UAT1/100/prechecks
Action:[MANUAL]
Info:Return status is ERROR
ExecutionError:No
Error Message:The following checks have ERROR severity and no auto fixup is available or
the fixup failed to resolve the issue. Fix them before continuing:
UAT1 DISK_SPACE_FOR_RECOVERY_AREA
------------------------------------------
[oracle@oraclelab1 19c-autoupg]$
5. Increase the physical free space inside the ASM diskgroup since the database is resides inside ASM diskgroup and FRA a location is set to +RECO diskgroup
[oracle@oraclelab1 dbhome_1]$ . oraenv
ORACLE_SID = [oracle] ? +ASM1
The Oracle base has been set to /u01/app/oracle
[oracle@oraclelab1 dbhome_1]$
[oracle@oraclelab1 dbhome_1]$ asmcmd -p
ASMCMD [+] > lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 20476 4888 0 4888 0 N DATA/
MOUNTED EXTERN N 512 512 4096 4194304 3068 2668 0 2668 0 Y OCR/
MOUNTED EXTERN N 512 512 4096 4194304 20472 2388 0 2388 0 N RECO/
ASMCMD [+] > cd RECO/DEV/ARCHIVELOG/
ASMCMD [+RECO/DEV/ARCHIVELOG] > rm -rf *
ASMCMD [+RECO/DEV/ARCHIVELOG] > lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 20476 4888 0 4888 0 N DATA/
MOUNTED EXTERN N 512 512 4096 4194304 3068 2668 0 2668 0 Y OCR/
MOUNTED EXTERN N 512 512 4096 4194304 20472 6884 0 6884 0 N RECO/
ASMCMD [+RECO/DEV] > cd +RECO/TEST/ARCHIVELOG]
ASMCMD [+RECO/TEST/ARCHIVELOG] > rm -rf *
ASMCMD [+RECO/TEST/ARCHIVELOG] > lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 20476 4888 0 4888 0 N DATA/
MOUNTED EXTERN N 512 512 4096 4194304 3068 2668 0 2668 0 Y OCR/
MOUNTED EXTERN N 512 512 4096 4194304 20472 11376 0 11376 0 N RECO/
ASMCMD [+RECO/TEST/ARCHIVELOG] >
ASMCMD [+RECO/TEST/ARCHIVELOG] > exit
[oracle@oraclelab1 dbhome_1]$
6. Increase the FRA free space inside the database.
[oracle@oraclelab1 19c-autoupg]$ . oraenv
ORACLE_SID = [oracle] ? UAT1
The Oracle base has been set to /u01/app/oracle
[oracle@oraclelab1 19c-autoupg]
[oracle@oraclelab1 19c-autoupg]$sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Thu May 8 10:31:09 2025
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +RECO
db_recovery_file_dest_size big integer 8016M
recovery_parallelism integer 0
remote_recovery_file_dest string
SQL> alter system set db_recovery_file_dest_size=20G;
System altered.
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +RECO
db_recovery_file_dest_size big integer 20G
recovery_parallelism integer 0
remote_recovery_file_dest string
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@oraclelab1 19c-autoupg]$
7. Rerun the auto-upgrade prechks in ANALYZE mode which got completed successfully
[oracle@oraclelab1 19c-autoupg]$ /u01/app/oracle/product/19.0.0.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/admin/autoupgrade.jar -config UAT_config.cfg -mode ANALYZE
AutoUpgrade 24.8.241119 launched with default internal options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 Non-CDB(s) will be analyzed
Type 'help' to list console commands
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| UAT1|PRECHECKS|EXECUTING|RUNNING| 10:41:22| 0s ago|Executing Checks|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> Job 102 completed
------------------- Final Summary --------------------
Number of databases [ 1 ]
Jobs finished [1]
Jobs failed [0]
Please check the summary report at:
/u01/patches/19c-autoupg/cfgtoollogs/upgrade/auto/status/status.html
/u01/patches/19c-autoupg/cfgtoollogs/upgrade/auto/status/status.log
[oracle@oraclelab1 19c-autoupg]$ more /u01/patches/19c-autoupg/cfgtoollogs/upgrade/auto/status/status.log
==========================================
Autoupgrade Summary Report
==========================================
[Date] Thu May 08 10:41:42 IST 2025
[Number of Jobs] 1
==========================================
[Job ID] 102
==========================================
[DB Name] UAT
[Version Before Upgrade] 12.2.0.1.0
[Version After Upgrade] 19.17.0.0.0
------------------------------------------
[Stage Name] PRECHECKS
[Status] SUCCESS
[Start Time] 2025-05-08 10:41:22
[Duration] 0:00:20
[Log Directory] /u01/patches/19c-autoupg/UAT/UAT1/102/prechecks
[Detail] /u01/patches/19c-autoupg/UAT/UAT1/102/prechecks/uat_preupgrade.log
Check passed and no manual intervention needed
------------------------------------------
[oracle@oraclelab1 19c-autoupg]$
No comments:
Post a Comment