-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
apologize for the typo in my previous post. Restore & Recover commands should be like below ...
> restore datafile file_id ;
> recover datafile file_id ;
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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
-
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|