Hi, sorry for the late answer, I hope these informations are still useful for you.
RMAN is able to restore to any Point Of Time on wich you have the backup. There are many RMAN script options that can be used to set the Point of Time: - until time 'date_string' wich specifies a time as an upper limit. - until scn integer wich specifies an SCN as an upper limit. - until logseq integer wich specifies a redo log sequence number as an upper limit. The until clause can be specified on the Restore and on the Recover commands or, more usefull, with a Set command like the below script: run { set until time "to_date('07-DEC-2004 09:00:00','DD-MON-YYYY HH24:MI:SS')"; allocate channel TsmCh1 type 'sbt_tape'; allocate channel TsmCh2 type 'sbt_tape'; restore database; sql "alter database mount"; recover database; sql "alter database open resetlogs"; } As shown in the script, after a Point in Time recover the database must be opened with the resetlogs option. For all informations regarding this issue there is the Oracle manual: Oracle8i Backup and Recovery Guide Release 8.1.5 - a67773.pdf and the RedBook manual: Backing Up Oracle Using Tivoli Storage Management - sg246249.pdf Regards, Mike Angel Aix and Oracle System Engineer -----Messaggio originale----- Da: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] conto di Pawel Wozniczka Inviato: giovedl 21 ottobre 2004 11.09 A: ADSM-L@VM.MARIST.EDU Oggetto: Re: TDP Oracle Restore >Question is : >when i go about restore, how would i know which backup is being restored.. the >active backup?? what would i need to do to restore any inactive backup?? Hello As far as I know "rman" always uses the latest available backupsets, and there is no official and supported way to restore previous versions of a database. But, as usually, there is a trick that makes is possibile, I use it quite frequently in order to test & verify my oracle-tdp backups. The trick is based on the fact that if the "rman" finds that the latest backupsets are marked "unavailable" it will search its database backwards until available backupsets are found and those backupsets will be used for restore operations. To summarize: a) change status of the rman backupsets that You do NOT want to be used to unavailable (change backupset xxx unavailable) b) restore database c) change status of the rman backupsets that were modified in step "a" back to available (change backupset xxx available) To make it easier I created a shell/rman script. (It's strongly hard-coded to my environment, but with a little effort can be adjusted to be useful in other environments). Please let me know whether You are interested, if yes I can send that script and try to assist in customizing it. kind regards Pawel W. [EMAIL PROTECTED] Mike Angel Unix and Tsm Specialist --------------------------------- Nuovo Yahoo! Messenger E' molto piy divertente: Audibles, Avatar, Webcam, Giochi, Rubrica Scaricalo ora!