to find the file from the TM, you can copy the file from the TM, but you want to recover the entire system (that is, including the system), you need to boot from the system disk to go in, speaking of system disks, they can be attached to a USB flash drive or a partition of a mobile hard disk. I like pure installation, so before the TM restoration, I formatted it and then restored it. This problem occurs.
Cause: There is a lack of recovery partitions
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 3 '/u01/tiger/oradata/orcl2/redo03.log' SIZE50M
DATAFILE
'/U01/tiger/oradata/orcl2/system01.dbf ',
'/U01/tiger/oradata/orcl2/tiger. dbf
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-Production on Monday August 1 21:40:03 2011
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connected to an idle instance.
SQ
= 800 text_enable = TRUE snapshot_refresh_processes= 1 background_dump_dest = %RDBMS73%\trace user_dump_dest = %RDBMS73%\traceMon Jun 16 16:46:57 2014PMON startedMon Jun 16 16:46:57 2014DBWR startedMon Jun 16 16:46:57 2014LGWR startedMon Jun 16 16:46:57 2014RECO startedMon Jun 16 16:46:57 2014SNP0 startedMon Jun 16 16:46:57 2014alter database mount exclusiveMon Jun 16 16:46:58 2014Successful mount of redo thread 1.Mon Jun 16 16:46:58 2014Completed: al
Method One, enter the recovery mode of the system with self
The phone is completely off, while holding down the cell phone key and the volume on the key, the two keys together to enter the interface to release the key, that is, into the recovery mode
Method Two, enter the third party recovery mode method
Preparation Tool:
1. Download Brush Package pan.baidu.c
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_change# from V$datafile; Check the data files in the control file SCNcheckpoint_change#------------------862849862849862849862849862849
In the implementation of a requirement in the Remcovery mode, in the/cache/recovery/directory to create a log file to record the relevant log information, in order to read the log information after the boot, and then according to the log information to make corresponding processing, But it is strange that every time the file is not automatically deleted by the system, and the system's original log files (such as upgrade log---last_log_r) are still ret
One, the recovery of control files1, the path of the query control fileSQL>SELECT* from v$controlfile; STATUS NAME is_recovery_dest_file block_size file_size_blks------------------------------------- -----------------------------------------------------------------------------16384594 163845942. Delete the control fileSql> shutdownimmediate; The database is closed. The database has been uninstalled. The ORACLE routine has been closed. SQL>host del D:
Server RAID 5 Data recovery caseThis shared case is a RAID disk array in a server, with 12 disks in the disk array, a single-disk capacity 500g,ext3 file system, and a Linux platform for the system platform. Raid in 2nd and 6th, two hard disks reported yellow lights, management personnel after the check on the 6th plate has been forced on-line operation, forced on-line found that most of the directory can not open, there are some directories in the di
MySQL backup and recovery-percona-xtrabackup incremental backup and recovery bitsCN.com article review
In the previous article, we talked about the use of percona-xtrabackup software. This article describes how percona-xtrabackup achieves incremental backup and recovery.
2. incremental backup
How to implement incremental backup and
. (yes, you need to do this and need absolutely moisture proof)4. Place the double-pack hard drive in one of the coldest panes of your refrigerator.5. Freeze the hard drive for more than 12 hours.6. Immediately install the frozen hard drive back to the computer and start retrieving the data.7. At some point, the hard drive is still unreadable. If necessary, freeze it again.8. You may need to repeat multiple times until the hard drive stops working or all data is retrieved.The scientific nature o
1, zip rar compression format before and after the file system is one of the Ntfs/exfat/fat32, and the format of the zip rar compressed file size and location has not changed.
2, if the zip rar compressed file before the file system is one of the Ntfs/exfat/fat32, but the formatted partition has changed, please select "Partition Recovery"
3, if the zip RAR compressed file format before and after the file system is not ntfs/exfat/fat32, please select
Tags: 5.4 analysis file set CIN nod DDR host byte tableMySQL database failed to start recovery MySQL database crash recover MySQL database recovery Customer Name confidentiality data type MySQL 5.5 innodb data capacity MB Failure type server power outages cause MySQL to fail to boot. The customer tries InnoDB crash recovery from parameter 1-6 invalid, innodb:
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/zbdba01.dbf'Sometimes, after offline data files, we need to restore the media online.
SYS@orcl11g>select file#,name,status from v$datafile;
outage or shuts down unexpectedly, the database does not shut down cleanly, then the database will be crash recovery when it is started. However, if the database parameter AutoRestart is set to OFF, DB2 does not crash RECOVERY after starting the database. About crash recovery, in the Db2diag.log log will have a relevant expressionThis scenario is reproduced belo
Article analysisWe searched for the Lenovo a790e mobile phone. Unlike other mobile phones, the mobile phone can directly enter the Fastboot mode, so we need other third-party tools to help complete the process.Recovery button introduction:Menu key = Move back key = returnHome key = confirm power supply key = confirmOn the volume key (+) = move the volume key (-) = move it downProcedure:1. Our mobile phone must have the ROOT permission before the operation. If you do not have the root permission,
In the case of Chip dw01a (Lithium battery protection ICS)
Overcharge detection voltage (overcharge threshold voltage) (Overcharge protection voltage) (4.28V): When the battery is charged, the voltage from low to high reaches 4.28V, the overcharge protection function starts, stops charging
Overcharge release voltage (overcharge recovery voltage) (over-charge recovery voltage) (4.08V): When the battery is no
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 recovery of the da
My colleague Xiao Wang has a serious problem with the Windows XP system that needs to be reinstalled. This can make Xiao Wang angry, reload system means not only to the system of all the upgrade patch reinstall, but also to install all the software again, this will not waste a lot of time?
In fact, Windows XP users need to do the prevention work ahead of time, restore their own computer system is not so cumbersome. Because you have a weapon in your Windows XP system that restores your system-th
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.