About DATABASE

공유볼륨 설정

{공유볼륨 설정]

cmd 창에서 실행 파일 생성

정해진 크기로 파일 볼륨으로 만듬 추후 ASM 용으로 사용

vboxmanage createmedium --filename CRS1.vdi --size 1024--format VDI --variant Fixed
vboxmanage createmedium --filename CRS 2.vdi --size 1024 --format VDI --variant Fixed
vboxmanage createmedium --filename CRS 3.vdi --size 1024 --format VDI --variant Fixed
vboxmanage createmedium --filename REDATA1.vdi --size 30720 --format VDI --variant Fixed
vboxmanage createmedium --filename REDATA2.vdi --size 30720 --format VDI --variant Fixed
vboxmanage createmedium --filename REDATA3.vdi --size 30720 --format VDI --variant Fixed
vboxmanage createmedium --filename REFRA.vdi --size 20480 --format VDI --variant Fixed

-- 공유볼륨설정

vboxmanage modifymedium CRS1 .vdi --type shareable

vboxmanage modifymedium CRS2 .vdi --type shareable

vboxmanage modifymedium CRS3 .vdi --type shareable
vboxmanage modifymedium REDATA1.vdi --type shareable
vboxmanage modifymedium REDATA2.vdi --type shareable
vboxmanage modifymedium REDATA3.vdi --type shareable
vboxmanage modifymedium REFRA.vdi --type shareable

[INS-08101]
Oracle Database/client Installation fails with Error:[INS-08101] Unexpected error while executing the action at state:'clientSupportedOSCheck' (문서 ID 2584365.1)

export CV_ASSUME_DISTID=OL7                 -- If software is installed on RHEL 8/OL8

-- 다시 실행

./runInstaller

 이 방법은 기존에 rac 운영에 문제가 생겨서 single로 변경 했을 시에

문제 처리가 끝났다고 가정한 후 rac로 바꾸는 방법

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

기존 rac to single 방법

https://theone79.tistory.com/1012

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

crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.CRS.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.DATA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.FRA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.LISTENER.lsnr
               ONLINE  OFFLINE      arac1                    STARTING
ora.MGMT.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.chad
               ONLINE  OFFLINE      arac1                    STABLE
ora.net1.network
               ONLINE  ONLINE       arac1                    STABLE
ora.ons
               ONLINE  ONLINE       arac1                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      arac1                    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  INTERMEDIATE arac1                    FAILED OVER,STABLE
ora.aracdb.db
      1        ONLINE  ONLINE       arac1                    Open,HOME=/u01/app/o
                                                             racle/product/12c/db
                                                             _1,STABLE
      2        OFFLINE OFFLINE                               STABLE
ora.asm
      1        ONLINE  ONLINE       arac1                    Started,STABLE
      2        ONLINE  OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       arac1                    STABLE
ora.mgmtdb
      1        ONLINE  OFFLINE      arac1                    Instance Shutdown,ST
                                                             ARTING
ora.qosmserver
      1        ONLINE  ONLINE       arac1                    STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       arac1                    STABLE
--------------------------------------------------------------------------------

Shutdown  instance 
Shutdown all the listeners.

SQL> shutdown immediate

srvctl stop listener -n arac1
srvctl stop scan_listener
crsctl stat res -t

[aracdb1:/u01/app/oracle/product/12c/db_1/rdbms/lib]> 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
               OFFLINE OFFLINE      arac1                    STABLE
               OFFLINE OFFLINE      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        OFFLINE OFFLINE                               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        OFFLINE OFFLINE                               STABLE
      2        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
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
--------------------------------------------------------------------------------

Relink Oracle executable with rac_on option
  
  [aracdb1:/u01/app/oracle/product/12c/db_1/rdbms/lib]> make -f ins_rdbms.mk rac_on
(if /u01/app/oracle/product/12c/db_1/bin/skgxpinfo | grep rds;\
then \
make -f  /u01/app/oracle/product/12c/db_1/rdbms/lib/ins_rdbms.mk ipc_rds; \
else \
make -f  /u01/app/oracle/product/12c/db_1/rdbms/lib/ins_rdbms.mk ipc_g; \
fi)
make[1]: Entering directory `/u01/app/oracle/product/12c/db_1/rdbms/lib'
rm -f /u01/app/oracle/product/12c/db_1/lib/libskgxp12.so
cp /u01/app/oracle/product/12c/db_1/lib//libskgxpg.so /u01/app/oracle/product/12c/db_1/lib/libskgxp12.so
make[1]: Leaving directory `/u01/app/oracle/product/12c/db_1/rdbms/lib'
 - Use stub SKGXN library
cp /u01/app/oracle/product/12c/db_1/lib/libskgxns.so /u01/app/oracle/product/12c/db_1/lib/libskgxn2.so
/usr/bin/ar d /u01/app/oracle/product/12c/db_1/rdbms/lib/libknlopt.a ksnkcs.o
/usr/bin/ar cr /u01/app/oracle/product/12c/db_1/rdbms/lib/libknlopt.a /u01/app/oracle/product/12c/db_1/rdbms/lib/kcsm.o 
[aracdb1:/u01/app/oracle/product/12c/db_1/rdbms/lib]> make -f ins_rdbms.mk ioracle
chmod 755 /u01/app/oracle/product/12c/db_1/bin

 - Linking Oracle 
