Re: Oracle 8.0.5 Linux

Brian

TSPITR is an Oracle8 feature. But I think the bigger answer is you are confused about what it does. TSPITR is used to recover an individual tablespace to a point in time in the past, while the rest of the database remains current at today's time.

The ALTER TABLESPACE xyz BEGIN BACKUP command simply tells Oracle that the tablespace is in backup mode. It freezes the header of the datafiles for the tablespace, while still allowing blocks in the datafiles to be updated.

HTH. Pete

Brian McKerr wrote:

> Hello all,
> quick question.....does the above version of oracle allow
> Table Space Point in Time Recovery ?
>
> I checked V$OPTION and it says "FALSE" however I can issue a "alter
> tablespace xyz begin backup" and it does not complain. The alert log
> shows the statement processed successfully also !
>
> I checked dba_tablespaces and the tablespace appears as ONLINE. Is this
> correct ?
>
> Any help would be appreciated.
>
> Cheers
>
> Brian
>
> (Post replies to newsgroup please otherwise remove 'nospamm' to reply
> via email)

Received on Mon Nov 15 1999 - 18:03:16 CST