It is believed that many people have encountered the accidental deletion of data and asked the DBA to restore the data, but the user only knows the approximate time of occurrence. At this time, you may see that there are two backups at the same time as the error occurs. If you restore to the last one, you may have to check the data and find that something went wrong. If there are many logs, it takes a lot of time. Today, we see the Oracle recovery pri
Mysql common operations: mysql backup and recovery, mysql backup and recoveryLog on to mysql = mysql-uroot-p to view the database version select version ();
View DatabasesShow datases; view the current database select database (); view the current logon user select user (); View tables under a database; use db; show tables; view table fields; desc dong; create database db1; create table tb1 ('id' int (4), 'name' char (40) ENGINE = myisam default chars
MySQL5.6 backup and recovery command, mysql5.6 backup and recoveryBackup
Mysqldump-P 3010-h 130.51.2.24-uroot-proot zplatdb> backup. SQL
Restore
Recover to my local machine, because I have not set a password for this machine, the password is blank,-p there do not know fill in the token
Mysql-u root-p *** zplatdb
In fact, you can:
Mysql-u root zplatdb
In addition, you can also use the source command, which is simpler, but the time is much
Method 1: The original method is the built-in method of the Android system.After the phone is shut down, press "volume down key" + "power supply key". After seeing the power-on sign, we immediately release the power button, but the "volume down key" cannot be relaxed, in a few seconds, you can enter the Recovery mode.SecondIf master Zhuo is installed on the computer, we can connect the mobile phone to the computer, and th
When the iOS corruption in router needs to be restored, Ctrl+break (Packettrace is CTRL + C) When the router starts, enters Rommon mode, and the command prompt changes to: Rommon 1>Then enter the following command:Rommon 1>IP_ADDRESS=A.B.C.D//router's current IP addressRommon Subnet mask for 2>ip_subnet_mask:x.x.x.x//routerRommon 3>default_gateway=y.y.y.y//Router Default gatewayRommon 4>tftp_server=a.b.c.d//tftp Server IP AddressRommon 5>tftp_file=c2800nm-advipservicesk9-mz.124-15.t1.bin//iOS fi
Tags: SQL version data type Java Build database nbsp ERP software MDFData type SQL2008R2 database data capacity GB fault type in the Ransomware virus,. The extension was changed to arrow repair result client sent to encrypt database, using excellent SQL database repair Master 10.0 Direct scan ransomware virus database, generate new database MDF LDF directly by ER P software use. This extension arrow and Java Artea, and so on a few ransomware virus is encrypted 0-31 blocks, for the database file
Label:Recovering archived log filesIf you simply apply the archive after recovering the data file, you do not need to manually restore the archive file, and Rman automatically recovers the appropriate archive when recover.Recovering an archive separately is typically a special requirement, such as creating a data guard environment. Some archived files are missing from the standby side and need to be retrieved from the primary side.1. Recover all archived log filesRman> RESTORE ARCHIVELOG All;2.
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
;}
Example 2: the disk where the system tablespace data file is located is faulty
The backup database (Omitted) deletes the data files corresponding to the system tablespace. Start the database to the mount status. Before restore database, run set newname to specify a new location for the data file. After the restore database, Run switch datafile to change the location and name of the data file in the control file. Then, archive logs by executing the recover database application. Finally, exec
Today, we have encountered the Oracle database sequence problem. We simply need to back up and restore the entire database. As follows:
Imp/exp Method
Table mode backup:
Oracle @ sencloudserver: EXP dhoffice/dhoffice rows = y indexes = n compress = n buffer = 65536 file = dhoffice_090101.dmp log = exp_tianle_090101.log tables = David. tianle;
User Mode backup:Oracle @ sencloudserver: EXP dhoffice/dhoffice owner = David rows = y indexes = n compress = n buffer = 65536 file = dhoffice _ 090101.dmp
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
1. We need to download a key flash brush, and download and install it on the Baidu search "Qitu flash brush" tool.2. After the curious rabbit is installed, we connect the mobile phone to the USB interface of the computer through the data cable, and then the odd rabbit will automatically help us install the driver.3. we can also use the Qitu flash machine to back up the mobile phone data. This must be done during the flash machine, click "utility-device management-data backup"
IOS firmware version is not correct
1. Using itunes to upgrade the system we should be aware that we want to upgrade the IOS firmware system to be consistent with our phone, otherwise it may cause the phone to fail to restore Oh, here we download the system firmware we need to look at the firmware is not compatible with our version oh.
2. Alternatively, we can choose to have itunes download the firmware automatically in the itunes recovery interfa
Want to know the free data recovery software which works? The following will be recommended for free data recovery software, in the use of computers or mobile phones will inevitably mistakenly delete files, data, this time need data recovery software to help, the following to see what free data recovery software it ~
Recovery | Control 1.1. Loss of recovery 1.1.1 for all control files. Analog Control file loss
rman> shutdown abort;
Oracle routines are closed
Rman> host;
Microsoft Windows XP [version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\>del d:\oracle92\test1\control*. Ctl
C:\>dir d:\oracle92\test1\control*. Ctl
The volume in drive D is not labeled.
The serial number of the volume is 644
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.