rm -f /u01/app/oracle/product/12c/db_1/rdbms/lib/oracle
/u01/app/oracle/product/12c/db_1/bin/orald  -o /u01/app/oracle/product/12c/db_1/rdbms/lib/oracle -m64 -z noexecstack -Wl,--disable-new-dtags -L/u01/app/oracle/product/12c/db_1/rdbms/lib/ -L/u01/app/oracle/product/12c/db_1/lib/ -L/u01/app/oracle/product/12c/db_1/lib/stubs/   -Wl,-E /u01/app/oracle/product/12c/db_1/rdbms/lib/opimai.o /u01/app/oracle/product/12c/db_1/rdbms/lib/ssoraed.o /u01/app/oracle/product/12c/db_1/rdbms/lib/ttcsoi.o -Wl,--whole-archive -lperfsrv12 -Wl,--no-whole-archive /u01/app/oracle/product/12c/db_1/lib/nautab.o /u01/app/oracle/product/12c/db_1/lib/naeet.o /u01/app/oracle/product/12c/db_1/lib/naect.o /u01/app/oracle/product/12c/db_1/lib/naedhs.o /u01/app/oracle/product/12c/db_1/rdbms/lib/config.o  -ldmext -lserver12 -lodm12 -lofs -lcell12 -lnnet12 -lskgxp12 -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lclient12  -lvsn12 -lcommon12 -lgeneric12 -lknlopt `if /usr/bin/ar tv /u01/app/oracle/product/12c/db_1/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap12" ; fi` -lskjcx12 -lslax12 -lpls12  -lrt -lplp12 -ldmext -lserver12 -lclient12  -lvsn12 -lcommon12 -lgeneric12 `if [ -f /u01/app/oracle/product/12c/db_1/lib/libavserver12.a ] ; then echo "-lavserver12" ; else echo "-lavstub12"; fi` `if [ -f /u01/app/oracle/product/12c/db_1/lib/libavclient12.a ] ; then echo "-lavclient12" ; fi` -lknlopt -lslax12 -lpls12  -lrt -lplp12 -ljavavm12 -lserver12  -lwwg  `cat /u01/app/oracle/product/12c/db_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat /u01/app/oracle/product/12c/db_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnnzst12 -lzt12 -lztkg12 -lmm -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lztkg12 `cat /u01/app/oracle/product/12c/db_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat /u01/app/oracle/product/12c/db_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnnzst12 -lzt12 -lztkg12   -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `if /usr/bin/ar tv /u01/app/oracle/product/12c/db_1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo12 -lserver12"; fi` -L/u01/app/oracle/product/12c/db_1/ctx/lib/ -lctxc12 -lctx12 -lzx12 -lgx12 -lctx12 -lzx12 -lgx12 -lordimt12 -lclsra12 -ldbcfg12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12 -locr12 -locrb12 -locrutl12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12  -lgeneric12 -lorazip -loraz -llzopro5 -lorabz2 -lipp_z -lipp_bz2 -lippdcemerged -lippsemerged -lippdcmerged  -lippsmerged -lippcore  -lippcpemerged -lippcpmerged  -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lsnls12 -lunls12  -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lasmclnt12 -lcommon12 -lcore12  -laio -lons  -lfthread12   `cat /u01/app/oracle/product/12c/db_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/12c/db_1/lib -lm    `cat /u01/app/oracle/product/12c/db_1/lib/sysliblist` -ldl -lm   -L/u01/app/oracle/product/12c/db_1/lib `test -x /usr/bin/hugeedit -a -r /usr/lib64/libhugetlbfs.so && test -r /u01/app/oracle/product/12c/db_1/rdbms/lib/shugetlbfs.o && echo -Wl,-zcommon-page-size=2097152 -Wl,-zmax-page-size=2097152 -lhugetlbfs`
test ! -f /u01/app/oracle/product/12c/db_1/bin/oracle || (\
   mv -f /u01/app/oracle/product/12c/db_1/bin/oracle /u01/app/oracle/product/12c/db_1/bin/oracleO &&\
   chmod 600 /u01/app/oracle/product/12c/db_1/bin/oracleO )
mv /u01/app/oracle/product/12c/db_1/rdbms/lib/oracle /u01/app/oracle/product/12c/db_1/bin/oracle
chmod 6751 /u01/app/oracle/product/12c/db_1/bin/oracle


기존에 백업 해 뒀던 파라미터 파일 내용 복사

[aracdb1:/u01/app/oracle/product/12c/db_1/dbs]> vi initaracdb1.ora
*.audit_file_dest='/u01/app/oracle/admin/aracdb/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='12.2.0'
*.control_files='+DATA/ARACDB/CONTROLFILE/current.269.1136924667','+FRA/ARACDB/CONTROLFILE/current.259.1136924667'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_name='aracdb'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=10g
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=aracdbXDB)'
family:dw_helper.instance_mode='read-only'
aracdb1.instance_number=1
aracdb2.instance_number=2
*.local_listener='-oraagent-dummy-'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='KOREAN'
*.nls_territory='KOREA'
*.open_cursors=300
*.pga_aggregate_target=1000m
*.processes=320
*.remote_login_passwordfile='exclusive'
*.sga_target=2998m
aracdb2.thread=2
aracdb1.thread=1
aracdb1.undo_tablespace='UNDOTBS1'
aracdb2.undo_tablespace='UNDOTBS2'

[aracdb1:/u01/app/oracle/product/12c/db_1/dbs]> sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Mon Jan 29 15:01:15 2024
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 3154116608 bytes
Fixed Size                  8625656 bytes
Variable Size             838861320 bytes
Database Buffers         2298478592 bytes
Redo Buffers                8151040 bytes
Database mounted.
Database opened.


SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                             IS_     CON_ID
---------- ------- ------- -------------------------------------------------- --- ----------
         2         ONLINE  +DATA/ARACDB/ONLINELOG/group_2.271.1136924671      NO           0
         2         ONLINE  +FRA/ARACDB/ONLINELOG/group_2.261.1136924673       YES          0
         1         ONLINE  +DATA/ARACDB/ONLINELOG/group_1.270.1136924671      NO           0
         1         ONLINE  +FRA/ARACDB/ONLINELOG/group_1.260.1136924673       YES          0
         3         ONLINE  +DATA/ARACDB/ONLINELOG/group_3.274.1136924835      NO           0
         3         ONLINE  +FRA/ARACDB/ONLINELOG/group_3.262.1136924835       YES          0
         4         ONLINE  +DATA/ARACDB/ONLINELOG/group_4.275.1136924837      NO           0
         4         ONLINE  +FRA/ARACDB/ONLINELOG/group_4.263.1136924837       YES          0

8 rows selected.

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TI NEXT_CHANGE# NEXT_TIM     CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------- ------------ -------- ----------
         1          1         27  209715200        512          2 YES INACTIVE               1840293 24/01/26      1852823 24/01/26          0
         2          1         28  209715200        512          2 NO  CURRENT                1853020 24/01/27   1.8447E+19 24/01/27          0
         3          2          5  209715200        512          2 YES INACTIVE               1849934 24/01/26      1859299 24/01/27          0
         4          2          6  209715200        512          2 YES INACTIVE               1859343 24/01/27      1866531 24/01/27          
 

spfile 생성
SQL> create spfile from pfile;

File created.  

SQL> select tablespace_name from dba_data_files;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS2
USERS
UNDOTBS1

파라미터 파일 spfile 로 교체 및 2번 서버 기동 
spfile asm 경로 확인
ASMCMD> ls -l
Type           Redund  Striped  Time             Sys  Name
                                                 Y    ASM/
                                                 N    aracdb/
PARAMETERFILE  UNPROT  COARSE   JAN 29 15:00:00  N    spfilearacdb1.ora => +DATA/aracdb/PARAMETERFILE/spfile.278.1159542267
ASMCMD> 
[aracdb1:/u01/app/oracle/product/12c/db_1/dbs]> vi  initaracdb1.ora
spfile='+DATA/aracdb/PARAMETERFILE/spfile.278.1159542267'

[aracdb2:/u01/app/oracle/product/12c/db_1/dbs]> vi  initaracdb2.ora
spfile='+DATA/aracdb/PARAMETERFILE/spfile.278.1159542267'

srvctl start instacne -d aracdb -i aracdb2

상태 확인

[aracdb1:/u01/app/oracle/product/12c/db_1/dbs]> 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  OFFLINE      arac2                    Instance Shutdown,ST
                                                             ARTING
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
--------------------------------------------------------------------------------

완료

-- 12.2.0.1 기준 rac 에서 single로 변환

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jan 27 22:13:02 2024
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 pfile;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/ARACDB/PARAMETERFILE/spf
                                                 ile.276.1136924839
SQL> create pfile from spfile;

File created.

[aracdb1:/u01/app/oracle/product/12c/db_1/dbs]> ls -ltr
합계 19272
-rw-r--r--. 1 oracle oinstall     3079  5월 15  2015 init.ora
-rw-r-----. 1 oracle oinstall     2048  5월 23  2023 orapwaracdb1
-rw-r--r--. 1 oracle oinstall       71  5월 23  2023 afiedt.buf
-rw-r-----. 1 oracle asmadmin 19709952  1월 25 16:34 snapcf_aracdb1.f
-rw-rw----. 1 oracle asmadmin     1544  1월 27 22:12 hc_aracdb1.dat
-rw-r--r--. 1 oracle asmadmin     1816  1월 27 22:13 initaracdb1.ora
[aracdb1:/u01/app/oracle/product/12c/db_1/dbs]> cat  initaracdb1.ora
aracdb1.__data_transfer_cache_size=0
aracdb2.__data_transfer_cache_size=0
aracdb1.__db_cache_size=2264924160
aracdb2.__db_cache_size=2264924160
aracdb1.__inmemory_ext_roarea=0
aracdb2.__inmemory_ext_roarea=0
aracdb1.__inmemory_ext_rwarea=0
aracdb2.__inmemory_ext_rwarea=0
aracdb1.__java_pool_size=16777216
aracdb2.__java_pool_size=16777216
aracdb1.__large_pool_size=33554432
aracdb2.__large_pool_size=33554432
aracdb1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
aracdb2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
aracdb1.__pga_aggregate_target=1056964608
aracdb2.__pga_aggregate_target=1056964608
aracdb1.__sga_target=3154116608
aracdb2.__sga_target=3154116608
aracdb1.__shared_io_pool_size=167772160
aracdb2.__shared_io_pool_size=167772160
aracdb1.__shared_pool_size=654311424
aracdb2.__shared_pool_size=654311424
aracdb1.__streams_pool_size=0
aracdb2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/aracdb/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='12.2.0'
*.control_files='+DATA/ARACDB/CONTROLFILE/current.269.1136924667','+FRA/ARACDB/CONTROLFILE/current.259.1136924667'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_name='aracdb'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=10g
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=aracdbXDB)'
family:dw_helper.instance_mode='read-only'
aracdb1.instance_number=1
aracdb2.instance_number=2
*.local_listener='-oraagent-dummy-'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='KOREAN'
*.nls_territory='KOREA'
*.open_cursors=300
*.pga_aggregate_target=1000m
*.processes=320
*.remote_login_passwordfile='exclusive'
*.sga_target=2998m
aracdb2.thread=2
aracdb1.thread=1
aracdb1.undo_tablespace='UNDOTBS1'
aracdb2.undo_tablespace='UNDOTBS2'

[root@arac1 ~]# 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  OFFLINE      arac1                    Instance Shutdown,ST
                                                             ARTING
      2        ONLINE  OFFLINE      arac2                    Instance Shutdown,ST
                                                             ARTING
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
--------------------------------------------------------------------------------

1.  Shutdown all the instance in RAC environment.
[root@arac1 ~]# srvctl stop database -d aracdb
[root@arac1 ~]# 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        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
      2        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
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
--------------------------------------------------------------------------------

2.  Shutdown all the listeners.

[root@arac1 ~]# srvctl stop listener -n arac1
[root@arac1 ~]# srvctl stop listener -n arac2
[aracdb1:/u01/app/oracle/product/12c/db_1/dbs]> srvctl stop scan_listener
[aracdb1:/u01/app/oracle/product/12c/db_1/dbs]> 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
               OFFLINE OFFLINE      arac1                    STABLE
               OFFLINE OFFLINE      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        OFFLINE OFFLINE                               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        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
      2        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
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
--------------------------------------------------------------------------------

3.  Relink Oracle executable with rac_off option.

  $ make -f ins_rdbms.mk rac_off
  $ make -f ins_rdbms.mk ioracle
  
  
[aracdb1:/u01/app/oracle/product/12c/db_1/rdbms/lib]> make -f ins_rdbms.mk rac_off
rm -f /u01/app/oracle/product/12c/db_1/lib/libskgxp12.so
cp /u01/app/oracle/product/12c/db_1/lib//libskgxpg.so /u01/app/oracle/product/12c/db_1/lib/libskgxp12.so
rm -f /u01/app/oracle/product/12c/db_1/lib/libskgxn2.so
cp /u01/app/oracle/product/12c/db_1/lib//libskgxns.so \
      /u01/app/oracle/product/12c/db_1/lib/libskgxn2.so
/usr/bin/ar d /u01/app/oracle/product/12c/db_1/rdbms/lib/libknlopt.a kcsm.o
/usr/bin/ar cr /u01/app/oracle/product/12c/db_1/rdbms/lib/libknlopt.a /u01/app/oracle/product/12c/db_1/rdbms/lib/ksnkcs.o 

[aracdb1:/u01/app/oracle/product/12c/db_1/rdbms/lib]> make -f ins_rdbms.mk ioracle
chmod 755 /u01/app/oracle/product/12c/db_1/bin

 - Linking Oracle 
rm -f /u01/app/oracle/product/12c/db_1/rdbms/lib/oracle
/u01/app/oracle/product/12c/db_1/bin/orald  -o /u01/app/oracle/product/12c/db_1/rdbms/lib/oracle -m64 -z noexecstack -Wl,--disable-new-dtags -L/u01/app/oracle/product/12c/db_1/rdbms/lib/ -L/u01/app/oracle/product/12c/db_1/lib/ -L/u01/app/oracle/product/12c/db_1/lib/stubs/   -Wl,-E /u01/app/oracle/product/12c/db_1/rdbms/lib/opimai.o /u01/app/oracle/product/12c/db_1/rdbms/lib/ssoraed.o /u01/app/oracle/product/12c/db_1/rdbms/lib/ttcsoi.o -Wl,--whole-archive -lperfsrv12 -Wl,--no-whole-archive /u01/app/oracle/product/12c/db_1/lib/nautab.o /u01/app/oracle/product/12c/db_1/lib/naeet.o /u01/app/oracle/product/12c/db_1/lib/naect.o /u01/app/oracle/product/12c/db_1/lib/naedhs.o /u01/app/oracle/product/12c/db_1/rdbms/lib/config.o  -ldmext -lserver12 -lodm12 -lofs -lcell12 -lnnet12 -lskgxp12 -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lclient12  -lvsn12 -lcommon12 -lgeneric12 -lknlopt `if /usr/bin/ar tv /u01/app/oracle/product/12c/db_1/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap12" ; fi` -lskjcx12 -lslax12 -lpls12  -lrt -lplp12 -ldmext -lserver12 -lclient12  -lvsn12 -lcommon12 -lgeneric12 `if [ -f /u01/app/oracle/product/12c/db_1/lib/libavserver12.a ] ; then echo "-lavserver12" ; else echo "-lavstub12"; fi` `if [ -f /u01/app/oracle/product/12c/db_1/lib/libavclient12.a ] ; then echo "-lavclient12" ; fi` -lknlopt -lslax12 -lpls12  -lrt -lplp12 -ljavavm12 -lserver12  -lwwg  `cat /u01/app/oracle/product/12c/db_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat /u01/app/oracle/product/12c/db_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnnzst12 -lzt12 -lztkg12 -lmm -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lztkg12 `cat /u01/app/oracle/product/12c/db_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat /u01/app/oracle/product/12c/db_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnnzst12 -lzt12 -lztkg12   -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `if /usr/bin/ar tv /u01/app/oracle/product/12c/db_1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo12 -lserver12"; fi` -L/u01/app/oracle/product/12c/db_1/ctx/lib/ -lctxc12 -lctx12 -lzx12 -lgx12 -lctx12 -lzx12 -lgx12 -lordimt12 -lclsra12 -ldbcfg12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12 -locr12 -locrb12 -locrutl12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12  -lgeneric12 -lorazip -loraz -llzopro5 -lorabz2 -lipp_z -lipp_bz2 -lippdcemerged -lippsemerged -lippdcmerged  -lippsmerged -lippcore  -lippcpemerged -lippcpmerged  -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lsnls12 -lunls12  -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lasmclnt12 -lcommon12 -lcore12  -laio -lons  -lfthread12   `cat /u01/app/oracle/product/12c/db_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/12c/db_1/lib -lm    `cat /u01/app/oracle/product/12c/db_1/lib/sysliblist` -ldl -lm   -L/u01/app/oracle/product/12c/db_1/lib `test -x /usr/bin/hugeedit -a -r /usr/lib64/libhugetlbfs.so && test -r /u01/app/oracle/product/12c/db_1/rdbms/lib/shugetlbfs.o && echo -Wl,-zcommon-page-size=2097152 -Wl,-zmax-page-size=2097152 -lhugetlbfs`
test ! -f /u01/app/oracle/product/12c/db_1/bin/oracle || (\
   mv -f /u01/app/oracle/product/12c/db_1/bin/oracle /u01/app/oracle/product/12c/db_1/bin/oracleO &&\
   chmod 600 /u01/app/oracle/product/12c/db_1/bin/oracleO )
