chronos backup

A Some advantages of RMAN backup 1. RMAN detects and reports corrupted blocks of data. 2. RMAN can connect to the backup database without having to put the table space into hot backup mode. Additional build redo logs are generated during hot backup. 3. RMAN automatically tracks new data files and tablespaces so that

Mysql backup script and delete the backup file bitsCN.com from the previous five days USER = root # Database username PASSWORD = cucrzmysql # database user PASSWORD # DATABASE = idssr # DATABASE name For DATABASE in 'ls/mysql/data/mysql/| grep idss' # DATABASE name Do # WEBMASTER = 849699940@qq.com # administrator email address to send backup failure message remi

Regular oracle database backup and oracle Database Backup Currently, we need to design a batch of processing files to achieve full backup on Monday, Incremental backup on Tuesday, Friday, and Incremental backup on Thursday and Sunday. In addition, the daily data of the previ

The major server hardware vendors (IBM,HP, etc.) provide good data protection policies (hardware or software). A well known RAID disk array (redundant array of independent disks) is a good way to protect data. In the case of SQL Server , a detailed data backup plan can be developed through a maintenance plan. Data backup strategy (full backup, differential

Cold Backup Introduction: Cold Backup database is to back up all critical files including data files, control files, online redo log files, and copy them to another location after shutting down the database. In addition, cold backups can include backups of parameter files and password files, but these two backups can be selected as needed. , cold backup is actual

Label:Introduction Xtrabackup is a MySQL database backup tool provided by Percona, officially described, which is the world's only one by one open source tools that enable hot provisioning of InnoDB and XTRADB databases. Characteristics:(1) The backup process is fast and reliable;(2) The backup process does not interrupt the executing transaction;(3) Can save dis

I. Overview The simple recovery model and the bulk recovery model are described earlier, and this article continues to write backup and restore under the full recovery model. The biggest advantage in the full recovery model is that as long as the tail log can be successfully backed up, it can be restored to any point contained in the log backup ("Point-in-time recovery"). Of course compared to the first two

Tags: mysql xtrabackup backup######################################################################### # # Install MySQL or mariadb local also installed MySQL or mariadb related packages # #########################################################################Slightly######################################## # # # of Xtrabackup installation # # ########################################[email protected] ~]# Yum install http://www.percona.com/downloads/

Cold backup occurs when the database is shut down normally. When the database is shut down normally, it will provide us with a complete database. Cold backup is one of the key files copied to another location. Cold backup occurs when the database is shut down normally. When the database is shut down normally, it will provide us with a complete database. Cold

MySQL backup and recovery-cold backup-What is cold backup-General cold backup is to stop database services, such as MySQL and Oracle, and then back up the data directory using the copy, package, or compression commands. If the data is abnormal, you can recover the data through back