I. Basic Information
OS: RHEL 3
CPU: 4 Intel (R) Xeon (TM) mp cpu 2.70 GHz
Mem: 8 GB
Swap: 16 GB
Disk: 120 GB
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0Ii. Backup Mode
The database runs in archive mode and supports multi-level Incremental backup of RMAN. The policy is as follows:
Sets automatic backup of control files.
A full database backup (including all the databases and read-only tablespaces) is performed every three months, and archiving logs are backed up.
Perform a zero-lev
Now the U disk has become the most commonly used mobile storage devices, the advantages of the U disk is not elaborate, because these are the reason why we buy. The process of using a USB stick, there are always some problems, especially in the virus, formatting, operation errors, etc., these problems generally result in the loss of data stored on the U disk. With the increasing capacity of the USB drive, the trouble with data loss is increasing. Therefore, the Invincible data
This article is a simulated test. The main steps are as follows:1. Perform rman full backup for the Test Database (nocatalog mode)2. Delete all files in the oradata \ orcl Directory3. Use rman for recovery.The detailed steps are as follows:1. Perform rman full backup for the Test DatabaseC: \ Documents Ents and Settings \ xGss2000> rman nocatalog target/Recovery Manager: Release 10.2.0.1.0-Production on Sunday, September 11, August 14 00:06:16 2011Cop
Article Title: Linux and Unix file system backup and recovery methods. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
Backup target: User File or entire File System
Key backup Prob
Have you ever encountered this situation, accidentally deleted the file and emptied the Recycle Bin, mistakenly deleted files can be found back? Yes, many friends will feel that can be recovered. If the difficulty is too large, can only find data recovery company. Connect the system to the home to share the next how to restore the Recycle Bin mistakenly deleted files.
The specific steps are as follows:
Me
RMAN backup and recovery-parameter file Restoration
In RMAN, "restoration" and "restoration" have different meanings. "restoration" refers to accessing the previously generated backup set to obtain one or more objects, then restore these objects at a location on the disk. Detached from restoration. Recovery is an actual operation that allows a database to be open
around 1.2TB. Some of the file directories are as follows:650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M01/8C/CD/wKiom1h4fEXS340oAAC4LOt9Vgk017.jpg "title=" 3.jpg "alt=" Wkiom1h4fexs340oaac4lot9vgk017.jpg "/>11, test database file is completeUse the Oracle Database file Detection Tool "DBV" to detect the integrity of each database
server| Recovery | data | database
There are two ways to backup a SQL Server database, one is to back up the database files using Backup databases, and the other is to directly copy the database file MDF and log file LDF. The following is a major discussion of the latter's backup and recovery. This article assumes that
it's a lot of files, you need to use the following commandLsof |grep deleted Note: This deleted represents the deleted file, but the file handle is not released, and this command lists all the processes that have not disposed of the file handle.Note: Some systems you do not configure the environment variables, direct lsof will be an error without the command, yo
Recently because of the busy work, coupled with the end of a lot of projects, there is no time to write Bo, today, a friend asked about the Windows 2003 shadow copies of the function, said is only a whole disk restore, from itself, when we look at the disk properties, this is the case, this Windows R2 , Windows R2 is different, in Windows R2 we can restore files directly in the disk properties, in fact, under Windows 2003 can also achieve file-level
Label:Oracle Database Logic export EXP DMP file corruption, extracting data from the table in the DMP file through unconventional recovery In some cases, the exp DMP file is damaged for some reason (such as a disk exception, exp process corruption, etc.), resulting in IMP import cannot continue, the following processin
ServerMSSQLDatatest_data.mdf'
2. Only mdf file Restoration Technology
For various reasons, if we only backed up the mdf file at that time, it would be very troublesome to restore it.
If your mdf file is generated by the current database, you may be lucky to use sp_attach_db or sp_attach_single_file_db to restore the database, but the following prompt will appear
Oracle non-critical file recovery, redo, temporary files, index files, password files, and oracleredo
The Application of Incremental backup is in the rediscovery stage and is no longer in the restore stage.
Learn about the database settings table:SQL> desc database_propertiesName Null? Type-----------------------------------------------------------------------------PROPERTY_NAME not null VARCHAR2 (30)PROPER
\FTTEST01 ', ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS02. DBF ', ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ZXF1. DBF ', ' E:\ORACLE\PRODUCT\10.2.0\ORADATa\orcl\zxf2. DBF ', ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TZX01. DBF ' CHARACTER SET ZHS16GBK;
3.recover database; Restore Database
4. Open database alter DB open;
Since Noresetlogs is recovered with the high SCN of the current log, there is basically no problem.
IV: Using Resetlogs to perform control files and database
"User units"A branch of China Unicom"Data Recovery failure description"Sun Fiber Storage System, the central storage of 6 pieces of 300G hard disk RAID6, divided into several lun,map to different services on the server, the server runs the Sun Solaris operating system.In normal operation, the user needs to add a new application, so an IBM server is added, then a LUN in the store is mapped to the new IBM server in the online state, and unexpectedly, th
=%backpath_full%. DMP SET backpath= SET backpath_full= EXITRecommendation IV:RMAN target=rman/[email protected] Recommendation Five: Edit the cmd command in the text. Then save it as a bat file. When you define a task schedule in Windows, you It can be executed automatically. Cases: Edit a text file Del c:\exp\*.dmp Exp userid=cw/[email protected] file= ' c:\
Data Recovery tips how to restore a computer file deleted
During the use of computers, we often delete useless computer files, but sometimes important files may be deleted accidentally. If you just delete the file to the recycle bin, you just need to find the file in the recycle bin and restore it. But what if the rec
1 HD movie format before and after the file system is one of the Ntfs/exfat/fat32, and the format of the HD movie file size and location has not changed.
2 If the file system is one of the Ntfs/exfat/fat32 before the HD movie file, but the formatted partition has changed, please select "Partition Restore"
3 If the
a file in Windows Explorer, Windows puts the file in the Recycle Bin, and even if we empty the Recycle Bin (or do not start the Recycle Bin feature), the operating system does not actually erase the file's data.
What Windows calls deletion actually simply changes the first letter of the file name to a special character, the cluster is then marked as idle, but t
Tags: install mount http. com Hive Summary Collection file system ASPDescription: Not necessarily effective, need to keep tryingFirst, lsofThe file has just been deleted and you want to restore it, try Lsof first.lsof | grep Data.file1 CP /proc/xxx/xxx/xx /dir/data.file1If the lsof cannot see the file, then recovery s
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.