its corresponding transaction: A simple picture example is as follows: Many types of operations are logged in the transaction log. These actions include:
The start and end of each transaction.
Each data modification (INSERT, update, or delete). This includes changes made by system stored procedures or data definition language (DDL) statements to any table, including system tables.
Each allocation or deallocation area and page.
Creates or deletes a table or index.
F
• List the actions that occur when you perform a table space point-in-time restore (TSPITR) • Illustrate the definition of terms used by Tspitr • Determine the conditions that are appropriate for using TSPITR as a solution • Determine the correct target time for point-in-time recovery • Identify situations where tspitr cannot be used and how to resolve them · Perform an automatic tspitr
Tablespace Point-in-time
? Determine what types of failures can occur in Oracle DB? Describe how to optimize instance recovery? Explain the importance of checkpoints, redo log files, and archived log files? Configure the quick recovery area? Configuring Archivelog Mode
Part of the work content
The responsibilities of the database administrator include:? Try to avoid a database failure?extended mean time between failur
? Perform a full recovery after losing critical or non-critical data files? Restore with incremental update backup? Switch to image copy for quick recovery? Restore the database to a new host? Using Backup control files for recovery
Using the Rman Restore and recover commands
? Restore command: Restoring a database file from a backup? Recover comman
I. Backup and Recovery Overview1. Backup and Recovery Overview1.1 What is Backup and Recovery?Generally, backup and recovery references various policies and procedures to protect your database from data loss, and recreate the database after any data loss.1.1.1 Physical Backups and Logical BackupsA backup is a copy of a
Tags: RMAN ORACLE zhangIntroduction: Welcome to add QQ Exchange 1445696451 Weibo address http://blog.51cto.com/13434336~~~~~~~ Split~~~~~~Database backup and recovery is what the database administrator must master. No system can be protected from physical damage to the hard disk, careless user error operations, or potential disasters that could threaten to store data. In order to maximize the recovery of da
Label: style blog HTTP color Io OS AR
Hard raw format data recovery
1. raw format reason2. raw format Solution
Experience:
1. raw format reason
I searched the internet for the reasons for the formation, and I will not tell them one by one, but the results will have a cause.The correct statement found on the internet is caused by DBR damage to the hard disk. If I do not understand the hardware, I will reference the explanation provided by my predecesso
From the perspective of the recovery type, Oracle data recovery can be divided into two types: full recovery and Incomplete recovery. Actually, I am familiar with Oracle
After the architecture, there will be a general concept for Oracle recovery. Because the peripheral compo
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
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
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.