I want to refresh one of my db's from production. I had my backup operator restore my prod db from last nights backup. The database is 9i. I rebuilt the controlfiles from the contents of a backup controlfile to trace command. When I went to open the database with an alter database open resetlogs; command I got the following message.
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\ORACLE\ORADATA\PSUAT\SYSTEM01.DBF' So Then I issue the following command to recover the data file
recover datafile 'E:\ORACLE\ORADATA\PSUAT\SYSTEM01.DBF';
and I recieve the following error
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
so I issued the recover database using backup control file and it asked for a log file with a certian sequence #. I put the path of the file it wanted and it returned to a sql prompt returning no error message. I guess it worked. so I then went to open the database using the alter database open noresetlogs it says I must use the resetlogs option. So I issue the alter database open resetlogs and I get the original message saying
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\ORACLE\ORADATA\PSUAT\SYSTEM01.DBF'