Today, when I used exp/imp for a small backup and recovery operation, I encountered a problem. Many empty tables cannot be expressed. I didn't understand it at the beginning, later, I went to the Oracle official website and read Oracle data. I sent Oracle11g R2 with a new feature. When exp and imp are used, no segment is allocated when the table has no data, to save space. This will prevent the empty table data from being expressed. I want to say some
Oracle table data recovery and oracle Data Recovery
When you accidentally delete data in a table for table data recovery, you generally do not need to operate on the table any more. You can recover the data in the table as follows.
Scenario: If data in table test is accidentally deleted, the following methods can be used to restore data in the table:
Method 1:
First, use WinPE to make recovery CD
1, first on the development machine to adminstrator users run cmd, into the WES7 installation directory under the Petools folder, such as D:program fileswindows embedded Standard7toolspetools, Run the following command:
Copype.cmd x86 c:winpe_x86
If the target machine is 64 bits, the middle argument "x86" is replaced with "AMD64", and the following path can be arbitrarily specified.
2, then, enter the path spec
1. As shown in the following image, we press the power button at the top of the phone to wait for the iphone screen to turn off when the computer is turned off.
2. After shutdown, we do not turn on the Apple iphone and the computer with the original data cable link up (Recommended reading: How the Apple phone to connect to the computer)
3. Now we need to press the operation Fast to the Apple mobile phone DFU recovery mode
①, in the shutdown sta
the entire/DEV/SDA1,-A flag to think of the/dev/sda1 as a textual form (the partition itself is in binary form),-B 10-a 100 If you find the keyword, print out the first 10 lines and the last 100 lines:
The code is as follows
Copy Code
# grep-a-B 10-a ' vpsee.com '/dev/sda1 > Tmp.txt
You can find what we just deleted in a bunch of @:
The code is as follows
Copy Code
$ VI Tmp.txt...@$^@^@^@^@^@^@^@^@^@^@^@^a^@^@^@^@^@^@^@?^@^@^@^
Linux O M Study Notes MySQL backup and recovery (incremental recovery) tutorial, Study Notes mysql
Chapter 2 MySQL backup and recovery advanced-incremental recovery
I. Under what circumstances do I need incremental database recovery?
1. Do I need incremental
Full and incomplete Oracle database recovery and user management Backup Recovery
Comparison between full recovery and Incomplete recovery:
1. Full recovery: restores the database to the latest status, including all submitted data changes until the request is restored.
2. Inc
Summary of win10 system recovery methods and win10 System Recovery Summary
As the saying goes: When we often walk by the river, we can't avoid system crashes when we often use computers. Can we just take out the re-installed CD and USB flash disks at this time, if the system is win10, it is unnecessary (the method inherited from win8, so win8 can also be used in imitation), because the remedy measures of t
The simplest Oracle data recovery select as of usage, oracle Data Recovery
You perform a Flashback Query by using a SELECT statementwith an as of clause. you use a flashback query to restrieve data as it existed at some time in the past. the query explicitly references a past time by menasof timestamp or SCN. it returns committed data that was current at that point intime.You can perform a flashback query b
I. Cold backup1. When the database is shut down normally, you must know the name and path of the backup file before performing the cold backup.Copy codeThe Code is as follows:SQL> select name from v $ datefile;SQL> select name from v $ controlfile;SQL> select member from v $ logfile;
2. files to be backed up for cold backup include:All data files, all control files, and all online redo log files3. Cold backup steps① Shut down the instance to be backed up normally)② Copy all important files to th
There was a client recovery request this morning, and he accidentally used the RM-RF oradata command in the Solaris system to delete all the data files under one partition. Now do not know how to do, ask us to give support. Check it out. found that the database is not crash, it seems that directly consider the use of handle recoveryROOT@CNISORCLSVR # Uname-aSunOS cnisorclsvr 5.9 generic_112233-08 sun4u SPARC sunw,sun-fire-880ROOT@CNISORCLSVR # Ps-ef|g
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_CHANGE#,CHECKPOINT_TIMEFROMV$DATAFILE;SELECTCHECKP
Openerp data backup and recovery, openerp backup and recoveryBack up the entire database:Use the backup file to restore the database:Notes:
It is best to write a script to automatically back up data
If you do not stop openerp When deleting a database, a prompt is displayed, indicating that the database is in use and cannot be deleted.
When data is restored, If you import the data directly without clearing the old data, an error is prompted and
Method 1
1, we first use the original method of the hands of the machine.
2, then we simultaneously press the phone volume + do not put, boot, until the interface appears robot, loosen the volume + as shown in the following figure.
3, after we press the power button, we can enter the recovery menu as shown in the following figure
Method 2
We search for a "Brush Machine Wizard" in Baidu as shown in the following image
[Figure] Samsung's most popular big screen Android mobile phone demonstrates three buttons with clear labelsIf you often play with Samsung mobile phones, you must know the functions of these three keys and can easily enter the engineering mode (recovery) hold down the volume, HOME, and power keys at the same time, and wait until the screen is on.The above is how most Samsung mobile phones enter the Recovery
data Recovery Software How to use the top data recovery software? Many people in the use of computers, will encounter errors in computer files or data. And a lot of top data recovery software, then, the top data recovery software which is good? In fact, the top data recovery
Oracle data recovery from the recovery type, cast aside the specific files, the total can be divided into two major types of recovery, one is full recovery, one is not full recovery. In fact, once you are familiar with the Oracle architecture, there is a general concept for
Oracle version 9 because of the automatic backup of control files, the recovery directory is not required to use, but the recovery directory also has the following benefits• Some commands are only restored to the directory support (for 9i, that is, specifically to operate the recovery directory of statements)• Retention of more historical backup information• A
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.