unfortunately no response yet. Luckily, my DBA's went into something and there
are corrupted data blocks in database which failed the database backup. so
tuntil they are fixing i mtrying to find out the restore procedure.

Regards,
sandra

Yiannakis Vakis wrote:

> Sandra,
> did you get an answer to this question ? I saw your posting and I was
> waiting to see if anyone would reply because I have the same question.
> If you found out the procedure can you please let me know ?
> Thanks
> Yiannakis
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Sandra
> Sent: Monday, October 18, 2004 5:01 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: TDP Oracle Restore
>
> Dear All,
> Sorry to bother you all again.
> I am going to restore backup of oracle database tomorrow.
>
> The only thing I know about restore is that sample script:
>
> run
> {
> allocate channel t1 type ?sbt_tape? parms
> ?ENV=(TDPO_OPTFILE=/home/oracle/tdpo.opt)?;
> restore database;
> recover database;
> alter database open;
> }
>
> which is called from the command line while involking MAN.
>
> 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??
>
> Cheers
> Sandra