My Own DBA Experience

Recently We had an requirement for restoring an old database , Scenario :   We just have an old database rman backup and do not have anything,      1. Do not know weather spfile and controlfile backed up or not,      2. Do not know weather archive files included or not ,      3. Do not know weather the backup is consistent or not, Client just provided the backup on the same server and asked us to restore the database, Rman restore can be done in 2 ways, 1 . Rman Cloning using Duplicate command 2 . Complete Restore - with procedure , 1st case : Clonning :-    To do this we need to have both Source and target database with up and running or one on the mounted state , most of all the target will be mounted ,  But our scenario has just backup and no database is up and running , This case we had no other choice than the 2nd case. 2nd Case : Complete restore  Here is how we followed the steps, ...