cms automatic backup system

Label:Add the following script to the server scheduled task, set to execute daily, the file backup path is the path of the script, you must install the compressed file@echo offREM Calculates a date that precedes a specified number of days and is used to delete data for a specified number of daysSet daysago=7set/a year=1REM assumes that the format of the system date is YYYY-MM-DDCall:D atetodays%date:~0,4%%d

Data backup is almost a task that every system administrator has to do every day. However, this is very tedious-if the system automatically backs up data at a fixed time every day, that would be nice! Next, I will talk about how to implement automatic Oracle Database Backup

BKJIA exclusive original] An accident occurs on the Web server, such as a network virus or Trojan attack, or hardware damage on the server host. To restore the Web server to normal in the shortest time, the most effective method is to restore the previously backed up Web server data directly. However, this method requires us to back up important data on the Web server in a timely manner. Unfortunately, many network administrators cannot manually back up Web servers every day because they have a

I believe that many system administrators are doing the same job almost every day, that is, backing up relevant data. In case of negligence one day, and the system suffers some faults on this day, and data recovery is required, there will be nothing to do at this time. Let's talk about the automatic backup of Oracle da

First, preface:When the database server is set up, the first thing we need to do is not to consider which MySQL-supported programs to run on this database server, but how to recover to the last normal state when the database is compromised, so that the loss of data is minimized.Or, the mere creation of a database server can only explain what it can do, and it does not mean that it can do something stably. The efficiency and comprehensiveness of disaster recovery are also a quasi-factor in the st

_ % T '; SQL 'alter system archive log current '; Crosscheck archivelog all; Backup filesperset 3 archivelog all tag 'arch 'format'/home/oracle/oarch _ % u _ % s _ % P' delete input; Release channel c1; Release channel c2; Release channel c3; } Exit; EOF Note: The last format of the log file name is bk _ year, month, hour, minute, second. log Rman_bk_20120102101501.logID of the % s

: Skips read-only data files. Filesperset: specifies the maximum number of files that can be contained in each type of backup set. In this example, filesperset appears in the backup archiving clause. Therefore, it is used to limit that each archive backup set can contain up to 20 archive files. Write commands to execute rman batch processing files SetORACLE_SID

Automatic file backup software In this unstable network environment, system crashes, host crashes, and other incidents are common. Nowadays, many children's shoes think that their blogs can only be built to ignore the security of their websites. Otherwise, you will know the pain points when you lose data. Therefore, back up data first.Here we recommend t

In large commercial applications, the data disaster recovery backup is very important and necessary. Based on his own practical experience, the author designs A set of methods for automatic data backup in different places, which can be used for reference by database administrators. All the procedures in this paper have been tested and run well. The simulated offs