Rman scn #

[BeefStu]

a) These numbers are read from control file or data file.
b) If you want to recover everything do not specify until clause, just do recover database command.
c) You can run a query to convert scn to timestamp

select scn_to_timestamp(SCN) as timestamp from dual;

Thanks appreciate the help.

Just one more question if you don't mind, if your doing a point in time recovery why would you want to use a scn number why not just use a
time or does the time have to correlate exactly to the time of a specific time
for example:

SQL> select scn_to_timestamp(614309) as timestamp from dual;

TIMESTAMP
---------------------------------------------------------------------------
22-AUG-10 08.20.29.000000000 PM


Or can I say do something like this (note the time is different) would it not
just recover until 08.20.29?

set until time "to_date('22-08-2010 08:25:00', 'dd-mm-yyyy hh24:mi:ss')";