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

RMAN-06403: could not obtain a fully authorized session

1 Answers  


ORA-23442: object already exists for the refresh group template

1 Answers  


SQL*Loader-00712: Internal error: bad address for big endian UTF16 conversion

1 Answers  


ORA-09709: soacon: failed to accept a connection.

1 Answers  


ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION

2 Answers  






NNL-00802: Queries received, type ADDRESS: number

1 Answers  


ORA-06607: LU6.2 Driver: Reset occurred in send state

1 Answers  


LPX-00312: cannot construct XML PI with content: ~S

1 Answers  


PCC-02153: Open file: string

1 Answers  


ORA-23350: maximum number of recursive calls exceeded

1 Answers  


RMAN-06458: AS COPY option cannot be used with RECOVERY FILES, RECOVERY AREA or DB_RECOVERY_FILE_DEST

1 Answers  


ORA-26666: cannot alter STREAMS process string

1 Answers  


Categories