怎麼下落表空間和恢復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 -