can i do database recovery until TIME of the time-stamp of last archive log ?

[ngwh]

hi guys,

If I am going to use recreate controlfile and then perform database recovery until time where time is the time-stamped of my latest available archive log ?? would it work? pardon me for asking this qn as i have limited server to run and test it so i just have to seek some answer here

thanks

[marist89]

Instead of time, I would recover until logseq (whatever your last archived log is +1)

[SANJAY_G]

or recover until cancel.

[ngwh]

hi guys,

thks for ur replies..i have few queries to ur suggestion..

1)how can i recover until logseq? is there such parameter allowed?
do u mind if u can quote a few eg. here?

2)if we recover until cancel does it know what archive log sequence to start using??

thanks

[SANJAY_G]

http://tahiti.oracle.com

[ngwh]

Hi SanJay,

As I am really not too clear on the part of recreating controlfile with datafiles which are actually hot backups whether after recreating the controlfile and when i perform recovery database does it know which archivedlog to start using??

here i am saying recreating controlfile because i am assumming i lost all controlfile binary backups..solely depend on datafiles hotbackup and archived logfiles...but I am not too sure if a Recover database will know when to start looking for an archived log as I dont have a spare machine to test and was hoping some kind soul that know will provide me an answer here?

thks

[SANJAY_G]

Originally posted by ngwh
but I am not too sure if a Recover database will know when to start looking for an archived log as I dont have a spare machine to test and was hoping some kind soul that know will provide me an answer here?

thks

"If all control files of a database have been lost or damaged by a permanent media failure, but all online redo logfiles remain intact, then you can recover the database by creating a new control file."

http://download-west.oracle.com/docs...scen.htm#11848

[ngwh]

Hi Sanjay,

Perhaps I put it in another scenairo..how easily can i "CLONE" the same database with just hotbackup datafiles and archived logfiles only by recreating controlfile...without online redo log..will i be able to do just that?

thks