rman disaster recovery testing
I did hot backup on my server (27th March). I want to test it on other server by recovering whole database. I copied the archives,datafiles copies and controlfile to other machine. Location is same on both servers and database name is same. I am not using rman catalog. On the other server, i started the database in mount stage and found the latest scn. then using rman i ran the following script.
rman>run {
rman> set until scn 456345;
rman>allocate channel d1 type disk;
rman>restore database;
rman>recover database;
rman> sql 'alter database open resetlogs';
rman>}
The database was recovered properly.