Re: Tablespace recovery possible?

From: Krisztian Rassay <krisztian.rassay_at_sysdata.siemens.hu>
Date: Thu, 15 Feb 2001 10:52:21 +0100
Message-ID: <3A8BA6D5.EFFA96E9_at_sysdata.siemens.hu>


Hi Rob,
[Quoted] 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 Received on Thu Feb 15 2001 - 10:52:21 CET

Original text of this message