資料庫主機重啟卡住問題處理分享

硬體平臺 & 作業系統 

Linux x86 64-bit

[root@nursing ~]# vgscan

[root@nursing ~]# vgchange -ay vg_mcsdb

[root@nursing ~]# mount /dev/mapper/vg_mcsdb-lv_home /home

[root@nursing ~]# ls -l /home/

total 32

drwxr-xr-x.  7 1101     1101  4096 Oct 15  2020 app

drwx------. 24    500      500  4096 Mar 22  2021 ewell

drwx------.  2 1101    1101  16384 Oct 13  2020 lost+found

drwx------   4   1101     1102  4096 Nov 26  2020 mockbuild

drwx------. 34 1101     1101   4096 May 11 20:10 oracle

[root@nursing ~]# gropadd -g 1100 oinstall

[root@nursing ~]#  groupadd -g 1100 oinstall

[root@nursing ~]#  groupdel oinstall

[root@nursing ~]#  groupadd -g 1100 oinstall

[root@nursing ~]#  groupadd dba

[root@nursing ~]#  useradd -u 1100 -g oinstall -G dba oracle

[root@nursing ~]# service iptable stop

[root@nursing ~]# chkconfig iptables off

[root@nursing ~]#  service NetworkManager stop

[root@nursing ~]# chkconfig NetworkManager off

[root@nursing ~]# vi /etc/selinux/config

修改：SELINUX=disabled

[root@nursing ~]# yum install  binutils compat-libstdc++-33 compat-libstdc++-296 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++-devel make openmotif sysstat unixODBC unixODBC-devel compat-libcap1

[root@nursing ~]# vi/etc/hosts

增加：172.20.1.14 nursing

[root@nursing ~]# crontab -l

10 20 * * * su - oracle -c "/home/oracle/del_arch.sh"

[root@nursing ~]# cat /home/oracle/del_arch.sh

#!/bin/bash

source /home/oracle/.bash_profile

rman target / >/home/oracle/bak.log <<EOF

crosscheck archivelog all;

delete noprompt expired archivelog all;

delete noprompt archivelog all completed before 'sysdate-3';

exit;

EOF