Archived logs backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Archived logs backup

  1. #1
    Join Date
    Jan 2000
    Posts
    387

    Post

    Hi,

    I would like to know should i switch logfile first before I backup the archive logs at OS level? I saw some articles that say that some archive logs are not properly backup which results in incomplete recovery. Can someone help me to confirm how to backup the archived logs correctly please? Thanks!

  2. #2
    Join Date
    Aug 2001
    Posts
    111
    Yep always switch the logfile after completing a hot backup
    i.e. when tablespaces (and their datafiles) are backed up. Switch the logfile. Then backup the archive log files.

    Hint: You can always past a unarchived redo log as an archive log, in the event a recovery complains the database or more specifically datafile is out of sync. Just don't reset logs before you do this
    I would suggest (if you have the benefit of time) to always run a job to check for table corruptions. In these days of NOLOGGING, nasty things can happen.
    It is one of those things which should be a grantable privilege (Are you listening out there ORACLE?) not a right, as people can get carried away and then complain when their table can't be recovered

    Have Fun
    Performance... Push the envelope!

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