complete recovery through rmnan oracle 9i

I backed up my oracle 9i database at 7:00 A.M in the morning through rman

RMAN> backup database plus archivelog

At 5:30 P.M on the same day I lost one of my datafile (transaction) .

My system is already running in archive log mode and i have all the archived

redo logs intact till the last rman backup (7:00 A.M of the same day ).


Now i want to recover my database till 5:30 P.M. Is it possible,if so then plz
tell me how i will apply the archived redo logs and on line redo logs.

Thanks in advance

Jatoi

restore the backup and recover up to 5.30

whats the problem?

Jatoi -

You don't need to recover the "database" if you miss the data file. Restore and Recover only the missing "data file".

* Find the data file_id
* Put the corresponding tablespace offline
> restore datafile ;
> recover datafile ;
* Put the corresponding tablespace online

Thanks,

apologize for the typo in my previous post. Restore & Recover commands should be like below ...

> restore datafile file_id ;
> recover datafile file_id ;

Thanks,

Quote:

---

Originally Posted by vnktummala

apologize for the typo in my previous post. Restore & Recover commands should be like below ...

> restore datafile file_id ;
> recover datafile file_id ;

Thanks,

---

depends how the file was deleted, if just an OS delete - will be fine

it deleted from the database, it won't work

Thanks Dave.

Thanks,

Quote:

---

Originally Posted by davey23uk

depends how the file was deleted, if just an OS delete - will be fine

it deleted from the database, it won't work

---

or unless your db is past 05:30