can i do database recovery until TIME of the time-stamp of last archive log ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

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

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456

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

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Instead of time, I would recover until logseq (whatever your last archived log is +1)
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    or recover until cancel.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  4. #4
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    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

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    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

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  8. #8
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width