Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2008
    Posts
    27

    Unanswered: Run duplicate until scn

    Hi all

    Now I need to run duplicate command by using :
    set until scn ....
    allocate channel ch1 type disk;
    duplicate target database to TESTDB


    at set until scn ... : I don't know what number I will put. but I also has list backup like this:

    BS Key Size Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    35 49.84M DISK 00:00:51 09-SEP-08
    BP Key: 35 Status: AVAILABLE Compressed: YES Tag:AG20080909T075231
    Piece Name: /backup/hotb/rman_bakup/archivelogarch_ELTPROD_14jq51m4_36_20080909

    List of Archived Logs in backup set 35
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 39 837051546 08-SEP-08 837057803 08-SEP-08
    1 40 837057803 08-SEP-08 837057810 08-SEP-08
    1 41 837057810 08-SEP-08 837077939 08-SEP-08
    1 42 837077939 08-SEP-08 837090007 08-SEP-08
    1 43 837090007 08-SEP-08 837126661 09-SEP-08
    1 44 837126661 09-SEP-08 837126669 09-SEP-08

    Can anybody help me?How to restore by using until scn number?

    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Now I need to run duplicate command by using :
    >set until scn ....
    How/why do you feel compelled to do something you don't know how to do?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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