mv /u01/app/oracle/product/12c/db_1/rdbms/lib/oracle /u01/app/oracle/product/12c/db_1/bin/oracle
chmod 6751 /u01/app/oracle/product/12c/db_1/bin/oracle
[aracdb1:/u01/app/oracle/product/12c/db_1/rdbms/lib]> 


4.  Remove all the parameters from init.ora which points to second instance and it is on other node.
[aracdb1:/u01/app/oracle/product/12c/db_1/dbs]> cat  initaracdb1.ora
*.audit_file_dest='/u01/app/oracle/admin/aracdb/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='12.2.0'
*.control_files='+DATA/ARACDB/CONTROLFILE/current.269.1136924667','+FRA/ARACDB/CONTROLFILE/current.259.1136924667'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_name='aracdb'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=10g
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=aracdbXDB)'
family:dw_helper.instance_mode='read-only'
aracdb1.instance_number=1
*.local_listener='-oraagent-dummy-'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='KOREAN'
*.nls_territory='KOREA'
*.open_cursors=300
*.pga_aggregate_target=1000m
*.processes=320
*.remote_login_passwordfile='exclusive'
*.sga_target=2998m
aracdb1.thread=1
aracdb1.undo_tablespace='UNDOTBS1'


5.  Remove cluster_database parameter
-- 주석 처리
#*.cluster_database=true

