recover database until cancel;There were no transaction or any changes in the database that happened since the moment i took the coldbackup as it is a test database.
alter database open resetlogs;
$phinx19 wrote:If you had read Hemant's post thoroughly, you would have seen this statement: "The point of my post is that RMAN does not backup Online Redo Log files and since I did not have Online Redo Log files available, I had to OPEN RESETLOGS."
The cold backup was taken using OS commands and restoration was also done using OS commands and from the documents that I have read so far, even If I will take a cold backup using RMAN at mount, I will need to open my DB after restoration using resetlogs option as RMAN does not backup redologs. Here is the link that I have referred: