Results 1 to 10 of 10
  1. #1
    Join Date
    Feb 2003
    Location
    In your thoughts
    Posts
    195

    Unanswered: Configure Automatic Backup W/O OEM

    Can someone help me figure out a way to backup my db every night at 12:00 AM in the morning? I don't have OEM so I can't do it via GUI. Thanks, Jeremy

    Oracle 8.1.7
    Windows 2000 Server
    Nothing better than a good ride.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    I use the AT command at most of my client's sites for online backup
    during the week and offline on the weekend. I place the AT commands
    in the AUTOEXEC.BAT file...

    Attached is an example of the offline. It calls a SQL script that shutsdown the database in IMMEDIATE mode, brings the database back up and shuts it down again in NORMAL mode prior to running the backup. This .BAT file will also stop the instance, rename archive files and remove OLD archives off the machine. Tape backup programs will copy the BACKED up database files and archives only ... not the live ORACLE data files.




    at /delete /yes
    at 21:45 /every:m,t,w,th,f e:\oracle8i\...\online_backup_bjc2.bat
    at 1:45 /every:s e:\...\backups\offline_backup_bjc1.bat



    at / delete - removes all entries then reapplies for the times listed ... Note: Military time...

    Hope this helps

    Gregg
    Attached Files Attached Files

  3. #3
    Join Date
    Feb 2003
    Location
    In your thoughts
    Posts
    195
    I just checked out your bat file and it makes good sense. Just need to make changes to suit my needs. Not too hard. Thanks alot, Jeremy
    Nothing better than a good ride.

  4. #4
    Join Date
    Feb 2003
    Location
    In your thoughts
    Posts
    195
    I don't understand what you were talking about here though:

    Code:
    at /delete /yes
    at 21:45 /every:m,t,w,th,f e:\oracle8i\...\online_backup_bjc2.bat
    at 1:45 /every:s e:\...\backups\offline_backup_bjc1.bat
    
    
    
    at / delete - removes all entries then reapplies for the times listed ... Note: Military time...
    That's no where in the script. Also...how would I set this to run automagically? Thanks, Jeremy
    Nothing better than a good ride.

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Drop the AT commands in a separate .BAT file and execute it ...

    go to dos prompt ... type AT and return... you will see your
    scheduled times and events ... It's windows AT scheduler but done
    from the OS level ...

    I usually put these in the AUTOEXEC.BAT file and just double click the
    file to execute it ... If you need to change the times, edit the file,
    make the changes and execute it again ...
    drop to CMD or dos, type AT and see your changes....

    Gregg

  6. #6
    Join Date
    Feb 2003
    Location
    In your thoughts
    Posts
    195
    Beautiful. Do the locations of these files matter? I can create the At.bat and create the schedule...create autoexec.bat (modified for my needs)...then sit back and relax? You are a very smart guy and sometimes, I don't fully get what you are saying. BTW...thanks for helping me out regarding undoing an update in my DB. I never got it fixed and that's why I'm here. Thanks, Jeremy
    Nothing better than a good ride.

  7. #7
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Glad to be of help... It doesn't matter where these files are ... as
    long as you reference them in the AT command line. I'm sure I
    don't get my point across at times ... Being a consultant and having
    to go to different sites, sometimes I only have a few minutes to attempt
    to answer a question ... Good luck and let me know if I can help out.

    Gregg

  8. #8
    Join Date
    Feb 2003
    Location
    In your thoughts
    Posts
    195
    It's not that. It's just your Oracle knowledge is alot more in depth than mine. Something simple to you is usually new to me. I'll be Oracle Certified one day, just hasn't happened yet. Later, Jeremy
    Nothing better than a good ride.

  9. #9
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Again, I know that I don't explain things very well on occassions ...
    It's hard sometimes when you don't know the audience and their
    level of understanding ... Sorry... Again, let me know if I can help
    out ...

    Gregg

  10. #10
    Join Date
    Feb 2003
    Location
    In your thoughts
    Posts
    195
    Will do. Your explaination was great, no complaints on my end. Jeremy
    Nothing better than a good ride.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •