반응형

※RAC 전체 Node를 각각 실행 해야 함

Oracle RAC관련 필수 파일 백업

/etc 밑에 있는 File Backup

---/etc/oratab
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba)
[oracle@rac1 DATASYNCXML]$ ls -al /etc/oratab
-rw-rw-r--. 1 oracle dba 741 May 21 09:15 /etc/oratab
[oracle@rac1 DATASYNCXML]$ cp /etc/oratab ./oratab_backup_20260526
[oracle@rac1 DATASYNCXML]$ ls -al
total 92
drwxr-xr-x. 2 oracle dba    82 May 26 10:01 .
drwx------. 9 oracle dba  4096 May 22 09:06 ..
-rw-r-----. 1 oracle dba 27042 May 21 14:41 dbca.rsp
-rw-r--r--. 1 oracle dba 19881 May 21 10:08 db.rsp
-rw-r--r--. 1 oracle dba 36699 May 21 09:00 grid.rsp
-rw-r--r--  1 oracle dba   741 May 26 10:01 oratab_backup_20260526
[oracle@rac1 DATASYNCXML]$

---/etc/oraInst.loc,/etc/oracle.ahf.loc,/etc/oracle
[root@rac1 etc]# id
uid=0(root) gid=0(root) groups=0(root)
[root@rac1 etc]# pwd
/etc
[root@rac1 etc]# ls -al *.loc
-rw-r--r--. 1 root root 16 May 21 13:41 oracle.ahf.loc
-rw-r--r--. 1 root root 53 May 21 09:15 oraInst.loc
[root@rac1 etc]#
[root@rac1 etc]# cp oracle.ahf.loc /home/oracle/DATASYNCXML/oracle.ahf.loc_backup_20260528
[root@rac1 etc]# cp oraInst.loc /home/oracle/DATASYNCXML/oraInst.loc_20260528
[root@rac1 etc]# ls -al /home/oracle/DATASYNCXML/
total 100
drwxr-xr-x. 2 oracle dba    148 May 26 10:04 .
drwx------. 9 oracle dba   4096 May 22 09:06 ..
-rw-r-----. 1 oracle dba  27042 May 21 14:41 dbca.rsp
-rw-r--r--. 1 oracle dba  19881 May 21 10:08 db.rsp
-rw-r--r--. 1 oracle dba  36699 May 21 09:00 grid.rsp
-rw-r--r--  1 root   root    16 May 26 10:03 oracle.ahf.loc_backup_20260528
-rw-r--r--  1 root   root    53 May 26 10:04 oraInst.loc_20260528
-rw-r--r--  1 oracle dba    741 May 26 10:01 oratab_backup_20260526
[root@rac1 etc]#
[root@rac1 etc]# cd oracle
[root@rac1 oracle]# pwd
/etc/oracle
[root@rac1 oracle]# ls
lastgasp  maps  ocr.loc  ocr.loc.orig  olr.loc  olr.loc.orig  oprocd  scls_scr  setasmgid
[root@rac1 oracle]# cd ..
[root@rac1 etc]# tar -cvf /home/oracle/DATASYNCXML/etc_oracle.tar_20260528 ./oracle
./oracle/
./oracle/lastgasp/
./oracle/lastgasp/cssmonit_rac1.lgl
./oracle/lastgasp/cssagent_rac1.lgl
./oracle/oprocd/
./oracle/oprocd/check/
./oracle/oprocd/stop/
./oracle/oprocd/fatal/
./oracle/scls_scr/
./oracle/scls_scr/rac1/
./oracle/scls_scr/rac1/root/
./oracle/scls_scr/rac1/root/rdsmodld
./oracle/scls_scr/rac1/root/crsstart
./oracle/scls_scr/rac1/root/ohasdrun
./oracle/scls_scr/rac1/root/ohasdinitpid
./oracle/scls_scr/rac1/root/ohasdstr
./oracle/scls_scr/rac1/oracle/
./oracle/scls_scr/rac1/oracle/cssfatal
./oracle/maps/
./oracle/olr.loc
./oracle/ocr.loc
./oracle/ocr.loc.orig
./oracle/olr.loc.orig
./oracle/setasmgid
[root@rac1 etc]#
[root@rac1 etc]# ls -al /home/oracle/DATASYNCXML/
total 4240
drwxr-xr-x. 2 oracle dba      179 May 26 10:05 .
drwx------. 9 oracle dba     4096 May 22 09:06 ..
-rw-r-----. 1 oracle dba    27042 May 21 14:41 dbca.rsp
-rw-r--r--. 1 oracle dba    19881 May 21 10:08 db.rsp
-rw-r--r--  1 root   root 4239360 May 26 10:05 etc_oracle.tar_20260528
-rw-r--r--. 1 oracle dba    36699 May 21 09:00 grid.rsp
-rw-r--r--  1 root   root      16 May 26 10:03 oracle.ahf.loc_backup_20260528
-rw-r--r--  1 root   root      53 May 26 10:04 oraInst.loc_20260528
-rw-r--r--  1 oracle dba      741 May 26 10:01 oratab_backup_20260526
[root@rac1 etc]#

 

