Log files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Log files

  1. #1
    Join Date
    Jul 2001
    Posts
    93
    Hi,

    Question with Hotbackup.

    What is the procedure for backing up logfiles during the hotbackup? Does they really need to be backed up?

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Yes, they need to be backed up. I would backup your oldest until the logswitch before your backup starts.
    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
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Are we talking on-line or archived redo here?

  4. #4
    Join Date
    Feb 2001
    Posts
    290
    I think Archive Redo Logs !

    I also heard , backing up the online redo logs can leads to corruption, correct me if i am wrong ,JEFF >>>
    Madhu Reddy
    xdollor@yahoo.com

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by mrvajrala
    I also heard , backing up the online redo logs can leads to corruption, correct me if i am wrong
    Lead to corruption? I don't see that.

    However, backing up online redo logs during a hot backup is pointless. Some even argue that backing up online redo logs during a cold backup is pointless (although I believe the contrary).
    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."

  6. #6
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by marist89
    Originally posted by mrvajrala
    I also heard , backing up the online redo logs can leads to corruption, correct me if i am wrong
    Lead to corruption? I don't see that.

    However, backing up online redo logs during a hot backup is pointless. Some even argue that backing up online redo logs during a cold backup is pointless (although I believe the contrary).
    and whats the basis of their belief ?
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    The theory is that since the database was shutdown normal/immediate anyway no media recovery will be needed when the database comes back up. The redo logs can then be re-created if the database needs to be restored.

    However, I am of the opinion that with a cold backup I should be able to get the database back exactly as it was when I shut it down.

    See http://www.dbasupport.com/forums/sho...threadid=23565 for this discussion.
    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."

  8. #8
    Join Date
    Jul 2001
    Posts
    93
    Hi,

    I was referring to online logfiles, not the archive logfiles.

    Sorry if that cuased any confusion

    Thanks

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by marist89
    Yes, they need to be backed up. I would backup your oldest until the logswitch before your backup starts.
    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."

  10. #10
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Cool

    default,

    Here is what I am recommending you to do:

    1. Perform a forced checkpoint and a log switch just before backing up the archive redo log files and backup the database files before the archive log files.

    2. Backup the control file before the forced log switch/checkpoint, if you lose your online redo logs you will always have to do an incomplete recovery but the intention is that you will not lose much.

    3. Have your logs and archived logs on different physical disks/arrays or you risk losing both the logs and the archives in a single disk/controller/cache failure. Be wary of shared caches on disk arrays and whether they are write back or write through.


    A backup of the online redo logs is worthless, they do not contain the current data only the data at the time of backup. You do NOT need them to perform a recovery if you have performed a full backup.

    Hope that helps,



    --clio_usa
    OCP 8, 8i, 9i - Senior Oracle DBA
    ------------------------------------

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