Tags: GUID user flash get Oracle Lost condition Oracle Database TarOfficial referencehttps://docs.oracle.com/database/121/ADMQS/GUID-CBC5870F-2C9A-4F67-B5E9-D65049AD1E8E.htm#ADMQS09112Translate as follows:If you restore archived redo log files and data files, you must perform media recovery before you can open the database. Any database transactions in the archive redo log file that are not reflected in the data file will be applied to the data file,
Note: If you are going to install Mac OS10.12 into the virtual machine to learn, then I strongly recommend that you do not install any other software gas, follow my blog to enter the recovery mode (Recovery), disable the rootless mechanism!!! After this, you can use Mac OS at will, otherwise you will eventually find that you have to go into recovery mode (
Today I had the honor to do a few Rman full database recovery experiment, here is a brief version, easy to forget when you can find the instantaneous speed
A full recovery
1. Database entire Library "full recovery"
$ rman Target/Login Rman tool, if the catalog is used, then the login method Rman Targetsys/oracle@lscatalogcata/cata@leo
Rman> startup mount must
This one-key restore operation normally only restores the C disk, but in order to prevent an accident, other disks if there is important data, you also back up good, so as not to cause your personal important data loss. For your data security, back up the overall critical data before you operate, and copy the files that are important to you to another computer or to your mobile storage device.
There are two ways to enter a key recovery interface:
1.
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
(Norton partitionmagic), Diskgenius, Acronis Disk Director Suite, and merging partition errors.
5, determine whether the operating system failure. The conclusion is that the reload system is still after antivirus. Troubleshoot similar failures caused by viruses that hijack all executable files or join file system interception layers.
6, no other abnormal operation. It is inferred that the failure may be caused by a virus or Trojan.
Because of the
oracle10g Database Recovery (RMAN recovery) tutorial
I. Automatic management of documentsIi. use of the Rman function, including all data archive maintenance and reporting capabilities to "invoke the Rman recovery script" by using Oracle Enterprise ManagerRman recovery: Restore and Recover commandsRestore: Rman looked
Tags: Linux virtual machine KVM data recovery mistakenly deletedone, virtual machine failure Environment DescriptionThe client's physical machine operating system is a Linux system, and the file system is the EXT4 file system. The KVM virtual machine on it is deleted, each virtual machine contains a disk file in Qcow2 format, and a disk file of approximately 1.2T in raw format, mainly to restore RAW format disk files. Customer has backed up on their o
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
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
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. However, the problem of the firmware area of th
Label:monmatchledcheck cause Fault alsconfig data type Data type MongoDB 3.x data capacity GB Failure type Server power loss causes WIREDTIGER.WT file corruption Start error detected data files in E:\DTLFolder\MongoDB\ Data created by the ' Wiredtiger ' storage engine, so setting the active storage engine to ' Wiredtiger '. 2018-05-08t16:10:09.755+0800 I STORAGE [initandlisten] Wiredtiger_open config:create,cache_size=18g,session_ Max=20000,eviction= (threads_max=4), config_base=false,stati
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 performing an action2.3 Starting the databaseStart the database when the database error occurred, prompted unable to confirm the control file,
Operation Steps:
Factory pre-installed dos for Windows 8 hidden partition One-click Recovery 8.0 You can set up an initial backup to restore the initial backup state system use.
The specific actions are as follows:
1. The first time to get the machine, install the operating system Windows 8 system and factory random drive disc;
2. Boot Press F2 appear rescue System 4.0 interface Select one key recovery;
One, example demo Bacula Full recovery function
1. Full recovery via differential backup
Action steps are as follows:
*status status Available for:1: Director 2:storage 3:client 4:all Select daemon Type For status (1-4): 1 f10-64-build-dir version:3.0.2 (July 2009) X86_64-unknown-linux-gnu Redhat Daemon started 21-
Aug-09 15:01, 1 Job run since started. heap:heap=253,952 smbytes=84,808 max_bytes=
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.