RMAN 8.0.5
If you login to the recovery catalog schema using sqlplus, you can get the
information on the archivelogs you want with the following query:
select * from al where dbinc_key = 'put_database_incarnation_key_here' and
trunc(next_time) < trunc(sysdate -30);
You can get the proper value for 'put_database_incarnation_key_here' by
selecting from the dbinc table.
select DBINC_KEY, DB_KEY, DB_NAME from dbinc;
You also might want to view the information in the db table.
KRoshto
"Marx, Wolfgang, HiServ/DE" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on
10/16/2000 02:11:06 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: RMAN and Resetlogs
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]
