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-32125: Attribute type is not appropriate

1 Answers  


RMAN-08522: input datafile fno=string name=string

1 Answers  


DRG-11818: Temporary Redirect

1 Answers  


ORA-31520: CDC subscription string already subscribes to publication ID string

1 Answers  


ORA-30104: 'string' is not a legal integer for 'string'

1 Answers  






RMAN-08585: copying standby controlfile

1 Answers  


PCC-00132: Indicator array size must not be less than its host variable

1 Answers  


RMAN-06135: error executing host command: string

1 Answers  


ORA-29390: some resource plans are not part of any top-plan

1 Answers  


ORA-09818: Number is too large

1 Answers  


ORA-19032: Expected XML tag string got string

1 Answers  


ORA-26725: cannot downgrade apply handlers

1 Answers  


Categories