Before we go through the incomplete recovery case walkthrough, we need to learn how to use the Logminer tool. The tool mainly digs the redo log to find out the DDL or DML operations made at a point in time (including: Point-in-time, DataBlock SCN, SQL statement)
1. Analysis of DML
Sql> select * from SCOTT.TB01;
Id
----------
1
2
3
3 Rows selected.
Sql> D
ignores tables for the specified engine-M,--no-schemas no table structure-K,--no-locks does not add temporary share read lock, which may cause inconsistent data--less-locking InnoDB table, minimum time lock-L,--long-query-guard set the maximum query time, default is 60s-K,--kill-long-queries to kill the long query-D,--daemon open daemon mode-I,--snapshot-interval snapshot time, default is 60s-L,--logfile log file, default is standard output--TZ-UTC sets the time zone, which is used only when th
supports up to SQL 2008 and SQL 2012. The trial version provides a free trial period with no limit of 14 days.
Download and install the tool directly. Official Website:
After the installation is complete, open the main interface:
Click "New ":
Enter the database information and click "Open ":
Click "Evaluate Product ":
The table lists the operations performed previously. Right-click the row with incorrect operations and many
XP System Stop Service Recovery Tool Encyclopedia-antivirus software XP Special Edition list:
Recommend 1:100 degrees Guardian XP Escort Special Edition
Baidu Guardian first launched the "XP Escort program." With other security products "patching" way of continuous maintenance WinXP system, Baidu Guardian launched the "XP user solution" in the concept of commitment to "no harassment, not coe
Summary of 19 common Android tools and android tools. Summary of 19 commonly used Android tools, and summary of android tools mainly describes the commonly used tools in Android development, most of which are also applicable to Java. Currently, this includes 19 common
Odin flash machine toolOdin3 is Samsung's exclusive flash brush tool. It enters Samsung's coal mining mode (Samsung's flash brush mode, also known as coal mining) through the combination key or a coal mining artifact (that is, a mini-tool with a pin staple) to import the rom package to easily flash the machine, the success rate is high, and recovery c
Setting up the android environment -- to do things well, you must first sharpen the tool 2. android must first sharpen the tool
Two days ago drums android, set up the environment, do not want to trouble on the use of the adt-bundle-windows-x86-20140702. rar, a simulator wow
Android multi-thread download tool core code sharing, android download Tool
First, we will share with you the core multi-thread download class:Press Ctrl + C to copy the code
Press Ctrl + C to copy the code
The following is the logic code of the interface:
1 package com. example. urltest; 2 3 import
Android 5.x OTA Update official documentation (V. Partition ing in the Recovery System), androidota
Preface: if the translation can be translated, the translation will not be translated, and the translation will not be translated. In order to choose not to mislead others, the translation will also be missed. English is hard. If there is a mistake, ask a passing friend to correct it, so as not to mislead mor
One can ' t stress enough on the importance of backups and when it comes to tinkering with your Android phone, a backup of Y Our system, recovery and boot partitions can save your a lot of hassle so you might otherwise has to go through if you m ESS things up and need those stock images. In the This guide, we'll tell the these backups using a free tool called rom
Simple tutorial for Android-50th gun (Tool Test) and android Tool
In development, we generally customize our own tool classes to improve development efficiency. To ensure the reliability of the project, we usually perform unit tests on the
11 indispensable tool classes (download) and Android tool classes for quick development of androidFunction category: tool support platform: Android runtime environment: EclipseDevelopment language: Java Development Tool: Eclipse s
Server-side divided into window and Unix-likeLink unix-like tools juicessh1. Mobile Search Juicessh2. Download the installation software, the following is the post-installation interface diagram, click the link3. Enter IP, port, select authentication Mode4. Adding certifications5. Click on the link and click on the blank area to appearLink Window Tool
Search for Microsoft Remote Desktop, or search for downloads in the app marketplace
Open
Oracle DBA's Artifact: PRM recovery Tool, which runs from Oracle software and reads data directly from Oracle data filesPRM is all called Parnassusdata Recovery Manager, by the Tan software independent research and development, with independent software copyright. The PRM can be run independently of the Oracle software, extracting data from the table directly fro
| Mysql-uusername-p--force-read,-FWhen this parameter is used, the Mysqlbinlog tool prints out warning when it reads an unrecognized log event, ignores the event and resumes execution, Mysqlbinlog stops without this parameter.Mysqlbinlog vms00781-bin.000001-d testdb-f | Mysql-uusername-p--no-defaultsPrevents the Mysqlbinlog tool from reading parameters from any profile, except for. MYLOGIN.CNF (for safe pa
parameters that can be used #--database db_name Specifies only incremental recovery of data db_name the specified database #--start-position Specifies the Binlog point at which to start the recovery, which should exist in the specified first Binlog file. #--stop-position Specifies the Binlog site to revert to, which should exist in the last Binlog file specified. #--START-DATETIME Specifies the point in ti
their event locations 1: Record location in change MASTER to, can be used for recovery after direct start from the server 2: Record location in change MASTER to, but is commented by default --lock-all-tables,-x: Lock All tables --flush-logs,-F: Performing log scrolling --events,-E: Backup Event Scheduler --routines,-r: Backing up stored procedures and storage functions --triggers: Backup Trigger --all-databases,-A: Backing Up all libraries --database
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.