About DATABASE

12.2.0.1

grid 엔진 롤백

grid rollback  root 유저로 진행 - 1번 서버 진행

[root@arac1 33583921]# cd /u01/app/12c/grid
[root@arac1 grid]# cd OPatch
[root@arac1 OPatch]# ./opatchauto rollback /media/33583921/ -oh /u01/app/12c/grid

OPatchauto session is initiated at Fri Jan 26 15:10:04 2024

System initialization log file is /u01/app/12c/grid/cfgtoollogs/opatchautodb/systemconfig2024-01-26_03-10-12PM.log.

세션 로그 파일은 /u01/app/12c/grid/cfgtoollogs/opatchauto/opatchauto2024-01-26_03-10-54PM.log입니다.
이 세션의 ID는 KR4L입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12c/grid
Patch applicability verified successfully on home /u01/app/12c/grid


Executing patch validation checks on home /u01/app/12c/grid
Patch validation checks successfully completed on home /u01/app/12c/grid


Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/12c/grid

Prepatch operation log file location: /u01/app/oracle/crsdata/arac1/crsconfig/crspatch_arac1_2024-01-26_03-11-31PM.log
CRS service brought down successfully on home /u01/app/12c/grid


Start rolling back binary patch on home /u01/app/12c/grid
Binary patch rolled back successfully on home /u01/app/12c/grid


Performing postpatch operations on CRS - starting CRS service on home /u01/app/12c/grid
Postpatch operation log file location: /u01/app/oracle/crsdata/arac1/crsconfig/crspatch_arac1_2024-01-26_03-17-01PM.log
CRS service started successfully on home /u01/app/12c/grid

OPatchAuto를 성공했습니다.

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

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

Host:arac1
CRS Home:/u01/app/12c/grid
Version:12.2.0.1.0
Summary:

==Following patches were SUCCESSFULLY rolled back:

Patch: /media/33583921/33678030
Log: /u01/app/12c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_15-15-05오후_1.log

Patch: /media/33583921/33116894
Log: /u01/app/12c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_15-15-05오후_1.log

Patch: /media/33583921/26839277
Log: /u01/app/12c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_15-15-05오후_1.log

Patch: /media/33583921/33610989
Log: /u01/app/12c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_15-15-05오후_1.log

Patch: /media/33583921/33587128
Log: /u01/app/12c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_15-15-05오후_1.log



OPatchauto session completed at Fri Jan 26 15:27:56 2024
Time taken to complete the session 17 minutes, 53 seconds

============================================================================================

grid rollback  root 유저로 진행 - 2번 서버 진행

[root@arac2 media]# cd /u01/app/12c/grid
[root@arac2 grid]# cd OPatch
[root@arac2 OPatch]# ./opatchauto rollback /media/33583921/ -oh /u01/app/12c/grid

OPatchauto session is initiated at Fri Jan 26 15:29:27 2024

System initialization log file is /u01/app/12c/grid/cfgtoollogs/opatchautodb/systemconfig2024-01-26_03-29-31PM.log.

세션 로그 파일은 /u01/app/12c/grid/cfgtoollogs/opatchauto/opatchauto2024-01-26_03-29-51PM.log입니다.
이 세션의 ID는 3QLA입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12c/grid
Patch applicability verified successfully on home /u01/app/12c/grid


Executing patch validation checks on home /u01/app/12c/grid
Patch validation checks successfully completed on home /u01/app/12c/grid


Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/12c/grid
Prepatch operation log file location: /u01/app/oracle/crsdata/arac2/crsconfig/crspatch_arac2_2024-01-26_03-30-23PM.log
CRS service brought down successfully on home /u01/app/12c/grid


Start rolling back binary patch on home /u01/app/12c/grid
Binary patch rolled back successfully on home /u01/app/12c/grid


Performing postpatch operations on CRS - starting CRS service on home /u01/app/12c/grid
Postpatch operation log file location: /u01/app/oracle/crsdata/arac2/crsconfig/crspatch_arac2_2024-01-26_03-35-05PM.log
CRS service started successfully on home /u01/app/12c/grid

OPatchAuto를 성공했습니다.

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

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

Host:arac2
CRS Home:/u01/app/12c/grid
Version:12.2.0.1.0
Summary:

==Following patches were SUCCESSFULLY rolled back:

Patch: /media/33583921/33678030
Log: /u01/app/12c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_15-32-55오후_1.log

Patch: /media/33583921/33116894
Log: /u01/app/12c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_15-32-55오후_1.log

Patch: /media/33583921/26839277
Log: /u01/app/12c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_15-32-55오후_1.log

Patch: /media/33583921/33610989
Log: /u01/app/12c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_15-32-55오후_1.log

Patch: /media/33583921/33587128
Log: /u01/app/12c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_15-32-55오후_1.log



