mdf file recovery

Tags: style blog io color OS sp strong file dataDamage situation One:SQL Server has returned an error 23 (data error (cyclic redundancy check) in the file Xx.mdf, where the offset is xxx, and the operating system has given SQL Servers a full database consistency check (DBCC CHECKDB)--1. User mode is set to single usersp_dboption'dbname','Single user','true' --or--alter DATABASE dbname SET single_user2, run

-2] # partEd/Dev/sdb1 2. View partition information [Root @ MFS-chunkserver-2] #Df-Lh 3. view the directory structure [Root @ MFS-chunkserver-2] #Cd/Data/test/ [Root @ MFS-chunkserver-2] #TrEe 4. Delete all files and directories under/data/test [Root @ MFS-chunkserver-2] #Rm-Rf * [Root @ MFS-chunkserver-2] #Ls [Root @ MFS-chunkserver-2] # 5. Start to install the recovery tool [Root @ MFS-chunkserver-2] # tar zxvf ext3Grep-0.10.1.tar.gz[Root @ MFS-c

Control filesRMAN> RESTOREControlfile fromAutobackup;--The control file is restored to the initialization parameter: Control_files the specified path. StartRestoreIn +-December- -Use the target database control file instead of the channel for recovering directory allocations: Ora_disk_1 Channel Ora_disk_1:sid=TenDevice type=DISKRecovery Zone target: D:\app\Administrator\flash_recovery_area the database nam

, it is recommended that users do not blindly repeated power to try to avoid deformation of the magnetic head on the disc formation of serious scratches, resulting in irreparable damage. In this case, it is necessary to restore the open data in the clean room, replace a good set of normal working heads or motors to restore the data on the original disk completely. Very high demands on the working environment and the engineer's workmanship. 8. Irresistible damage to strong earthquakes, fires, flo

Oracle uses the backup control file for recovery, and then creates a tablespace for recovery. 1. Create a tablespace after the backup control file, and all the control files are lost. How can I restore the table using the backup control file? The procedure is as follows:1. B

　　Standard recovery In standard recovery mode, the top data recovery software performs a quick scan and can recover most of the deleted files. 　　Interface Part 1th: Drive list List all logical drives and use the ' Letter: (volume) label ' format; Part 2nd: Directory listing ' Scan result ' is the directory tree result of the scanner. ' Find results ' is

ServerMSSQLDatatest_data.mdf' 2. Only mdf file Restoration Technology For various reasons, if we only backed up the mdf file at that time, it would be very troublesome to restore it. If your mdf file is generated by the current d

Recovery Based on backup control file (unsing backup controlfile) Applicable:Recovery Based on backup control files is applicable to the following situations: the tablespace is accidentally deleted; all control files are damaged. 1. Close the database and perform a full-database cold backup: SQL> select file_name from dba_data_files; FILE_NAME --------------------------------------------------------------

1:ora-01589:must use resetlogs or noresetlogs option for database opensql> ALTER DATABASE open resetlogs;//in resetlogs form, prompting the data file 1 does notALTER DATABASE open Resetlogs*ERROR at line 1:Ora-01152:file 1 was wasn't restored from a sufficiently old backupora-01110:data file 1: ' +data/metro/datafile/system.257.848858337 'sql> Select checkpoint_

Label:Online redo log files are used to cycle through all operations of the Oracle database and are almost always read-write, so it is meaningless to back up the online redo log files at some point in time, and to restore them at all. The Rman backup does not have the ability to back up the online redo log at all, and not only Rman, but all backup software does not have the idea of backing up the online redo log file. Therefore, the

-recursiveMaking all in SRCMaking install in SRC/usr/bin/install-c ' extundelete '/usr/local/bin/extundelete 'Restore Operation command--umount or Read only partitionUmount/dev/partitionMount-o remount,ro/dev/partition --Recover filesXtundelete/dev/partition--restore-allExtundelete/dev/partition--restore-directory/backup/gnutool-deleteExtundelete/dev/partition--restore-files/etc/passwdTest recovery--Based on directory

Inconsistent recovery of data file headers and inconsistent recovery of Data Headers SYS@orcl11g>alter database datafile 6 online;alter database datafile 6 online*ERROR at line 1:ORA-01113: file 6 needs media recoveryORA-01110: data file 6: '/opt/oracle/oradata/orcl11g/zbdba

We can use the Windows 7 File Recovery feature from the Windows 8 system to make a recovery CD from a row or to back up the mirror to a removable hard disk to resolve the problem. Graphic Tutorials: 1. Open the Windows 8 Control Panel and find the Windows 7 file recovery o

server| Recovery | data | database There are two ways to backup a SQL Server database, one is to back up the database files using Backup databases, and the other is to directly copy the database file MDF and log file LDF. The following is a major discussion of the latter's backup and

to back up the control file to the trace fileTwo methods are available to control file recovery.1) Use recover database using backup controlfile in the mount status2) in the mount status, the trace file is generated and restored. 2-2 example:[Oracle @ localhost ~] $ Rlsqlplus/as sysdba SQL * Plus: Release 10.2.0.1.0-

SQL Server database file Recovery Technology Yzhshi (yzhshi@etang.com) There are two ways to back up SQL Server databases: one is to back up database files using backup database, and the other isDirectly copy the MDF and log files of the database.The following describes the backup and recovery of the latter. This docu

SQL Server supports two backup methods: one is to use backup database to back up database files, and the other is to directly copy database files MDF and log files LDF. This article describes the backup and recovery of the latter. This article assumes that you are skilled in using the Server Enterprise Manager and SQL Server Query analyzer) 　1. Normal backup and recove