使撤消表空间数据文件脱机，处于恢复模式？

发布于 2024-10-17 23:43:25 字数 789 浏览 4 评论 0原文

我正在尝试使用以下命令在脱机模式下撤消数据文件，

alter database datafile '<datafile path>' offline;

该数据文件处于恢复模式。 Oracle 在数据库成功更改时显示消息。

但是执行此命令后，当我选择 v$datafile 中的条目时。我刚刚离线制作的文件仍保留在该表中。

有人可以告诉我如何使撤消数据文件脱机吗？

OS: RHEL
Oracle version: 11g
Datafile status: Recovery

编辑：

我已经尝试过命令

alter database datafile '/your/data/file/name'离线删除

它说数据库更改成功，

alter database open;

失败并显示消息;需要恢复撤消文件。

我无法恢复它，因为我丢失了存档文件。看起来文件在逻辑上而不是物理上被删除。现在我只想让我的数据库启动并运行，为此我想让这个文件离线。

当我检查 v$datafile 表时，它显示文件的条目，而不管 alter database datafile '' Offline drop; 运行成功，请帮我解决问题。数据库从早上就宕机了，我无法启动它

原文

I am trying to take undo datafile in offline mode using following command

alter database datafile '<datafile path>' offline;

this datafile is in recovery mode. Oracle shows message as database successfully altered.

But after executing this command when I select entries in v$datafile. The file that I just made offline remains in this table.

Can somebody please tell how to take undo datafile offline.

OS: RHEL
Oracle version: 11g
Datafile status: Recovery

EDIT:

I already tried command

alter database datafile '/your/data/file/name' offline drop

it says database altered successfully ,

alter database open;

fails with message <my undo log file name> needs recovery of undo file.

I cannot recover it as I have lost the archive files.
It seems like file is getting dropped logically not physically. Now I just want my database to be up and running and for that I want to take this file to be offline.

When I check v$datafile table it shows the entry for the file irrespective of alter database datafile '<datafile path>' offline drop; ran succesfully, Please help me resolve the issue. Database is down from the morning and I could not get it started

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

多孤肩上扛 2024-10-24 23:43:25

你为什么要这样做？
你想实现什么目标？

v$tablespaces 中列出了表空间。数据文件是
在 v$datafiles 中。

一个表空间可以有多个数据文件。
您的数据库和备份设置如何？
您需要表空间吗？

如果您只想删除数据文件（和表空间），您可以尝试在挂载模式下删除它：

startup mount
alter database datafile '/your/data/file/name' offline drop;
alter database open;
drop tablespace your_tablespace_name including contents and datafiles;

如果您确实需要在线表空间，则首先恢复数据文件并执行完整介质恢复。

我希望这有效，
罗纳德.

Why do you want to do this?
What are you trying to accomplish?

In v$tablespaces are the tablespaces listed. The datafiles are
in v$datafiles.

A tablespace can have multiple datafiles.
How is your database and backup setup ?
Do you need the tablespace?

If you just want to get rid of the datafile (and the tablespace) you could try to drop it while in mount mode:

startup mount
alter database datafile '/your/data/file/name' offline drop;
alter database open;
drop tablespace your_tablespace_name including contents and datafiles;

If you do need the tablespace online, you start with restoring the datafile and do a full media recovery.

I hope this works,
Ronald.

回复收藏 0 原文

~没有更多了~