In recent days, the company's technical maintenance staff frequently asked me to restore the database, because they always have fewer where conditions, resulting in unrecoverable consequences for the update and delete operations, the libraries are dozens of GB. It takes less than 10 minutes to recover. For this reason, I have found some materials and work summaries and provided several methods to quickly restore
ORACLE does not have parameter files and control files. How can I restore databases through rman?Scenario: a dev tells me that a user's table cannot be seen in the production environment and needs to be restored. At this time, the disk directory file of the parameter file control file that is automatically backed up in the production database is broken, therefore, only data files and archive log files are backed up by rman. In this case, how can we us
Dump backup
Restore
Dd Data Backup
Create a mkisofs Image File
Dump backup
Dump is mainly used to back up a real file system backup. Although it can also back up a single directory, it does not provide sufficient support for the directory. We recommend that you back up a single directory by packing and compressing it.
Dump another function is to set the level, that is, Incremental Backup can be performed.
Dump levels are divided into 0 ~ 9: 10 leve
To create a System restore point
First find "Computer" in the Start menu, Win7 users need to be found in the Start menu, the sidebar on the right. Then right click Computer and select Properties. Find the third option in the left column of the Computer Properties dialog box "System Protection" click Open.
Under the System Properties window select the System Protection tab, under the Protection settings to select the drive you want to cre
A variety of trojans, viruses, malware increasingly rampant, for us computer enthusiasts, the time to face the worry of the installation system. So do we just have to reload the system to solve the problem? The answer is No. A key to restore the wizard, computer enthusiasts, the most loyal friends, gently help you solve the problem, just a key can make your computer operating system instantaneous restore, y
--- Start of recovery content --- data recovery is particularly important for a good application. Because the data recovery function can recover data to the system when data is damaged, so as to ensure that the system is re-running properly, so as to avoid the loss caused by abnormal data loss. This example shows how to restore a database in C. Restore database
--- Start of recovery content --- data recover
Computer users often sigh at the computer "can't afford" Ah! Are you also like this? For the computer crash sigh "can't afford", for the computer lost data sigh "injury", for the computer unresponsive sigh "can't afford". With Odd rabbit one key restore, let computer say Goodbye "can't afford".
Odd Rabbit One key restore is the first implementation of 3 seconds backup, 5 seconds to
Link: http://www.xitongzhijia.net/xtjc/20121017/17511.html
As an internal enterprise network administrator, it is inevitable that there will be exceptions in the routine maintenance of the Active Directory of the AD. How can we solve this inevitable accident? To avoid the loss of the current production environment, the enterprise's internal network administrator can restore the lost user data at the first time. This tutorial will explain the methods
WIN8 Chinese version integrates the System Restore function, lets the user easily restores the system to the initial state, does this mean that the ghost system reload will be replaced? Next, let's test the Win8 Chinese version of the recovery computer and initialize the computer function to see if they can recover the damaged and poisoned system, and whether to compete with Ghost, through the final results we can see the use of WIN8 with the system r
Computer in what system backup software is best, do not think that only foreign must be the best, there are more than ghost cattle-made software oh, this article we will take a look at the easy number of a key to restore the use of evaluation.
Easy to use one-key reduction using evaluation than ghost more cattle-made software
Easy number one key to restore the latest version is 1.2.3, is the December 2013
Auto-configuration database_console version Restore database, Database Console
Error message:
Configuration:
Cause: the database name "5" is not the actual logical name of the database backup file named "Sdzn"
View the actual logical name of the database backup file named "Sdzn:
From the above we can see that "5" should be changed to "SdznSmartCloudEdu_Empty"
【
Note:
There are three names in SQL Server: Database Name, logical file name, and physic
Restore rm from CentOS and rm from centos
I. Mount the disk partition as read-only
This step is very important, and the disk should be mounted as read-only as soon as possible after the file is deleted by mistake. The sooner you start the process, the higher the chances of successful recovery.
1. Check the partition in which the deleted file is located.
[root@localhost~]#mount/dev/mapper/VolGroup-lv_root on/type ext4(rw)/dev/mapper/VolGroup-lv_home o
The default backup format for control files is:C-iiiiiiiiii-yyyymmdd-qqwhichC: Indicates a control fileIIIIIIIIII: Indicates dbidYYYYMMDD: Time stamp for backupQq:16 binary serial number, starting from 00, maximum value FFUsing the fast recovery area or recovery catalog1. Restore the control file from an automated backuprman> restore controlfile from Autobackup;2. Resto
Together to see how the small Yi is done!First, find the E -disk Test folder, right-click, and select properties .
Put
this picture away.
expand this picture
Open the Previous Versions tab, select the appropriate restore point (if there are more than one), and press restore .
Put
this picture away.
expand this picture
Win7 System Restore creation method, in the Windows system, the introduction of the System Restore this feature, when mistakenly deleted files or programs damaged, through the System Restore function, can be restored to a certain period of normal state, without reinstalling the system, or to create a system repair disc, You can use the System Recovery CD to quick
The Restore Wizard is a pure software version of the HDD Restore tool, which uses ghost manual backup. Compared to a one-click Restore Wizard, it is not a hard disk partition and storage backup, on the contrary. So, how do you use the Restoration Wizard?
In order to protect the backup files (prevent accidental deletion, prevent the disk from being co
1. Back up all archived log filesrman> Backup Archivelog all delete input;Second: Various options for restore Archivelog0. According to the RAC thread, restore Archivelog from Logseq 6160 thread 2;1.restore Archivelog All restores all archived log filesrman> restore Archivelog all;2. Recover only 5 to 8 of these four a
Differential backup: Back up data based on full backup. Because the tar command cannot implement differential backup, this article explains how to use the dump and restore commands. Of course, the dump and restore commands can also implement full backup and Incremental backup.
1. Create Backup directory partition mounting
[root@serv01 data]# mkdir /backup[root@serv01 data]# fdisk /dev/sdb[root@serv01 data]
This series of articles has never touched on the "Restore" topic, because once this topic is involved, it will involve a lot of misunderstandings, it's as long as I can't finish using an article.
In fact, I want to number every misunderstanding in alphabetical order. I hope you will not be sleepy. The following 26 misunderstandings are exposed.
Misunderstanding #24: 26 misunderstandings about restorationAll are errors.
24 a) The with stopat parameter
Manual steps for backing up the registry in Windows XP:
1. Click Start, click Run, type%systemroot%\system32\restore\rstrui.exe, and then click OK;2. On the Welcome to the System Restore page, click Create a restore point, and then click Next.3. On the Create a Restore Point page, type the name of 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.