I. Problem Description
OS: RedHat 5.8
Database: 11.2.0.3
2 node RAC.
When using RMAN for backup, the following error is reported:
ORA-00245: control file backup failed; target is likely on a local file system
This issue only exists in RAC environments after Oracle 11gr2.
2. ORA-245 trigger conditions
ORA-00245 errors
Configure swap space and file system backup, and configure swap space backup
1. Overview of swap space:
Swap Space is a mechanism used by Linux to temporarily supplement physical memory to provide more memory Space. Swap Space is helpful for computers with limited memory, but cannot replace physical memory, because it is located on the hard disk, the access speed
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
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
"Linux instructions from beginner to proficient" in the 3rd chapter of document management, this chapter introduces many common commands, such as CP, LN, chmod, Chown, diff, Tar, MV, etc., because these are related to file management, used in daily use, so this chapter is the key chapter of this book. This section introduces you to dump (file system backup).AD:3.
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
Regular backup of gadgets in configuration files and configuration tables, configuration file configuration backup
The currently maintained configuration files/tables are all manually backed up by people. The last time a machine went down, I wanted to pull the application on another machine. When I went to find the backup
1. First, create a backup directory and backup script file. this is not much to mention. 2. back up and submit the file as follows :#! /Bin/bashnow =$ (date + quot; % Y % m % d quot ;) # obtain the current date days = 5bk_dr =/# path to the backup directory find $ bk_dr/
Oracle RMAN backup-control file backup
Go to the RMAN page
Rman target/
RMAN>
Change the backup mode of control files to automatic backup
RMAN> configure controlfile autobackup on;
Check whether the backup of the control
Control files are used to record and maintain databases. When the database is restored, the server process and background process need to read various backup-related information from the control file. If the control file is corrupted, the backup information will be lost. Although the use of diverse control files can pr
Mysql is automatically backed up in centos, And the backup file is transferred to another machine for backup.
1. Create a backup directory and a backup script file.
2. Submit the backup
Background:Colleagues mistakenly delete online data, so they need to recover data from the backup. Real estate leakage of the rain, the ship late and the wind, the first two days of backup disk bad block, now only rman full of. bak files, no control files and parameter files, so now it is necessary to consider how to recover data from a BAK file on the
after the measurement product deploys the service end, because the service side has each kind of encapsulation encrypted attachment, the file and so on data, in order to safeguard the security of the information, in addition to establish the high availability backup mechanism, we can through the batch script, unifies to the system plan to carry on the local or the offsite
From: http://bbs.xiamenwcdma.com/space.php? Uid = 12
Update one-click installation and backup. It is difficult to manually uninstall and load the previous version. If you choose to restore the text message to uninstall and load during installation, the subsequent registry import will be invalid, So modify it.The other reason is that my first HD {Function onclick (){Function onclick (){Tagshow (Event)}}} "> Template, so release a new version.
Update re
Today an accident, I wrote the diary of the big half month the encrypted file is damaged and cannot be recovered. He decided to write a dedicated backup script file.
The main idea is to create a folder under current directory backup based on today's date, and then copy the files to that folder.
The script files are as
How to use ITunes to delete a backup file
If you're using an iTunes backup, the backup file is stored somewhere on your computer. Go to the folder? No, we delete this backup file d
How to import an Oracle 11g backup dat file into a 10g database workaround: Add the target database version number after exportingExport:Execute under SQL Plus: Create or replace directory File_path as ' e:\ ';--creating Export \ Import file storage path (my is on E-drive)Execute inside CMD: EXPDP username/password @ service name Directory=file_path dumpfile= Exp
. Net-based incremental file backup system implementation and. net Incremental Backup implementation
. Net provides many easy-to-use methods, including searching for files in processing files and copying files. Today, Incremental backup files are implemented through simple programs.
First, you need to select the
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.