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 18.104.22.168.0
04-20-2001, 04:25 PM
allocate channel for maintenance type 'sbt_tape/disk';
04-20-2001, 04:49 PM
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.
04-20-2001, 05:13 PM
Login to the catalog database through the sql and then run the query
SET HEADING OFF;
SELECT TO_CHAR(s.completion_time, 'MON DD YYYY HH24:MI:SS') BACKUP_DATE_TIME,
FROM rman_bb50.rc_backup_set s,
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
and now check the out.txt file
Hope this would help you.
04-20-2001, 06:18 PM
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.
04-20-2001, 06:37 PM
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.