-
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,
-
Try
allocate channel for maintenance type 'sbt_tape/disk';
report obsolete;
release channel;
Sam
-
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.
-
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
-
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.
-
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. :o
I'm sorry for not giving you the answer to the point. Any comments or critisizms are welcomed.
Cheers http://www.plauder-smilies.de/jump.gif
Sam
[Edited by sambavan on 04-20-2001 at 07:32 PM]