6.  Remove undo_tablespace parameter which points to second instance
-- 주석 처리
#aracdb1.undo_tablespace='UNDOTBS2'
7.  Start-up the database in mount stage and execute..

SQL> startup pfile='/u01/app/oracle/product/12c/db_1/dbs/initaracdb1.ora'
ORACLE instance started.

Total System Global Area 3154116608 bytes
Fixed Size                  8625656 bytes
Variable Size             788529672 bytes
Database Buffers         2348810240 bytes
Redo Buffers                8151040 bytes
Database mounted.
Database opened.



alter database disable thread <thread of other instance>

SQL> select INSTANCE_NUMBER,INSTANCE_NAME,THREAD#,STATUS from v$instance;

INSTANCE_NUMBER INSTANCE_NAME       THREAD# STATUS
--------------- ---------------- ---------- ------------
              1 aracdb                    1 OPEN

파라미터 파일 인식

SQL> create spfile from pfile;

-- +data에 spfilearacdb1.ora 생긴다
ASMCMD> pwd
+data
ASMCMD> ls -al
Type           Redund  Striped  Time             Sys  Name
                                                 Y    ASM/
                                                 N    aracdb/
PARAMETERFILE  UNPROT  COARSE   JAN 29 14:00:00  N    spfilearacdb1.ora => +DATA/aracdb/PARAMETERFILE/spfile.278.1159539453

