The 11g active data guard implements rman backup for the standby database, so that the database can be backed up without affecting the external services of the primary database.
The test is as follows:
SQL> select OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, DATABASE_ROLE from v $ database;
OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL DATABASE_ROLE----------------------------------------------------------------------------READ ONLY WITH APPLY MAXIMUM A
Summary of database backup and Restoration Technology of the IT Ninja Turtles, and backup of the Ninja Turtles Database
1. exp/imp (export and import the library and unload the database) 1.1 Basic commands 1. Get help
$ Exp help = y
$ Imp help = y2. Three ways of working
(1) Interactive Mode
$ Exp // enter the required parameters as prompted
(2) Command Line
$ Exp user/pwd @ dbname file =/oracle/test. dmp
Tags: full backup incremental backup data restoreScenario: Sunday full Backup, Monday, Tuesday incremental backup, Wednesday problems, found after a few minutes;Installation of the database:
yum install mariadb-server-y
systemctl start mariadb
yum Install percona-xtrabackup-24-2.4.9-1.el7.x86_64.rpm
Default Instant i
LVM (LogicalVolumeManagement logical volume Management) achieves almost hot backup principle: the snapshot volume of LVM can be used to save the instantaneous state of the database at a certain time point. You only need to back up the snapshot at that time. LVM snapshot principle: After lvm creates a snapshot volume for a volume, the snapshot volume serves as another access point for the original volume.
LVM (Logical Volume Management) achieves almost
This article describes how to use shell to implement full and incremental mysql backup. Incremental backup copies the mysql-bin.00000 * to the specified directory at Monday-Sat, while full backup uses mysqldump to export all the databases at every Sunday, and will delete the last week left by the mysq-bin.00000 *. Then, the mysql
I wrote two blog posts on VPS security settings in a few days. In fact, no matter how secure we are, backing up VPS data in a timely manner is the most important thing. Because the VPS is different from the host, the host may often be backed up by the service provider on our behalf. Most of the operations and security of VPS require us to be responsible for this. Even if many VPS provide daily backup services, but there are too many uncertain factors.
Mongolerman backup in-depth analysis-online backup, start to execute the actual database backup operation, at this time a log switch (altersystemarchivelogcurrent
Oracle RMAN backup in-depth analysis-online backup, start to execute the actual database
On Sunday, I had a hard time tossing my computer, uninstalling Ubuntu8.04 installed in wubi, and re-installing it in LiveCD mode. Ubuntu8.04 it is easier for new users to install wubi. However, after more than a dozen days of use, when I have a little understanding of Ubuntu, I feel that the automatic partition installed with wubi is not reasonable. Use LiveCD to partition as needed and reinstall Ubuntu8.04. Setting, upgrading, and installing software is smooth. I used it for one day yesterday.
The simplest way to protect data is to copy all the database files to another place. In case of a problem, you can overwrite these files to the original location for recovery and then start the database, such an operation is called full (or all) Consistent database backup and recovery. Here, we note that consistent Database Backup usually refers to cold backup (C
Multi-Backup is a cloud platform (SaaS) application provider that focuses on backup, recovery, migration, storage, and archiving of business data in the cloud. In order to achieve adequate data security, we have adopted the self-developed cloud 5 technology.The source of the problemIn February 2014, a user hurried to call. Mention of his site every day a large number of orders to produce, he also backed up
Run the tar command and run the tar command to implement full backup and Incremental backup. First, find out what full backup, Incremental backup, and differential backup are. In short, it can be understood as follows: Full backup
Oracle hot backup-basic user management backup knowledge and explanation: http://blog.csdn.net/wanghui5767260/article/details/20627639
User Management backup: refers to the hot backup mode of the tablespace by placing it in the hot backup mode, and then copying it using the
Http://www.tektea.com/archives/2163.html.In one of the Linux OS backups: Online backup of Linux operating system data using LVM snapshots, we introduce the method of using LVM snapshot to realize the online backup of operational system, and LVM snapshot can realize the backup of the online operating system data, which means that Complete
the Windows Task plan, my scheduled task executes 1 months to execute the above bat file, a full backup of the database, in SQL form, normally set at around 3 o'clock in the morning.Why one months, because we also have incremental backup, if too often, consumption of disk space, also consumes a lot of database performance. So the proposal is a longer time period, do a good incremental
WIN2003
IIS--> Right---> All Tasks--> backup/Restore Configuration
After backup, the files are saved in the%windir%\system32\inetsrv\metaback directory ...
backing up IIS settingsIIS itself has the ability to back up and restore IIS settings. You need to back up IIS before you restore IIS settings. The process of backup is simple:
windows "
Note: Before
Tags: mysql linux1. Full-scale backupTo put it simply, all databases or a library are backed up.2. Incremental backupIt is called an incremental backup from the last full-volume backup to the next full-volume backup.For the Mysql,binlong log is MySQL data, the backup of Binlong is a backup of MySQL.To lock the table 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.