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-30204: buffer is not large enougth

1 Answers  


ORA-01637: rollback segment 'string' is being used by another instance (#string)

1 Answers  


NNL-00831: Deletes refused, name is not a leaf name: number

1 Answers  


ORA-01126: database must be mounted in this instance and not open in any instance

1 Answers  


ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

1 Answers  


ORA-08456: no sign in picture mask but SIGN clause in mask options

1 Answers  


IMG-02006: 2FF06 - average color feature cannot be determined

1 Answers  


LCD-00112: illegal integer radix specification [string]

1 Answers  


ORA-30032: the suspended (resumable) statement has timed out

1 Answers  


ORA-00310: archived log contains sequence string; sequence string required

1 Answers  


ORA-26513: push error: master proc. string$RP.string failed for trans:string seq:string

1 Answers  


LSX-00002: root element is not <schema>

1 Answers  


Categories