Recommendation 1:
The task plan, batch processing file, and Oracle exp export function can automatically generate Oracle backup files based on the date, greatly facilitating ORACLE data backup. :1. Create a batch file backup. BAT \.Exp system/manager file = D: \ backup \ ora
Mysql backup recovery (view, stored procedure) bitsCN.com
Mysql backup and restoration (views and stored procedures)
Recently, when I backed up and restored mysql, I found that the view was restored and an error occurred while creating the view. I checked the information o
_content_www_p3") # Mail address mail_address1= " Showerlee@vip.qq.com "mail_address2=" kevinywb@vip.qq.com "# 1. Backup MySQL mysqldump-u $user-p$passwd--opt--skip-lock-tables--flush-logs--database Test | gzip > $mysql _bak # 2. Back up the WWW source code (split several 45m of tar packets) if [-Z $rar];then exit 0 fi cd/data rar a-v45000k $www _bak www # 3 . Send attachment for (i=0; i!=${#All_bak[@]}; ++i)) ({if [F ${all_bak[i]}]; then echo ${mail
parameter is the same as specifying the "-H" parameter.--help online Help.--version Displays version information.From Linux system operations:Http://www.linuxyw.com/a/wenjianguanli/20130505/191.htmlFirst open it in a binary way:Vim Mbr.bak-bThen enter in VIM command mode::%!xxd #参数% refers to the file currently being editedThe MBR file appears in hexadecimal, and you can edit it now.When the edits are finished, we need to revert to binary files::%!xx
] logfile
Add a log Member
Alter datebase [add | drop] logfile member
Add a log Group
Alter datebase [add | drop] logfile group
Modify database Archive
Alter datebase [noarchivelog | archivelog]
Rename database files
Alter datebase rename file
Create a tablespace
Create tablespace
Add data files to the corresponding tablespace
Alter tablespace [add | rename] datafile
Modify Table space status
Alter tablespa
chkconfig servicename off21. How to make a service (if the service name is Nginx) open only in 3, 52 runlevel, other levels off?Chkconfig--levelWhat is the difference between the following two methods in the rsync Sync command?(1) rsync-av/dira/ip:/dirb/(2) RSYNC-AV/DIRA/IP: IRB:d(1) rsync-av/dira/ip:/dirb/is synchronized via SSH(2) RSYNC-AV/DIRA/IP::d IRB is synchronized via the Rsync serviceWhen Rsync is synchronized, how can I synchronize the destination file or directory of a soft connectio
timed TasksDaily 0 O'Clock 1 o'clock Execute file Check script[[email protected] script]# crontab-l0 1 * * */etc/zabbix/script/file_check.sh >/dev/null 2>1For the eighth step, if you do not want to push the monitoring message with a timed task, you can create a new monitoring item:1. New Monitoring Item2. Modify the configuration fileModifying a configuration file zabbix_agentd.conf[Email protected] zabbix]# View zabbix_agentd.confuserparameter=file.
I. Major improvements to 0_0_0001_beta2:1. Added viewing and backup of User Logon/logout records2. boot, shutdown, user logon, and user logout records are displayed in different colors.3. Improved the code for creating backup Record Files
Note:If you cannot view User Logon/logout records, follow these steps:(1) Open
We will share with you the Oracle control file technology. I want to go into details about the role of control files? It is important for children aged 90 to 5 to control documents.
We will share with you the Oracle control file technology. I want to go into details about the role of control files? It is important for children aged 90 to 5 to control documents.
Preface
Today we will share with you the
Enjoy the following link: http://blog.csdn.net/xieyufei/article/details/33770067(note here The main instructions on how to set up delete outdated backup files)First of all, SQL Server uses the job to delete outdated backup files general idea: ① back up the database file when the name to have rules, such as: "Ptm_workor
Preface
Today we will share with you the technology on Oracle control files. Without a long journey or even a thousand miles, without a small flow, it cannot become a sea of rivers. Oracle technology is profound and profound. With the power of my own person, it is no different from the world. Here, I hope that readers can interact well with me and make progress together. Today's discussion will begin immediately after the book is published.
Concept of
→ backup, (2):Figure (2)3. In the "Backup Database-dsideal_school_db" dialog box that opens, click Delete, then click "Add", (3):Figure (3)4. In the "Select Backup Destination" dialog box that pops up, (4)Figure (4)5, choose the path of the backup (such as the "D" Jiangxi-student-database
: to open the database, you must use the RESETLOGS or NORESETLOGS Option
SYS @ orcl # alter database open resetlogs;Alter database open resetlogs*Row 3 has an error:ORA-01194: File 1 requires more recovery to maintain consistencyORA-01110: Data File 1:'/Opt/oracle/oradata/ORCL/datafile/o1_mf_system_8no75lqw _. dbf'
SYS @ orcl #Try to recover:SYS @ orcl # recover database using backup controlfileORA-00279: Change 4400440 (generated at 05/18/2013 16:04:
Automatic deletion of temporary files 23:00 daily
First look at the crontab task list:Crontab-lAnd then NEW:Crontab-eAdd a line:* * * rm-rf/www/cmstest/my120/public/scripts/jpgraph/*Save exit.Restart Service:/etc/rc.d/init.d/crond restart
Second, daily 24:00 automatically back up the database
Use the system crontab to execute the backup file regularly, save the backu
. sp_addsrvrolemember @loginame = n ' replicationuser ', @rolename = n ' sysadmin 'GO3) Create a publication at the publisher, as shown in the following steps:(Figure3: New publication)(Figure4: Select data barfoo.testpublish)(FIGURE5: Select Transactional publication)(Figure6: Select a field to publish)(Figure7: Not checked)(Figure8: Setting up the Snapshot Agent)(FIGURE9: Set agent Security)(FIGURE10: Set the Log Reader Agent)(FIGURE11: Set account password)(Figure12: Creating a publication)(F
Analysis of Huawei Switch configuration backup: Implements switch File Replication. This article uses a notebook installed with FTP server software to replicate configuration files. This article provides detailed steps and related diagrams. Thank you for your guidance.
1) Upload the configuration file on the old switch to an FTP server
Figure 1 Huawei Switch configuration
This is where you use a LIUNX command to view disk space
Df:disk Free http://www.cnblogs.com/chenwenbiao/archive/2011/08/07/2129831.html
Common parameters: Df-h
-------------------------------------
1. Restart the Postgre under Linux
Pg_ctl Restart (postgres user)
Today's problems
Because the data is imported, the database keeps generating backup files, which fi
Delicious (delicious bookmarks) has been plagued by new pages since its revision at the end of September. It is no longer useful and bookmarks are not normal, forcing me to make changes. Soon after finding a solution, I found that Firefox Bookmarks can be synchronized on different machines, as long as you log on to the same account, so I backed up the bookmarks on delicious into HTML files and prepared to import them to Firefox. The problem arises: Fi
Background: I have a backup directory/home/kzy/bakup, which backs up some information every day. As the days go by, this folder is getting bigger, and finally the disk is full ...Requirements: Automatically delete the oldest 30 days of files in this folder when the disk share exceeds 80%, but keep files for at least the last 7 days.Code:As follows. (Code for a wh
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.