UPG-1312 AutoUpgrade

OS환경 : Oracle Linux 7.6 (64bit)

DB 환경 : Oracle Database 18.1.0.0

에러 : UPG-1312 AutoUpgrade

18c 에서 19c로 AutoUpgrade 명령으로 업그레이드 작업 중 발생한 문제

AutoUpgrade deploy 명령 실행

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config config.txt -mode deploy AutoUpgrade tool launched with default options Processing config file ... +--------------------------------+ | Starting AutoUpgrade execution | +--------------------------------+ 1 databases will be processed Type 'help' to list console commands upg> lsj -p +----+-------+---------+---------+-------+--------------+--------+--------+---------------+ |Job#|DB_NAME|    STAGE|OPERATION| STATUS|    START_TIME|END_TIME| UPDATED|        MESSAGE| +----+-------+---------+---------+-------+--------------+--------+--------+---------------+ | 103|   orcl|PRECHECKS|PREPARING|RUNNING|20/03/24 00:32|     N/A|00:32:34|Loading DB info| +----+-------+---------+---------+-------+--------------+--------+--------+---------------+ Total jobs 1

작업중 에러발생

-------------------------------------------------
Errors in database [orcl]
Stage     [PREFIXUPS]
Operation [STOPPED]
Status    [ERROR]
Info    [
Error: UPG-1312
[Unexpected Exception Error]
Cause: One of the checks present in the database has an ERROR severity but its fixup is not available.  
This will require a manual fix to the database.
For further details, see the log file located at /home/oracle/upg_logs/orcl/orcl/103/autoupgrade_20200324_user.log]
 
-------------------------------------------------
Logs: [/home/oracle/upg_logs/orcl/orcl/103/autoupgrade_20200324_user.log]
-------------------------------------------------

해당 작업 조회

upg> lsj -p
+----+-------+---------+---------+------+--------------+--------+--------+--------+
|Job#|DB_NAME|    STAGE|OPERATION|STATUS|    START_TIME|END_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+------+--------------+--------+--------+--------+
| 103|   orcl|PREFIXUPS|  STOPPED| ERROR|20/03/24 00:32|     N/A|00:34:04|UPG-1312|
+----+-------+---------+---------+------+--------------+--------+--------+--------+
Total jobs 1

MESSAGE가 UPG-1312로 표시됨

해당 로그 확인

$ cat /home/oracle/upg_logs/orcl/orcl/103/autoupgrade_20200324_user.log
2020-03-24 00:32:33.382 INFO 
build.hash:04dd9f2
build.version:19.7.5
build.date:2020/02/11 15:28:49
build.max_target_version:19
build.type:production
build.label:HEAD
 
2020-03-24 00:32:52.422 INFO Analyzing orcl, 74 checks will run using 2 threads 
2020-03-24 00:33:18.175 INFO Guarantee Restore Point (GRP) successfully removed [ORCL][AUTOUPGRADE_221145114461854_ORCL] 
2020-03-24 00:33:20.324 INFO Guarantee Restore Point (GRP) successfully created [ORCL][AUTOUPGRADE_221145114461854_ORCL] 
2020-03-24 00:33:20.385 INFO Using /home/oracle/upg_logs/orcl/orcl/103/prechecks/orcl_checklist.cfg as reference to determine the fixups which will be executed 
2020-03-24 00:33:20.493 INFO Adding fixup PURGE_RECYCLEBIN to execution queue of orcl 
2020-03-24 00:33:49.482 INFO Analyzing orcl, 74 checks will run using 2 threads 
2020-03-24 00:34:04.641 ERROR The following checks have ERROR severity and no fixup is available or
the fixup failed to resolve the issue. Please fix them manually before continuing:
orcl MIN_RECOVERY_AREA_SIZE 
2020-03-24 00:34:04.668 INFO Starting error management routine 
2020-03-24 00:34:04.674 INFO Ended error management routine 
2020-03-24 00:34:04.677 ERROR Error occurred while running the dispatcher for job 103
Cause: One of the checks present in the database has an ERROR severity but its fixup is not available.  This will require a manual fix to the database. 

해결 방법 : 로그파일에 나온 대로 db_recovery_file_dest_size 크기 증설

db_recovery_file_dest_size 기존 2g 에서 10g 로 변경

SQL> alter system set db_recovery_file_dest_size = 10g;
 
System altered.

확인

SQL> show parameter db_recovery_file
 
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     /home/oracle/fra
db_recovery_file_dest_size         big integer 10G

중단된 작업 재실행

upg> resume -job 103
Resuming job: [103][orcl]
upg> lsj -p
+----+-------+---------+---------+-------+--------------+--------+--------+---------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|    START_TIME|END_TIME| UPDATED|        MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+---------------+
| 103|   orcl|PREFIXUPS|EXECUTING|RUNNING|20/03/24 00:32|     N/A|00:33:27|Loading DB info|
+----+-------+---------+---------+-------+--------------+--------+--------+---------------+
Total jobs 1

정상적으로 실행됨

원인 : db_recovery_file_dest_size 의 값이 부족(사이즈가 적음)

db_recovery_file_dest_size 의 값이 부족(사이즈가 적음)

참조 :