scn in recovery
694352May 31 2009 — edited Jun 12 2009Hi
1-)
If I restored a datafile which has higher scn then controlfile and datafiles.
I think The only way to open the db is to recreate a controlfile or copy the old controlfile.
Correct me if I am wrong.
2-)
If I recreate the controlfile how does oracle determine checkpoint scn of the datafiles?
3-)
Even I`ve just recreated a new controlfile and copy a datafile which has high scn then other datafiles.
When I check;
select CHECKPOINT_CHANGE# from v$datafile, all numbers are equal.
What is the reason for that?