2014-07-27 BaoxinjianI. Summary
1. Cold BackupA cold backup database is a backup of all critical files, including data files, control files, and online redo log files, to be copied to another location after the database is closed.In addition, cold backups can include backups of parameter files and password files, but these two backups can be selected as needed.Cold
#!/bin/bash##description: the script function, cycle in weeks; Friday full backup, Saturday No backup, Sunday to Thursday differential backup;# due to work needs, do not implement compression packaging method, using CP full backup, rsync differential backup;# to use this s
Veeam backup Replication 9.5 permanent hack activates VMware Hyper-V BackupVeeam Backup Replication is a powerful, easy-to-use, cost-effective backup and availability solution that enables fast, flexible, and reliable recovery of virtualized applications and data, consolidating virtual machine (VM) backup and replicat
After the Rman backup and after the backup of the data files, learned that the process of Rman backup ODU, the majority of TRUNCATE TABLE raw data is not properly backed up (why the vast majority, I can not explain), here you can see the Rman Backup is not really completely physically replicated (and Rman copy is still
When the database is fully backed up, we may sometimes experience an extreme situation, such as three c,d,e on a server with only 5G of space left
But what if it takes 12G of space to fully back up the business library?
Use filegroup backup? But the database does not make table partitions, there are no multiple filegroups, there is only one primary filegroup AH
This time we can use backup file segmentati
Type of database backup
According to the database size backup, there are four types, applied to different occasions, the following briefly describes:
1.1 Full backups
This is a common way for most people to back up the entire database, including all database objects such as user tables, system tables, indexes, views, and stored procedures. But it takes more time and space, so it's generally recommended t
the introduction Several advanced applications of the WINDOWS2008 server Backup program. Mainly want to include network incremental backup, backup notification, space management and so on.Commercial backup software, in addition to having a nice management interface, also includes some very critical features, where netw
Full backup + Incremental backup completes time-to-point restoreFirst, some gratitude.Backup type:Hot backup, warm backup, cold backupHot backup, read/write not affected;Warm backup: Only read operation can be performed;Cold
MSSQL Server 2005 Restore the database Bak file, Web site using virtual Host station will often encounter, in general, the host has an online management program, but sometimes not, you need to restore the backup SQL database locally. In this case, MSSQL Server 2008 will also appear, sometimes "backup set of database backup and the existing XX database" error, thi
# # View data for tables in the current library([email protected]) [Test]>select Count (*) from T_innodb;+----------+| COUNT (*) |+----------+| 0 |+----------+1 row in Set (0.00 sec)# # Performs an insert data operation, which executes after full provisioning([email protected]) [Test]>call addtest (100000,0);# # Perform a full library backup# Backup folder: 2014-06-19_20-53-41# Backup_type = full-backuped#
In the daily operations, the backup of MySQL database is extremely important, in case the database table is lost or corrupted, can recover the data in time.On-line Database backup scenario:Perform a full backup every Sunday, and then perform a mysqldump incremental backup every 1 o'clock in the afternoon.Below is a det
Data processing becomes more and more important and critical in modern enterprise operations, and may even become a bottleneck of enterprise development. the importance of data protection is self-evident. if an enterprise does not have a good data protection solution or strategy, once important data is lost, the consequences will be disastrous, with economic losses.
Data processing becomes more and more important and critical in modern enterprise operations, and may even become a bottleneck of e
One, separate backup1. Classic backup of the whole library: backup as compressed backupset database include current controlfile plus archivelog Delete all input;2, tablespace:backup tablespace name;3, Data files: Backup datafile N; (N: Specific data file number select File_name,file_id,tablespace_name from Dba_data_files;)4, Control files:
Tags: clean disk rm-rf mtime option Insert Add tle submithttp://blog.csdn.net/mchdba/article/details/51527081 The MySQL version is the 5.7.10-log community version and needs to be backed up, but after a long backup time, the disk is not enough, so you need to clean up the specified old backup collection. 1,mysqldump Backup ScriptsBackup script for, there are sev
The following articles mainly introduce how to automatically back up Oracle databases under UNIX. The following describes the specific solutions, such as tape backup and remote backup, I hope this will help you in your future studies. The following describes the specific content of the text.I believe that many system administrators are doing the same job every day-backing up data. Once the system fails and
Script in/home/user/mysql tutorial _ backup. sh
Crontab
# Crontab-l
# M h dom mon dow command
28 16 ***/home/user/mysql_backup.sh
The script is as follows:
#! /Bin/sh
# Mysql_backup.sh: backup mysql databases and keep newest 5 days backup.
#
# Last updated: 20 march2006
#----------------------------------------------------------------------
# This is a free shell
Mysql backup policies can be divided into four types:
1) directly copy database files (not recommended)
2) use mysqlhotcopy to back up the database
3) Use mysqldump to back up the database
4) use the master-slave replication mechanism (for real-time database backup)
Mysqldump is widely used and easy to operate. The following describes the mysqldump backup policy.
Win2003
IIS --> right-click --> all tasks --> Backup/restore Configuration
After the backup, the file will be saved in the % WINDIR % \ system32 \ inetsrv \ metaback directory...
Back up IIS settings
IIS provides the backup and restoration functions for IIS settings. You need to back up IIs before restoring IIS settings. The
Mysql data backup and recovery, mysql backup and recoveryBackup/recovery policies:1. Regular mysql backup and recovery time that the system can afford should be taken into consideration.2. Make sure that mysql opens log-bin. With binarylog, mysql can perform full recovery, time point-based recovery, or location-based recovery when necessary.
3. always perform
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.