Suppose we have lost all the datafiles, logfiles and even control file and parameter file is also lost.
This usually happens when the Primary Disk is damaged
Then to recover the database from this kind of failure we need to do disaster recovery or full database recovery
To restore and recover the database do the following
If you have lost the primary disk where O/s and Oracle was installed. Then, install a new disk and format and install the same operating system and same version of Oracle database software which was install before failure
Make sure RMAN backups are available and also make sure archive log files of this database are also accessible
Start RMAN by typing the following command
$ export ORACLE_SID=test
$ rman target / nocatalog
Now the most important thing we need to do now is to set the database ID (DBID) at RMAN prompt. The DBID uniquely identifies the database.
If you have already noted down the DBID of the database then you can straight forward type the DBID at the RMAN prompt.
Otherwise if you have not noted down the DBID then the other ways you can get the DBIDx is
IIIIIIIIII stands for the DBID.
YYYYMMDD is a time stamp of the day the backup is generated.
QQ is the hex sequence that starts with 00 and has a maximum of FF.
Once you got the DBID then set it by typing the following command
RMAN> set dbid=2195428530