ORA-29314: tablespace 'string' is not OFFLINE FOR RECOVER nor READ ON

ORA-29314: tablespace 'string' is not OFFLINE FOR RECOVER
nor READ ONLY

Question Posted / guest

ORA-29314: tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY..

Answer / guest

Cause: Tablespace clean SCN is either 0 or invalid.

Action: ALTER the tablespace OFFLINE FOR RECOVER.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

More Oracle Errors Interview Questions

PCC-02105: Unable to open list file

ORA-00119: invalid specification for system parameter string

ORA-27480: window "string" is currently open

RMAN-03002: failure of string command at string

ORA-30129: invalid function argument received

ORA-24382: statement handled already executed or described

ORA-16167: LGWR network server could not switch to non-blocking mode

RMAN-06031: could not translate database keyword

ORA-09772: osnpmetbrkmsg: message from host had incorrect message type

RMAN-06042: PLUS ARCHIVELOG option is not supported with non-datafile backups

ORA-15181: Symbol [string] not found in library string, error [string]

ORA-04050: invalid or missing procedure, function, or package name

For more Oracle Errors Interview Questions Click Here