如何恢復一個只有完好數(shù)據(jù)文件的數(shù)據(jù)庫？

2024-07-21 02:32:53

字體：大中小

來源：轉載

供稿：網(wǎng)友

　　在沒有控制文件備份的情況下，重新創(chuàng)建控制文件也是其中一個選擇。本文旨在幫助初學者學習之用，謝謝！！　　如何恢復一個只有完好數(shù)據(jù)文件的數(shù)據(jù)庫？　　本文欲將此數(shù)據(jù)文件恢復成數(shù)據(jù)庫TTI，實例名TTI

　　$Oracle_HOME=d:oracleora92　　1、創(chuàng)建相關目錄

　　d:oracleoradatatti --拷貝數(shù)據(jù)文件到此目錄下，假如沒有redolog文件，需要手工創(chuàng)建

d:oracleadminttibdump

d:oracleadmintticdump

d:oracleadmintticreate

d:oracleadminttipfile

d:oracleadminttiudump　　2、創(chuàng)建初始化文件（本例的初始化文件D:oracleadminttipfileinit.ora）

　　可拷貝現(xiàn)有數(shù)據(jù)庫的初始化文件進行修改，主要修改內(nèi)容如下：

db_name=tti

background_dump_dest=D:oracleadminttibdump

core_dump_dest=D:oracleadmintticdump

timed_statistics=TRUE

user_dump_dest=D:oracleadminttiudump

control_files=("D:oracleoradatattiCONTROL01.CTL", "D:oracleoradatattiCONTROL02.CTL", "D:oracleoradatattiCONTROL03.CTL")

instance_name=tti

dispatchers="(PROTOCOL=TCP) (SERVICE=ttiXDB)"
　　3、創(chuàng)建實例及密碼文件

開始-〉執(zhí)行-〉cmd

D:>oradim.exe -new -sid tti -startmode m

D:>orapwd.exe file=d:oracleora92databasePWDtti.ora passWord=zlw001　　4、添加監(jiān)聽和連接

　　1）在d:oracleora92networkadminlistener.ora中的SID_LIST_LISTENER下面添加如下內(nèi)容：

(SID_DESC =

(GLOBAL_DBNAME = tti)

(ORACLE_HOME = D:oracleora92)

(SID_NAME = tti)

)　　2）在d:oracleora92networkadmintnsnames.ora中添加如下內(nèi)容：
　　（這里注重：假如你的d:oracleora92networkadminsqlnet.ora中的參數(shù)
NAMES.DEFAULT_DOMAIN = ###，則你的tnsnames.ora中下面的title那里也要改為tti.###）

tti = #title

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = MIS011)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = tti)

)

)
　　5、開始重建控制文件

　　1）在類似的數(shù)據(jù)庫(比如數(shù)據(jù)庫名稱"rman")上執(zhí)行：
　　alter database backup controlfile to trace;
　　然后在D:oracleadminrmanudump下找到最新的trace文件，以文本方式打開，找到類似下面的一段話:

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "rman" NORESETLOGS ARCHIVELOG

-- SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 50

MAXLOGMEMBERS 5

MAXDATAFILES 100

MAXINSTANCES 1

MAXLOGHISTORY 226

LOGFILE

GROUP 1 'D:ORACLEORADATARMANREDO01.LOG' SIZE 100M,

GROUP 2 'D:ORACLEORADATARMANREDO02.LOG' SIZE 100M,

GROUP 3 'D:ORACLEORADATARMANREDO03.LOG' SIZE 100M

-- STANDBY LOGFILE

DATAFILE

'D:ORACLEORADATARMANSYSTEM01.DBF',

'D:ORACLEORADATARMANUNDOTBS01.DBF',

'D:ORACLEORADATARMANCWMLITE01.DBF',

'D:ORACLEORADATARMANDRSYS01.DBF',

'D:ORACLEORADATARMANEXAMPLE01.DBF',

'D:ORACLEORADATARMANINDX01.DBF',

'D:ORACLEORADATARMANODM01.DBF',

'D:ORACLEORADATARMANTOOLS01.DBF',

'D:ORACLEORADATARMANUSERS01.DBF',

'D:ORACLEORADATARMANXDB01.DBF',

'D:ORACLEORADATARMANTEST.ORA'

CHARACTER SET WE8MSWIN1252
　　2）將上面這段話修改為如下：

STARTUP NOMOUNT

CREATE CONTROLFILE set DATABASE "tti" RESETLOGS --注重這里要"set"

-- SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 50

MAXLOGMEMBERS 5

MAXDATAFILES 100

MAXINSTANCES 1

MAXLOGHISTORY 226

LOGFILE

GROUP 1 'D:ORACLEORADATAttiREDO01.LOG' SIZE 100M,

GROUP 2 'D:ORACLEORADATAttiREDO02.LOG' SIZE 100M,

GROUP 3 'D:ORACLEORADATAttiREDO03.LOG' SIZE 100M