OPatchauto session completed at Fri Jan 26 15:37:35 2024
Time taken to complete the session 8 minutes, 8 seconds

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

DB 엔진 롤백

oracle rollback  root 유저로 진행 - 1번 서버 진행

[root@arac1 33583921]# /u01/app/oracle/product/12c/db_1/OPatch/opatchauto rollback /media/33583921 -oh /u01/app/oracle/product/12c/db_1

OPatchauto session is initiated at Fri Jan 26 16:51:14 2024

System initialization log file is /u01/app/oracle/product/12c/db_1/cfgtoollogs/opatchautodb/systemconfig2024-01-26_04-51-17PM.log.

세션 로그 파일은 /u01/app/oracle/product/12c/db_1/cfgtoollogs/opatchauto/opatchauto2024-01-26_04-52-08PM.log입니다.
이 세션의 ID는 JBEF입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12c/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12c/db_1


Executing patch validation checks on home /u01/app/oracle/product/12c/db_1
Patch validation checks successfully completed on home /u01/app/oracle/product/12c/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/12c/db_1
"[/bin/sh -c 'cd /u01/app/oracle/product/12c/db_1; ORACLE_HOME=/u01/app/oracle/product/12c/db_1 ORACLE_SID=aracdb1 /u01/app/oracle/product/12c/db_1/OPatch/datapatch -prereq -verbose']" command failed with errors. Please refer to logs for more details. SQL changes, if any, can be analyzed by manually retrying the same command.

SQL patch applicability verified successfully on home /u01/app/oracle/product/12c/db_1


Preparing to bring down database service on home /u01/app/oracle/product/12c/db_1
Successfully prepared home /u01/app/oracle/product/12c/db_1 to bring down database service


Bringing down database service on home /u01/app/oracle/product/12c/db_1
Database service successfully brought down on home /u01/app/oracle/product/12c/db_1


Performing prepatch operation on home /u01/app/oracle/product/12c/db_1
Prepatch operation completed successfully on home /u01/app/oracle/product/12c/db_1


Start rolling back binary patch on home /u01/app/oracle/product/12c/db_1
Binary patch rolled back successfully on home /u01/app/oracle/product/12c/db_1


Performing postpatch operation on home /u01/app/oracle/product/12c/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12c/db_1


Starting database service on home /u01/app/oracle/product/12c/db_1
Database service successfully started on home /u01/app/oracle/product/12c/db_1


Preparing home /u01/app/oracle/product/12c/db_1 after database service restarted
No step execution required.........
 

Trying to roll back SQL patch on home /u01/app/oracle/product/12c/db_1
No SQL patch operations are required on local node for this home

OPatchAuto를 성공했습니다.

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

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

Host:arac1
RAC Home:/u01/app/oracle/product/12c/db_1
Version:12.2.0.1.0
Summary:

==Following patches were SKIPPED:

Patch: /media/33583921/33116894
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/33583921/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/33583921/33610989
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY rolled back:

Patch: /media/33583921/33678030
Log: /u01/app/oracle/product/12c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_16-52-53오후_1.log

Patch: /media/33583921/33587128
Log: /u01/app/oracle/product/12c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_16-52-53오후_1.log



OPatchauto session completed at Fri Jan 26 16:55:48 2024
Time taken to complete the session 4 minutes, 34 seconds
[root@arac1 33583921]#
=================================================================================

oracle rollback  root 유저로 진행 - 2번 서버 진행

[root@arac2 ~]#  /u01/app/oracle/product/12c/db_1/OPatch/opatchauto rollback /media/33583921 -oh /u01/app/oracle/product/12c/db_1

OPatchauto session is initiated at Fri Jan 26 16:56:26 2024

System initialization log file is /u01/app/oracle/product/12c/db_1/cfgtoollogs/opatchautodb/systemconfig2024-01-26_04-56-29PM.log.

세션 로그 파일은 /u01/app/oracle/product/12c/db_1/cfgtoollogs/opatchauto/opatchauto2024-01-26_04-56-55PM.log입니다.
이 세션의 ID는 8D38입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12c/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12c/db_1


Executing patch validation checks on home /u01/app/oracle/product/12c/db_1
Patch validation checks successfully completed on home /u01/app/oracle/product/12c/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/12c/db_1
"[/bin/sh -c 'cd /u01/app/oracle/product/12c/db_1; ORACLE_HOME=/u01/app/oracle/product/12c/db_1 ORACLE_SID=aracdb2 /u01/app/oracle/product/12c/db_1/OPatch/datapatch -prereq -verbose']" command failed with errors. Please refer to logs for more details. SQL changes, if any, can be analyzed by manually retrying the same command.

SQL patch applicability verified successfully on home /u01/app/oracle/product/12c/db_1


