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-19570: file number string is outside valid range of 1 through string

1 Answers  


SQL-02146: Attempt to allocate an existing descriptor

1 Answers  


LFI-01510: fread() failed(OSD return value = string) in string.

1 Answers  


ORA-27011: skgfrd: cannot read from file opened for write

1 Answers  


ORA-00399: corrupt change description in redo log

1 Answers  






DRG-51019: unable to open or illegal format for fuzzy match data file: string

1 Answers  


ORA-27010: skgfwrt: write to file failed

1 Answers  


KUP-03011: OCI error getting database column size.

1 Answers  


ORA-06978: X.25 Driver: Too many callback tries

1 Answers  


ORA-12433: create trigger failed, policy not applied

1 Answers  


ORA-02361: error while attempting to allocate number bytes of memory

1 Answers  


DRG-12515: cannot specify language for stopwords in a BASIC_STOPLIST

1 Answers  


Categories