Hi all

Thanks for your response. So refering to your comment how can I correct that? Can you show me the command?
I have tried to recover the tablespace to a point in time and getting the "Auxilliary database error" Where is the auxilliary database? I think this should be the Target.

Recovery Manager complete.
hpxndx2:/home/oracledb > rman catalog dvrman/[email protected]

Recovery Manager: Release 9.2.0.5.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to recovery catalog database

RMAN> connect target /

connected to target database: DBS9I2 (DBID=3053171798)

RMAN> run {
allocate clone channel dev1 type 'SBT_TAPE';
recover tablespace TRISTA until time 'oct 09 2006 09:00:00';
}

RMAN-00571: ========================================
RMAN-00569: == ERROR MESSAGE STACK FOLLOWS RMAN-00571: ========================================
RMAN-03002: failure of allocate command at 10/10/2006 08:59:51
RMAN-06174: not connected to auxiliary database

RMAN>