recovery technologies use storage media and certain policies to regularly back up system business data to ensure that data can be recovered as soon as possible during accidental data loss and minimize user losses. It is a very important core technology in the information security discipline.
Backup Technology in
. Create a Test accountSql> create user test identified by test default tablespace test;
Sql> Grant Connect,resource to test;3. Inserting test dataSql> Conn test/test
sql> CREATE TABLE t1 (id int);
sql> INSERT INTO T1 values (1);
Sql> select * from T1;
ID
----------
14. Delete data files[[Emailprotected]~]$rm-f/opt/oracle/oradata/member/test01.dbf [[email Protected]~]$sqlplustest/test Sql>createtablet2asselect
*fromt1; Createtablet2asselect*fromt1
.Unmap LUNs and Disconnect server from legacy system–remove any proprietary device drivers from server–prepare server to use native multipathing (MPIO)3.Connect XIV to Legacy system–define XIV as a Linux ' host ' to legacy system–map legacy LUNs to XIV ' host '4.Start XIV Data Migration– "Keep Source Updated" is recommended–XIV reads LUN sequentially5.Connect Server to XIV–map new XIV LUN to server6.Product
Starting with the Oracle 11GR1 release, Oracle provides a recommended solution for database data file fixes to better enable users to choose a recovery approach
This becomes more and more intelligent, and we just need to follow the Fix Advice wizard.
Environment Oracle Linux as 5.5+oracle 11.2 (archive mode)
1, the situation before the backup
Sql> Conn Fmisma
When it comes to data recovery, we can't help but mention the hard disk data structure, file storage principles, and even the operating system startup process. These are the basic knowledge you have to take advantage of when restoring hard disk data. Even if you do not need to recover
When it comes to data recovery, we can't help but mention the hard disk data structure, file storage principles, and even the operating system startup process. These are the basic knowledge you have to take advantage of when restoring hard disk data. Even if you do not need to recover
chanel_following;
+ ------- + --------- + ------ + ----- + --------- + ------- +
| Field | Type | Null | Key | Default | Extra |
+ ------- + --------- + ------ + ----- + --------- + ------- +
| Id | int (11) | NO | PRI | NULL |
| Uid | int (11) | NO | NULL |
+ ------- + --------- + ------ + ----- + --------- + ------- +
2 rows in set (0.01 sec)1.2 back up data through mysqldump
(Prepare for the Restoration experiment): open another window for easy in
Set the mysql installation directory to system environment variables to facilitate direct execution on the command line terminal.
After mysql is installed in linux, the default root password is blank. You can directly log on to mysql.
Normal logon command mysql-h host address-u username-p Password
Note that no space is required. If you log on to mysql on the local machine directly, you do not need to add the-h parameter.
Database backup and
Open Source Tool TestDisk Data recovery method
Because of the operation error, in the installation of Fedora accidentally format the entire hard drive, resulting in all data loss (later access to relevant information, but the head data loss, sector data is still in), relucta
Yesterday at the customer did an Rman recovery, the production library to get a copy to the test library, the total library of about 80G, a total of 2 hours, when the customer's environment is Windows 11.2.0.3, this morning under Linux re-test a bit, recorded for everyone referenceEnvironment:All operations are distinguished by host nameSOURCE Library:Host name Bre1 instance named Bre1
-10-23_06-33-47/xtrabackup_suspended 'xtrabackup_55 version 2.0.0 for Percona Server 5.5.16 Linux (x86_64) (revision id:417)Xtrabackup:uses posix_fadvise ().XTRABACKUP:CD To/mysqldata/dataXtrabackup:target instance is assumed as followings.Xtrabackup:innodb_data_home_dir =/mysqldata/dataXtrabackup:innodb_data_file_path = Ibdata01:1g:autoextendXtrabackup:innodb_log_group_home_dir =/mysqldata/iblogsXtrabackup:innodb_log_files_in_group = 2Xtrabackup:inno
When we learn about Linux, we know that Linux is a free-to-use and freely-spread Unix-like operating system. During the learning process, we will encounter a Linux operating system hard disk partition table or data loss, it is a headache. Fortunately, a considerable number of tools are available to restore
.
Differential backup (Differential): Only the files and folders selected for backup with the logo are not cleared. That is, only files created or changed since the last normal backup or Incremental Backup are backed up. Because it does not clear the archive attributes of files, if two differential backups are performed on a file, the entire file will be backed up at each time. Differential backup uses more storage media than Incremental backup, but restoring differential backup
business database, import backup data, perform recovery operation, restore operation success, heart pressure finally put down, afterwards the whole person scared unceasingly.The database recovery process also encountered the problem of character set, and the installation of database device files when the device files need to be the original library file size, al
Today, we performed an incremental backup test on Oracle in Linux. When restoring with restoredatabase, the following error occurs: Channel ORA_DISK_2: Reading the backup segment homeor
Today, we performed an incremental backup test on Oracle in Linux. The following error occurs when recovering from the restore database: Channel ORA_DISK_2: Reading the backup segment/home/or
Today, we performed an incr
For how recovery works, see the first blog on the Restoration topic:Http://fly1116.blog.51cto.com/8301004/1337681For a brief introduction to the fly. sh script used in the restoration process and other scripts, see the second blog on the Restoration topic:Http://fly1116.blog.51cto.com/8301004/1338316If the database is not in the archive State and there is no backup, you can use the operating system command rm to accidentally delete all
For RM, many people have a bitter lesson. I also met once, the program written in the afternoon was the RM dropped, fortunately just a document, the next day and quickly re-write again. But a lot of people may not be as lucky as I am. This article collects some methods of recovering RM deleted files under Linux, and gives you a reference.First of all, the best way is to avoid this problem, here are a few suggestions:1, Rm-rf The consequences of misope
that can be matched before and after. This process is usually difficult to perform manually. Therefore, the data recovery center in North Asia has specially developed a program to verify the forward and backward offsets of the vhd format for matching. The detailed algorithms are not publicly available for the moment, however, you can refer to this article and my own
Record uuid "region" 2 and create the
Subversion (SVN) is an open source version control system that manages data that changes over time. This data is placed in a central repository, which is much like an ordinary file server that remembers every change in the file so that it can be restored to the old version, or the history of the changes to the file. This document directory: Linux SVN server deplo
= device BS = 64 K"
# Tar-CVF-| SSH remote_host "dd If = device BS = 10 K"
# Cpio-oacvb | SSH remote_host "dd If = device BS = 5 K"
Linux bare metal recovery method:
1. Back up important metadata # fdisk-L>/etc/fdisk-l.txt
2. Use a local tool to back up the system # cd/; tar CF-. | gzip-C>/backup/xxx.tar.gz
3. The system is damaged. Use other media to guide the system (BOOT disk, knoppix, etc ).
4. Partiti
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.