标签云
asm恢复 bbed bootstrap$ dul kcbzib_kcrsds_1 kccpb_sanity_check_2 kcratr_nab_less_than_odr MySQL恢复 obet ORA-00312 ORA-00704 ORA-00742 ORA-01110 ORA-01200 ORA-01555 ORA-01578 ORA-01595 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-600 kcratr_nab_less_than_odr ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 ORACLE恢复 Oracle 恢复 ORACLE数据库恢复 oracle碎片 OSD-04016 YOUR FILES ARE ENCRYPTED 比特币加密文章分类
- MongoDB (1)
- MongoDB恢复 (1)
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (112)
- 数据库 (1,884)
- DB2 (22)
- MySQL (82)
- Oracle (1,709)
- Data Guard (53)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (168)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (73)
- Oracle Bug (8)
- Oracle RAC (56)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (29)
- Oracle备份恢复 (662)
- Oracle安装升级 (108)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (91)
- PostgreSQL (37)
- pdu工具 (7)
- PostgreSQL恢复 (13)
- SQL Server (34)
- SQL Server恢复 (14)
- TimesTen (7)
- 达梦数据库 (5)
- 达梦恢复 (3)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (51)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (34)
- MongoDB (1)
-
最近发表
- 记录19c ASM磁盘掉线触发ORA-59048故障处理
- aix平台Oracle数据库由于断电无法启动故障处理
- 断电引起ORA-600 3005故障处理
- 记录一次云存储资源到期之后引起的数据库恢复
- Firebird 损坏数据库数据抢救工具—firebirdext
- Oracle 19c 202610补丁(RUs+OJVM)-19.33
- 由于con$.con#值达到极限,触发数据库增加约束报ORA-600 12807错误
- MongoDB 离线提取工具—mongoext
- .bres勒索病毒加密数据库dmp文件可恢复
- ORA-600 krsm_mrp_rebuild_lf_list.lno_mismatch
- 记录一次0丢失的ORA-00354: 损坏重做日志块标头故障恢复
- 不当数据库恢复操作导致一个月数据丢失
- obet快速修复oracle 位图损坏块
- 不太常见的10.2.0.1的oracle redo损坏恢复
- obet forcecopy功能抢救硬件故障中的数据文件
- kcratr_nab_less_than_odr和system坏块故障处理
- 通过obet 恢复system坏块,打开数据库
- obet dbv功能完整说明
- 分享一例运行在aix上的sap系统数据库恢复过程
- OBET-Oracle Block Editor Tool使用说明
分类目录归档:操作系统
fio测试io,导致磁盘文件系统损坏故障恢复
运行在云平台上的达梦数据库,部署了DMDataWatch(类似oracle的dataguard),在重启主备库进行扩容内存之后,发现两个机器数据库所在磁盘的分区信息,lvm信息全部丢失,通过查看history文件,最终确认在24年9月份做了一次fio的性能测试,但是当时数据没有出问题,一直运行至今,现在重启两个机器系统之后,均重现同样问题,导致主备容灾,备份全备异常.

通过对磁盘进行分析,发现客户说描述的分区信息(从磁盘2T,三个分区data,bak,arch,而且分区大小也一直10:6:4),但是没有发现lvm信息

对发现的分区进行恢复,发现达梦数据库相关文件,备份文件,以及arch归档日志