mv initaracdb1.ora initaracdb1.ora.old

vi initaracdb1.ora
spfile='+DATA/aracdb/PARAMETERFILE/spfile.278.1159539453'

SQL> startup
ORACLE instance started.

Total System Global Area 3154116608 bytes
Fixed Size                  8625656 bytesvi initaracdb1.ora
Variable Size             788529672 bytes
Database Buffers         2348810240 bytes
Redo Buffers                8151040 bytes
Database mounted.
Database opened.
SQL> show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/aracdb/PARAMETERFILE/spf
                                                 ile.278.1159539453

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
--------------------------------------------------------------------------------

1) Using ASMCMD Utility ( Latest method )
2) Using RMAN ( alternative method )
3) Using DBMS package ( old method )

첫 번째

> Using ASMCMD Utility

 select file_id,file_name,bytes/1024/1024 from dba_data_files;
   FILE_ID FILE_NAME                                          BYTES/1024/1024
---------- -------------------------------------------------- ---------------
         1 +DATA/ARACDB/DATAFILE/system.265.1136924533                    810
         3 +DATA/ARACDB/DATAFILE/sysaux.266.1136924577                    530
         5 +DATA/ARACDB/DATAFILE/undotbs2.273.1136924729                   25
         7 +DATA/ARACDB/DATAFILE/users.268.1136924605                       5
         4 +DATA/ARACDB/DATAFILE/undotbs1.267.1136924603                   70

