Originally the title Party wanted to write "in-depth JVM", but not too bold, I think a small blog I think it is not enough to explain the JVM, in this article, I would like to introduce you to the JVM a lot of internal knowledge, the concept will be relatively coarse, because too fine content to write, here is certainly not written; , in addition to some official information in the middle, there are some of their own understanding, so please do not fully trust the contents of this article; In ad
• List table space recovery at execution time (TSPITR) operations that will occur • Definitions of terms used by TSPITR • determining the appropriate conditions for using TSPITR as a solution • determining the correct target time for time point recovery • determining the cases where TSPITR cannot be used and solution • Execute automatic TSPITR
Table Space Time Point r
Recovery | Data 1.1. Loss of all data files
The major premise is that control files and log files are not corrupted.
1.1.1. Simulate loss of all data files
rman> shutdown abort;
Oracle routines are closed
Rman> host;
Microsoft Windows XP [version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\>del d:\oracle92\test1\*.dbf
C:\>exit
Host command complete
Rman>
1.1.2. Mount Database
rman> startup Mount;
Connected to target d
Recovery Overview
Android uses the recovery mode to restore factory settings, OTA upgrades, patch upgrades, and firmware upgrades.
The upgrade is generally performed by running the META-INF/COM/Google/Android/update-Script script in the upgrade package to execute a custom upgrade, the script is a set of recovery system can recognize the UI control, file System Op
When the control file backup and recovery instance is started, the process must read the control file and write the control file. Therefore, if a control file is damaged, the instance cannot be mounted. That is, the control files in this phase are indispensable. If the disk is damaged, it can only be started to the NOMOUNT state. Backup control file backups include: online control file image backup, manual backup, automatic backup online image backup
Perform full recovery: the key data file of the SYSTEM is lost in ARCHIVELOG mode. If a data file is lost or damaged and the file belongs to the SYSTEM or UNDO tablespace, perform the following steps: 1. the instance may or may not be automatically closed. 2. If the instance is not automatically closed, use SHUTDOWNABORT to close the instance. 3. Load the database
Perform full recovery: the key data file of
Basic Concepts of Block Media RecoveryWhenever block corruption have been automatically detected, you can perform block media recovery manually with the RECOVER ... BLOCK command. By default, RMAN first searches for good blocks in the real-time query physical standby database, then flashback logs and Then blocks with full or level 0 incremental backups.Identification of corrupt BlocksThe V$database_block_corruption view displays blocks marked corrupt
Problem phenomenonAfter using shutdown abort to stop Dataguard Standby library, the library can not open, reported ORA-01196 error.Specific as follows:Found a standby library can not apply the log, view the repository log did not find an error, suspect that the standby Library application log service stopped, so try to restart the repository;May be because the standby library is busy reading business, shutdown immediate shut down the standby time is too long, so the use of the Shutdown Abort com
As an operational personnel, to ensure that the security of data is the fundamental responsibility, so in the maintenance of the system, to be cautious, but sometimes it will inevitably occur when the data is mistakenly deleted, at this time to change how to quickly and effectively recover data? In this article, we will introduce several data recovery tools commonly used in Linux systems.first, how to use the "RM-RF" commandUnder the Linux system, the
Previous articles on restoration of RMAN:
RMAN series (V)-RMAN restoration and Restoration
Http://blog.csdn.net/tianlesoftware/archive/2010/07/11/5700474.aspx
RMAN backup and recovery instance
Http://blog.csdn.net/tianlesoftware/archive/2009/10/20/4699320.aspx
Oracle RMAN cross-resetlogs version recovery
Http://blog.csdn.net/tianlesoftware/archive/2009/10/17/4682463.aspx
The RMAN in RAC focuses on the c
MySQL series: innodb source code analysis-redo log recovery, innodbredo
In the previous "innodb source code analysis-redo log structure", we know the basic structure and log writing steps of the redo log. How does the redo log recover data? When will redo log deduction be performed? Redo log deduction is performed only when the database is abnormal or shut down. When the database is restarted, the log deduction is performed to restore the database sta
As an operational personnel, to ensure that the security of data is the fundamental responsibility, so in the maintenance of the system, to be cautious, but sometimes it will inevitably occur when the data is mistakenly deleted, at this time to change how to quickly and effectively recover data? In this article, we will introduce several data recovery tools commonly used in Linux systems.First, how to use the "RM-RF" commandUnder the Linux system, the
Recommendation: 10 Technical Masterpiece: "High-performance Linux server construction combat Ⅱ" full-network distribution, with probation chapters and the book instance source download!As an operational personnel, to ensure that the security of data is the fundamental responsibility, so in the maintenance of the system, to be cautious, but sometimes it will inevitably occur when the data is mistakenly deleted, at this time to change how to quickly and effectively recover data? In this article, w
The Recovery Console (Recovery console) is a command-line-based repair platform dedicated to Windows 2000/xp/server 2003, which is equivalent to the "Repair computer"-"System recovery Options" provided by Windows Vista Installer-" Command prompt, which is used to manually repair the system on the command line when Windows encounters a failure to start. The
Tags:/usr read note mysq problem RAC ack manual performanceSummary: Data recovery is a very important task that the DBA does not do much, but I have to understand Background: Data mis-operation can be broadly divided into two categories 1 DML operations (such as non-conditional update deletions) 2 DDL operations (such as increasing the reduction field or even truncate even the drop table) A method for: 1 for Operation: 1 set the time-delay library, th
When we use a database, we always hope that the database content is reliable and correct, but due to computer system faults, hardware faults, software faults, network faults, process faults and system faults) the operation of the database system is 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
Android recovery AnalysisFunctions of Recovery
Android uses the Recovery mode to restore factory settings, full-package OTA upgrades, and incremental package upgrades.
The upgrade is generally performed by running the META-INF/com/google/android/update-script in the upgrade package to execute a custom upgrade, the script is a set of
I. There are three database recovery modes: simple, large, and complete
Ii. Configure the database recovery mode
First, it is completed through the UI. Select database -- Right-click -- select attribute -- option -- recovery mode. Select the drop-down list to complete the change
Type 2: T-SQL
Code
Code highlighting produced by Actipro CodeHighlighter
-- ========================================
--
Use RMAN for recovery from different machine backups (WIN platform)
-- ========================================
In some cases, if the database server is under disk space pressure or costs control, you need to back up the data files to a different machine, and RMAN can be used to complete this work. Based on WindowsThe configuration required is relatively simple. It is only necessary to add an account and
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 the entire database to a time point in the past. This is achieved by introducing a new flashba
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.