把恢复的数据传输到客户新划分磁盘的达梦数据库服务器上,然后达梦厂商使用备份还原,和原库启动均正常,运气不错,完成了本次的达梦数据故障恢复.
通过这次故障,有几点我们需要引以为戒:
1.千万不要在生产环境做类似磁盘写操作的io性能测试,比如fio,orion等
2.对于有主备架构的系统,尽量不要同时进行维护,在确认一个库正常之后,再操作另外一个库
Linux 8 修改网卡名称
在某些情况下,我们希望通过修改网卡的名称,从而避免应用层面的一些配置(比如oracle rac 网络从千兆换成万兆,我们直接把万兆网卡的名称修改和之前使用的网卡名称一致,集群层面不用做任何配置),这里做一个测试,验证在linux 8(redhat/oracle linux/Rocky/AlmaLinux/centos等)修改网卡名称可行性:
查看当前主机网卡名称情况(有两个网卡ens160和ens192)
[root@xifenfeidg network-scripts]# cat /etc/redhat-release
Red Hat Enterprise Linux release 8.9 (Ootpa)
[root@xifenfeidg network-scripts]# cat /etc/oracle-release
Oracle Linux Server release 8.9
[root@xifenfeidg network-scripts]# ifconfig
ens160: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.118.141 netmask 255.255.255.0 broadcast 192.168.118.255
inet6 fe80::20c:29ff:fe2d:1c85 prefixlen 64 scopeid 0x20<link>
ether 00:0c:29:2d:1c:85 txqueuelen 1000 (Ethernet)
RX packets 265118 bytes 392933574 (374.7 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 24828 bytes 1374591 (1.3 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
ens192: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.222.18 netmask 255.255.255.0 broadcast 192.168.222.255
inet6 fe80::20c:29ff:fe2d:1c8f prefixlen 64 scopeid 0x20<link>
ether 00:0c:29:2d:1c:8f txqueuelen 1000 (Ethernet)
RX packets 165 bytes 18748 (18.3 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 127 bytes 21755 (21.2 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10<host>
loop txqueuelen 1000 (Local Loopback)
RX packets 6403 bytes 648853 (633.6 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 6403 bytes 648853 (633.6 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
virbr0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500
ether 52:54:00:ab:b4:34 txqueuelen 1000 (Ethernet)
RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
[root@xifenfeidg ~]# nmcli d s
DEVICE TYPE STATE CONNECTION
ens160 ethernet connected ens160
ens192 ethernet connected ens192
virbr0 bridge unmanaged --
lo loopback unmanaged --
[root@xifenfeidg ~]# cd /etc/sysconfig/network-scripts/
[root@xifenfeidg network-scripts]# ls
ifcfg-ens160 ifcfg-ens192
尝试把ens160修改为ens191,删除ens160设备
[root@xifenfeidg network-scripts]# nmcli connection delete ens160
Connection 'ens160' (ae9669d8-3db3-424e-8a0e-41d8b05197d0) successfully deleted.
[root@xifenfeidg network-scripts]# ifconfig
ens160: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 00:0c:29:2d:1c:85 txqueuelen 1000 (Ethernet)
RX packets 291009 bytes 431437623 (411.4 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 27085 bytes 1499570 (1.4 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
ens192: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.222.18 netmask 255.255.255.0 broadcast 192.168.222.255
inet6 fe80::20c:29ff:fe2d:1c8f prefixlen 64 scopeid 0x20<link>
ether 00:0c:29:2d:1c:8f txqueuelen 1000 (Ethernet)
RX packets 193 bytes 21530 (21.0 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 156 bytes 27505 (26.8 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10<host>
loop txqueuelen 1000 (Local Loopback)
RX packets 6427 bytes 650593 (635.3 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 6427 bytes 650593 (635.3 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
virbr0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500
ether 52:54:00:ab:b4:34 txqueuelen 1000 (Ethernet)
RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
[root@xifenfeidg network-scripts]# nmcli d s
DEVICE TYPE STATE CONNECTION
ens192 ethernet connected ens192
ens160 ethernet disconnected --
virbr0 bridge unmanaged --
lo loopback unmanaged --
增加ens191设备(注意mac地址使用之前ens160)
[root@xifenfeidg network-scripts]# nmcli connection add type ethernet con-name ens191 ifname ens191 mac 00:0c:29:2d:1c:85 Connection 'ens191' (62a5fd83-8dc9-407d-83cc-1327d400fa0b) successfully added. [root@xifenfeidg network-scripts]# [root@xifenfeidg network-scripts]# nmcli d s DEVICE TYPE STATE CONNECTION ens192 ethernet connected ens192 ens160 ethernet disconnected -- virbr0 bridge unmanaged -- lo loopback unmanaged --
重启主机
[root@xifenfeidg network-scripts]# reboot Activate the web console with: systemctl enable --now cockpit.socket Last login: Tue Sep 3 14:12:20 2024 from 192.168.222.1
重启之后登录主机查看网络信息(确认网卡名称从ens160修改为ens191)
[root@xifenfeidg ~]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: ens191: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
link/ether 00:0c:29:2d:1c:85 brd ff:ff:ff:ff:ff:ff
altname enp3s0
inet 192.168.118.141/24 brd 192.168.118.255 scope global dynamic noprefixroute ens191
valid_lft 1788sec preferred_lft 1788sec
inet6 fe80::30e4:c5bf:692a:2753/64 scope link noprefixroute
valid_lft forever preferred_lft forever
3: ens192: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
link/ether 00:0c:29:2d:1c:8f brd ff:ff:ff:ff:ff:ff
altname enp11s0
inet 192.168.222.18/24 brd 192.168.222.255 scope global noprefixroute ens192
valid_lft forever preferred_lft forever
inet6 fe80::20c:29ff:fe2d:1c8f/64 scope link
valid_lft forever preferred_lft forever
4: virbr0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN group default qlen 1000
link/ether 52:54:00:ab:b4:34 brd ff:ff:ff:ff:ff:ff
inet 192.168.122.1/24 brd 192.168.122.255 scope global virbr0
valid_lft forever preferred_lft forever
[root@xifenfeidg ~]# cd /etc/sysconfig/network-scripts/
[root@xifenfeidg network-scripts]# ls -ltr
total 8
-rw-r--r--. 1 root root 308 Jul 31 05:04 ifcfg-ens192
-rw-r--r--. 1 root root 300 Sep 3 14:16 ifcfg-ens191
[root@xifenfeidg network-scripts]# nmcli d s
DEVICE TYPE STATE CONNECTION
ens191 ethernet connected ens191
ens192 ethernet connected ens192
virbr0 bridge connected (externally) virbr0
lo loopback unmanaged --
配置win环境ssh和sftp并实现免密登录
在某些情况下,需要在win环境中安装ssh,sftp等服务,可以考虑通过安装OpenSSH,下载地址:https://github.com/PowerShell/Win32-OpenSSH/releases,下载最新版OpenSSH-Win64.zip并解压
openssh安装服务
Microsoft Windows [版本 10.0.19045.3208]
(c) Microsoft Corporation。保留所有权利。
C:\Windows\system32>cd E:\OpenSSH-Win64
C:\Windows\system32>e:
E:\OpenSSH-Win64>powershell.exe -ExecutionPolicy Bypass -File install-sshd.ps1
[*] E:\OpenSSH-Win64\moduli
Inheritance is removed from 'E:\OpenSSH-Win64\moduli'.
'NT AUTHORITY\Authenticated Users' now has Read access to 'E:\OpenSSH-Win64\moduli'.
'BUILTIN\Users' now has Read access to 'E:\OpenSSH-Win64\moduli'.
Repaired permissions
[*] C:\ProgramData\ssh
looks good
[SC] SetServiceObjectSecurity 成功
[SC] ChangeServiceConfig2 成功
[SC] ChangeServiceConfig2 成功
sshd and ssh-agent services successfully installed
Updated Machine PATH to include OpenSSH directory, restart/re-login required to take effect globally
E:\OpenSSH-Win64>net start sshd
OpenSSH SSH Server 服务正在启动 ..
OpenSSH SSH Server 服务已经启动成功。
E:\OpenSSH-Win64>ssh -V
OpenSSH_for_Windows_9.5p1, LibreSSL 3.8.2
也可以可以通过cmd命令设置:sc config sshd start= auto
配置免密登录
1)修改C:\ProgramData\ssh\ssh_config文件
PubkeyAuthentication yes AuthorizedKeysFile %programdata%/ssh/administrators_authorized_keys
2)拷贝C:\ProgramData\ssh\ssh_host_rsa_key为C:\ProgramData\ssh\administrators_authorized_keys
3)下载ssh_host_rsa_key和ssh_host_rsa_key.pub文件,放到其他机器的C:\Users\用户名\.ssh目录中并重命名为id_rsa和id_rsa.pub
测试其他机器免密ssh/sftp登录
C:\Users\XFF>ssh xifenfei@192.168.222.2 Microsoft Windows [版本 10.0.19045.3208] (c) Microsoft Corporation。保留所有权利。 xifenfei@DESKTOP-3PQ0P6C C:\Users\xifenfei>exit Connection to 192.168.222.2 closed. C:\Users\XFF>sftp xifenfei@192.168.222.2 Connected to 192.168.222.2. sftp> pwd Remote working directory: /C:/Users/xifenfei


加我微信(17813235971)
加我QQ(107644445)

