K Disk does not open the device hardware fatal error, resulting in the request failed because of this I disk file system internal structure damage caused. To recover the data inside it must be noted that the disk cannot be formatted, or the data will be further damaged. Specific recovery methods look at the textTools/Software: Meteor Data Recovery SoftwareStep 1:
the data file
[Oracle @ odb1 ~] $ Vi/u01/app/oracle/oradata/lhz/test01.dbf
3. Enter any characters and save them.
4. Shut down database instances
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
5. Start the instance
SQL> startup
ORACLE instance started.
Total System Global Area 599785472 bytes
Fixed Size 2098112 bytes
Variable Size 243272768 bytes
Database Buffers 348127232 bytes
Redo Buffers 6287360 bytes
D
First, the files to be recovered are placed in the data file in MS SQL and into the MS SQL primary database server.
1. We use the default method to establish a database for recovery use (e.g. MHDYF2005). Can be built in SQL Server.
2. Shut down the database server.
3. Delete the log file mhdyf2005_log.ldf the database you just generated, overwriting the databa
Environment Description:OS: aix 6.1DB: bare Oracle 10gR2 Device
An error occurred while using rman to back up the entire database. If the 71 Data File fails to be backed up separately$ Rman target/
Recovery Manager: Release 10.2.0.1.0-Production on Thu Nov 7 09:14:31 2013
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connected to target database: ORCL (DBID = 1237792397, not open)
RMAN> backup as c
When using a computer, we accidentally delete some useful files, but we are not professional maintenance personnel do not know how to get, small make up to tell everyone a small way, want to know friends hurriedly come this way, the following small series to give you a detailed explanation of the 360 security Guardian recovery file How to use? I hope we can be of some help to you.
1, first we enter 360 sec
PS: Red font is an important part, look carefullyWhen you are aware of the accidental deletion of files, you should never write more frequently, otherwise your data recovery will be very small. And what we want to do is, the first time the service on the server all stop, directly killall process name or kill-9 PID. Then delete the deleted files from the partition, re-mount the RO, read-only (Mount-o ro/dev/sdb2/data/).First, the use of System Tools De
The mobile disk cannot open files or directories that are corrupt and unreadable because of the internal structure corruption of the file system of the I drive. To recover the data inside it must be noted that the disk cannot be formatted, or the data will be further damaged. Specific recovery methods look at the textTools/Software: AuroradatarecoveryStep 1: First download and unzip the program to run, dire
If the operation is risky, proceed with the following operations with caution:
In the past, the file system format of a mobile hard disk was changed to raw format several times. You can click or view the hard disk properties to find the following points:
Displays 0 bytes and raw format.
The following message is displayed: "unformatted" or "file or directory structure is damaged and cannot be read "
and Real Application testing optionssql>sql> create SPFile from pfile= '/oracle/pfile.12 '; File created. Sql> Startup Nomountoracle instance started. Total System Global area 1453092864 bytesfixed size 2213416 bytesvariable size 855640536 bytesdatabase buffers 587202 560 Bytesredo Buffers 8036352 bytessql>Then re-Rman quit login to perform the alter operation, you can alter the database mount.[[emailprotected] ~]$ rlwrap rman target/
any key did you hit? You have to go to the recovery state! Go! Go! Go!Serial number [0168092006000880]: READ onlyHW Version Number [0710]: READ onlySelf MAC Address [0014-F6EE-DA80]: READ onlyBoot File name [Screenos_image]: Write the name of the image you have in the computer's Cisco TFTP server, anyway you can copy and paste it all.Self IP address [10.1.4.180]: Redefine the IP addresses of the e0/0 ports
Format File scope:
Delete a file or folder and empty the Recycle Bin
Delete files that are not placed in the Recycle Bin immediately
Delete infected files
Format a hard disk partition with important data
Specific recovery steps:
1th step: On the FinalData 3.0 Wizard interface, click the "Recover deleted/Lost Files" button.
2nd step: Click "Reco
.264.862339751 ONLINE+data/mecbs/datafile/undotbs2.265.862341013 ONLINE+DATA/MECBS/DATAFILE/SYSTEM01.DBF SYSTEM+DATA/MECBS/DATAFILE/CRM01.DBF ONLINE+DATA/MECBS/DATAFILE/TEST01.DBF OFFLINE+DATA/MECBS/DATAFILE/CROSS.DBF ONLINE+DATA/MECBS/DATAFILE/AIX_TRANS.DBF ONLINEOne by one rows selected.sql> alter tablespace test online;Tablespace altered.Sql> select Name,status from V$datafile;NAME STATUS------------------------------------------------------------ -------+data/mecbs/datafile/system.25
Some time ago, I helped a friend recover a damaged dmp file, which is more than 100 Gb. I recorded the recovery process and briefly summarized it.I. DescriptionThis dmp file is exp from an Oracle 9i Database. Two types of errors may occur randomly when importing the Oracle 11g version, as shown below (1) when the dmp file
Restore the database if the archive log is lost and the data file is damaged.Restore with rman, archive loss, recovery to the specified sequence1. When the database is open, perform some operations to determine the archive log file of these operations.
SQL> select group #, sequence #, members, status from v $ log;GROUP # SEQUENCE # MEMBERS STATUS-----------------
Test environment: Windows Azure Shanghai Room, virtual machine configured for large (quad core, 7 GB memory), the disk situation is shown in the figure below.
The database backup compression file is greater than 12.0 GB (12,914,327,552 bytes), placed in temporary Storage (D:).
The database restore operation commands are as follows:
RESTORE DATABASE [Cnblogstext] from DISK = N ' D:\cnblogstext.bak ' with FI
Two days ago, due to forced shutdown, data files in the database were damaged. One database cannot be started and the media needs to be restored. Follow the online method:
Login data: sqlplus "/as sysdba"
Disable data: shutdown immediate;
Then start the data: startup;
An error was reported during startup:
ORA-01113: File 1 requires media recovery
ORA-01110: Data F
Record the recovery process for SQL Server2008 log file corruption:Environment: System Windows Server2003Database SQL Server2008Failure reason: The user interface is inconsistent when linking the same server through MSTSC. The decision to restart the server, the application is not properly closed (the program is accessing the database), causing the database log file
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.