Preparing to bring down database service on home /u01/app/oracle/product/12c/db_1
Successfully prepared home /u01/app/oracle/product/12c/db_1 to bring down database service


Bringing down database service on home /u01/app/oracle/product/12c/db_1
Database service successfully brought down on home /u01/app/oracle/product/12c/db_1


Performing prepatch operation on home /u01/app/oracle/product/12c/db_1
Prepatch operation completed successfully on home /u01/app/oracle/product/12c/db_1


Start rolling back binary patch on home /u01/app/oracle/product/12c/db_1
Binary patch rolled back successfully on home /u01/app/oracle/product/12c/db_1


Performing postpatch operation on home /u01/app/oracle/product/12c/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12c/db_1


Starting database service on home /u01/app/oracle/product/12c/db_1
Database service successfully started on home /u01/app/oracle/product/12c/db_1


Preparing home /u01/app/oracle/product/12c/db_1 after database service restarted
No step execution required.........
 

Trying to roll back SQL patch on home /u01/app/oracle/product/12c/db_1
"[/bin/sh -c 'cd /u01/app/oracle/product/12c/db_1;ORACLE_HOME=/u01/app/oracle/product/12c/db_1 ORACLE_SID=aracdb2 /u01/app/oracle/product/12c/db_1/OPatch/datapatch -verbose']" command failed with errors. Please refer to logs for more details. SQL changes, if any, can be rolled back by manually retrying the same command.

SQL patch rolled back successfully on home /u01/app/oracle/product/12c/db_1

OPatchAuto를 성공했습니다.

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

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

Host:arac2
RAC Home:/u01/app/oracle/product/12c/db_1
Version:12.2.0.1.0
Summary:

==Following patches were SKIPPED:

Patch: /media/33583921/33116894
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/33583921/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /media/33583921/33610989
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY rolled back:

Patch: /media/33583921/33678030
Log: /u01/app/oracle/product/12c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_16-57-29오후_1.log

Patch: /media/33583921/33587128
Log: /u01/app/oracle/product/12c/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2024-01-26_16-57-29오후_1.log



OPatchauto session completed at Fri Jan 26 16:59:51 2024
Time taken to complete the session 3 minutes, 26 seconds

[root@arac1 ~]# su - grid
마지막 로그인: 금  1월 26 20:33:37 KST 2024
[+ASM1:/home/grid]> opatch lspatches
이 Oracle 홈에 설치된 Interim 패치가 없습니다 "/u01/app/12c/grid".

[aracdb1:/u01/app/oracle/product/12c/db_1/OPatch]> opatch lspatches
이 Oracle 홈에 설치된 Interim 패치가 없습니다 "/u01/app/oracle/product/12c/db_1".

OPatch succeeded.

[aracdb2:/home/oracle]> crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       arac1                    STABLE
               ONLINE  ONLINE       arac2                    STABLE
ora.CRS.dg
               ONLINE  ONLINE       arac1                    STABLE
               ONLINE  ONLINE       arac2                    STABLE
ora.DATA.dg
               ONLINE  ONLINE       arac1                    STABLE
               ONLINE  ONLINE       arac2                    STABLE
ora.FRA.dg
               ONLINE  ONLINE       arac1                    STABLE
               ONLINE  ONLINE       arac2                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       arac1                    STABLE
               ONLINE  ONLINE       arac2                    STABLE
ora.MGMT.dg
               ONLINE  ONLINE       arac1                    STABLE
               ONLINE  ONLINE       arac2                    STABLE
ora.chad
               ONLINE  ONLINE       arac1                    STABLE
               ONLINE  ONLINE       arac2                    STABLE
ora.net1.network
               ONLINE  ONLINE       arac1                    STABLE
               ONLINE  ONLINE       arac2                    STABLE
ora.ons
               ONLINE  ONLINE       arac1                    STABLE
               ONLINE  ONLINE       arac2                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      arac1                    STABLE
               OFFLINE OFFLINE      arac2                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       arac1                    STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       arac1                    169.254.51.97 192.16
                                                             8.0.111,STABLE
ora.arac1.vip
      1        ONLINE  ONLINE       arac1                    STABLE
ora.arac2.vip
      1        ONLINE  ONLINE       arac2                    STABLE
ora.aracdb.db
      1        ONLINE  ONLINE       arac1                    Open,HOME=/u01/app/o
                                                             racle/product/12c/db
                                                             _1,STABLE
      2        ONLINE  ONLINE       arac2                    Open,HOME=/u01/app/o
                                                             racle/product/12c/db
                                                             _1,STABLE
ora.asm
      1        ONLINE  ONLINE       arac1                    Started,STABLE
      2        ONLINE  ONLINE       arac2                    Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       arac1                    STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       arac1                    Open,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       arac1                    STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       arac1                    STABLE
--------------------------------------------------------------------------------