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:ADSM-L AT VM.MARIST DOT EDU]Per conto di

Pawel Wozniczka

Inviato: giovedl 21 ottobre 2004 11.09

A: ADSM-L AT VM.MARIST DOT 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.

pwozniczka@no_spam_kghm.pl





Mike Angel

Unix and Tsm Specialist

---------------------------------
Nuovo Yahoo! Messenger E' molto piy divertente: Audibles, Avatar, Webcam, 
Giochi, Rubrica  Scaricalo ora!