Oracle 用户管理模式下的恢复案例-完全恢复

介绍

        通过实操案例,熟悉oracle数据库在归档模式下,非系统数据文件丢失后,怎么完全恢复数据的过程和需要注意的地方,希望可以对读者带来帮助。

1. 环境准备

查询数据库有没有需要恢复的文件

SYS@hfzcdb> select * from v$recover_file;  

关库冷备

su - oracle 
shutdown immediate; 
mkdir /backup/hfzcdb1 
mkdir /backup/hfzcdb2 
mkdir /backup/hfzcdbhot 
cp /oradata/hfzcdb/* /backup/hfzcdb1 
startup 

归档打开

SYS@hfzcdb> archive log list; 
Database log mode Archive Mode 
Automatic archival Enabled 
Archive destination USE_DB_RECOVERY_FILE_DEST 
Oldest online log sequence 12 
Next log sequence to archive 16 
Current log sequence 16 

准备环境

create tablespace hfedu datafile '/oradata/hfzcdb/hfedu01.dbf' size 20m;
create user hfedu identified by hfedu123 default tablespace hfedu; 
grant dba to hfedu; 
sqlplus "/as sysdba"; 
conn hfedu/hfedu123 
create table hfedu(id int,name varchar2(10)); 
insert into hfedu values(1,'hfedu01'); 
commit; 
conn /as sysdba; 
shutdown immediate; 

再冷备一份

host cp /oradata/hfzcdb/* /backup/hfzcdb2 
*/ 
startup 
conn hfedu/hfedu123; 
select * from hfedu; 
insert into hfedu values(2,'hfedu02'); 
commit; 
select * from hfedu; 
ID NAME 
---------- ---------- 
1 hfedu01 
2 hfedu02 

修改表空间的备份模式,备份已经修改的数据文件

!mkdir /backup/hfzcdbhot 
conn /as sysdba; 
alter tablespace hfedu begin backup; 
host cp /oradata/hfzcdb/hfedu01.dbf /backup/hfzcdbhot 
alter tablespace hfedu end backup; 
conn hfedu/hfedu123; 
insert into hfedu values(3,'hfedu03'); 
commit; 
select * from hfedu; 
ID NAME 
---------- ---------- 
1 hfedu01 
2 hfedu02 
3 hfedu03 

切换归档日志

alter system switch logfile; 

2. 数据库关闭下如何完全恢复丢失的数据文件

--【只丢失数据文件,归档文件和重做日志文件都在】

包括系统表空间(系统数据文件)、Undo表空间、整个数据库

步骤:

hfedu@hfzcdb> conn / as sysdba

