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

Thread: DB user back up

  1. #1
    Join Date
    Jun 2003
    Posts
    108

    DB user back up

    Hi DBA's

    I am taking my user's back up after closing their transactions everyday evening.Is there any script to take the back up automatically everyday evening.

    If it is there, pls help me.

    OS - NT4
    DB - Oracle 8i

    Thanx in advance.

  2. #2
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    Are u taking backup using export utility ?
    Write your export command in batch file
    which can be run automatically using nt scheduler
    You can set the timing /frequency in the nt scheduler .

  3. #3
    Join Date
    Jun 2003
    Posts
    108
    Yes i am using the export utility.
    Can u give me the steps.

  4. #4
    Join Date
    May 2001
    Posts
    736
    Go to control pannel-->schedule tasks-->Add new task-->in the shecule task wizard go to oracle directory and select the exp.exe and time when u want to schedule it.Once it creats a new task,in the properties modify the command line as per your need.

  5. #5
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    I think akhadar have given detail steps to schedule the job.
    Hope it will help u.

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