从 Oracle 数据文件中恢复数据库 [英] Recover Database from Oracle Datafiles

问题描述

我有从损坏的分区中恢复的数据文件.请帮我将它们恢复到新的 Oracle 数据库中.我是 Oracle 的新手，所以这个任务对我来说太难了.我真的需要你的帮助！

I have datafiles which were recovered from damaged partition. Please help me restore them into a new Oracle database. I'm new to Oracle so this mission is too hard for me. I really need your help!

推荐答案

假设您复制这些文件时数据库已关闭.

Assuming when you copied these files the database was shutdown.

将所有原始数据文件备份到其他地方并将所有 *.dbf 文件复制到数据文件夹中

Backup your all original datafiles somewhere else and copy all your *.dbf files in datafile folder

试试下面的命令

SQL> conn / as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

 SQL> startup nomount;
 SQL> alter system set control_files = '/oracle/data/control.dbf';
 SQL> shutdown immediate

SQL> startup mount
ORACLE instance started.

Total System Global Area  264241152 bytes
Fixed Size                  1286916 bytes
Variable Size             205524220 bytes
Database Buffers           54525952 bytes
Redo Buffers                2904064 bytes
Database mounted.

SQL> recover database until cancel;
Media recovery complete.
SQL> alter database open resetlogs;

Database altered.

SQL>

这篇关于从 Oracle 数据文件中恢复数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！