10.1 Parallel Recovery (v7.1)
The goal of parallel recovery is to reduce the time for crash recovery, single instance recovery, and media recovery with parallel mechanisms for computing and I/O. Recovery time can be effectively r
Media recovery is used in cases where a data file is lost or corrupted or a control file is lost. Media recovery restores the restored data file to the current data file. Also able to recover data files when the exception is offline there is no time to do a checkpoint operation lost changes. Media recovery uses archive logs and online logs. Unlike the instance
1. Concept? ? REDO Log is a mechanism established by Oracle to ensure that transactions that have been committed are not lost. In fact, the existence of the redo log is prepared for two scenarios:
Instance recovery (INSTANCE RECOVERY);
Medium recovery (media RECOVERY).
? ? The purpose of the instance
Tags: multiple user mode database alter modify DISTINCT ACK loss comparisonOriginal: SQL Server Backup and Recovery series backup and restore under three simple recovery modelsI. OverviewIn front of some theoretical knowledge of backup, this article starts with backup and restore under the simple recovery model. In the simple mode is not a log backup, after a dis
SCN-based restoration. Article 2 1. view the current SCN for later data loss to restore: SQLgt; selectcurrent_scnfromv $ database; CUR
SCN-based recovery. Article 2 1. view the current SCN for later data loss to restore: SQLgt; select current_scn from v $ database; CUR
SCN-based recovery, article 2
1. Check the current SCN to facilitate data loss in the future for restoration:
SQL> select current_scn
RMAN recovery case -- Case of full recovery error (ControlFileError) RMAN recovery case: the user encounters the following error during rman recovery: RMANrestoredatabasefromtagTAG20140923T160003; Start
RMAN recovery case -- Case of full
SCN-based recovery, article 2
1. Check the current SCN to facilitate data loss in the future for restoration:
SQL> select current_scn from v $ database;
CURRENT_SCN
-----------
1511297
SQL> select file #, checkpoint_change # from v $ datafile;
FILE # CHECKPOINT_CHANGE #
----------------------------
1 1510535
2 1510535
3 1510535
4 1510535
5 1510535
6 1510535
7 1510535
7 rows selected.
SQL> col name format a45
SQL gt; set line 300
SQL> select nam
What do you mean, recovery?
Recovery translation is "recovery" means that after the boot through a special key combination (various manufacturers vary the model) can enter a system (engineering mode), in this interface you can directly with the SD card ZIP ROM upgrade or backup your system, The older version of the recovery
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
This article mainly describes the Rman recovery scheme and Oracle Machine recovery, the need for friends can refer to the followingNote:The premise of ① recovery is that it is ready for backup② Full Recovery database is a database that is experiencing a failure to recover without losing any data that has been submitted
Canon and other high-definition SLR now more and more popular and more advanced technology, users in the use of the same time, there will inevitably be data loss, etc., today encountered a shooting wedding customers mistakenly operation will canon 80D machine in the MP4 format file all format lost, Later use of the various scanning software on the Internet to try their own recovery failed, the recovered files will not play properly.Canon 80D machine u
I. fault description of RAID data recovery
Fault descriptionThe total storage space of hp fc msa2000 is composed of eight 450 gb sas hard disks, of which seven are a RAID 5 array, and the remaining one is used as a hot backup disk. Two hard disks are damaged in the RAID 5 array, and only one hot spare disk is activated successfully. As a result, the RAID 5 array is paralyzed and the upper-layer Lun cannot be used normally.Because some disks in the rai
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
--------------------------------------------------------------------------------
/DBBak2/oradata/WWL/users0
Server raid5 data recovery success stories, disk array data recovery methods, raid5 success stories
[Introduction to physical servers and logical Storage]
The customer uses an IBM 3850 server and four RAID 5 disk arrays made of 300 gb sas disks. The server operating system is Windows x64 and runs a single-node Oracle version of 11.2.0.2. The data is stored as a file system and is not archived. This oracle d
Label:A Beijing real estate company, an HP Dl380g7 server, because of physical damage to multiple disks, resulting in raid crashes, data loss. The HP Dl380g7 server runs a Kingdee EAS system with a background of more than 40 GB of Oracle database, and the database data is very important. The HP Dl380g7 server is plugged into 8 146GB SAS disks, and each 4 disk has a set of RAID5, and a total of two sets of RAID5 are made into a RAID0, a total of 8 disk RAID50. 8 disk has 3 disk damage, and offlin
Tags: Rman offsite recoveryObjectiveRman in the actual application of a few, many times a project began to set up a backup strategy, the follow-up is basically not used, unless the database is abnormal, it can be said that Rman is a less common but very important skills, but it is very easy to forget. In order not to drop the chain at the critical moment, an Rman geo-recovery database experiment was done.Introduction to the test environment
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,
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.