TSPITR recovery using rman 9i Rel 2

From: mike Desouza <mike_at_archoak.fsworld.co.uk>
Date: Fri, 28 Jun 2002 00:28:06 +0100
Message-ID: <afg72k$fec$1@news6.svr.pol.co.uk>

Hi guys

I am having problem performing TSPITR using RMAN, Has anyway succesfully done this using RMAN with Oracle 9i rel 2

here is the trace from rman , It would be grateful if someone could point me in the right direction

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. Windows NT Version 4.0 Service Pack 6, CPU type 586 Starting with debugging turned off

RMAN>
RMAN> connect target sys/practice_at_practice connected to target database: PRACTICE (DBID=2655990797)

RMAN> connect catalog rman901/rman_at_rcat connected to recovery catalog database

RMAN> connect auxiliary sys/auxy
connected to auxiliary database: practice (not mounted)

RMAN> run {

2>    set command id to 'Performing TSPITR';
3>    set until time "27-JUN-2002 21:04:12";
4>    allocate auxiliary channel d1 type disk;
5>    recover tablespace users;
6> }

executing command: SET COMMAND ID

executing command: SET until clause

allocated channel: d1
channel d1: sid=11 devtype=DISK

Starting recover at 27-06-2002:21:37:15

starting media recovery
media recovery failed
released channel: d1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 06/27/2002 21:37:17 ORA-00283: recovery session canceled due to errors RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 tablespace USERS

ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 9 - file is in use or recovery
ORA-01110: data file 9: 'C:\ORACLE\ORADATA\PRACTICE\USERS01.DBF'

RMAN>
RMAN> **end-of-file** Received on Thu Jun 27 2002 - 18:28:06 CDT