When to use SET DBID in RMAN

We should use the command SET DBID in RMAN under the following circumstances.

  • You are not connected to a recovery catalog and want to restore the control file or server parameter file (SPFILE)
  • You are connected to a recovery catalog want to restore the control file, but the database name is not unique in the recovery catalog.
  • The server parameter (SPFILE) file is lost and you want to restore it.

You can view the DBID value from this command:

SQL> select name, dbid from v$database;

NAME              DBID

CMS                 343422323

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube