ORA-01233: file string is read only - cannot recover using backup control file

ORA-01233: file string is read only - cannot recover using backup control file
Cause: An attempt to do media recovery using a backup control file found that one of the files is marked read only. Read only files do not normally need to be recovered, but recovery with a backup control file must recover all online files.
Action: If the file really is read only, take it offline before the recovery, and bring the read only tablespace online after the database is open. If the file does need recovery use a control file from the time the file was read-write. If the correct control file is not available, use CREATE CONTROLFILE to make one.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01233：文件字符串是只读的 - 无法使用备份控制文件进行恢复,
.原因：尝试使用备份控制文件执行介质恢复，发现其中一个文件被标记为只读。只读文件通常不需要恢复，但使用备份控制文件进行恢复必须恢复所有联机文件。,
.操作：如果文件确实是只读，在恢复之前使其脱机，并在数据库打开后使只读表空间联机。如果文件确实需要恢复，则从文件读写时起使用控制文件。如果正确的控制文件不可用，请使用CREATE CONTROLFILE创建一个。,
.

aiaiDBA

13718043309

010-86462881

ORA-01233: file string is read only - cannot recover using backup control file

1 个回答

相似问题