OS 설정 File Backup

[root@rac1 ~]#
[root@rac1 ~]# id
uid=0(root) gid=0(root) groups=0(root)
[root@rac1 ~]# cd /etc
[root@rac1 etc]# ls -al hosts
-rw-r--r--. 1 root root 407 May 20 15:27 hosts
[root@rac1 etc]#
[root@rac1 etc]# cp hosts /home/oracle/DATASYNCXML/hosts_backup_20260526
[root@rac1 etc]#
[root@rac1 etc]# cd sysctl.d/
[root@rac1 sysctl.d]# pwd
/etc/sysctl.d
[root@rac1 sysctl.d]# ls
50-libreswan.conf  98-oracle.conf  99-sysctl.conf
[root@rac1 sysctl.d]#
[root@rac1 sysctl.d]# cp 98-oracle.conf /home/oracle/DATASYNCXML/98-oracle.conf_backup_20260528
[root@rac1 sysctl.d]# cp 99-sysctl.conf /home/oracle/DATASYNCXML/99-sysctl.conf_backup_20260528
[root@rac1 sysctl.d]#
[root@rac1 sysctl.d]# cd ..
[root@rac1 etc]# ls -al sysctl.conf
-rw-r--r--. 1 root root 449 Feb  8  2022 sysctl.conf
[root@rac1 etc]#
[root@rac1 etc]# cp sysctl.conf /home/oracle/DATASYNCXML/sysctl.conf_backup_20260628
[root@rac1 etc]#
[root@rac1 etc]# cd /etc/security/limits.d
[root@rac1 limits.d]# ls
oracle-database-server-19c-preinstall.conf
[root@rac1 limits.d]#
[root@rac1 limits.d]# cp oracle-database-server-19c-preinstall.conf /home/oracle/DATASYNCXML/oracle-database-server-19c-preinstall.conf_backup_20260528
[root@rac1 limits.d]# cd /home/oracle/DATASYNCXML
[root@rac1 DATASYNCXML]# ls -al
total 4264
drwxr-xr-x. 2 oracle dba     4096 May 26 10:11 .
drwx------. 9 oracle dba     4096 May 22 09:06 ..
-rw-r--r--  1 root   root     376 May 26 10:08 98-oracle.conf_backup_20260528
-rw-r--r--  1 root   root     449 May 26 10:09 99-sysctl.conf_backup_20260528
-rw-r-----. 1 oracle dba    27042 May 21 14:41 dbca.rsp
-rw-r--r--. 1 oracle dba    19881 May 21 10:08 db.rsp
-rw-r--r--  1 root   root 4239360 May 26 10:05 etc_oracle.tar_20260528
-rw-r--r--. 1 oracle dba    36699 May 21 09:00 grid.rsp
-rw-r--r--  1 root   root     407 May 26 10:07 hosts_backup_20260526
-rw-r--r--  1 root   root      16 May 26 10:03 oracle.ahf.loc_backup_20260528
-rw-r--r--  1 root   root     261 May 26 10:11 oracle-database-server-19c-preinstall.conf_backup_20260528
-rw-r--r--  1 root   root      53 May 26 10:04 oraInst.loc_20260528
-rw-r--r--  1 oracle dba      741 May 26 10:01 oratab_backup_20260526
-rw-r--r--  1 root   root     449 May 26 10:10 sysctl.conf_backup_20260628
[root@rac1 DATASYNCXML]#

 

Oracle GRID 관련 백업

