Hello to you all,

I would like some explanation with regard to the followings:

1. Does a sequence generated during log switch has anything in common with the SCN of a database?

2. During Flashback operation of a database, can sequence of archived redo log be used instead of SCN?

Thus, for instance, can this statement :

FLASHBACK DATABASE TO SCN 1000

be changed to sey,

FLASHBACK DATABASE TO SEQUENCE nnnnn

where nnnnn is the sequence number of the redo log at the desired time?

Any assistance is welcome