Hi All,
DB: 10g
OS: windows
I am in a situation, i have a old controlfile trace and the latest controlfile is lost. The old controlfile doesnt have the new datafile entries.So i am mounting the database with the old trace with resetlog option and then i will be renaming the unamed datafiles. What i want to know here is why do i have to use
ALTER DATABASE OPEN RESETLOGS;
as i have already specified the reset logs option in the creation of controlfile.
I am confused as in when to use the Reset log and the No reset logs option.
Kindly clarify the same.
BR
Sphinx