alter system switch log file

Hi Amar

i see ur laughin..did you by any chance recollect yesterdays discussion ;-)


regards
Hrishy

Quote:

---

Originally posted by hrishy
Hi Amar

i see ur laughin..did you by any chance recollect yesterdays discussion ;-)


regards
Hrishy

---

:) no i was thinking, that you ur self must be knowing how to reproduce the situation but, u r still asking ? thats why...

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.)