How to Tell What State of Database
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 »How to Tell What State of Database
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: Database should be mounted exclusively
NID-00120 NID-00120 means that the current instance does not get the exclusivity of the cluster database, so DBNEWID utility (nid) cannot change the database name… Read More »How to Resolve NID-00120: Database should be mounted exclusively
How to Find 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 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?