simplify recovery after you lose a data file that belongs to that tablespace.If you lose such a data file, you can perform the following steps:1. Delete the data file.2. Delete the table space. 3. Re-create the index table space.4. Recreate the indexes that are contained in the table space.1. You can recover a table s
"Customer a total of 2 sets to recover, we know that MDF file will generate a lot of file fragments, scattered in the disk space, the engineer to fragment-level file extraction, need to put these fragments in a manual way to find all, and then reorganize the MDF
Label:1. Environment Readiness 1.1 Confirm database version1.2 Confirming database archiving1.3 Backing Up Database files2 The database recovery after the analog control file is lost (Full recovery).2.1 Viewing Control file Locations2.2 Deleting a control file after performi
SQL Server has two types of backup, one is to use backup database to back up the file, the other is to directly copy the database file MDF and log file LDF way. In this article, we will mainly introduce the latter's backup and recovery. (This article assumes that you are now
into a full virtual disk file by using the snapshots Merge program. Then use the Professional File system interpretation tool to interpret all the files in the virtual disk file.
2. Implementation direction Two: Restore MSSQL database files
If the direction-one implementation is less than ideal, the next step is to count, analyze, and aggregate the data regions
to try to recover the data in the database by rebuilding the transaction log. If you only have MDF files, the problem is more complicated and we need to rebuild the transaction log directly:1. Create a new database with the same name in SQL Server, and then stop the SQL Server service.2. Overwrite the. mdf file for the new database with the original LDF
file, which is somewhat destructive, but there is still the possibility of recovery."Data recovery process"customers have 2 a set of accounts to be restored, we know MDF files generate a lot of file fragmentation, scattered across the disk space, engineers to fragment-level
Easyrecovery How to restore the file? You can refer to the following Easyrecovery recovery file steps to operate, Easyrecovery is a very powerful data recovery software, then how do we use this software?
1, first in the computer download installation easyrecovery data Recovery
The recovery of the control file is divided into two steps: 1. Restore from backup; 2. Restore from redo log. 1. Backup control file recovery control files are classified by backup time span: 1 ). online image backup: the current control file, that is, the control
Record the recovery process for SQL Server2008 log file corruption:Environment: System Windows Server2003Database SQL Server2008Failure reason: The user interface is inconsistent when linking the same server through MSTSC. The decision to restart the server, the application is not properly closed (the program is accessing the database), causing the database log file
To recover deleted files We need to install a tool that can go online to download an invincible data recovery software installed in the computer.
Attention:
When the data is lost we do not have to do some file operations on your lost data disk, we do not put the recovered data in and lost a location in the recovery data.
Remove
Experimental project:Linux system files deleted by mistake recovery method;Host windows with Linux file sharingLab Environment:One: VMware virtual machine, Linux system RedHat6.5 (what version is not important);Two: Install the following 3 dependent packages (Please note the order!) )1 "rpm-ivh/mnt/packages/e2fsprogs-libs-1.41.12-18.el6.x86_64.rpm2 "rpm-ivh/mnt/packages/libcom_err-devel-1.41.12-18.el6.x86_6
.-- Data used by Recovery Manager will be lost.-- Additional logs may be required for media recovery of offline-- Use this only if the current versions of all online logs are-- Available.-- After mounting the created controlfile, the following SQL-- Statement will place the database in the appropriate-- Protection mode:-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;-- Commands to re-create i
/EXAMPLE01.DBF 'Ora-27041:unable to open Filelinux-x86_64 error:2: No such file or directoryAdditional Information:3[Email protected] ~]$ Vi/tmp/1.rmanTo create a recovery script:[Email protected] ~]$ Cat/tmp/1.rmanrun{SQL ' ALTER DATABASE datafile 5 offline ';Restore DataFile 5;Recover DataFile 5;SQL ' ALTER DATABASE datafile 5 online ';}Rman uses the established script to recover data from the database:[E
Tags: --Backup control file rmantarget/rman>startup rman>configurecontrolfileautobackup on;--Start automatic backup rman>showcontrolfileautobackup;--show whether the control files are automatically backed up RMAN> configurecontrolfileautobackupformatfordevicetypediskto '/backup/%f '; --set control file backup path rman>showcontrolfileautobackupformat;-- Show automatic backup control
Many friends may have had the case of mistakenly deleted files, in general, mistakenly deleted files can also be found in the recycling station, but often there are many friends did not pay attention to, often mistakenly deleted files even after the recycling station also emptied, this situation to retrieve the mistakenly deleted file can be found in theory (file deletion will not do), Many friends may asso
are not available, and there are dozens of files named "????.?" file, the capacity size is exactly the same and cannot be opened.
Second, recovery processing
1. Insert the USB drive into a different computer and display the drive letter normally.
2. Use the advanced Recovery feature in the Easyrecovery software to restore the USB drive, only the previously
If the control file is lost or damaged, how can this problem be solved?
View the settings in the parameter file:
SQL> show parameter control_files;
Name type value-----------------------------------------------------------------------------Control_files string c: \ oracle \ product \ 10.2.0 \ oradaTa \ keymen \ control01.ctl, c: \ orACLE \ product \ 10.2.0 \ oradata \ KeYmen \ control02.ctl, c: \ oracle \Pr
recovery
ORA-01110: data file 7: 'e: Oracle/product/10.2.0/oradata/orcl/test01.dbf '.
This is because the database considers this data file to be damaged and needs to be usedRecoverCommandBackupAnd log information. Database Backup Recovery is a complex problem, but the solution for this instance is relatively simple.
1. Because the normal situation of the U disk is deleted files can not find, we introduce the use of tools, to Baidu Search "U Disk File Recovery Tool plus cracked version" download and installed in your computer.
2. Now we first Test, the U disk file directly deleted, and then see if the software can be recovered.
3. Open the software just installed in 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.