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
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.
The essential difference between crash/instance recovery and media recovery is:
Crash/instance recovery applies the redo log from the incremental checkpoint (incremental checkpoint) for the instance that needs to be recovered. Because the first condition of log coverage is to complete the logfile switch checkpoint of t
1. Concept
REDO Log is a mechanism that Oracle has established to ensure that committed transactions are not lost. In fact, the existence of the redo log is prepared for two scenarios, one we call instance recovery (INSTANCE RECOVERY), one we call Media recovery (medium RECOVERY
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
Important Reminders:
Before you return to factory settings, be sure to back up important data from each partition to your mobile hard disk or to another computer. The personal data is deleted because a key is restored. If you have multiple partitions and only restore C, you can also back up important data from several other partitions to an external storage device, because partitioning may affect one-click recovery, and if one-click
Full media recovery of database for Rman database recoveryEnvironment: Control files and parameter files SPFile and archive files, redo log files are all in. Other data files are missing.Recovery method: Restore using a full-library backup created previously1. Delete the data file:SQL>SHUTDOWN IMMEDIATE; the database is closed. The database has been uninstalled. The ORACLE routine has been closed. SQL> HO
In the oracle world, there are three types of data: undo, redo, and data. While redo should quot; Commit transactions without losing quot;, a mechanism is generated to serve two types of scenarios: instance
In the oracle world, there are three types of data: undo, redo, and data. While redo should quot; Commit transactions without losing quot;, a mechanism is generated to serve two types of scenarios: instance
In the Oracle world, there are three types of data: undo, redo, and data. Redo is
In the Oracle world, there are three types of data: undo, redo, and data. Redo is a mechanism generated by "no loss of committed transactions" to serve two types of scenarios: instance recovery and media recovery.
Instance recovery objective: to ensure data loss in buffer cache and Database Consistency when the databas
last_change #.
You can first mount the database, and then query
Select last_time, last_change # from V $ datafile;
You can see. If a result is returned, it is disabled normally. If no result is returned, it is disabled abnormally.
Determine whether the file needs media recovery:
V $ datafile; From Control File
V $ datafile_header comes from the data file header.
colnamefora40selectname,CHECKPOINT_CHANG
OCP 053:
399. Which of the following is not an advantage of Block Media recovery (BMR )?
A. Reduced MTTR.
B. datafiles remain offline while loading upt blocks are retried red.
C. datafiles remain online while uploading upt blocks are retried red.
D. A and C
Answer: B
Answer:
According
Lowers the mean time to recover (MTTR) because only blocks needing recovery
18.7. Performing Complete user-managed Media RecoveryAfter a consistent backup, restoring the database to the current SCN is the best result. The ability to recover an entire database. Restores a single table space. or recover data files. Consistent recovery does not require resetlogs to open the database, and non-conformance recovery requires resetlogs to open t
Basic Concepts of Block Media RecoveryWhenever block corruption have been automatically detected, you can perform block media recovery manually with the RECOVER ... BLOCK command. By default, RMAN first searches for good blocks in the real-time query physical standby database, then flashback logs and Then blocks with full or level 0 incremental backups.Identifica
18.7. Performing Complete user-managed Media RecoveryTo complete a consistent backup, restoring the database to the current SCN is the best result. You can restore an entire database, restore a single tablespace, or recover a data file. Consistent recovery does not require resetlogs to open the database, and non-conformance recovery requires resetlogs to open the
18.6, about user-managed Media RecoveryTo complete the recovery, Oracle recommends using the recover statement. You can also use the ALTER DATABASE recover statement, but the recover statement is simpler.18.6.1, preconditions of performing user-managed RecoveryTo begin any kind of media recovery, you must adhere to the
Environment Introduction: a two-node single-instance Linux + oracle11.2.0.3 + customized uard maximize availability environment was set up a few days ago.
Fault description: synchronization failed today. An error message is found in the trace file alert_orcl.log, but the MRP cannot be started.
Mrp0: background media recovery terminated with error 328
ORA-00328: 8386238,897 2415ORA-00334: '/opt/Oracle/fast_r
Environment: Oracle 121020In the Dataguard construction, encountered the ORA-01153 error, prompt as follows:Ora-01153:an incompatible Media recovery is activeAn incompatible media recovery is in progressThis problem is performed twice in succession sql> ALTER DATABASE recover managed standby database using current logf
Creating an OEM recovery media requires a larger space, with a 16G or more USB disk or a removable hard drive is recommended. (The Removable Storage device will be formatted, please back up the data in advance).
Create a recovery media step like the WIN8.1 created by the
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.