标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-00742 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 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-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 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (103)
- 数据库 (1,714)
- DB2 (22)
- MySQL (74)
- Oracle (1,574)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (160)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (68)
- Oracle Bug (8)
- Oracle RAC (53)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (574)
- Oracle安装升级 (94)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (81)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (28)
- SQL Server恢复 (9)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- 使用sid方式直接访问pdb(USE_SID_AS_SERVICE_LISTENER)
- ORA-00069: cannot acquire lock — table locks disabled for xxxx
- ORA-600 [4000] [a]相关bug
- sql server数据库“正在恢复”故障处理
- 如何判断数据文件是否处于begin backup状态
- CDM备份缺少归档打开数据库报ORA-600 kcbzib_kcrsds_1故障处理
- ORA-07445: exception encountered: core dump [expgod()+43] [IN_PAGE_ERROR]
- 2025年第一起ORA-600 16703故障恢复
- _gc_undo_affinity=FALSE触发ORA-01558
- public授权语句
- 中文环境显示AR8MSWIN1256(阿拉伯语字符集)
- 处理 Oracle 块损坏
- Oracle各种类型坏块说明和处理
- fio测试io,导致磁盘文件系统损坏故障恢复
- ORA-742 写丢失常见bug记录
- Oracle 19c 202501补丁(RUs+OJVM)-19.26
- 避免 19c 数据库性能问题需要考虑的事项 (Doc ID 3050476.1)
- Bug 21915719 Database hang or may fail to OPEN in 12c IBM AIX or HPUX Itanium – ORA-742, DEADLOCK or ORA-600 [kcrfrgv_nextlwn_scn] ORA-600 [krr_process_read_error_2]
- ORA-600 ktuPopDictI_1恢复
- impdp导入数据丢失sys授权问题分析
分类目录归档:操作系统
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