06 2021 档案
摘要:## 1.创建测试环境 ### 1.1.新建用户和表 ```sql CREATE USER monkey01 IDENTIFIED BY monkey01; GRANT UNLIMITED TABLESPACE TO MONKEY01; GRANT CREATE SESSION TO MONKEY0
阅读全文
摘要:1.确定增量恢复起点SCN 有如下方法: 备库查看丢失的归档序列号 --备库查看丢失的归档号 SELECT * FROM V$ARCHIVE_GAP; --主库执行,查看SCN,146为第一个缺失归档的序列号 SELECT FIRST_CHANGE# FROM V$ARCHIVED_LOG WHER
阅读全文
摘要:1.安裝前環境 1.1.關閉防火墻(主備機) systemctl stop firewalld systemctl disable firewalld systemctl disable NetworkManager systemctl stop NetworkManager vi /etc/sel
阅读全文