Oracle Controlfile 控制文件

Database►Oracle Comments
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
[root@ksqit0102m network-scripts]# cd /etc/sysconfig/network-scripts/
[root@ksqit0102m network-scripts]# ls -lrth | tail -12 | sort -k9
-rw-r--r--  1 root root  165 Jan  7  2021 ifcfg-bond0
-rw-r--r--  1 root root   98 Jan  7  2021 ifcfg-bond1
-rw-r--r--  1 root root   99 Jan 25  2021 ifcfg-bond1.3681
-rw-r--r--  1 root root  100 Aug 27 10:22 ifcfg-bond1.3684
-rw-r--r--  1 root root   99 Jan 25  2021 ifcfg-bond1.3901
-rw-r--r--  1 root root  111 Jan 25  2021 ifcfg-br3681
-rw-r--r--  1 root root  111 Aug 27 10:23 ifcfg-br3684
-rw-r--r--  1 root root  110 Jan 25  2021 ifcfg-br3901
-rw-r--r--  1 root root  311 Jan  7  2021 ifcfg-enp61s0f0
-rw-r--r--  1 root root  311 Jan  7  2021 ifcfg-enp61s0f1
-rw-r--r--  1 root root   85 Jan  7  2021 ifcfg-ens1f0
-rw-r--r--  1 root root   85 Jan  7  2021 ifcfg-ens4f0
[root@ksqit0102m network-scripts]# cat ifcfg-bond0
DEVICE=bond0
IPADDR=10.207.83.21
NETMASK=255.255.255.0
GATEWAY=10.207.83.254
BOOTPROTO=none
USERCTL=no
BONDING_OPTS="mode=1 miimon=100 primary=enp61s0f0"
HOTPLUG=no
[root@ksqit0102m network-scripts]# cat ifcfg-enp61s0f0
TYPE=Ethernet
PROXY_METHOD=none
BROWSER_ONLY=no
BOOTPROTO=none
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6_ADDR_GEN_MODE=stable-privacy
NAME=enp61s0f0
UUID=39a8362a-2f2a-40e7-acbb-017147930f1a
DEVICE=enp61s0f0
ONBOOT=yes
SLAVE=yes
MASTER=bond0
[root@ksqit0102m network-scripts]# cat ifcfg-enp61s0f1
TYPE=Ethernet
PROXY_METHOD=none
BROWSER_ONLY=no
BOOTPROTO=dhcp
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6_ADDR_GEN_MODE=stable-privacy
NAME=enp61s0f1
UUID=f16d05c9-e27c-44a7-a617-343da8e27c67
DEVICE=enp61s0f1
ONBOOT=yes
SLAVE=yes
MASTER=bond0
[root@ksqit0102m network-scripts]# cat ifcfg-bond1.3681
DEVICE=bond1.3681
NAME="VLAN3681 sqit 10.207.81"
BOOTPROTO=none
USERCTL=no
VLAN=yes
BRIDGE='br3681'
ONBOOT=yes
[root@ksqit0102m network-scripts]# cat ifcfg-br3681
DEVICE='br3681'
NAME="Br3681 vlan3681 10.207.81"
NM_CONTROLLED='yes'
ONBOOT='yes'
TYPE='Bridge'
BOOTPROTO=none
[root@ksqit0102m ~]# brctl show
bridge name	bridge id		STP enabled	interfaces
br3681		8000.f010907f853d	no		bond1.3681
br3684		8000.f010907f853d	no		bond1.3684
2222222eth0
2222222vnet0
2222222vnet1
2222222vnet2
2222222vnet3
2222222vnet4
2222222vnet5
2222222vnet6
2222222vnet7
2222222vnet8
br3901		8000.f010907f853d	no		bond1.3901
virbr0		8000.5254000289d9	yes		virbr0-nic

