ORA-01623: log string is current log for instance string
(thread string) - cannot drop



ORA-01623: log string is current log for instance string (thread string) - cannot drop..

Answer / guest

Cause: A thread's current log cannot be dropped even if the
thread is closed. A disabled thread usually does not have a
current log, but a half completed disable may need to be
disabled again.

Action: If the database is not open then disable the thread.
If the database is open and an instance has the thread open,
then the instance can be requested to switch logs. If the
database is closed the log can be archived or cleared to
force a switch.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02327: cannot create index on expression with datatype string

1 Answers  


KUP-04044: error positioning file string

1 Answers  


ORA-16802: downgrading log transport mode from SYNC disallowed

1 Answers  


ORA-06705: TLI Driver: remote node is unknown

1 Answers  


ORA-01683: unable to extend index string.string partition string by string in tablespace string

1 Answers  


RMAN-08542: channel string: starting proxy archivelog backup at string

1 Answers  


ORA-01925: maximum of string enabled roles exceeded

2 Answers  


ORA-25157: Specified block size string is not valid

1 Answers  


ORA-01042: detaching a session with open cursors not allowed

1 Answers  


PLS-01416: Use of <id> (<value>...) here

1 Answers  


DRG-12233: xml sections cannot co-exist with other section types

1 Answers  


ORA-29315: tablespace 'string' has been recreated

1 Answers  


Categories