Re: replace some datafiles

What do you mean by every user has its own datafiles????? Do you mean that they have their own TABLESPACE?!?! If not, how can you tell which user is using which datafile?!?!?

But apart from that, I think you are asking if it is possible to restore some of the datafiles while leaving the other alone. The answer is almost NO if you are using NOARCHIVELOG mode. Unless you are so lucky that all the redo log files are still online since your last cold backup.

If you really want to do tablespace online recovery, do change your database to archivelog mode!

Winnie Liu

Certified DBA

Johann Tinnacher wrote in message <909586972.869770_at_proxy.styria.com>...
>we're running owg 7.1.6 (HP-UX 10.01, NOARCHIVELOG) with one instance with
 4 database
>users. every user has it's own datafiles.
>
>we're doing a cold backup of all files (datafiles & controlfiles etc.)
 every night. now i
>think of restoring data from one of the users.
>
>is there a way to
>- shutdown oracle
>- replace some of the database files (the datafiles of one user) from tape
>- (do something i dont't know yet)
>- start oracle
>- (do something i dont't know yet)
>- start the instance, working with the old datafiles of one user and the
 current datafiles
>of the other users.
>
>(without creating different instances or using exp for backup)
>
>TIA
>
>Johann
>
>----------------------------------------------------
>Johann Tinnacher j.tinnacher_at_posch.com
>Posch Ges.m.b.H. www.posch.com
>Paul Anton Kellerstr. 40 Tel. ++43/3452/82954-35
>A-8430 Leibnitz Fax ++43/3452/73389
Received on Wed Oct 28 1998 - 00:00:00 CST