如何恢复一个只有完好数据文件的数据库？[3]

文章作者 100test 发表时间 2007:03:14 13:59:27
来源 100Test.Com百考试题网

3）开始重建控制文件

Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/

D:>sqlplus/nolog



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



Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.



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> 0select instance_name,status from v$instance.



INSTANCE_NAME STATUS

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

tti OPEN



SQL> 0select 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 0selected.



SQL>