Database Identifier (DBID)

How to Change DBID of a Single-Instance Database

by Ed Chen
January 13, 2021December 22, 2020

For a duplicate database, you may want to change its Database Identifier (DBID) only in order to distinguish this one from another. Here we use… Read More »

How to Resolve NID-00120: Database should be mounted exclusively

by Ed Chen
January 6, 2021January 9, 2021

NID-00120 I was trying to change database name (DB_NAME) of a 19c RAC database by DBNEWID utility (nid), but it failed with NID-00120: Database should… Read More »

How to Find DBID

by Ed Chen
December 30, 2020December 22, 2020

In some situations, you may have to know DBID of the database to let backup catalog know the subsequent steps are for specific database in… Read More »

Why Should I Know DBID of a Database

by Ed Chen
May 19, 2016December 22, 2020

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 »

How does Recovery Catalog Recognize Databases Which is Which?

by Ed Chen
May 1, 2016December 22, 2020

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 »