how should archive log need to backedup?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: how should archive log need to backedup?

Hybrid View

  1. #1
    Join Date
    Apr 2006
    Posts
    35

    how should archive log need to backedup?

    could some one help me in explaining the backup part for archive logs

    i have to set up incremental backup setup here for 30g database for oracle 8
    level 0 on saturday
    level 2 on monday,tuesday,thursday,friday
    level 1 on wednesday
    Now i have great doubt
    in backing up archive logs
    could some one guide me
    thanx for ur help


    thanks and regards

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    yes they need backing up - what else do you want to know?

  3. #3
    Join Date
    Apr 2006
    Posts
    35
    Thanks for ur reply

    run
    {
    backup
    filesperset 20
    format 'c:\al_%s_%p_%t'
    (archivelog all
    delete input);
    }

    would execution of the above code with every level of backup
    would to correct
    thanks for ur support

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    That looks fine, but you should test your recoveries now before you need them.

    http://marist89.blogspot.com/2005/05/backup-top-11.html
    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."

  5. #5
    Join Date
    Apr 2006
    Posts
    35
    thank u sir,
    That makes me confident about my backup plan
    thanks for the url
    i have got more valid points to tell my IT manager
    thank u again

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