----OCR/VOTE
[root@rac1 bin]#
[root@rac1 bin]# pwd
/oradb/app/oracle/grid/19.0.0/bin
[root@rac1 bin]# ls -al ocrbackup
ls: cannot access 'ocrbackup': No such file or directory
[root@rac1 bin]#
[root@rac1 bin]#
[root@rac1 bin]# id
uid=0(root) gid=0(root) groups=0(root)
[root@rac1 bin]# pwd
/oradb/app/oracle/grid/19.0.0/bin
[root@rac1 bin]#
[root@rac1 bin]# ls -al ocrconfig
-rwxr-xr-x. 1 root dba 11567 May 21 13:36 ocrconfig
[root@rac1 bin]#
[root@rac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84488
         Available space (kbytes) :     407196
         ID                       : 1590616498
         Device/File Name         :   +OCRVOTE
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded
[root@rac1 bin]#
[root@rac1 bin]# ./ocrconfig -showbackup
PROT-24: Auto backups for the Oracle Cluster Registry are not available
rac2     2026/05/22 09:58:31     +OCRVOTE:/racdb/OCRBACKUP/backup_20260522_095831.ocr.259.123391                                                                                                      4311     3669234883
rac1     2026/05/21 13:40:14     +OCRVOTE:/racdb/OCRBACKUP/backup_20260521_134014.ocr.258.123384                                                                                                      1215     526767740
[root@rac1 bin]#
[root@rac1 bin]# ./ocrconfig -manualbackup
rac1     2026/05/26 10:16:51     +OCRVOTE:/racdb/OCRBACKUP/backup_20260526_101651.ocr.260.1234261013     3669234883
rac2     2026/05/22 09:58:31     +OCRVOTE:/racdb/OCRBACKUP/backup_20260522_095831.ocr.259.1233914311     3669234883
rac1     2026/05/21 13:40:14     +OCRVOTE:/racdb/OCRBACKUP/backup_20260521_134014.ocr.258.1233841215     526767740
[root@rac1 bin]#
[root@rac1 bin]# pwd
/oradb/app/oracle/grid/19.0.0/bin
[root@rac1 bin]# cd /home/oracle/DATASYNCXML/
[root@rac1 DATASYNCXML]# pwd
/home/oracle/DATASYNCXML
[root@rac1 DATASYNCXML]# /oradb/app/oracle/grid/19.0.0/bin/ocrconfig -local -manualbackup
rac1     2026/05/26 10:22:07     /oradb/app/base/crsdata/rac1/olr/backup_20260526_102207.olr     3669234883
rac1     2026/05/22 09:58:53     /oradb/app/base/crsdata/rac1/olr/backup_20260522_095853.olr     3669234883
rac1     2026/05/21 13:39:58     /oradb/app/base/crsdata/rac1/olr/backup_20260521_133958.olr     526767740
rac1     2026/05/21 09:41:16     /oradb/app/base/crsdata/rac1/olr/backup_20260521_094116.olr     724960844
[root@rac1 DATASYNCXML]# cp /oradb/app/base/crsdata/rac1/olr/backup_20260526_102207.olr /home/oracle/DATASYNCXML/
[root@rac1 DATASYNCXML]# ls -al
total 5436
drwxr-xr-x. 2 oracle dba     4096 May 26 10:22 .
drwx------. 9 oracle dba     4096 May 22 09:06 ..
-rw-r--r--  1 root   root     376 May 26 10:08 98-oracle.conf_backup_20260528
-rw-r--r--  1 root   root     449 May 26 10:09 99-sysctl.conf_backup_20260528
-rw-------  1 root   root 1200128 May 26 10:22 backup_20260526_102207.olr
-rw-r-----. 1 oracle dba    27042 May 21 14:41 dbca.rsp
-rw-r--r--. 1 oracle dba    19881 May 21 10:08 db.rsp
-rw-r--r--  1 root   root 4239360 May 26 10:05 etc_oracle.tar_20260528
-rw-r--r--. 1 oracle dba    36699 May 21 09:00 grid.rsp
-rw-r--r--  1 root   root     407 May 26 10:07 hosts_backup_20260526
-rw-r--r--  1 root   root      16 May 26 10:03 oracle.ahf.loc_backup_20260528
-rw-r--r--  1 root   root     261 May 26 10:11 oracle-database-server-19c-preinstall.conf_backup_20260528
-rw-r--r--  1 root   root      53 May 26 10:04 oraInst.loc_20260528
-rw-r--r--  1 oracle dba      741 May 26 10:01 oratab_backup_20260526
-rw-r--r--  1 root   root     449 May 26 10:10 sysctl.conf_backup_20260628
[root@rac1 DATASYNCXML]#

----ASM 메타데이터 백업
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba)
[oracle@rac1 DATASYNCXML]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$ asmcmd md_backup /home/oracle/DATASYNCXML/asm_metadata_backup_20260526.sql
Disk group metadata to be backed up: DATA01
Disk group metadata to be backed up: OCRVOTE
Disk group metadata to be backed up: RECO01
Current alias directory path: OCPRODDB/PASSWORD
Current alias directory path: OCPRODDB/TEMPFILE
Current alias directory path: OCPRODDB/PARAMETERFILE
Current alias directory path: OCPRODDB/CONTROLFILE
Current alias directory path: OCPRODDB/DATAFILE
Current alias directory path: OCPRODDB/ONLINELOG
Current alias directory path: OCPRODDB
Current alias directory path: racdb/OCRFILE
Current alias directory path: racdb
Current alias directory path: racdb/OCRBACKUP
Current alias directory path: racdb/ASMPARAMETERFILE
Current alias directory path: ASM
Current alias directory path: ASM/PASSWORD
Current alias directory path: OCPRODDB/ONLINELOG
Current alias directory path: OCPRODDB
[oracle@rac1 DATASYNCXML]$ ls -al asm_metadata_backup_20260526.sql
-rw-r--r-- 1 oracle dba 45513 May 26 10:25 asm_metadata_backup_20260526.sql
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba)
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rac1 DATASYNCXML]$ sqlplus "/as sysasm"
SQL> create pfile='/home/oracle/DATASYNCXML/asm_init.ora_20260526' from spfile;
File created.
SQL> exit
[oracle@rac1 DATASYNCXML]$ ls -al asm_init.ora_20260526
-rw-r--r-- 1 oracle dba 316 May 26 10:30 asm_init.ora_20260526
[oracle@rac1 DATASYNCXML]$

 

