hi,
Try the following. That's a suggestion from Oracle.
You can perform join on RC_BACKUP_PIECE and RC_DATABASE_INCARNATION to get
backup pieces for all incarnation. Likewise, for archivelogs of all
incarnations use RC_ARCHIVED_LOG.
regards,
Thiha
>Hello everybody,
> I'm saving an Oracle 8.0.5 on Windows NT with RMAN.
> Therefor i has made a script to delete Backups and Archivelogs
which
>are older than 30 Days.
> In the script I use the command " list backupset of archivelog
until
>time 'SYSDATE -30' " to get
> the Information which Redologs I have.
> Last week I must restore the Database to an older date (only 3
hours
>back) and in fact of that
> I must made a new incarnation in the RecoveryCatalog (with the
>command reset database).
> Now I have the problem that my list doesen't show me the Redologs
of
>the older incarnations.
> The only way I found was to reset the database to an older
>incarnation, but this is only possible if
> the target-Database is in the state nomount. (If I shutdown the
>Database only to get information which
> Archivelogs I could delete, my customer will kill me.)
> Is there any way to get information about the backups and
>archivelogs of the older incarnations without
> 'reset the database to incarnation' ?
> Every idea would be helpfull .
best regards
Wolfgang Marx
Triaton GmbH
BU CPS Datenspeichermanagement
mailto:[EMAIL PROTECTED]
