Data backups are in the form of full backups, differential backups, and incremental backups, so what are the differences between these three types of backups, and how do you choose them in specific applications? This paper introduces these problems.
A brief introduction of backup method
1. Full backup
Backing up all selected folders does not depend on the file's
In the first two articles, we described the backup and recovery solutions for Small and Medium databases using RMAN catalog, all related scripts are provided to simulate Oracle Data guard to a certain extent in a car to reduce database losses on the prod Server caused by hardware faults. This article mainly describes how to restore the changes of the prod database on the Bak server.
rman_tsAt this time, we can use the catalog Database normally. You can perform the test.[Oracle @ ora10 ~] $ Rman target/catalog rman/rmanRecovery Manager: Release 10.2.0.4.0-Production on Thu Mar 28 15:05:06 2013Copyright (c) 1982,200 7, Oracle. All rights reserved.Connected to target database: QDYX (DBID = 3280546065)Connected to recovery catalog databaseScenario 2: Do not use Restore directoryRman targe
Tags: xtrabackup mysql backup incremental backupXtrabackup is a MySQL database backup tool provided by Percona, an open source tool capable of hot and incremental backups of InnoDB and XTRADB databases, for MyISAM, only for Win Bei, and for MyISAM when using incremental back
Higher uptime due to faster restore time
features
Create Hot InnoDB backups without pausing your database
Make incremental backups of MySQL
Stream compressed MySQL backups to another server
Move tables between MySQL servers on-line
Create new MySQL Replication slaves easily
Backup MySQL without adding load to the server
No need to stop database for InnoD
Does Block recovery use incremental backup?Translated from:Does Block Recovery use Incremental Backups?? (Doc ID 727706.1)Suitable for:Oracle database-enterprise edition-version 9.2.0.8 to 12.1.0.1 [Release 9.2 to 12.1]Information in this document applies to any platform.Information in this document applies to any platform.Goal:Does Block Recovery take into accou
Data security is more and more important, not to say that your production database security, your data must be safe, Rman backup is also an important place to leak data, if someone else got your backup set, same as the intrusion of your production library. For Rman backups to be secure, the easiest way to do this is to
How to encrypt rman backup sets in oracle
Let's take a look at an oracle rman backup set encryption method. I hope this example will help you.
Data security is becoming more and more important. It doesn't mean that your production database is secure and your data is secure. rman
Unreasonable setting of MAXPIECESIZE and FORMAT causes RMAN backup failure
Today, I went to the customer to build the DG. When I created the RMAN backup set, I encountered a problem, causing the backup set to never be generated. Because the customer's
grant recovery_catalog_owner the following permissions:SQL> create user rmanuser identified by rmanuserTemporary tablespace TEMPDefault tablespace tbs_rmanQuota unlimited on tbs_rman;
C. Assign PermissionsSQL> grant recovery_catalog_owner to rmanuser;
3. Create a catalog
# Sometimes directly using rman linux will consider it as its own command, so it is safer to add full path.> $ ORACLE_HOME/bin/rman
Incremental backup:2 levels, level 0, and level 1, 0 levels of backup contain all block,1 level backup changes in the data file block, when performing an incremental backup, the first to do a 0-level
noun Explanation:As the name implies, full recovery means the recovery of data without loss. Incomplete recovery refers to some data loss after recovery. They are two ways to recover a database.Full recovery: Restores a block of data to a point in time closest to the current time, using a redo log or an incremental backup. This is called full recovery becauseOracle applies all of the changes in the archive
: ========================================================== ==============================
Configure can be found through show all;Exercise: Write a file, incre_lv0.rman, and restore the file as level 0.Run {Configure retention policy to recovery window of 14 days;Configure controlfile autobackup on;Configure controlfile autobackup format for device type disk to '/opt/ora10g/oradata/backup/% F ';Allocate c
Tags: com myisam libev binlog log file Inno copy Rman incremental backupDirectory: one, incremental backup and recovery Second, MySQL master-slave synchronization One incremental backup with i
database objects during the import causes some of the lead-in objects to find their dependent objects (such as view, procedure, and so on), causing the ORA-00942 (table or graph not to exist) error. The usual way to solve this problem is to do two import work, the first time the import is set as follows:$ imp sys/password file=demo0701 full=y commit=y rows=yIf an error occurs during import, modify the settings: Rows=n,ignore=n:$ imp sys/password file=demo0701 full=y rows=n commit=y ignore=n(3).
Rman backup recovery test 1, Open Database new test data $ sqlplus/nolog SQL> conn/as sysdba SQL> startup SQL> create table cds (id number (1 ), name varchar2 (20); SQL> insert into cds (id, name) values ('1', 'litao'); 2, start to archive mode $ sqlplus/nolog SQL> conn/as sysdba SQL> alter database archivelog; SQL> archive log list; * # data record time, add the time point to the recovery script 3 and perf
Enter the Rman interfaceRman target/rman>Modify control file backup mode for automatic backupRMAN > Configure Controlfile autobackup on;Check if the control file backup is an automatic backupRMAN > Show Controlfile autobackup;View Control file Automatic backup pathRman> show
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.