Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

Cause: An attempt to do media recovery using a backup
controlfile 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 controlfile 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 controlfile from the time the file was
read-write. If the correct controlfile is not available, use
CREATE CONTROLFILE to make one.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-29278: SMTP transient error: string

1 Answers  


ORA-00229: operation disallowed: already hold snapshot controlfile enqueue

1 Answers  


ORA-12496: cannot change existing level, category, or release numbers

1 Answers  


LPX-00308: attribute ~S not found in ~S

1 Answers  


ORA-06511: PL/SQL: cursor already open

1 Answers  






PLS-00718: type of attribute 'string' does not allow modifications to the attribute

1 Answers  


LFI-00105: Unable to add path.

1 Answers  


ORA-27547: Unable to query IPC OSD attribute string

1 Answers  


NNC-00418: name "string" cannot be modified because it has children

1 Answers  


ORA-31461: logfile location string contains no files that match pattern string

1 Answers  


ORA-23484: internal internet Application Server error: string

1 Answers  


ORA-34181: (MXCHGDCL21) workspace object is not a partitioned VARIABLE.

1 Answers  






Categories