We all know that the rm command in Linux can be used to delete files, and the deleted files are difficult to recover, but the database files are accidentally deleted. Is there any way to recover them? Don't worry, the following small series will introduce you to Linux how to recover the rm deleted database files, let's get to know it.
1. First test rm accidentally deleted file database
[oracle @ primary dbwdn] $ ll
total 2153164
-rw-r ----- 1 oracle dba 8536064 Nov 27 21:50 control01.ctl
-rw-r----- 1 oracle dba 8536064 Nov 27 21:50 control02.ctl
-rw-r----- 1 oracle dba 8536064 Nov 27 21:50 control03.ctl
-rw-r----- 1 oracle dba 104865792 Nov 27 21:32 ggs01.dbf
-rw-r----- 1 oracle dba 525344768 Nov 27 21:32 perfstat.dbf
-rw-r----- 1 oracle dba 52429312 Nov 27 21:10 redo01 .log
-rw-r----- 1 oracle dba 52429312 Nov 27 21:49 redo02.log
-rw-r----- 1 oracle dba 52429312 Nov 27 21:10 redo03.log
-rw-r----- 1 oracle dba 10493952 Nov 27 21:32 shkz_data_01.dbf
-rw-r----- 1 oracle Dba 524296192 Nov 27 21:49 sysaux01.dbf
-rw-r----- 1 oracle dba 524296192 Nov 27 21:49 system01.dbf
-rw-r--- -- 1 oracle dba 209723392 Nov 18 10:54 temp01.dbf
-rw-r----- 1 oracle dba 52436992 Nov 27 21:32 test01.dbf
-rw-r----- 1 oracle dba 251666432 Nov 27 21:49 undotbs01.dbf
-rw-r----- 1 oracle dba 26222592 Nov 27 21:32 users01.dbf
[oracle@primary dbwdn]$ rm test01.dbf
2. Find the database background process dbw0
oracle 3493 1 0 21:10 ? 00:00:00 ora_dbw0_dbwdn
Process ID 3493
3. Find the database file that was accidentally deleted
[oracle@primary dbwdn]$ ll /proc/3493/fd
total 0
lr-x------ 1 oracle oinstall 64 Nov 27 21:52 0 -> /dev/null
lr-x-- ---- 1 oracle oinstall 64 Nov 27 21:52 1 -> /dev/null
lr-x------ 1 oracle oinstall 64 Nov 27 21:52 10 -" /dev/Zero
lr-x------ 1 oracle oinstall 64 Nov 27 21:52 11 -" /dev/zero
lr-x------ 1 oracle oinstall 64 Nov 27 21:52 12 -> /u01/app/oracle/product/10.2.0/db_1/rdbms/mesg/oraus.msb
lrwx------ 1 oracle oinstall 64 Nov 27 21:52 13 -" /u01/app/oracle/product/10.2.0/db_1/dbs/hc_dbwdn.dat
lrwx------ 1 oracle oinstall 64 Nov 27 21:52 14 - /u01/app/oracle/product/10.2.0/db_1/dbs/lkDBWDN
lrwx------ 1 oracle oinstall 64 Nov 27 21:52 15 -" /u01/app/oracle /oradata/dbwdn/control01.ctl
lrwx------ 1 oracle oinstall 64 Nov 2 7 21:52 16 -> /u01/app/oracle/oradata/dbwdn/control02.ctl
lrwx------ 1 oracle oinstall 64 Nov 27 21:52 17 -》 /u01/app /oracle/oradata/dbwdn/control03.ctl
lrwx------ 1 oracle oinstall 64 Nov 27 21:52 18 -> /u01/app/oracle/oradata/dbwdn/system01.dbf< Br>
lrwx------ 1 oracle oinstall 64 Nov 27 21:52 19 ->> /u01/app/oracle/oradata/dbwdn/undotbs01.dbf
lr-x--- --- 1 oracle oinstall 64 Nov 27 21:52 2 -" /dev/null
lrwx------ 1 oracle oinstall 64 Nov 27 21:52 20 -" /u01/app/oracle /oradata/dbwdn/sysaux01.dbf
lrwx------ 1 oracle oinstall 64 Nov 27 21:52 21 -" /u01/app/oracle/oradata/dbwdn/users01.dbf
lrwx------ 1 oracle oinstall 64 Nov 27 21:52 22 -> /u01/app/oracle/oradata/dbwdn/test01.dbf (deleted)
lrwx---- -- 1 oracle oinstall 64 Nov 27 21:52 23 -> /u01/app/oracle/oradata/dbwdn/ggs01.dbf
lrwx------ 1 oracle oinstall 64 Nov 27 21:52 24 -" /u01/app/oracle/oradata/db Wdn/perfstat.dbf
lrwx------ 1 oracle oinstall 64 Nov 27 21:52 25 -> /u01/app/oracle/oradata/dbwdn/shkz_data_01.dbf
Lrwx------ 1 oracle oinstall 64 Nov 27 21:52 26 -> /u01/app/oracle/oradata/dbwdn/temp01.dbf
lr-x------ 1 oracle Oinstall 64 Nov 27 21:52 27 -> /u01/app/oracle/product/10.2.0/db_1/rdbms/mesg/oraus.msb
lr-x------ 1 oracle oinstall 64 Nov 27 21:52 3 -》 /dev/null
lr-x------ 1 oracle oinstall 64 Nov 27 21:52 4 -》 /dev/null
L-wx------ 1 oracle oinstall 64 Nov 27 21:52 5 ->> /u01/app/oracle/admin/dbwdn/udump/dbwdn_ora_3485.trc
l-wx---- -- 1 oracle oinstall 64 Nov 27 21:52 6 -> /u01/app/oracle/admin/dbwdn/bdump/alert_dbwdn.log
lrwx------ 1 oracle oinstall 64 Nov 27 21 :52 7 -" /u01/app/oracle/product/10.2.0/db_1/dbs/hc_dbwdn.dat
l-wx------ 1 oracle oinstall 64 Nov 27 21:52 8 -》 /u01/app/oracle/admin/dbwdn/bdump/alert_dbwdn.log
Error deletion After the database is not restarted, the system is not used to restart
4. Copy the database file
[oracle@primary ~]$ cp /proc/3493/fd/22 /u01/app/oracle /oradata/dbwdn/test01.dbf
[oracle@primary ~]$ cd /u01/app/oracle/oradata/dbwdn
[oracle@primary dbwdn]$ ls
control01.ctl control03.ctl perfstat.dbf redo02.log shkz_data_01.dbf system01.dbf test01.dbf users01.dbf
control02.ctl ggs01.dbf redo01.log redo03.log sysaux01.dbf temp01.dbf Undotbs01.dbf
The database file is back.
5.Recovering database files
[oracle@primary dbwdn]$ sqlplus “/as sysdba”
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Nov 27 21:55:15 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Previous123Next 3 page
In many cases, Linux is used as a server to allow computers on the Internet to acce
There are a lot of Linux users who use the Firefox browser, and the silent request
Linux system operation, many people are not very familiar with the installation of
Many users often confuse rpm and yum under Linux system, they have similar names and functions, and
Ubuntu notebook to increase heat dissipation through Bumblebee
What is the meaning of Linux beginners learning commands?
Linux vsftp prompt 530 Permission denied how to do?
Usage of the Linux tail command
How to configure Kickstart script
How to use the command to modify the man pages text color under Linux
Summary of usage of Linux chmod commands
What should I do if the Linux crontab has a BAD FILE MODE error?
How to turn off recovery mode in Ubuntu 12.04 system
Linux mydumper error libmysqlclient_16 not defined how to do?
Ten features that were abandoned by Windows 7
IE 9 compatibility view settings
Cleverly solve the problem that IE can't be used normally in Win8
Win8 system to create user accounts
How to change the IP address in batches
Windows XP system can not start normally solution
The Win7 system computer clicks to shut down but becomes a logout
What should I do if there is no sound after reinstalling Win7 system
XP boot menu how much do you know (novice must read)
How to set the optimal resolution for win10 system? Win10 set the best resolution method