怎么下落表空间和恢复Oracle数据库，当偶然地删除数据档案

事故可以发生，即使它是昂贵一个。 这是特别是实际情形在Oracle数据库，在数据文件完全存放数据库对象在硬盘。 快速的手管理员也许偶然地删除某些数据档案，或者数据档案在硬盘失败也许得到腐败或不值一读。 您可以在数据库恢复过程以后也得到一些缺掉数据档案。 无论如何，错过的a或几个数据档案将造成Oracle数据库无法到起动，使整体DB不能进入。

对缺掉数据档案的解答将下降受影响的表空间，有残缺不全的数据档案，然后再创造表空间和进口数据入表空间从备份。 然而，步不是那么平直向前的。

  1. 跑SQL*Plus。
  2. 连接到数据库作为SYSDBA用这次询问：

    连接/作为SYSDBA

  3. 登上数据库而不是开始它：

    起始的登上;

  4. 发出以下指令带来缺掉数据档案离线，以便Oracle将不设法再连接和访问数据档案：

    修改数据库数据档案`<数据档案名字以完全道路>’离线下落;

    重覆命令为每未解释清楚的数据档案。

  5. 现在开始数据库适当：

    修改数据库开放;

  6. 因为表空间损坏了，下降它从新备份再创造。

    下落表空间 <表空间名字> 包括内容;

  7. 保证其他数据档案为表空间被删除了，如果不，从操作系统手工去除他们。

    技巧： 如何检查属于表空间的数据档案.

  8. 继续通过恢复进程。

重要: 这是现状提供，不用保单的机器翻译的页。 计算机翻译也许是难了解。 参见 原始的英国文章 每当可能。

分享并且贡献或者得到技术支持并且帮助在 我的数字式生活论坛.



This entry was posted on Saturday, August 4th, 2007 at 2:55 am and is filed under Databases. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

4 Responses to “How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile”

  1. How to Remove and Drop Datafiles from Tablespace in Oracle Database » My Digital Life
    August 4th, 2007 02:57
    1

    [...] If one or more datafiles is missing after a recovery process or accidental deletion, you can use ALTER DATABASE DATAFILE <datafile name> OFFLINE DROP command to make the datafile offline so that database can starts up after which the troubled tablespace can be dropped. (See instruction to recover from missing datafiles.) [...]

  2. LP
    April 2nd, 2008 18:27
    2

    These are only to drop the TS

    but not to recover…

    hence the worst….

  3. ravisha
    July 8th, 2008 19:31
    3

    This info helped us to a very great extent and hence we are able to proceed further smoothly.

  4. Cesar
    September 2nd, 2008 00:31
    4

    Thank you very much, this was really helpful.
    I had problems dropping the tablespace, i had to drop the user also.

Leave a Reply

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Subscribe without commenting

« New Logitech G9 Laser Gaming Mouse
Intel vs. AMD: Intel Fought Back With Price Slashing War »

Custom Search

New Articles

Incoming Search Terms for the Article

drop tablespace - drop tablespace in oracle - oracle drop tablespace - recover tablespace - drop tablespace offline - drop tablespace ORACLE - alter database drop tablespace - oracle recover datafile - recover oracle datafile - offline drop - oracle recover database - DROP TABLESPACE MOUNT - oracle recover tablespace - recover datafile oracle - drop oracle tablespace - oracle drop table space - recover database Oracle - oracle drop tablespace offline - oracle drop database - Recover Oracle database - alter datafile offline drop - offline drop tablespace - oracle offline drop - oracle delete datafile - drop datafile offline - all - drop datafile - recover oracle database missing data file - tablespace offline drop - drop tablespace command in oracle - restore oracle database - recover database in oracle - alter tablespace offline - oracle drop tablespace mount - oracle recover - alter database oracle - drop a tablespace - recover drop tablespace - accidental+deletion+file+oracle - oracle data file missing - damaged missing datafiles oracle - drop oracle database - oracle drop tablespace with missing datafile - drop data file - recover dropped tablespace - oracle offline drop tablespace - drop tablespace missing datafile - how to offline the tablespace without opening the database - Oracle tablespace offline drop - recover datafile -