SCN /resetlogs question
Posted on 2003-11-07
I need some reference to get a simple minded understaning of SCN and the relationship to resetlogs.
This is the sequence of events as far as I can tell.
Database files were tar'ed and hardware was reconfigured.
The files were then un - tar'ed back into an area smaller than the original. After the files were untarred, I attempted to start the database. Some error messages came out that indicated I could recover until cancel which I did for one of the three databases and everything was fine. Apparently noticing the space situation and the other two data bases giving error messages someone started trying to make space and deleted some files. When I tried starting the database i had recovered, i got error messages. I had my own backup of the data files and replaced them. At this point I resetlogs,
immediately made a backup. Again files were deleted, this time all the datafiles plus the backup I had made immediately after the resetlogs. Now SCN questions. How does SCN relate to datafiles and /or controlfiles?