Posted in control files, Database Administration (DBA), Oracle, Oracle Recovery, Oracle Solutions. Tagged in control files, DBID, DBID in oracle, oracle, SET DBID in oracle. Shortlink. Leave a comment.
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;