RMAN 9.2.0.3 Slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: RMAN 9.2.0.3 Slow

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    RMAN 9.2.0.3 Slow

    I have a target database 9.2.0.3 that is being backed up by rman (9.2.0.3). It is very slow. I have a 60G database and it is taking 5 hours.

    When I log into rman to just do a crosscheck archivelog command it is taking over an hour. This seems to be the bottleneck.

    I checked metalink and it said it could be due to a bug but has no workaround.

    Has anyone else experienced this? Were you able to fix this?

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Cool

    Is it become slow recently or has it been allways slow?

    What is the configuration? Directly to tape or to disk?

    How many channels are you using?

    Provide more info...
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    Slow for a while

    It has been slow for a while.

    I increased the channels to 3 from 1 recently but that did not do much. I am going to disk not tape.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what are your wait events?

  5. #5
    Join Date
    Jan 2001
    Posts
    515

    Here is what I see

    The major wait is free buffer waits in the RMAN catalog database. I see it running this for a long time:

    DELETE FROM ckp
    WHERE dbinc_key = :b3
    AND ckp_key NOT IN (:b2, :b1)
    AND ckp_key NOT IN (
    SELECT NVL (MAX (ckp_key), 0)
    FROM ckp
    WHERE dbinc_key = :b3
    UNION
    SELECT start_ckp_key
    FROM tsatt
    WHERE dbinc_key = :b3
    UNION
    SELECT NVL (end_ckp_key, 0)
    FROM tsatt
    WHERE dbinc_key = :b3
    UNION
    SELECT start_ckp_key
    FROM dfatt
    WHERE dbinc_key = :b3
    UNION
    SELECT NVL (end_ckp_key, 0)
    FROM dfatt
    WHERE dbinc_key = :b3)

    In the target database I see waits on SQL Net Message from Client. I think it is waiting on the RMAN catalog.

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