Re: Tablespace recovery possible?

>Subject: Re: Tablespace recovery possible?
>From: Krisztian Rassay krisztian.rassay_at_sysdata.siemens.hu
>Date: 2/15/01 9:52 AM GMT Standard Time
>Message-id: <3A8BA6D5.EFFA96E9_at_sysdata.siemens.hu>
>
>Hi Rob,
>I'm using this rman script:
>
>run {
> allocate channel c1 type disk;
> set until time '2001-01-19:13:16:50';
> sql "alter tablespace table1 offline immediate";
> restore tablespace table1;
> recover tablespace table1;
> sql "alter tablespace table1 online";
> release channel c1;
>}
>
>
>> Hi Chris,
>> Could you be a bit more specific about what type of recovery you're
 trying
>> to perform and what you're trying to recover from. It may well be that
 rman
>> has recovered the tablespace from the backup and then rolled forward
 throught
>> the archive and online redo logs in order to bring the tablespace up to
 date,
>> this may be why the tablespace appears to be the same as prior to recovery.
>> Regards,
>> Rob
>
>In this case, how could I prohbit, that the latter redo logs will be rolled
>forward?
>
>thanks,
>Chris

Hi Chris,
 I think that's your problem in that I don't believe that you can recover a single tablespace to a point in time only the whole database. Regards,
  Rob Received on Thu Feb 15 2001 - 16:00:38 CET