The plan was to copy the database from 1 box to another, by copying all the datafiles over and run the create controlfile command on the new:-
unfortunatly the script that we had set to run from cron had not set all the environments up correctly so it didn't understand the command 'svrmgrl' which means it didn't shut the db down before copying all the files. So we came in this morning with all the files copied over but they were all open when copied.
SO - we went into svrmgrl on the live db and issued: 'alter database backup controlfile to trace resetlogs' and then removed the recover db part and then we copied this over to the other box and ran this in svrmgrl.
Everything seems fine apart from the ..system01.dbf needs media recovery. so we did 'recover database using backup controlfile' it went through all the logs and is now asking for a log we havn't got... so we canceled this and tried 'recover database using backup controlfile until cancel' it says the recovery is complete and when we try 'alter database open resetlogs' it says ..system01.dbf needs media recovery....
HELP - WHAT DO WE DO???!!!