Oracle DB관련 백업

/*
추가적으로 $ORACLE_HOME/network/admin 하위의 listener.ora, tnsnames.ora, sqlnet.ora 백업 필요
*/
[oracle@rac1 DATASYNCXML]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba)
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$ env | grep SID
ORACLE_SID=OCPRODDB1
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$ sqlplus "/as sysdba"
SQL> create pfile='/home/oracle/DATASYNCXML/db_init.ora_backup_20260526' from spfile;
File created.
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/home/oracle/DATASYNCXML/cr_controlfile.sql_20260526';
Database altered.
SQL> exit
[oracle@rac1 DATASYNCXML]$ ls -al db_init.ora_backup_20260526
-rw-r--r-- 1 oracle dba 1840 May 26 10:28 db_init.ora_backup_20260526
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$ ls -al cr_controlfile.sql_20260526
-rw-r--r-- 1 oracle dba 8473 May 26 10:32 cr_controlfile.sql_20260526
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 app]$ pwd
/oradb/app
[oracle@rac1 app]$ ls
base  oracle  oraInventory  STAGE
[oracle@rac1 app]$ tar -cvf /home/oracle/DATASYNCXML/oraInventory.tar_backup_20260526 ./oraInventory/
./oraInventory/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
./oraInventory/backup/2026-05-21_08-47-39AM/
./oraInventory/backup/2026-05-21_08-47-39AM/ContentsXML/
./oraInventory/backup/2026-05-21_08-47-39AM/ContentsXML/inventory.xml
./oraInventory/backup/2026-05-21_08-47-39AM/ContentsXML/oui-patch.xml
./oraInventory/backup/2026-05-21_08-47-39AM/ContentsXML/comps.xml
./oraInventory/backup/2026-05-21_08-47-39AM/ContentsXML/libs.xml
./oraInventory/backup/2026-05-21_09-58-18AM/
./oraInventory/backup/2026-05-21_09-58-18AM/ContentsXML/
./oraInventory/backup/2026-05-21_09-58-18AM/ContentsXML/inventory.xml
./oraInventory/backup/2026-05-21_09-58-18AM/ContentsXML/oui-patch.xml
./oraInventory/backup/2026-05-21_09-58-18AM/ContentsXML/comps.xml
./oraInventory/backup/2026-05-21_09-58-18AM/ContentsXML/libs.xml
[oracle@rac1 app]$
[oracle@rac1 app]$ cd /home/oracle/DATASYNCXML/
[oracle@rac1 DATASYNCXML]$ ls -al oraInventory.tar_backup_20260526
-rw-r--r-- 1 oracle dba 37058560 May 26 10:34 oraInventory.tar_backup_20260526
[oracle@rac1 DATASYNCXML]$

 

Oracle DB 중지 및 Oracle CRS 중지

