Backup is actually a copy of data. The purpose of backup is to prevent unexpected data loss and application errors.
A restore refers to the process of restoring a backup copy file to the original database when the data file or control file is damaged.
Recovery refers to the application archiving log and redo log transaction to update the copy file to the status before the data file fails.
1.2.1 backup and recovery
When the master server suddenly fails or stops working due to other damages, it starts to start the VM that is synchronized with the master server and backed up, send an email to the administrator or send a notification directly to the mobile terminal of the Administrator. After the master server recovers, the VM includes the operating system, database, and application.ProgramAnd other related data are seamlessly migrated back to the original master server. To complete these operations, you only
Some other maintenance activities are involved when using the recovery directory, such as upgrading the recovery directory during database upgrades or migrations, manually configuring the database counterpart, and synchronizing the recovery directory after some database operations.
1. Unregister the database in Rman
Before Oracle 10g, it was a manual process to
affected, the correctness of the data in the database is affected, or even the database is damaged, so that all or part of the data in the database is lost. Therefore, when the above fault occurs, we hope to re-establish a complete database, which is called database recovery. The restoration subsystem is an important part of the database management system. The recovery process changes with the structure af
All about login Ming User-Managed Database Recovery Issuing set autorecovery on before issuing the RECOVER command. if you recovery with set autorecovery off, which is the default, then you must enter filenames manually or accept the suggested filename by pressing Enter. startup mountset autorecovery onrecover databasealter database open; Note: After issuing the SQL * Plus RECOVER command, you can view all
When learning basic knowledge about Oracle, we will understand the concept of Instance Recovery or Crash recovery, sometimes even these two terms share the same meaning in our daily language. In fact, there is a difference between Instance Recovery and Crash Recovery: for the Recov
-- ====================================
-- Oracle backup recovery concept
-- ====================================
During database maintenance, backup or recovery is the top priority. Although the database system runs slowly in many cases, it is clear that the cost of the latter is the loss of database data.
It is self-evident. Therefore, it is the minimum requirement for DBA to improve the system performan
New Feature of Oracle10g: Flash recovery area)
Oracle9i starts to provide a flashback query so that consistent data at a time point in the past can be found as needed, which is implemented through undo. This function has a lot of limitations, that is, the Undo of related transactions cannot be overwritten, otherwise it will be unable to return to the day. Oracle10g greatly enhances the flash-back query function and provides the ability to roll back t
In data recovery, we often encounter array data recovery, some array data recovery is relatively simple, such as RAID1, RAID0, RAID5 and other simple structure of the array data recovery, this array of data recovery in the Shanghai Day Shield Data
Restoration Technology is the most effective means for the mesh optical network to effectively cope with network faults and ensure service transmission in the network. Recovery techniques can be categorized and implemented in a variety of ways from different perspectives.
Link-level and channel-level
Based on the recovery granularity, optical network fault recovery
• Explains the differences between user-managed backup and recovery and server-managed backup and recovery • Perform user-managed database Full recovery • Perform user-managed database incomplete recovery
Types of use for backup and recovery
Types of database b
Computer suddenly crashes or power off, hard drive data loss? U disk important documents accidentally deleted? Computer poisoning, file missing or unreadable? The system crashes suddenly, important files are lost? The most afraid of using the computer is like these sudden catastrophic failure caused by the loss of important data, misoperation, computer virus attacks and software, hardware failures and other natural and man-made disasters are at all times threatening the security of data files, T
Oracle? Database 2 day + Real application Clusters Guide11g Release 2 (11.2)E17264-136 Administering Backup and RecoveryOverview of Oracle RAC Database Backup and RecoveryNote:For the RMAN utility-properly on Linux platforms, the $ORACLE _home/bin directory must appear in the PATH variable Before The/usr/x11r6/bin directory.The Enterprise Manager Guided Recovery capability provides a Recovery Wizard that en
Backup method: Logical backup and physical backup
Logical backup: The data is backed up by dragging the logical export. The logical backup data can only be dumped at the backup time. Therefore, the recovered data can only be recovered to the data saved during the backup. logical backup is suitable for backing up data tables with few changes. If you use logical backup for full database recovery, you usually need to recreate the database and import the
Androidsystemrecoverywork use update.zipupgrade Process Analysis (wuyun---update.zip package to enter the recovery service from the upper layer
In this document, we will refer to the update.zip package from two sources: OTA online download (generally downloaded to the/cache partition) and manual copy to the SD card. This document does not describe the official update.zip package. This zip package is not processed before it enters the
Timeout retransmission is an important mechanism for TCP to ensure data reliability. Its principle is to enable a timer after a data is sent,If no ACK packet is sent within a certain period of time, the data will be re-sent until the message is sent successfully. This is dataA repair mechanism is provided when the package is lost. Generally, retransmission occurs after timeout, but if the sender receives more than threeThe duplicate ack should realize that the data is lost and needs to be re-tra
1.6. Automatic disk-based Backup and recovery:the Flash Recovery areaComponents that create different backup and recovery files have no knowledge of the size of each file system. With automatic disk-based backup and Recovery, you can create a flashback recovery area that automates the management of backup files. Select
In the previous topic, we have actually made a complete introduction to the backup and recovery of rman. We talked about the backup of databases, tablespaces, parameter files, and control files, at the same time, we also talked about their recovery, including catastrophic recovery. The non-consistent recovery that we a
This article describes how to improve the efficiency of DB2 data backup and recovery. When designing a data backup and recovery solution, we mainly consider two aspects.
The first is whether the backup and recovery policies are secure, that is, whether the database can be backed up in a timely and accurate manner.
Second, the efficiency of data backup and
In RAID array data recovery, we often encounter simple structure such as RAID1, RAID0, RAID5 and so on array data recovery, such array data recovery is generally difficult, the data recovery success rate is higher. However, when encountering complex structure of array type, such as composite array structure raid0+1, ra
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.