SYS@hfzcdb> host rm -f /oradata/hfzcdb/*.dbf

SYS@hfzcdb> shutdown abort

[oracle@hfzcdb91:/oradata/hfzcdb]$ls -lsa

hfeduSQL> startup

ORACLE instance started.

Total System Global Area 2466249672 bytes

Fixed Size 8899528 bytes

Variable Size 671088640 bytes

Database Buffers 1778384896 bytes

Redo Buffers 7876608 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '/oradata/hfzcdb/system01.dbf'

hfeduSQL> select * from v$recovery_log; 【数据库中需要恢复的日志】

hfeduSQL> select * from v$recover_file;【数据库中需要恢复的文件】


FILE# ONLINE  ONLINE_ ERROR                                                                CHANGE# TIME                    CON_ID
---------- ------- ------- ----------------------------------------------------------------- ---------- ------------------- ----------
1 ONLINE  ONLINE  FILE NOT FOUND                                                             0                              0
2 ONLINE  ONLINE  FILE NOT FOUND                                                             0                              0
3 ONLINE  ONLINE  FILE NOT FOUND                                                             0                              0
4 ONLINE  ONLINE  FILE NOT FOUND                                                             0                              0
6 ONLINE  ONLINE  FILE NOT FOUND                                                             0                              0

hfeduSQL> host cp /backup/hfzcdb2/*.dbf /oradata/hfzcdb/

hfeduSQL> host cp /backup/hfzcdbhot/hfedu02.dbf /oradata/hfzcdb

hfeduSQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: '/oradata/hfzcdb/system01.dbf'

hfeduSQL> recover database; 【重做日志中恢复的日志,就不需要归档日志,直接用redo日志恢复】

alter日志:

Media Recovery Start

Started logmerger process

2023-03-28T18:14:34.360123+08:00

Parallel Media Recovery started with 4 slaves

2023-03-28T18:14:34.743870+08:00

Recovery of Online Redo Log: Thread 1 Group 6 Seq 41 Reading mem 0

Mem# 0: /oradata/hfzcdb/redo06.rdo

2023-03-28T18:14:37.404648+08:00

Recovery of Online Redo Log: Thread 1 Group 1 Seq 42 Reading mem 0

Mem# 0: /oradata/hfzcdb/redo01.rdo

2023-03-28T18:14:38.275438+08:00

Recovery of Online Redo Log: Thread 1 Group 2 Seq 43 Reading mem 0

Mem# 0: /oradata/hfzcdb/redo02.rdo

2023-03-28T18:14:39.471615+08:00

Recovery of Online Redo Log: Thread 1 Group 3 Seq 44 Reading mem 0

Mem# 0: /oradata/hfzcdb/redo03.rdo

2023-03-28T18:14:39.587248+08:00

Recovery of Online Redo Log: Thread 1 Group 4 Seq 45 Reading mem 0

Mem# 0: /oradata/hfzcdb/redo04.rdo

2023-03-28T18:14:40.161213+08:00

Recovery of Online Redo Log: Thread 1 Group 5 Seq 46 Reading mem 0

Mem# 0: /oradata/hfzcdb/redo05.rdo

2023-03-28T18:14:43.988793+08:00

Media Recovery Complete (hfzcdb)

Completed: ALTER DATABASE RECOVER database

2023-03-28T18:14:56.818204+08:00

alter database open

hfeduSQL> recover database;【重做日志中没有,需要用归档日志文件恢复】

ORA-00279: change 1986594 generated at 03/27/2023 21:05:38 needed for thread 1

ORA-00289: suggestion : /archive/HFZCDB/archivelog/2023_03_27/o1_mf_1_41_l237wpsm_.arc

hfeduSQL> select * from v$recovery_log;


THREAD#  SEQUENCE# TIME                ARCHIVE_NAME                                 CON_ID
---------- ---------- ------------------- ---------------------------------------- ----------
1         42 2023-03-27 21:52:22                                                   0
1         43 2023-03-28 11:43:39 /archive/HFZCDB/archivelog/2023_03_28/o1          0
_mf_1_43_l24skhoc_.arc1         44 2023-03-28 11:59:43 /archive/HFZCDB/archivelog/2023_03_28/o1          0
_mf_1_44_l24skkz4_.arc1         45 2023-03-28 11:59:45 /archive/HFZCDB/archivelog/2023_03_28/o1          0
_mf_1_45_l24w22vq_.arc1         46 2023-03-28 12:42:42 /archive/HFZCDB/archivelog/2023_03_28/o1          0
_mf_1_46_l25hk27b_.arc1         47 2023-03-28 18:14:57 /archive/HFZCDB/archivelog/2023_03_28/o1          0
_mf_1_47_l25jl6ll_.arc1         48 2023-03-28 18:32:38 /archive/HFZCDB/archivelog/2023_03_28/o1          0
_mf_1_48_l25jl86d_.arc1         49 2023-03-28 18:32:39 /archive/HFZCDB/archivelog/2023_03_28/o1          0
_mf_1_49_l25jlk31_.arc

hfeduSQL> select * from v$log;


GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME             CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ ------------------- ----------
1          1         54  268435456        512          1 YES INACTIVE               2711950 2023-03-28 18:32:54      2711955 2023-03-28 18:33:03        0
2          1         55  268435456        512          1 NO  CURRENT                2711955 2023-03-28 18:33:03   1.8447E+19           0
6          1         53  268435456        512          1 YES INACTIVE               2711947 2023-03-28 18:32:54      2711950 2023-03-28 18:32:54        0
4          1         51  268435456        512          1 YES INACTIVE               2711941 2023-03-28 18:32:50      2711944 2023-03-28 18:32:52        0
5          1         52  268435456        512          1 YES INACTIVE               2711944 2023-03-28 18:32:52      2711947 2023-03-28 18:32:54        0
3          1         50  268435456        512          1 YES INACTIVE               2711938 2023-03-28 18:32:48      2711941 2023-03-28 18:32:50        06 rows selected.

【如果备份之后,还增加了表空间的话,还需要重建控制文件,再恢复】

Media recovery complete.

hfeduSQL> alter database open;

3. 数据库打开下如何完全恢复丢失的非系统数据文件

【系统文件先offline打开数据库后,再进行恢复】

hfeduSQL> host rm /oradata/hfzcdb/hfedu03.dbf

hfeduSQL> conn hfedu/hfedu123

hfedu@hfzcdb> insert into hfedu3 values(5,'hfedu5');

insert into hfedu3 values(5,'hfedu5')

*

ERROR at line 1:

ORA-01116: error in opening database file 6

ORA-01110: data file 6: '/oradata/hfzcdb/hfedu03.dbf'

ORA-27041: unable to open file

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

hfedu@hfzcdb> select *from v$recover_file;

no rows selected

hfedu@hfzcdb> alter system checkpoint;

ERROR:

ORA-03114: not connected to ORACLE

hfeduSQL> startup

ORACLE instance started.

Total System Global Area 2466249672 bytes

Fixed Size 8899528 bytes

Variable Size 671088640 bytes

Database Buffers 1778384896 bytes

Redo Buffers 7876608 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file

ORA-01110: data file 6: '/oradata/hfzcdb/hfedu03.dbf'

只要不是系统文件,这时候是可以把这个文件offline,打开数据库的

hfeduSQL> alter database datafile 6 offline;   Database altered.

再打开数据库

hfeduSQL> alter database open;
Database altered.

再查询哪个文件需要恢复

hfeduSQL> select * from v$recover_file;     -- 6号文件需要恢复
FILE# ONLINE  ONLINE_ ERROR                                                                CHANGE# TIME                    CON_ID
---------- ------- ------- ----------------------------------------------------------------- ---------- ------------------- ----------
6 OFFLINE OFFLINE FILE NOT FOUND                                                             0                              0

将之前备份的文件拷贝过来,进行恢复。

hfeduSQL> host cp /backup/hfzcdb1/hfedu03.dbf /oradata/hfzcdb/
hfeduSQL> recover datafile 6;
ORA-00279: change 1724884 generated at 03/28/2023 20:36:10 needed for thread 1
ORA-00289: suggestion : /archive/HFZCDB/archivelog/2023_03_28/o1_mf_1_26_l25rbmdp_.arc
ORA-00280: change 1724884 for thread 1 is in sequence #26Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 1725794 generated at 03/28/2023 20:45:07 needed for thread 1
ORA-00289: suggestion : /archive/HFZCDB/archivelog/2023_03_28/o1_mf_1_27_l25rbwpm_.arc
ORA-00280: change 1725794 for thread 1 is in sequence #27ORA-00279: change 1725808 generated at 03/28/2023 20:45:16 needed for thread 1
ORA-00289: suggestion : /archive/HFZCDB/archivelog/2023_03_28/o1_mf_1_28_l25rc1o6_.arc
ORA-00280: change 1725808 for thread 1 is in sequence #28ORA-00279: change 1725814 generated at 03/28/2023 20:45:21 needed for thread 1
ORA-00289: suggestion : /archive/HFZCDB/archivelog/2023_03_28/o1_mf_1_29_l25rc4p9_.arc
ORA-00280: change 1725814 for thread 1 is in sequence #29Log applied.
Media recovery complete.

再将 6 号文件 online,查询备份之后插入的数据还在。

hfeduSQL> conn hfedu/hfedu123
Connected.
hfedu@hfzcdb> select * from hfedu3;
select * from hfedu3
*
ERROR at line 1:
ORA-00376: file 6 cannot be read at this time
ORA-01110: data file 6: '/oradata/hfzcdb/hfedu03.dbf'
hfedu@hfzcdb> alter database datafile 6 online;Database altered.hfedu@hfzcdb> select * from hfedu3;ID NAME
---------- ----------------------------------------
1 hfedu01
2 hfedu02
3 hfedu03
4 hfedu04

4. 数据文件无备份情况下的如何完全恢复

【无备份的数据文件,需要在开启归档之前备份,或者是需要全部的归档文件才可以恢复】

SYS@hfzcdb> conn hfedu/hfedu123
Connected.
hfedu@hfzcdb> insert into hfedu3 values(5,'hfedu5');1 row created.hfedu@hfzcdb> alter system checkpoint;System altered.hfedu@hfzcdb> alter system switch logfile;System altered.hfedu@hfzcdb> host rm /oradata/hfzcdb/hfedu03.dbfhfedu@hfzcdb> insert into hfedu3 values(6,'hfedu6');1 row created.hfedu@hfzcdb> commit
2  ;Commit complete.hfedu@hfzcdb> alter system checkpoint;System altered.SYS@hfzcdb> shutdown abort
ORACLE instance shut down.

启动数据库,报文件丢失

SYS@hfzcdb> startup
ORACLE instance started.Total System Global Area 2466249672 bytes
Fixed Size                  8899528 bytes
Variable Size             671088640 bytes
Database Buffers         1778384896 bytes
Redo Buffers                7876608 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/oradata/hfzcdb/hfedu03.dbf'

将非 system 文件,offline 掉。

SYS@hfzcdb> alter database datafile 6 offline;Database altered.

查询数据库中需要恢复的文件

SYS@hfzcdb> select * from v$recover_file;
FILE# ONLINE  ONLINE_ ERROR                                                                CHANGE# TIME                    CON_ID
---------- ------- ------- ----------------------------------------------------------------- ---------- ------------------- ----------
6 OFFLINE OFFLINE FILE NOT FOUND                                                             0                              0

手动创建 6 号文件

SYS@hfzcdb> alter database create datafile 6;Database altered.SYS@hfzcdb> select * from v$recover_file;FILE# ONLINE  ONLINE_ ERROR                                                                CHANGE# TIME                    CON_ID
---------- ------- ------- ----------------------------------------------------------------- ---------- ------------------- ----------
6 OFFLINE OFFLINE                                                                      1723336 2023-03-28 20:25:34          0

启动数据库

SYS@hfzcdb> alter database open;
Database altered.SYS@hfzcdb> select * from v$recovery_log;
SYS@hfzcdb> host ls -ls /oradata/hfzcdb/
total 2734828
43920 -rw-r-----. 1 oracle oinstall  44974080 Mar 28 21:16 control01.ctl
43920 -rw-r-----. 1 oracle oinstall  44974080 Mar 28 21:16 control02.ctl
102416 -rw-r-----  1 oracle oinstall 104873984 Mar 28 21:15 hfedu02.dbf
51216 -rw-r-----  1 oracle oinstall  52445184 Mar 28 21:14 hfedu03.dbf
204804 -rw-r-----. 1 oracle oinstall 209715712 Mar 28 21:15 redo01.log
204804 -rw-r-----. 1 oracle oinstall 209715712 Mar 28 21:15 redo02.log
204804 -rw-r-----. 1 oracle oinstall 209715712 Mar 28 21:15 redo03.log
675856 -rw-r-----  1 oracle oinstall 692076544 Mar 28 21:15 sysaux01.dbf
860176 -rw-r-----  1 oracle oinstall 880820224 Mar 28 21:15 system01.dbf
4960 -rw-r-----  1 oracle oinstall  20987904 Mar 28 20:50 temp01.dbf
332816 -rw-r-----  1 oracle oinstall 340803584 Mar 28 21:15 undotbs01.dbf
5136 -rw-r-----  1 oracle oinstall   5259264 Mar 28 21:15 users01.dbf

再通过归档和在线日志文件进行恢复

这个时候的归档日志文件要有创建 6 号文件以后的所有归档才可以恢复

SYS@hfzcdb> recover datafile 6    【开启归档之后创建的文件才可以恢复】
ORA-00279: change 1723336 generated at 03/28/2023 20:25:34 needed for thread 1
ORA-00289: suggestion : /archive/HFZCDB/archivelog/2023_03_28/o1_mf_1_26_l25rbmdp_.arc
ORA-00280: change 1723336 for thread 1 is in sequence #26Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 1725794 generated at 03/28/2023 20:45:07 needed for thread 1
ORA-00289: suggestion : /archive/HFZCDB/archivelog/2023_03_28/o1_mf_1_27_l25rbwpm_.arc
ORA-00280: change 1725794 for thread 1 is in sequence #27ORA-00279: change 1725808 generated at 03/28/2023 20:45:16 needed for thread 1
ORA-00289: suggestion : /archive/HFZCDB/archivelog/2023_03_28/o1_mf_1_28_l25rc1o6_.arc
ORA-00280: change 1725808 for thread 1 is in sequence #28ORA-00279: change 1725814 generated at 03/28/2023 20:45:21 needed for thread 1
ORA-00289: suggestion : /archive/HFZCDB/archivelog/2023_03_28/o1_mf_1_29_l25rc4p9_.arc
ORA-00280: change 1725814 for thread 1 is in sequence #29ORA-00279: change 1725820 generated at 03/28/2023 20:45:24 needed for thread 1
ORA-00289: suggestion : /archive/HFZCDB/archivelog/2023_03_28/o1_mf_1_30_l25rpj1z_.arc
ORA-00280: change 1725820 for thread 1 is in sequence #30ORA-00279: change 1925835 generated at 03/28/2023 20:51:28 needed for thread 1
ORA-00289: suggestion : /archive/HFZCDB/archivelog/2023_03_28/o1_mf_1_31_l25s4850_.arc
ORA-00280: change 1925835 for thread 1 is in sequence #31ORA-00279: change 2026748 generated at 03/28/2023 20:58:48 needed for thread 1
ORA-00289: suggestion : /archive/HFZCDB/archivelog/2023_03_28/o1_mf_1_32_l25svkt3_.arc
ORA-00280: change 2026748 for thread 1 is in sequence #32Log applied.
Media recovery complete.

打开数据库,查询数据已经恢复

SYS@hfzcdb> alter database datafile 6 online;Database altered.SYS@hfzcdb> select * from hfedu.hfedu3;ID NAME
---------- ----------------------------------------
1 hfedu01
2 hfedu02
3 hfedu03
4 hfedu04
5 hfedu5
6 hfedu66 rows selected.SYS@hfzcdb>

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:http://www.xdnf.cn/news/35225.html

如若内容造成侵权/违法违规/事实不符,请联系一条长河网进行投诉反馈,一经查实,立即删除!

相关文章

【计算机网络】期末速成(2)

部分内容来源于网络&#xff0c;侵删~ 第五章 传输层 概述 传输层提供进程和进程之间的逻辑通信&#xff0c;靠**套接字Socket(主机IP地址&#xff0c;端口号)**找到应用进程。 传输层会对收到的报文进行差错检测。 比特流(物理层)-> 数据帧(数据链路层) -> 分组 / I…

Vue3网站锚点定位

网站上实现锚点定位的方法有很多&#xff0c;今天介绍vue3实现的定位效果的方式。通过scrollIntoViewh函数的行为&#xff0c;滑动至指定的容器。 一、样式布局 <template> <div style"width: 100%; display: flex;flex-direction: column;"><div …

微信小程序实现图片拖拽调换位置效果 -- 开箱即用

在编写类似发布朋友圈功能的功能时&#xff0c;需要实现图片的拖拽排序&#xff0c;删除图片等功能。 一、效果展示 **博主的小程序首页也采用了该示例代码&#xff0c;可以在威信中搜索&#xff1a;我的百宝工具箱 二、示例代码 1.1、在自己的小程序中创建组件 1.2、组件…

五、docker的网络模式

五、docker的网络模式 5.1 Docker的四种网络模式 当你安装docker时&#xff0c;它会自动创建三个网络&#xff0c;可使用如下命令查看&#xff1a; [rootlocalhost ~]# docker network ls NETWORK ID NAME DRIVER SCOPE 7390284b02d6 bridge bridge lo…

ros项目dual_arm_pick-place(对比moveit配置助手生成的文件)

目录 前言正文gazebo_controllers.yaml变更ros_controllers.yaml变更simple_moveit_controllers.yaml变更moveit_planning_execution.launch变更ros_controllers.launch变更其他文件 汇总总结 前言 在本专栏前文中讲到&#xff0c;作者有moveit配置助手导出的包marmbots&#…

【uni-app 微信小程序】新版本发布提示用户进行更新

知识准备 uni.getUpdateManager文档介绍 不支持APP与H5&#xff0c;所以在使用的时候要做好平台类型的判断&#xff0c;如何判断&#xff0c;参考条件编译处理多端差异 代码参考 export const updateApp () > {const updateManager uni.getUpdateManager()updateManag…

Java-操作xls替换文本或图片

准备xls模板文件&#xff1a;template.xls 要求根据不同的产品型号和图片&#xff0c;插入到模板文件中&#xff0c;然后再填充产品信息。 准备需要替换的图片和数据 功能实现 package net.work.controller.base;import io.swagger.annotations.Api; import io.swagger.annot…

.Net学习

1 什么是.NET Core .NET是开发平台&#xff0c;.NET Framework、.NET Core、Xamaarin/Mono的统称。 .NET Framework是只能在Windows上开发的技术 .NET Core是可以跨平台开发的技术 Xamaarin/Mono是移动端开发的技术 .NET Core&#xff1a;跨平台、免费、开源&#xff0c;可…

半监督学习与数据增强

✨✨ 欢迎大家来访Srlua的博文&#xff08;づ&#xffe3;3&#xffe3;&#xff09;づ╭❤&#xff5e;✨✨ &#x1f31f;&#x1f31f; 欢迎各位亲爱的读者&#xff0c;感谢你们抽出宝贵的时间来阅读我的文章。 我是Srlua小谢&#xff0c;在这里我会分享我的知识和经验。&am…

【成功解决:Can‘t uninstall ‘ultralytics‘. No files were found to uninstall.】

问题&#xff1a; 尝试卸载ultralytics时&#xff0c;使用pip uninstall ultralytics命令&#xff0c;已经卸载了ultralytics&#xff0c;但是仍出现Cant uninstall ultralytics. No files were found to uninstall&#xff0c;导致无法卸载干净。 原因 ultralytics相应的dis…

AcWing 3496. 特殊年份

文章目录 前言代码思路 前言 写简单题没啥。反正都是要写的&#xff0c;先把能拿到的分数拿了&#xff0c;之后有机会再去啃一啃硬骨头。啃不下来就算了。 代码 #include<bits/stdc.h> using namespace std; char a1[10],a2[10],a3[10],a4[10],a5[10]; int main(){cin…

MongoDB性能监控工具

mongostat mongostat是MongoDB自带的监控工具&#xff0c;其可以提供数据库节点或者整个集群当前的状态视图。该功能的设计非常类似于Linux系统中的vmstat命令&#xff0c;可以呈现出实时的状态变化。不同的是&#xff0c;mongostat所监视的对象是数据库进程。mongostat常用于…

【LeetCode: 999. 可以被一步捕获的棋子数 + 模拟】

&#x1f680; 算法题 &#x1f680; &#x1f332; 算法刷题专栏 | 面试必备算法 | 面试高频算法 &#x1f340; &#x1f332; 越难的东西,越要努力坚持&#xff0c;因为它具有很高的价值&#xff0c;算法就是这样✨ &#x1f332; 作者简介&#xff1a;硕风和炜&#xff0c;…

智创 AI 新视界 -- 优化 AI 模型训练效率的策略与技巧(16 - 1)

&#x1f496;&#x1f496;&#x1f496;亲爱的朋友们&#xff0c;热烈欢迎你们来到 青云交的博客&#xff01;能与你们在此邂逅&#xff0c;我满心欢喜&#xff0c;深感无比荣幸。在这个瞬息万变的时代&#xff0c;我们每个人都在苦苦追寻一处能让心灵安然栖息的港湾。而 我的…

专业140+总分420+上海交通大学819考研经验上交电子信息与通信工程,真题,大纲,参考书。博睿泽信息通信考研论坛,信息通信考研Jenny

考研结束&#xff0c;专业819信号系统与信号处理140&#xff0c;总分420&#xff0c;终于梦圆交大&#xff0c;高考时敢都不敢想目标&#xff0c;现在已经成为现实&#xff0c;考研后劲很大&#xff0c;这一年的复习经历&#xff0c;还是历历在目&#xff0c;整理一下&#xff…

K8S服务突然中断无法访问:报The node had condition: [DiskPressure]异常

一、背景 程序在运行过程中&#xff0c;突然无法访问&#xff0c;发现后台接口也无法访问&#xff1b;查看kuboard&#xff0c;发现报如下异常&#xff1a;The node had condition: [DiskPressure]. 继续查看磁盘使用率&#xff0c;发现系统盘使用率已经高达93%。问题前后呼应…

【工具变量】上市公司企业违规数据(企业当年是否违规、企业当年违规的次数)2000-2022年

一、测算方式&#xff1a;参考C刊《当代财经》纪亚方&#xff08;2023&#xff09;老师的研究&#xff0c;通过对上市公司被处罚涉及的年份进行追溯&#xff0c;为了保证企业违规行为变量度量的准确性&#xff0c;将追溯到公司被处罚的年份定义为违规年份。 采用两个指标对企业…

视频孪生携手视联网 智汇云舟亮相中国电信2024数字科技生态大会

12月3日&#xff0c;由中国电信主办的“2024数字科技生态大会”在广州盛大开幕。活动现场&#xff0c;前沿科技与创新理念交相辉映&#xff0c;数字科技未来蓝图徐徐展开。智汇云舟作为中国电信的战略合作伙伴&#xff0c;受邀出席本次活动。 展会期间&#xff0c;以“天翼视联…

Unity 使用LineRenderer制作模拟2d绳子

效果展示&#xff1a; 实现如下&#xff1a; 首先&#xff0c;直接上代码&#xff1a; using System.Collections; using System.Collections.Generic; using UnityEngine;public class LineFourRender : MonoBehaviour {public Transform StartNode;public Transform MidNod…

力扣-图论-4【算法学习day.54】

前言 ###我做这类文章一个重要的目的还是给正在学习的大家提供方向和记录学习过程&#xff08;例如想要掌握基础用法&#xff0c;该刷哪些题&#xff1f;&#xff09;我的解析也不会做的非常详细&#xff0c;只会提供思路和一些关键点&#xff0c;力扣上的大佬们的题解质量是非…