restoring table in new instance from archive logs -Oracle 8i
Posted on 2009-02-11
Let me start by saying I'm not a DBA but a web developer who must maintain an Oracle 8i DB to run a website.
I need to retrieve the data of a single user that was deleted from a particular table in the DB without disrupting data in current/live table of same name. The DB is in archivelog mode, I have no rman backup but the entire hard drive is backed up weekly (ie datafiles, control files, etc). Last week's data is good enough for this restore.
I'm guessing I need to create a new instance into which I can restore the DB in order to retrieve this table but rather not if I don't have to). I have never done a restore before so any help and/or pointers to instructions would be most appreciated.