-- STANDBY LOGFILE

DATAFILE

'D:ORACLEORADATAttiSYSTEM01.DBF',

'D:ORACLEORADATAttiUNDOTBS01.DBF',

'D:ORACLEORADATAttiCWMLITE01.DBF',

'D:ORACLEORADATAttiDRSYS01.DBF',

'D:ORACLEORADATAttiEXAMPLE01.DBF',

'D:ORACLEORADATAttiINDX01.DBF',

'D:ORACLEORADATAttiODM01.DBF',

'D:ORACLEORADATAttiTOOLS01.DBF',

'D:ORACLEORADATAttiUSERS01.DBF',

'D:ORACLEORADATAttiXDB01.DBF',

'D:ORACLEORADATAttiTEST.ORA'

CHARACTER SET WE8MSWIN1252
　　3）開始重建控制文件

D:>sqlplus/nolog

SQL*Plus: Release 9.2.0.1.0 - ProdUCtion on Thu Nov 16 09:08:19 2006

SQL> conn sys/zlw001@tti as sysdba;

Connected to an idle instance.

SQL> startup nomount pfile=d:oracleadminttipfileinit.ora;

ORACLE instance started.

Total System Global Area 135338868 bytes

Fixed Size 453492 bytes

Variable Size 109051904 bytes

Database Buffers 25165824 bytes

Redo Buffers 667648 bytes

SQL> CREATE CONTROLFILE set DATABASE "tti" RESETLOGS

2 -- SET STANDBY TO MAXIMIZE PERFORMANCE

3 MAXLOGFILES 50

4 MAXLOGMEMBERS 5

5 MAXDATAFILES 100

6 MAXINSTANCES 1

7 MAXLOGHISTORY 226

8 LOGFILE

9 GROUP 1 'D:ORACLEORADATAttiREDO01.LOG' SIZE 100M,

10 GROUP 2 'D:ORACLEORADATAttiREDO02.LOG' SIZE 100M,

11 GROUP 3 'D:ORACLEORADATAttiREDO03.LOG' SIZE 100M

12 -- STANDBY LOGFILE

13 DATAFILE

14 'D:ORACLEORADATAttiSYSTEM01.DBF',

15 'D:ORACLEORADATAttiUNDOTBS01.DBF',

16 'D:ORACLEORADATAttiCWMLITE01.DBF',

17 'D:ORACLEORADATAttiDRSYS01.DBF',

18 'D:ORACLEORADATAttiEXAMPLE01.DBF',

19 'D:ORACLEORADATAttiINDX01.DBF',

20 'D:ORACLEORADATAttiODM01.DBF',

21 'D:ORACLEORADATAttiTOOLS01.DBF',

22 'D:ORACLEORADATAttiUSERS01.DBF',

23 'D:ORACLEORADATAttiXDB01.DBF',

24 'D:ORACLEORADATAttiTEST.ORA'

25 CHARACTER SET WE8MSWIN1252;

Control file created.

SQL> alter database open resetlogs;

Database altered.

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

tti OPEN

SQL> select ts#,name from v$datafile;

file# NAME

--------- --------------------------------------------

1 D:ORACLEORADATATTISYSTEM01.DBF

2 D:ORACLEORADATATTIUNDOTBS01.DBF

3 D:ORACLEORADATATTICWMLITE01.DBF

4 D:ORACLEORADATATTIDRSYS01.DBF

5 D:ORACLEORADATATTIEXAMPLE01.DBF

6 D:ORACLEORADATATTIINDX01.DBF

7 D:ORACLEORADATATTIODM01.DBF

8 D:ORACLEORADATATTITOOLS01.DBF

9 D:ORACLEORADATATTIUSERS01.DBF

10 D:ORACLEORADATATTIXDB01.DBF

11 D:ORACLEORADATATTITEST.ORA

11 rows selected.

SQL>
　　至此全部結束！

上一篇：一次SPA數(shù)據(jù)庫的OFFLINE備份的恢復測試

下一篇：備份的控制文件和新的數(shù)據(jù)文件

學習交流

如何查找有故障的配件

如何查找有故障的配件...

熱門圖片

猜你喜歡的新聞

猜你喜歡的關注

新聞熱點

最牛同桌！我考了696分我同桌考了703分

2024-06-26 22:28:41

650分！高二女生考入北大：遺憾不能上高三

2024-06-26 22:26:16

男生估分600只考了397 媽媽：高考雖重要，但不代表所有

2024-06-26 22:23:01

唐尚珺回應是否會直播帶貨：有人出100萬想和他合作！

2024-06-25 19:29:23

名校搶人名場面：清華、北大太拼了！

2024-06-25 19:22:14

男生高考語文滿分！網(wǎng)友：第一次聽說

2024-06-25 19:19:15

疑難解答

圖片精選

網(wǎng)友關注

国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

如何恢復一個只有完好數(shù)據(jù)文件的數(shù)據(jù)庫？