backup Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: backup

  1. #1
    Join Date
    Jan 2002


    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
    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
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Aug 2001
    what view can I query to get the LSN? thanks.

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


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