[root@ksqit0102m ~]# df -TH
Filesystem                    Type      Size  Used Avail Use% Mounted on
devtmpfs                      devtmpfs  270G     0  270G   0% /dev
tmpfs                         tmpfs     270G     0  270G   0% /dev/shm
tmpfs                         tmpfs     270G  323M  270G   1% /run
tmpfs                         tmpfs     270G     0  270G   0% /sys/fs/cgroup
/dev/mapper/vg_root-lv_root   xfs        54G   18G   36G  34% /
/dev/sda1                     xfs       1.1G  196M  868M  19% /boot
/dev/mapper/vg_root-lv_tmp    xfs        22G  256M   22G   2% /tmp
/dev/mapper/vg_root-lv_boslog xfs       5.4G   35M  5.4G   1% /boslog
/dev/mapper/vg_root-lv_nbu65  xfs        17G  3.2G   13G  20% /nbu65
/dev/mapper/vg_root-lv_patrol xfs       5.4G  1.2G  4.3G  22% /patrol
tmpfs                         tmpfs      54G   33k   54G   1% /run/user/0
/dev/mapper/vg_data-lv_data   xfs       5.0T  4.3T  724G  86% /data

[root@ksqit0102m data]# ls -lrth /data
total 0
drwxr-xr-x 2 root root 37 Aug 20 19:15 template_centos78
drwxr-xr-x 2 root root 84 Aug 20 20:53 sqmsbmslakafka01
drwxr-xr-x 2 root root 72 Aug 20 20:54 sqmsbmslakafka02
drwxr-xr-x 2 root root 72 Aug 20 20:55 sqmsbmslakafka03
drwxr-xr-x 2 root root 78 Aug 20 20:56 sqmsbmslaes01
drwxr-xr-x 2 root root 78 Aug 20 20:56 sqmsbmslaes02
drwxr-xr-x 2 root root 66 Aug 20 20:57 sqmsbmslaes03
drwxr-xr-x 2 root root 70 Aug 20 21:12 sqmsbmsiaprom01
drwxr-xr-x 2 root root 88 Aug 20 21:12 sqmsbmsiapromfed01
[root@ksqit0102m data]# virsh list --all
 Id    Name                           State
----------------------------------------------------
 38    sqmsbmsiaprom01                running
 39    sqmsbmsiapromfed01             running
 49    sqmsbmslakafka01               running
 50    sqmsbmslakafka02               running
 51    sqmsbmslakafka03               running
 52    sqmsbmslaes01                  running
 53    sqmsbmslaes02                  running
 54    sqmsbmslaes03                  running
 -     template_centos78              shut off

[root@ksqit0102m ~]# virsh attach-interface --domain sqmsbmslaes01 --type bridge --source 3684 --model virtio --config --persistent

[root@ksqit0102m ~]# virsh attach-disk --domain sqmsbmslaes01 --source /data/sqmsbmslaes01/sqmsbmslaes01-data.qcow2 --config --persistent

[root@ksqit0102m ~]# virsh domiflist --domain sqmsbmslaes01
Interface  Type       Source     Model       MAC
-------------------------------------------------------
vnet6      bridge     br3684     virtio      52:54:00:c9:e0:fd

[root@ksqit0102m ~]# virsh domifaddr --domain sqmsbmslaes01 --source agent
 Name       MAC address          Protocol     Address
-------------------------------------------------------------------------------
 lo         00:00:00:00:00:00    ipv4         127.0.0.1/8
 -          -                    ipv6         ::1/128
 eth0       52:54:00:c9:e0:fd    ipv4         10.207.84.13/24
 -          -                    ipv6         fe80::5054:ff:fec9:e0fd/64

[root@ksqit0102m ~]# virsh domblklist --domain sqmsbmslaes01
Target     Source
------------------------------------------------
vda        /data/sqmsbmslaes01/sqmsbmslaes01.qcow2
vdb        /data/sqmsbmslaes01/sqmsbmslaes01-disk1.qcow2

素丶素丶丶wodetian

忍一时越想越气，退一步越想越亏。