DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: RMAN -- List unavailable backup pieces?

  1. #1
    Join Date
    Aug 2000
    Posts
    194
    Hi:

    Is there any way (Other than querying the RC_* tables), to list the backupsets/pieces even when they are unavailable.

    The "List backupset", "List backup of database" shows only the backups available and doesn't list the ones which are made unavailable.

    ***
    Is there any RMAN command to list all the backups irrespective of their status?
    ***

    Note: I am running oracle 8.1.6.1.0

    Thanks,

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Try


    allocate channel for maintenance type 'sbt_tape/disk';

    report obsolete;

    release channel;


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Aug 2000
    Posts
    194
    Thanks Sambavan!

    But, this command wouldn't show the status of the backup set. What I am looking for is some thing similar to the "LIST" command, with all the status (not just the "AVAILABLE") listed.


  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Login to the catalog database through the sql and then run the query

    SET HEADING OFF;
    SPOOL out.txt

    SELECT TO_CHAR(s.completion_time, 'MON DD YYYY HH24:MI:SS') BACKUP_DATE_TIME,
    s.bs_key,
    s.pieces,
    s.status
    s.db_id,
    p.piece#,
    p.bp_key
    FROM rman_bb50.rc_backup_set s,
    rman_bb50.rc_backup_piece p,
    rman_bb50.rc_database_incarnation i
    WHERE s.bs_key = p.bs_key
    AND i.current_incarnation = 'YES'
    AND s.completion_time = p.completion_time
    AND s.db_id = p.db_id
    ORDER BY s.completion_time DESC
    /

    SPOOL OFF;


    and now check the out.txt file

    Hope this would help you.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Aug 2000
    Posts
    194
    Sambavan:

    Thanks for the query. I was mainly interested to know whether there is any RMAN command available to do this?

    Text from my initial posting:
    (Other than querying the RC_* tables)

    Anyway, I will stick with the query. Somehow, I was thinking there might be a RMAN command to do this.

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Actually, oracle had not yet brought RMAN to the level of our expectations. There are a number of improvements needed to be made in RMAN and to my 2 cents, I only know.

    Yes I did noticed the posting of (Other than querying the RC_* tables) , but since there aren't much command that could do the required work, I gave your the other ways to achieve the result that you were looking for.


    I'm sorry for not giving you the answer to the point. Any comments or critisizms are welcomed.

    Cheers
    Sam

    [Edited by sambavan on 04-20-2001 at 07:32 PM]
    Thanx
    Sam



    Life is a journey, not a destination!


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