Database States Differentiations in Oracle
We have already known that there're 4 states in life cycle of an instance. They are idle, nomount, mount and open. In this post, we… Read More »Database States Differentiations in Oracle
Database Identifier (DBID)
How to Change DB_NAME of a RAC Database
In previous post, we have talked about how to change DBID of a RAC database. In this post, we will talk about how to change… Read More »How to Change DB_NAME of a RAC Database
How to Change DBID of a Single-Instance Database
For a duplicate database, you may want to change its Database Identifier (DBID) only in order to distinguish this one from another. For a RAC… Read More »How to Change DBID of a Single-Instance Database
How to Resolve NID-00120 Error Message
NID-00120: Database should be mounted exclusively NID-00120 means that the current instance does not get the exclusivity of the cluster database, so DBNEWID utility (nid)… Read More »How to Resolve NID-00120 Error Message
How to Find Oracle DBID
DBID Database Identifier (DBID) is a unique number that can be identified by RMAN so as to do backup and restore whenever needed. In some… Read More »How to Find Oracle DBID
Why Should I Know DBID of a Database
Different database has their own DBID that can make recovery catalog distinguish which is which, but in the same data guard infrastructure, the database, either… Read More »Why Should I Know DBID of a Database
How does Recovery Catalog Recognize Databases Which is Which?
Normally and generally, recovery catalog recognizes the databases by DBID which is a unique number among different databases. But there's a problem: the primary database… Read More »How does Recovery Catalog Recognize Databases Which is Which?