backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: backup

  1. #1
    Join Date
    Jan 2002
    Posts
    44

    Post

    hi,
    if i want to have online/hot backup then i start with making the database in archivelog mode.
    now after doing that i find that LSN is at 59.
    i will be able to recover fully if something happens after 59 & not if something is lost that is contained in LSN say 54 'coz that has been overwritten.

    i hope i am right.
    please do give me feedback as to if my point is valid.

    thanx a lot
    thanks a lot

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Correct! Since you started archiving your logs at 59, that is the earliest point in which you can recover.

    When switching on archivelog mode, I like to:
    1. put the db in archivelog mode
    2. force a logswitch n+1 (where n=number of redo logs you have) times to make sure I am archiving correctly
    3. take a hot backup immediately.
    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
    Aug 2001
    Posts
    64
    what view can I query to get the LSN? thanks.

  4. #4
    Join Date
    Jan 2001
    Posts
    126
    Check V$LOG

    Baliga

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