RMAN -- List unavailable backup pieces?

[gsprince]

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,

[sambavan]

Try


allocate channel for maintenance type 'sbt_tape/disk';

report obsolete;

release channel;


Sam

[gsprince]

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.

[sambavan]

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

[gsprince]

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.

[sambavan]

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]