photorec recovery

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

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

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