반응형
※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 ~]$
기타사항
주의사항

참고문서
- How to Manage Oracle Grid Infrastructure During Operating System Upgrades KB87228
- https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/upgrading-os-for-an-oracle-grid-infrastructure-server.html
반응형
