1. Your guess as to the meaning of your script is correct

2. RMAN> list backup of archivelog <specification>;

the specification is always a range of archived redolog files;
you can specify several ranges (based on date, scn or log sequence) :
- until [from] time 'date'
- from time 'date' until time 'date'

- until scn 1234
- from scn 1234 until scn 4567

- until logseq 3456
- from logseq 3456 until logseq 6789


You cannot list the archives in a backupset, at least not in 8.1.7


Hans

-----Original Message-----
From: benbart
[mailto:oracledba-ezmlmshield-x28068209.[Email address protected]
Sent: donderdag 29 juni 2006 3:57
To: LazyDBA Discussion
Subject: RMAN list what's in the backupset ...


Hi all,

One of the RMAN scripts that I inherited is doing a backup of the
archivelogs as
follows:

backup
filesperset 20
format '${ORACLE_SID}_a${TSM_LEVEL}s%sp%p'
archivelog all
delete input;

Am "guessing" what this means is to backup all the archivelogs and then
delete them and each backupset will contain 20 archived logs and the
backupsets are named as per the format, am I guessing it correctly so
far?

Now my question is how do I query the RMAN catalog to tell me what
archived logs are on which backupset? BTW, Oracle version is,
unfortunately, still on 8.1.7.4. Am currently browing via the web for
answers but if someone around here know the answer straight out of their
head, please post it please ...

Thanks in advance ...





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------


Oracle LazyDBA home page