I just figured out that we will not be able to take a cold backup on our prod database to copy for a QA db. Instead we have a hot backup of yesterday's that we need to use for this purpose.

So, in this case, how would I handle ?

Restore DF's and Redologs basically..
Then in the Controlfile creation script, how would I handle about recovery part?

# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# All logs need archiving and a log switch is needed.
ALTER SYSTEM ARCHIVE LOG ALL;
# Database can now be opened normally.
ALTER DATABASE OPEN;
# Commands to add tempfiles to temporary tablespaces.
# Online tempfiles have complete space information.
# Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/data/oracle/PNYKDD01/u01/temp_01.dbf' REUSE;
# End of tempfile additions.
#

With the cold bu restoration, i would have commented the recover database and alter system archive log all and should made the open statement to alter database open resetlogs. How would I do now?

Thanks, ST2003