如何恢复一个只有完好数据文件的数据库?
来源:互联网 发布:tz淘宝买东西怎么查 编辑:程序博客网 时间:2024/05/07 00:37
如何恢复一个只有完好数据文件的数据库?
本文欲将此数据文件恢复成数据库TTI,实例名TTI
$ORACLE_HOME=d:oracleora92
1、创建相关目录
d:oracleoradatatti --拷贝数据文件到此目录下,如果没有redolog文件,需要手工创建
d:oracleadminttibdumpd:oracleadmintticdumpd:oracleadmintticreated:oracleadminttipfiled:oracleadminttiudump
2、创建初始化文件(本例的初始化文件D:oracleadminttipfileinit.ora)
可拷贝现有数据库的初始化文件进行修改,主要修改内容如下:
db_name=ttibackground_dump_dest=D:oracleadminttibdumpcore_dump_dest=D:oracleadmintticdumptimed_statistics=TRUEuser_dump_dest=D:oracleadminttiudumpcontrol_files=("D:oracleoradatattiCONTROL01.CTL", "D:oracleoradatattiCONTROL02.CTL", "D:oracleoradatattiCONTROL03.CTL")instance_name=ttidispatchers="(PROTOCOL=TCP) (SERVICE=ttiXDB)"
3、创建实例及密码文件
开始-〉执行-〉cmdD:>oradim.exe -new -sid tti -startmode mD:>orapwd.exe file=d:oracleora92databasePWDtti.ora password=zlw001
4、添加监听和连接
1)在d:oracleora92networkadminlistener.ora中的SID_LIST_LISTENER下面添加如下内容:
(SID_DESC =(GLOBAL_DBNAME = tti)(ORACLE_HOME = D:oracleora92)(SID_NAME = tti))
2)在d:oracleora92networkadmintnsnames.ora中添加如下内容:
(这里注意:如果你的d:oracleora92networkadminsqlnet.ora中的参数
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)))
1)在类似的数据库(比如数据库名称"rman")上执行:
alter database backup controlfile to trace;
然后在D:oracleadminrmanudump下找到最新的trace文件,以文本方式打开,找到类似下面的一段话:
<iframe name="google_ads_frame" marginwidth="0" marginheight="0" src="http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-1572879403720716&dt=1173066663984&hl=zh-CN&lmt=1165263495&alternate_ad_url=http%3A%2F%2Fwww.pcdog.com%2F0000js%2Fgoogle336.htm&format=336x280_as&output=html&channel=6686853775&url=http%3A%2F%2Fwww.pcdog.com%2Fedu%2Foracle%2F2006%2F11%2Fs175094_2.html&color_bg=FFFFFF&color_text=000000&color_link=0000ff&color_url=008000&color_border=FFFFFF&ad_type=text_image&ref=http%3A%2F%2Fwww.pcdog.com%2Fedu%2Foracle%2F2006%2F11%2Fs175094.html&cc=29&u_h=768&u_w=1024&u_ah=738&u_aw=1024&u_cd=32&u_tz=480&u_his=1&u_java=true" frameborder="0" width="336" scrolling="no" height="280" allowtransparency="allowtransparency"></iframe>
STARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "rman" NORESETLOGS ARCHIVELOG-- SET STANDBY TO MAXIMIZE PERFORMANCEMAXLOGFILES 50MAXLOGMEMBERS 5MAXDATAFILES 100MAXINSTANCES 1MAXLOGHISTORY 226LOGFILEGROUP 1 'D:ORACLEORADATARMANREDO01.LOG' SIZE 100M,GROUP 2 'D:ORACLEORADATARMANREDO02.LOG' SIZE 100M,GROUP 3 'D:ORACLEORADATARMANREDO03.LOG' SIZE 100M-- STANDBY LOGFILEDATAFILE'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 NOMOUNTCREATE CONTROLFILE set DATABASE "tti" RESETLOGS --注意这里要"set"-- SET STANDBY TO MAXIMIZE PERFORMANCEMAXLOGFILES 50MAXLOGMEMBERS 5MAXDATAFILES 100MAXINSTANCES 1MAXLOGHISTORY 226LOGFILEGROUP 1 'D:ORACLEORADATAttiREDO01.LOG' SIZE 100M,GROUP 2 'D:ORACLEORADATAttiREDO02.LOG' SIZE 100M,GROUP 3 'D:ORACLEORADATAttiREDO03.LOG' SIZE 100M-- STANDBY LOGFILEDATAFILE'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
D:>sqlplus/nologSQL*Plus: Release 9.2.0.1.0 - Production on Thu Nov 16 09:08:19 2006Copyright (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 bytesFixed Size 453492 bytesVariable Size 109051904 bytesDatabase Buffers 25165824 bytesRedo Buffers 667648 bytesSQL> CREATE CONTROLFILE set DATABASE "tti" RESETLOGS2 -- SET STANDBY TO MAXIMIZE PERFORMANCE3 MAXLOGFILES 504 MAXLOGMEMBERS 55 MAXDATAFILES 1006 MAXINSTANCES 17 MAXLOGHISTORY 2268 LOGFILE9 GROUP 1 'D:ORACLEORADATAttiREDO01.LOG' SIZE 100M,10 GROUP 2 'D:ORACLEORADATAttiREDO02.LOG' SIZE 100M,11 GROUP 3 'D:ORACLEORADATAttiREDO03.LOG' SIZE 100M12 -- STANDBY LOGFILE13 DATAFILE14 '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 OPENSQL> select ts#,name from v$datafile;file# NAME--------- --------------------------------------------1 D:ORACLEORADATATTISYSTEM01.DBF2 D:ORACLEORADATATTIUNDOTBS01.DBF3 D:ORACLEORADATATTICWMLITE01.DBF4 D:ORACLEORADATATTIDRSYS01.DBF5 D:ORACLEORADATATTIEXAMPLE01.DBF6 D:ORACLEORADATATTIINDX01.DBF7 D:ORACLEORADATATTIODM01.DBF8 D:ORACLEORADATATTITOOLS01.DBF9 D:ORACLEORADATATTIUSERS01.DBF10 D:ORACLEORADATATTIXDB01.DBF11 D:ORACLEORADATATTITEST.ORA11 rows selected.SQL>
至此全部结束!
- 如何恢复一个只有完好数据文件的数据库?
- 如何恢复只有完好数据文件的oracle数据库
- 如何从完好的数据文件恢复oracle数据库
- 如何从完好的数据文件恢复oracle数据库
- 如何从完好的数据文件恢复oracle数据库
- 只有数据文件恢复数据库
- Oracle之只有数据文件恢复数据库
- 恢复只有一个mdf文件的数据库
- Oracle10g只有数据文件的恢复(Windows)
- Oracle10g只有数据文件的恢复(Windows)
- oracle 只有数据文件时的恢复
- 仅仅只有数据文件情况的恢复
- 仅仅只有数据文件情况的恢复
- sql server 没有日志文件只有数据文件(.mdf) 的数据库恢复方法
- 拥有归档日志 如何恢复一个丢失的数据文件
- 没有备份、只有归档日志,如何恢复数据文件?
- 没有备份、只有归档日志,如何恢复数据文件?
- 没有备份、只有归档日志,如何恢复数据文件?
- 动态生成验证码&计数器图片
- 吃不着萝卜的驴子
- 如何写网站策划书(即网站建设方案)?
- dsp初始化
- IBM 认证 SOA 解决方案设计师认证考试准备,第 1 部分: SOA 最佳实践
- 如何恢复一个只有完好数据文件的数据库?
- 第一个脚印
- 如何搞垮他的数据库——谈Oracle安全
- 一个有关数据库的网站
- 正月十五雪打灯
- OEM BIOS Emulation Toolkit For Windows Vista x86 v1.0
- VSS的每日自动备份
- ANSI C字符串相关的实现
- Http File Server 2.1d.088