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
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
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
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
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
location is 0 outside the area, often referred to as negative tracks. Similarly, as with the file, due to sudden power outages and negative tracks, and so on, can also cause firmware information loss or corruption, which causes the hard disk to be recognized or mistaken, so that the data can not read properly. In this case, the PC3000, HRT and other disk underlying tools for the firmware area can be rewritten or modified to read the data normally. Ho
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
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
-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
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
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-
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
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
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
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.