목록Database (40)

DoubleDBDeep

[ORACLE] RMAN Incremental backup 및 확인

증분백업에 대해서 .. lv0 = 처음 전체 백업 / lv1= lv0 대비 바뀐것만 백업lv0 백업#!/bin/bashexport ORACLE_SID=wintrgexport ORACLE_UNQNAME=wintrgexport ORACLE_UNQNAME_LOWER=`echo $ORACLE_UNQNAME | tr A-Z a-z`export EDITOR=viexport LANG=Cexport ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1export DT=`date +%Y%m%d%H%M`/u01/app/oracle/product/19.0.0.0/dbhome_1/bin/rman target / log /u01/backup/log/${ORACLE_SID}_lv0_${..
ORACLE/Backup & Recovery 2025. 4. 15. 08:38
[ORACLE] 19.26 패치 OPatch / Oracle Database 19.26.0.0.0 RU

싱글이어서 DB패치만 했음 1. 패치 다운받고 언집[target@oracle:/media/sf_01.oracle/4.Opatch/2.grid]> unzip 19.26_p37257886_190000_Linux-x86-64.zip -d /u01/patch 2. DB 패치[target@oracle:/u01/patch/37257886]> opatch apply ./37260974 -oh /u01/app/oracle/product/19.0.0.0/dbhome_1Oracle Interim Patch Installer version 12.2.0.1.45Copyright (c) 2025, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/ora..
ORACLE/INSTALL 2025. 3. 20. 13:20
Linux 64bit | Oracle database 19c Gateway for DRDA 설치 (DB2<-> ORACLE DBLINK 연결)

오라클 엔진에 종속되게 하지 않고 유저/엔진 분리함  1. 게이트웨이 전용 유저 생성/usr/sbin/useradd -g oinstall -G oinstall,dba,dgdba,kmdba,racdba,vboxsf db2gwmkdir -p /u02/app/oracle/product/19.0.0.0/dbhome_1chown -R db2gw:oinstall /u02chown -R db2gw:oinstall /u02/app/oracle/productchmod -R 775 /u02# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then . ~/.bashrcfi# User specific environment and startup ..
ETC/도전 2025. 3. 20. 10:45
이전 Prev 1 2 3 4 5 ··· 14 Next 다음