Rman scn #
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Rman scn #

  1. #1
    Join Date
    Jul 2006
    Posts
    195

    Rman scn #

    I am trying to get my hands around RMAN and issues the command
    restore database preview summary and I see below.

    Can somebody explain the following lines?

    Media recovery start SCN is 614309
    Recovery must be done beyond SCN 614318 to clear data files fuzziness.

    a) where are these numbers comming from?
    b) what recovery syntax would I use to recovery my DB up to the moment it
    was shutdown, 614319, 614320, ......
    c) If I chose to use a recovery until scn # syntax how would I correlate that
    to a time my DB would be recovered


    restore database preview summary
    .....
    .....
    .....

    List of Archived Logs in backup set 4544
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 349 614293 22-AUG-10 614323 22-AUG-10

    List of Archived Log Copies
    Key Thrd Seq S Low Time Name
    ------- ---- ------- - --------- ----
    4694 1 350 A 22-AUG-10 /oracle/data/pri/arch/arch_350_1_727035906.arc
    4695 1 351 A 22-AUG-10 /oracle/data/pri/arch/arch_351_1_727035906.arc
    4696 1 352 A 22-AUG-10 /oracle/data/pri/arch/arch_352_1_727035906.arc
    4697 1 353 A 22-AUG-10 /oracle/data/pri/arch/arch_353_1_727035906.arc
    4698 1 354 A 23-AUG-10 /oracle/data/pri/arch/arch_354_1_727035906.arc
    4699 1 355 A 23-AUG-10 /oracle/data/pri/arch/arch_355_1_727035906.arc
    4700 1 356 A 23-AUG-10 /oracle/data/pri/arch/arch_356_1_727035906.arc
    Media recovery start SCN is 614309
    Recovery must be done beyond SCN 614318 to clear data files fuzziness
    Finished restore at 23-AUG-10

  2. #2
    Join Date
    Dec 2002
    Posts
    60
    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;

  3. #3
    Join Date
    Jul 2006
    Posts
    195
    Quote Originally Posted by skhanal View Post
    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')";

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width