I would like to take a clone of a database and have all the necessary steps. However
one crucial step is not entirely clear to me and that is the part when I am on the target
server and issue a 'recover database until sequence = xxx';

My question is where do I obtain this sequence number from?

is it from the source database, prior to the backup?

Can I obtain the sequence number on the target database after I have performed 'restore database'

I am not using Dataguard but simply a restore, recover and open resetlogs

Can anyone help provide me the SQL and explain how I obtain the necessary sequence number

Many thanks in advance