Restore Ora Database

From: sean <sean_at_kistem.po.my>
Date: Wed, 7 Nov 2001 11:40:58 +0800
Message-ID: <9saasv$b4m$1@news6.jaring.my>

HI All,

I have following datafiles

D:\PROD\DB\SYSCUSA.ORA
D:\PROD\DB\CUSA01.DBF
D:\PROD\DB\CUSA02.DBF
D:\PROD\DB\CUSA03.DBF
D:\PROD\DB\CUSATMP.DBF
D:\PROD\DB\CUSAIND.DBF

And I have the 2 controlfiles and the 2 logfiles in the same location. The CUSA03.DBF was just added this month, and it is working fine. Now, the user want to restore old data (JUNE 2001) which does not have this new CUSA03.DBF. In the past I have been using Windows NT backup. I know how to restore at a different location example, E:\PROD\DB\... and I used to patch the INITCUSA.ORA to tell my oracle (ver 7.3.4) instead of pointing to Drive D:, now point to Drive E:. And then I have to use svrmgr23 to manually "alter database rename file" for each of the datafiles and logifles, before "alter database open".

You see cannot rename CUSA03.DBF to nothing. Please help

Regards,
Sean Received on Tue Nov 06 2001 - 21:40:58 CST