|
-
use
create controlfile set database "database name" resetlogs archivelog........
and then specify online redo log and controlfiles.
This will create a controlfile and new on line redo log files.
Then do
recover database using backup controlfile until cancel;
and then specify required archived redo log files until database become point in time and then type cancel.
it will say database recovery complete.
then type
alter database open resetlogs;
this will open the database upto the last archived redo log file.
If you have any question then let me know. i have done this so many time.
UKDBA
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
|