Hi all,
What are the least possible privs to execute DBMS_STATS on every
objects in a database.
Thanks,
Rings
Hans wrote:
>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.
>-----------------------------------------------------------------
>
>
>
>--------
>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
>
>
>
>
Oracle LazyDBA home page