如何还原oracle数据备份 [英] how to restore oracle data backup

问题描述

最近，我的计算机的高清出现了问题.我的oracle 10g xe已安装并在此HD中运行.

但是在HD停止运行之前，我在文件夹"oradata \ XE"中执行了DBF文件的副本.这些文件是:CONTROL.DBF，SYSAUX.DBF，SYSTEM.DBF，TEMP.DBF，UNDOTBS1.DBF，USERS.DBF

我想知道是否有可能从这些文件中恢复我的数据.或者，如果有可能将该文件中的数据导入到新安装的Oracle 10g中.我拥有所有用户名和密码.

有人可以帮我吗?

先感谢您.此致

悲剧:(

SQL>启动nomount
SQL>显示参数控制

名称类型值

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

control_file_record_keep_time整数7

control_files字符串X:\ ORCLXE \ CONTROL \ CONTROL01.C
TL，X:\ ORCLXE \ CONTROL \ CONTROL
02.CTL，X:\ ORCLXE \ CONTROL \ CON
TROL03.CTL

 创建 CONTROLFILE REUSE 数据库  "  RESETLOGS NOARCHIVELOG
    MAXLOGFILES  16 
    MAXLOGMEMBERS  3 
    MAXDATAFILES  100 
    MAXINSTANCES  8 
    MAXLOGHISTORY  292 
日志文件
  组  1  ' 组  2  ' 组  3  ' '  X:\ ORCLXE \ DATA \ SYSTEM01.DBF'，
  '  X:\ ORCLXE \ DATA \ UNDOTBS01.DBF'，
  '  X:\ ORCLXE \ DATA \ SYSAUX01.DBF'，
  '  X:\ ORCLXE \ DATA \ USERS01.DBF'，
  '  X:\ ORCLXE \ DATA \ UNDOTBS02.DBF'
CHARACTER  SET  WE8MSWIN1252; 

控制文件已创建.

 更改 数据库 mount； 

 更改 数据库 打开 resetlogs; 

Recently, the HD of my computer was having problems. My oracle 10g xe was installed and running in this HD.

But I performed a copy of the DBF files in the folder "oradata\XE", before the HD stop functioning. These files are: CONTROL.DBF ,SYSAUX.DBF,SYSTEM.DBF,TEMP.DBF,UNDOTBS1.DBF,USERS.DBF

I wonder if is possible to recover my data from these files. Or, if is possible to import the data in this files to a new installation of Oracle 10g. I have all users and passwords.

Can someone help me?

Thank you in advance. Best Regards

解决方案

It''s tragedy :(

SQL> startup nomount
SQL> show parameter control

NAME TYPE VALUE

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

control_file_record_keep_time integer 7

control_files string X:\ORCLXE\CONTROL\CONTROL01.C
TL, X:\ORCLXE\CONTROL\CONTROL
02.CTL, X:\ORCLXE\CONTROL\CON
TROL03.CTL

CREATE CONTROLFILE REUSE DATABASE "ORCLXE" RESETLOGS NOARCHIVELOG 
    MAXLOGFILES 16 
    MAXLOGMEMBERS 3 
    MAXDATAFILES 100 
    MAXINSTANCES 8 
    MAXLOGHISTORY 292 
LOGFILE 
  GROUP 1 'X:\ORCLXE\LOG\REDO01.LOG'  SIZE 50M, 
  GROUP 2 'X:\ORCLXE\LOG\REDO02.LOG'  SIZE 50M, 
  GROUP 3 'X:\ORCLXE\LOG\REDO03.LOG'  SIZE 50M 
DATAFILE 
  'X:\ORCLXE\DATA\SYSTEM01.DBF', 
  'X:\ORCLXE\DATA\UNDOTBS01.DBF', 
  'X:\ORCLXE\DATA\SYSAUX01.DBF', 
  'X:\ORCLXE\DATA\USERS01.DBF', 
  'X:\ORCLXE\DATA\UNDOTBS02.DBF' 
CHARACTER SET WE8MSWIN1252; 

Control file created.

alter database mount;

alter database open resetlogs;

这篇关于如何还原oracle数据备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！