ORA-01138: database must either be open in this instance or
not at all

Answers were Sorted based on User's Feedback



ORA-01138: database must either be open in this instance or not at all..

Answer / linda s

You will see this on RAC 12c if you mistakenly only shutdown one node of the RAC and the start RMAN. You have to use srvctl to shutdown both nodes and then you can run rman.

Is This Answer Correct ?    1 Yes 0 No

ORA-01138: database must either be open in this instance or not at all..

Answer / guest

Cause: The requested operation can not be done when the
database is mounted but not open in this instance, and
another instance has the database open.

Action: Execute the operation in an open instance, open the
datbase in this instance, or close the database in the other
instances.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13768: Snaphshot ID must be between string and string.

1 Answers  


RMAN-06718: could not find file "string" in catalog

1 Answers  


ORA-22991: insufficient space allocated for argument string

1 Answers  


ORA-19908: datafile string has invalid checkpoint

1 Answers  


ORA-08112: a composite partition may not be coalesced as a whole

1 Answers  






SQL-02143: Target object has not been properly allocated

1 Answers  


NZE-28768: bad magic number

1 Answers  


ORA-00231: snapshot controlfile has not been named

1 Answers  


ORA-30134: reserved for future use

1 Answers  


ORA-12335: database (link name string) is not open

1 Answers  


ORA-02463: Duplicate HASH IS option specified

1 Answers  


ORA-01636: rollback segment 'string' is already online

1 Answers  


Categories