
MySQL Backup and Restore
MySQL 备份恢复
姚远ACE
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
-
原创 Dataguard环境下archivelog删除测试的设置
RMAN> show ARCHIVELOG DELETION POLICY ;RMAN configuration parameters for database with db_unique_name ORCL are:CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultSQL> set linesize 200; select * from v$flash_recovery_area_usage where FILE_T2020-09-04 15:24:4167
0
-
原创 Xtrabackup版本低,不支持备份MySQL8.0.20,提示Unknown redo log format (4).
备份时出现下面的提示Unknown redo log format (4). Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/ upgrading-downgrading.html.MySQL8.0.20的Release Note中有下面的提示:InnoDB: Redo log records for modifications to undo tablespaces increased in size2020-07-14 10:43:25557
1
-
转载 快速找到 binlog 中是否有大事务
https://mp.weixin.qq.com/s/jX1RSOcHq0LTUPwXaHqjfQ2020-07-11 09:09:25140
0