, 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
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
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
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
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
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
--------------------------------------------------------------
Server2000, SqlServer2005, SQL2008 database sysobjects and other system table corruption can not be applied in the case of recovery.7. The SQL Server database recovers only if the data files do not have any logs .8. The recovery of SQL Server data files is deleted by mistake.9, SQL Server2000, SQL Server2005, SQL2008 database master database is corrupted and cannot be resumed under normal operation conditi
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
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
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-
Label:Recovering archived log filesIf you simply apply the archive after recovering the data file, you do not need to manually restore the archive file, and Rman automatically recovers the appropriate archive when recover.Recovering an archive separately is typically a special requirement, such as creating a data guard environment. Some archived files are missing from the standby side and need to be retriev
can restore the control file based on the text file of the control file backed up earlier.
Createcontrolfile reuse database "ORCL2" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
# MAXLOGHISTORY 292
LOGFILE
GROUP 1'/u01/tiger/oradata/orcl2/redo01.log' SIZE 50 M,
GROUP 2'/u01/tiger/oradata/orcl2/redo02.log 'SIZE 50 M,
GROUP
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
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
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.