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-16782: some instance not open for read and write access

1 Answers  


ORA-02068: following severe error from stringstring

2 Answers  


ORA-09341: scumnt: unable to mount database

1 Answers  


ORA-02829: No segment of the proper size is available

1 Answers  


ORA-30380: REWRITE_TABLE does not exist

1 Answers  


ORA-16148: user requested expiration of managed recovery operation

1 Answers  


ORA-08183: Flashback cannot be enabled in the middle of a transaction

1 Answers  


ORA-23443: missing template parameter

1 Answers  


ORA-13195: failed to generate maximum tile value

1 Answers  


ORA-02359: internal error setting attribute string

1 Answers  


ORA-01597: cannot alter system rollback segment online or offline

1 Answers  


ORA-33454: (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.

1 Answers  


Categories