RE: How to recover the DB if we lost controlfile and w...
If there is no backup of control file then recreate the control file and specify name location and size of all datafiles redolog files and controlfiles in script on the behalf of this you can resolve the scenario
RE: How to recover the DB if we lost controlfile and we are not having backup also and the database is down...?
We can create the controlfile while recreating controlfile specify the REUSE oprtion and if having all the Logfiles intact then use norestlogs option while creating the Control file than specify the name of all the datafiles and logfiles and issue the startup nomount command then run the script to craete a controlfile. The script must have all necessery info.
RE: How to recover the DB if we lost controlfile and we are not having backup also and the database is down...?
If controlfile is lost we can go to the trace file in udump and there after we can create control file by copying the datafile and redologfile and paste in user managed backup by giving old location to a new new location and then try to recover the old one giving the reuse option.
0 
1