restoration process of the Oracle database is divided into two steps. First, all the retries stored in the redo log file are applied to the data file, and then all uncommitted transactions in the Redo are rolled back, in this way, all the data will be restored to the time of the disaster. Database recovery can only be used to redo data files before a fault occurs, restoring them to the time of failure, rat
it in the buffer, to avoid the addition of the command to the disk IO conflict.
auto-aof-rewrite-percentage #当前AOF文件大小是上次日志重写得到AOF文件大小的二倍时, automatically start a new log rewrite process.
auto-aof-rewrite-min-size 64MB #当前AOF文件启动新的日志重写过程的最小值 to avoid frequent rewrites due to small file sizes when Reids is just started.
What are you going to choose? Here are some suggestions from the official:In general, if you want to provide high data supportability, it is recommended that you use both pe
need for specialized techniques and program changes.
The recovery process has not changed and is very similar to the process of restoring files to a physical server.
This makes it possible to recover the file, which is even more important when we adopt other methods.
It is also possible to implement full and incremental backups, and this is particularly important as we discuss other approaches.
If you use specialized application-aware backup prog
server, so there is no need for special skills and program changes.The recovery process has not changed, much like the process of recovering files to a physical server.In this way, it is possible to recover files, which is even more important when we adopt other methods.It is also possible to implement full and incremental backups, which is especially important when we discuss other methods.If you are using a dedicated application-aware backup progra
.
E. Cross-room disaster preparedness, backup copy data. 2.MySQL Incremental Restore Prerequisites 2.1 Turn on MySQL log-bin log feature
[root@mysql ~]# egrep "\[mysqld]|log-bin" /data/3306/my.cnf
[mysqld]
log-bin = /data/3306/mysql-bin
Tip: Both the main library and the backup from the library need to turn on the Binlog logging feature.
Summary: Conditions for incremental rec
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.