-
Hi Amar
i see ur laughin..did you by any chance recollect yesterdays discussion ;-)
regards
Hrishy
-
-
Hi Amar
Nope ..i had no clue on how to this..but thank you very much..i wanna go home now...and give it a try ;-)
reagrds
Hrishy
-
When you create control file, you have to use:
create controlfile set database resetlogs
......
If you have noresetlogs, then your recover will alway ask for more archive logfiles.
-
The dbas give you this hot backup should have give you the archive logfile after hot backup. If they did not switch log file after hot backup, then you need to run select * from v$log;(select * from v$logfile ). So you can know online redo log's sequence and logfilename, then just change the redo log file name to archive log file name with the sequence number you get from v$log.
Then keep recover ddatabase until current redolog file.(Do not use current redolog file.)
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
|