[+ASM1:/home/grid]> asmcmd
ls
ASMCMD> CRS/
DATA/
FRA/
MGMT/
ASMCMD> cd data
ASMCMD> ls
aracdb/
ASMCMD> cd a*
ASMCMD> ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
PASSWORD/
TEMPFILE/
ASMCMD> cd datafile
ASMCMD> ls
SYSAUX.258.1136915229
SYSAUX.266.1136924577
SYSTEM.257.1136915185
SYSTEM.265.1136924533
UNDOTBS1.259.1136915255
UNDOTBS1.267.1136924603
UNDOTBS2.273.1136924729
USERS.260.1136915255
USERS.268.1136924605

-- 복사

ASMCMD> cp SYSAUX.266.1136924577 /home/grid/sysaux01.dbf
copying +data/aracdb/datafile/SYSAUX.266.1136924577 -> /home/grid/sysaux01.dbf

두 번째

> Using RMAN

[aracdb1:/home/oracle]> rman target /
Recovery Manager: Release 12.2.0.1.0 - Production on Thu Jan 25 11:12:10 2024
Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ARACDB (DBID=2943394426)
RMAN> copy datafile 1 to '/home/oracle/system01.dbf'             ;
Starting backup at 24/01/25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=277 instance=aracdb1 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+DATA/ARACDB/DATAFILE/system.265.1136924533
output file name=/home/oracle/system01.dbf tag=TAG20240125T111517 RECID=1 STAMP=1159182926
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:16
Finished backup at 24/01/25

Starting Control File and SPFILE Autobackup at 24/01/25
piece handle=+FRA/ARACDB/AUTOBACKUP/2024_01_25/s_1159182933.287.1159182935 comment=NONE
Finished Control File and SPFILE Autobackup at 24/01/25

세 번째

> Using DBMS package

SQL> desc dbms_file_transfer
PROCEDURE COPY_FILE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SOURCE_DIRECTORY_OBJECT        VARCHAR2                IN
 SOURCE_FILE_NAME               VARCHAR2                IN
 DESTINATION_DIRECTORY_OBJECT   VARCHAR2                IN
 DESTINATION_FILE_NAME          VARCHAR2                IN
PROCEDURE COPY_FILE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SOURCE_DIRECTORY_OBJECT        VARCHAR2                IN
 SOURCE_FILE_NAME               VARCHAR2                IN
 DESTINATION_DIRECTORY_OBJECT   VARCHAR2                IN
 DESTINATION_FILE_NAME          VARCHAR2                IN
 CREATED_FILE_NAME              VARCHAR2                OUT
 DESTINATION_FILE_TAG           VARCHAR2                IN     DEFAULT
PROCEDURE GET_FILE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SOURCE_DIRECTORY_OBJECT        VARCHAR2                IN
 SOURCE_FILE_NAME               VARCHAR2                IN
 SOURCE_DATABASE                VARCHAR2                IN
 DESTINATION_DIRECTORY_OBJECT   VARCHAR2                IN
 DESTINATION_FILE_NAME          VARCHAR2                IN
PROCEDURE PUT_FILE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SOURCE_DIRECTORY_OBJECT        VARCHAR2                IN
 SOURCE_FILE_NAME               VARCHAR2                IN
 DESTINATION_DIRECTORY_OBJECT   VARCHAR2                IN
 DESTINATION_FILE_NAME          VARCHAR2                IN
 DESTINATION_DATABASE           VARCHAR2                IN

SQL> create directory SOURCE_DIR as '+DATA/aracdb/datafile';
Directory created.
SQL> create directory TARGET_DIR as '/oradata/';
Directory created.
SQL> BEGIN
  2  dbms_file_transfer.copy_file(source_directory_object =>
  3  'SOURCE_DIR', source_file_name => 'SYSAUX.266.1136924577',
  4  destination_directory_object => 'TARGET_DIR',
  5  destination_file_name => 'sysaux001.dbf');
  6  END;  
  7  /
PL/SQL procedure successfully completed.

[oracle@arac1 ~]$ cd /oradata
[oracle@arac1 oradata]$ ls
sysaux001.dbf
[oracle@arac1 oradata]$ ls -al
합계 542732
drwxr-xr-x.  2 oracle dba             26  1월 25 11:36 .
dr-xr-xr-x. 20 root   root          4096  1월 25 11:27 ..
-rw-r-----.  1 oracle asmadmin 555753472  1월 25 11:36 sysaux001.dbf

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

 ASM 에서 filesystem으로 복사 하는 3가지 방법이 있습니다.

