I am wondering whether someone can help me
I am testing a hot backup restore from our live system on a test system. I issue alter database switch logfile before starting to take the tablespaces ofline for backup mode.
On the test system, I have issued startup nomount and created a new controlfile. This has run ok. I have then issued alter database open resetlogs but get an error about the system datafile being inconsistent. Issuing a recover database until time using backup controlfile returns an error about needing a further archive log. This archive log does not exist in my backup set. Can someone please tell me how to open the dataabse without it?