[oracle@rac1 ~]$ srvctl stop instance -d RACDB -i RACDB1
[oracle@rac1 ~]$ su - root
[root@rac1 bin]#
[root@rac1 bin]# id
uid=0(root) gid=0(root) groups=0(root)
[root@rac1 bin]# pwd
/oradb/app/oracle/grid/19.0.0/bin
[root@rac1 bin]#
[root@rac1 bin]# ./crsctl stop crs
[root@rac1 bin]#
[root@rac1 bin]# ./crsctl config crs
CRS-4622: Oracle High Availability Services autostart is enabled.
[root@rac1 bin]#
[root@rac1 bin]# ./crsctl disable crs
CRS-4621: Oracle High Availability Services autostart is disabled.
[root@rac1 bin]#
[root@rac1 bin]# ./crsctl config crs
CRS-4621: Oracle High Availability Services autostart is disabled.
[root@rac1 bin]#

 

OS Upgrade

Redhat 8에서 Redhat9로 OS Upgrade하는 과정에 몇차레 OS rebooting 발생 함

 

OS Upgrade 후 후속 작업

필수 RPM 존재 여부 확인

---필수 rpm 존재 여부 확인
[root@rac1 ~]#
[root@rac1 ~]# id
uid=0(root) gid=0(root) groups=0(root)
[root@rac1 ~]#
[root@rac1 ~]# rpm -qa | grep cvuqdisk
cvuqdisk-1.0.10-1.x86_64
[root@rac1 ~]#
[root@rac1 ~]# rpm -qa | grep compat-openssl11
[root@rac1 ~]#
[root@rac1 ~]# dnf install compat-openssl11 -y
Updating Subscription Management repositories.
Unable to read consumer identity

This system is not registered with an entitlement server. You can use "rhc" or "subscription-manager" to register.

Last metadata expiration check: 1:22:32 ago on Tue 26 May 2026 01:51:25 PM KST.
Dependencies resolved.
======================================================================================================================================================================================================
 Package                                            Architecture                             Version                                              Repository                                     Size
======================================================================================================================================================================================================
Installing:
 compat-openssl11                                   x86_64                                   1:1.1.1k-4.el9_0                                     AppStream96                                   1.5 M

Transaction Summary
======================================================================================================================================================================================================
Install  1 Package

Total size: 1.5 M
Installed size: 3.7 M
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                                              1/1
  Installing       : compat-openssl11-1:1.1.1k-4.el9_0.x86_64                                                                                                                                     1/1
  Running scriptlet: compat-openssl11-1:1.1.1k-4.el9_0.x86_64                                                                                                                                     1/1
  Verifying        : compat-openssl11-1:1.1.1k-4.el9_0.x86_64                                                                                                                                     1/1
Installed products updated.

Installed:
  compat-openssl11-1:1.1.1k-4.el9_0.x86_64

Complete!
[root@rac1 ~]#

 

Update the Oracle Clusterware operating system files

[root@rac2 bin]#
[root@rac2 bin]# id
uid=0(root) gid=0(root) groups=0(root)
[root@rac2 bin]#
[root@rac2 bin]# pwd
/oradb/app/oracle/grid/19.0.0/bin
[root@rac2 bin]#
[root@rac2 bin]# ./crsctl config crs
CRS-4621: Oracle High Availability Services autostart is disabled.
[root@rac2 bin]#
[root@rac2 bin]# cd /oradb/app/oracle/grid/19.0.0/crs/install
[root@rac2 install]#
[root@rac2 install]# ls -al rootcrs.sh
-rwxr-x---. 1 root dba 8055 May 21 09:07 rootcrs.sh
[root@rac2 install]#
[root@rac2 install]# ./rootcrs.sh -updateosfiles
Using configuration parameter file: /oradb/app/oracle/grid/19.0.0/crs/install/crsconfig_params
The log of current session can be found at:
  /oradb/app/base/crsdata/rac2/crsconfig/crsupdate_osfiles_rac2_2026-05-26_05-19-08PM.log
Redirecting to /bin/systemctl restart rsyslog.service
2026/05/26 17:19:16 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
[root@rac2 install]#
[root@rac2 install]#
[root@rac2 install]# cd /oradb/app/oracle/grid/19.0.0/bin/
[root@rac2 bin]#
[root@rac2 bin]# ./crsctl config crs
CRS-4622: Oracle High Availability Services autostart is enabled.
[root@rac2 bin]#

 

Oracle CRS / DB 시작

[root@rac1 bin]#
[root@rac1 bin]#
[root@rac1 bin]# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@rac1 bin]#
[root@rac1 bin]# su - oracle
[oracle@rac1 ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba)
[oracle@rac1 ~]$
[oracle@rac1 ~]$ env | grep SID
ORACLE_SID=OCPRODDB1
[oracle@rac1 ~]$ srvctl stop instance -d RACDB -i RACDB1
[oracle@rac1 ~]$

 

기타사항

주의사항

 

참고문서

반응형

+ Recent posts