위 3가지 방법 중에서는 1,2번(asmcmd cp,rman copy) 방법이 제일 간단히 할 수 있겠습니다.

감사합니다.

오라클 동적 리스너 설정 - single 서버 기준

-- 리스너 설정

listener.ora
LISTENER_TEST = (ADDRESS = (PROTOCOL = TCP)(HOST = ora19c)(PORT = 1529))

-- tns 설정
tnsnames.ora
LISTENER_TEST = (ADDRESS = (PROTOCOL = TCP)(HOST = ora19c)(PORT = 1529))

-- DB 접속 후 LOCAL LISTENER 등록

alter system set local_listener=' LISTENER_TEST';

show parameter local
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      LISTENER_TEST
parallel_force_local                 boolean     FALSE

[ora19c:/u01/app/oracle/product/19c/db_1/network/admin]> lsnrctl start listener_test

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 18-JAN-2024 17:45:57

Copyright (c) 1991, 2023, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/19c/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19c/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/ora19c/listener_test/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora19c)(PORT=1529)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora19c)(PORT=1529)))
STATUS of the LISTENER
------------------------
Alias                     listener_test
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                18-JAN-2024 17:45:57
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19c/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ora19c/listener_test/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora19c)(PORT=1529)))
The listener supports no services
The command completed successfully

alter system register;

[ora19c:/home/oracle]> lsnrctl status listener_test

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 18-JAN-2024 20:46:30

Copyright (c) 1991, 2023, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=ora19c)(PORT=1529))
STATUS of the LISTENER
------------------------
Alias                     listener_test
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                18-JAN-2024 20:45:32
Uptime                    0 days 0 hr. 0 min. 58 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19c/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ora19c/listener_test/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora19c)(PORT=1529)))
Services Summary...
Service "ora19c" has 1 instance(s).
  Instance "ora19c", status READY, has 1 handler(s) for this service...
Service "ora19cXDB" has 1 instance(s).
  Instance "ora19c", status READY, has 1 handler(s) for this service...
The command completed successfully

rac asm 환경에서 파일을 일반 파일시스템으로 잘못 만들었을 때 ASM으로 이동
SQL> select tablespace_name,file_name,bytes/1024/1024 from dba_data_files;

TABLESPACE_NAME                FILE_NAME                                          BYTES/1024/1024
------------------------------ -------------------------------------------------- ---------------
SYSTEM                         +DATA/RACDB/DATAFILE/system.257.1093539089                     910
SYSAUX                         +DATA/RACDB/DATAFILE/sysaux.258.1093539113                     640
UNDOTBS1                       +DATA/RACDB/DATAFILE/undotbs1.259.1093539129                   345
USERS                          +DATA/RACDB/DATAFILE/users.260.1093539129                        5
UNDOTBS2                       +DATA/RACDB/DATAFILE/undotbs2.270.1093539589                    25
IMSI                           /u01/app/oracle/product/19c/db_1/dbs/data1
ASMTBS                         +ASMDATA/RACDB/DATAFILE/asmtbs.256.1139007429                   14

7 rows selected.


SQL> alter tablespace imsi offline;

Tablespace altered.


rman 접속 후 copy
RMAN> copy datafile '/u01/app/oracle/product/19c/db_1/dbs/data1' to '+DATA'
2> ;

Starting backup at 23/12/18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=214 instance=racdb1 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00015 name=/u01/app/oracle/product/19c/db_1/dbs/data1
output file name=+DATA/RACDB/DATAFILE/imsi.281.1155917741 tag=TAG20231218T161539 RECID=4 STAMP=1155918015
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
Finished backup at 23/12/18

Starting Control File and SPFILE Autobackup at 23/12/18
piece handle=/share/backup/rman/db_ctl_c-1091155962-20231218-00 comment=NONE
Finished Control File and SPFILE Autobackup at 23/12/18

RMAN> 
# asm위치로 변경(rename)
SQL> alter database rename file '/u01/app/oracle/product/19c/db_1/dbs/data1' to '+DATA/RACDB/DATAFILE/imsi.281.1155917741' ;

Database altered.

SQL> recover datafile '+DATA/RACDB/DATAFILE/imsi.281.1155917741';
Media recovery complete.

SQL> alter tablespace imsi online;

Tablespace altered.

제가 먹어 본 생비중에 최고네요

오후 3시까지만 하고 재료 떨어지면 장사 안합니다.

점심 시간 조금 늦게 가면  시골인데도 밖에서 대기해야 합니다.

리두로그 그룹 파일 추가
alter database add logfile group 4 '/oracle/oradata/orcl/redo04a.log' size 1g;

alter database add logfile group 5 '/oracle/oradata/orcl/redo05a.log' size 1g;

리두로그 그룹 삭제
(alter system switch logfile 및 alter system checkpoint 명령어로 해당 그룹이 inactive일 때 drop)

alter database drop logfile group 1

alter database drop logfile group 2

alter database drop logfile group 3

리두로그 그룹 파일 추가

alter database add logfile group 1 '/oracle/oradata/orcl/redo01a.log' size 1g;

alter database add logfile group 2 '/oracle/oradata/orcl/redo02a.log' size 1g;

