ORA-01145: offline immediate disallowed unless media
recovery enabled



ORA-01145: offline immediate disallowed unless media recovery enabled..

Answer / guest

Cause: ALTER TABLESPACE ... OFFLINE IMMEDIATE or ALTER
DATABASE DATAFILE ... OFFLINE is only allowed if database is
in ARCHIVELOG mode.

Action: Take tablespace offline normally or shutdown abort.
Reconsider your backup strategy. You could do this if you
were archiving your logs.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06803: TLI Driver: the IPX device file could not be opened

1 Answers  


ORA-25133: duplicate SINGLE TABLE option specified

1 Answers  


NZE-28800: data source failed to open

1 Answers  


ORA-32500: Dirname 'string' cannot exceed 'number' characters

1 Answers  


ORA-02143: invalid STORAGE option

1 Answers  






SQL-02137: Multi-threaded agent with no RETURNING clause present

1 Answers  


IMP-00041: Warning: object created with compilation warnings

1 Answers  


ORA-09930: LUB of two labels is invalid

1 Answers  


LFI-00138: Unable to perform string on a name object that is string.

1 Answers  


ORA-28530: Heterogeneous Services initialization error in NLS language ID

1 Answers  


ORA-36698: (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.

1 Answers  


ORA-23417: unknown materialized view type: string

1 Answers  


Categories