alter database add logfile group 3 '/oracle/oradata/orcl/redo03a.log' size 1g;

# ASM을 쓰는 DB에서 추가

SQL> ALTER DATABASE ADD LOGFILE MEMBER     '+DATA'  TO GROUP 1;

SQL> ALTER DATABASE ADD LOGFILE MEMBER
         '+DATA' TO GROUP 1 ,
         '+DATA' TO GROUP 2 ,
         '+DATA' TO GROUP 3 ;

리두 로그파일 멤버 삭제

select * from v$log;  조회시 상태가 active 이면

alter system checkpoint; 후  inactive 로 상태가 바뀔 때  로그 그룹 또는 멤버 삭제 alter database drop logile member '/data1/redo01.log';

리두 로그 파일 멤버 추가

select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                   IS_
---------- ------- ------- ---------------------------------------- ---
         1         ONLINE  /data1/orcl/redo001.log               NO
         3         ONLINE  /data1/orcl/redo003.log               NO
         2         ONLINE  /data1/orcl/redo002.log               NO
         4         ONLINE  /data1/orcl/redo004.log               NO
         5         ONLINE  /data1/orcl/redo005.log               NO
         7         ONLINE  /data1/orcl/redo007.log               NO
         6         ONLINE  /data1/orcl/redo006.log               NO
         8         ONLINE  /data1/orcl/redo008.log               NO
         9         ONLINE  /data1/orcl/redo009.log               NO
        10         ONLINE  /data1/orcl/redo010.log               NO

alter database add logfile member  '/data2/orcl/redo001b.log' to group 1;
                                                                   
alter database add logfile member  '/data2/orcl/redo002b.log' to group 2;

alter database add logfile member  '/data2/orcl/redo003b.log' to group 3;

alter database add logfile member  '/data2/orcl/redo004b.log' to group 4;

alter database add logfile member  '/data2/orcl/redo005b.log' to group 5;

alter database add logfile member  '/data2/orcl/redo006b.log' to group 6;

alter database add logfile member  '/data2/orcl/redo007b.log' to group 7;

alter database add logfile member  '/data2/orcl/redo008b.log' to group 8;

alter database add logfile member  '/data2/orcl/redo009b.log' to group 9;

alter database add logfile member  '/data2/orcl/redo010b.log' to group 10;


==========================================================================================
용량 증설 후 리두 로그 사이즈 변경 기존 파일 드랍 후 재 생성 
select * from v$log;  조회시 상태가 active 이면

alter system checkpoint; 후  inactive 로 상태가 바뀔 때  로그 그룹 또는 멤버 삭제

alter database drop  logfile group 1;


alter database add logfile group 1 '/data1/orcl/redo001.log' size 2g;

alter database drop  logfile group 3;

alter database add logfile group 3 '/data1/orcl/redo003.log' size 2g;

alter database drop  logfile group 5;

alter database add logfile group 5 '/data1/orcl/redo005.log' size 2g;

alter database drop  logfile group 7;

alter database add logfile group 7 '/data1/orcl/redo007.log' size 2g;

alter database drop  logfile group 9;


alter database add logfile group 9 '/data1/orcl/redo009.log' size 2g;




alter database drop logfile group 2;

alter database add logfile group 2 '/data1/orcl/redo002.log' size 2g;

alter database drop logfile group 4;

alter database add logfile group 4 '/data1/orcl/redo004.log' size 2g;

alter database drop logfile group 6;

alter database add logfile group 6 '/data1/orcl/redo006.log' size 2g;


alter database drop logfile group 8;

alter database add logfile group 8 '/data1/orcl/redo008.log' size 2g;


alter database drop logfile group 10;

alter database add logfile group 10 '/data1/orcl/redo010.log' size 2g;

==============================================================================
멤버 추가

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

select * from v$logfile;
    GROUP# STATUS  TYPE    MEMBER                                   IS_
---------- ------- ------- ---------------------------------------- ---
         1         ONLINE  /data1/orcl/redo001.log               NO
         3         ONLINE  /data1/orcl/redo003.log               NO
         2         ONLINE  /data1/orcl/redo002.log               NO
         4         ONLINE  /data1/orcl/redo004.log               NO
         5         ONLINE  /data1/orcl/redo005.log               NO
         7         ONLINE  /data1/orcl/redo007.log               NO
         6         ONLINE  /data1/orcl/redo006.log               NO
         8         ONLINE  /data1/orcl/redo008.log               NO
         9         ONLINE  /data1/orcl/redo009.log               NO
        10         ONLINE  /data1/orcl/redo010.log               NO

alter database add logfile member  '/data2/orcl/redo001b.log' to group 1;
                                                                   
alter database add logfile member  '/data2/orcl/redo002b.log' to group 2;

alter database add logfile member  '/data2/orcl/redo003b.log' to group 3;

alter database add logfile member  '/data2/orcl/redo004b.log' to group 4;

alter database add logfile member  '/data2/orcl/redo005b.log' to group 5;

alter database add logfile member  '/data2/orcl/redo006b.log' to group 6;

alter database add logfile member  '/data2/orcl/redo007b.log' to group 7;

alter database add logfile member  '/data2/orcl/redo008b.log' to group 8;

alter database add logfile member  '/data2/orcl/redo009b.log' to group 9;

alter database add logfile member  '/data2/orcl/redo010b.log' to group 10;