Results 1 to 8 of 8

Thread: Backup Schedule

  1. #1
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Talking Unanswered: Backup Schedule

    Hello Gang, I have a database running around 14 gigs. What type of schedule would be best suited for the size. Because administration is on the east coast. Servers reside In the midwest and Users are On both the East & West Coast what CA. Any Suggestions would appreciated.

  2. #2
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198

    Re: Backup Schedule

    Originally posted by garrydawkins
    Hello Gang, I have a database running around 14 gigs. What type of schedule would be best suited for the size. Because administration is on the east coast. Servers reside In the midwest and Users are On both the East & West Coast what CA. Any Suggestions would appreciated.
    Some add'l info would be good.
    Are you a 24x7 shop?
    Do your outlets/stores/centers close at a certain time?
    How long does your typical dump take?
    Are there automated tasks running against your DB?
    Can you shut your DB down at a certain time?
    Are you using Disk to Tape, Disk to Disk?
    How fast are your tape drives and B/u software?
    Can you run replication of the DB?
    How big is your b/u window?

    And these are the basic questions. Smile, it only gets worse.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

  3. #3
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Wink Backup Schedule

    Are you a 24x7 shop?
    No
    Do your outlets/stores/centers close at a certain time?
    Yes, Base on Time Zones when users have access
    How long does your typical dump take?
    Manually, about 7 hrs.
    Are there automated tasks running against your DB?
    Not at this point
    Can you shut your DB down at a certain time?
    Only on off hours.
    Are you using Disk to Tape, Disk to Disk?
    Disk to Disk
    How fast are your tape drives and B/u software?
    I'm Using the Veritas network backup software now.
    Can you run replication of the DB?
    That's what I've been looking into
    How big is your b/u window?
    ?????

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Can you run ONLINE backups during 'NONPEAK' hours
    and maybe OFFLINE backup on the Weekends ???

    Replication maybe a possiblity as well as Failover depending on your
    needs.

    Gregg

  5. #5
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198

    Re: Backup Schedule

    Originally posted by garrydawkins
    Are you a 24x7 shop?
    No
    Do your outlets/stores/centers close at a certain time?
    Yes, Base on Time Zones when users have access
    How long does your typical dump take?
    Manually, about 7 hrs.
    Are there automated tasks running against your DB?
    Not at this point
    Can you shut your DB down at a certain time?
    Only on off hours.
    Are you using Disk to Tape, Disk to Disk?
    Disk to Disk
    How fast are your tape drives and B/u software?
    I'm Using the Veritas network backup software now.
    Can you run replication of the DB?
    That's what I've been looking into
    How big is your b/u window?
    ?????
    Here are some thoughts on how to do this -
    Assume your last user is out by 8P PDT which is Midnight EST and you start having users show up at 7A EST. That means your b/u window is 7 hours

    Maybe determine how much data/tables are static and which are actual changing data. Then just export the tables that are important on a nightly basis. And then a full dump/shutdown on the weekends.

    My database, with archives files, redo logs and room to grow is 12.5G and is dumping nightly to dump files for a total of just under 3G in a about 45 minutes. Note that I had to tune the database fairly well to get that speed. And I do shut down the test db to give the server less overhead. But it works. I also for safety sake, can shutdown the database and let the backup copy the dump file and the database files. But I really depend on the dump files and a pretty well built/automated script and batch files to rebuild the production database with virtually no human intervention.

    I'm not familiar with Veritas beyond the name, but it could be hanging on the open files as it goes by.

    And here is another thought, is using batches and scripts, could you alter tablespaces/datafiles offline and copy them individually and maybe just shut down the database to get the system/sys areas as the last thing?

    When was the last time you ran an anlyxe on the database? And are you analyzing the "SYS" schema? There is an error in 8i, at least, that if you analyze the sys schema your dumps go from an hour to many hours.
    Reference Metalink/oracle for Note:35272.1 , BUG:954191, BUG:969814, BUG:954191, BUG:365425, BUG:141539

    EXECUTE DBMS_UTILITY.ANALYZE_schema ('SYS','DELETE');
    EXECUTE DBMS_UTILITY.ANALYZE_schema ('SYSTEM','COMPUTE');
    EXECUTE DBMS_UTILITY.ANALYZE_schema ('<SCHEMA>,'COMPUTE');


    Just giving you some food for thought.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

  6. #6
    Join Date
    Mar 2010
    Posts
    1

    Scheduling Export Dump Backup - Oracle 10g

    Jimpen,

    Can you help me out in scheduling my export dump backup-Oracle 10g is the database ,Operating System -Windows Server 2003.

    The Syntax i'm using is exp username/password file=.dmp log=.log consistent=y

  7. #7
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    garrydawkins,

    Stern warning:

    NEVER, NEVER, NEVER use exp or expdp for backups !
    You might wake up one day with an import that will not work (exp was never meant to be a backup tool, so it doesn't care about foreign key constraints)

    Always use RMAN for backups !

    Apart from the fact, that it's the right tool, its much easier to handle than exp/expdp and you can use it while the DB is running an processing transactions (o.k., I would not recommend to use it during peak hours, but the impact on the system resources is usually less than 5% if you are not running in compressed mode)

    And:

    7 hours for 14 GBytes of data seems an awful lot of time for such a small DB (It takes one of the servers I manage about 23 hours to back up a 42 TByte database. And that one is backed up in compressed mode which usually takes 3-5 times the time of a regular backup)

    The backup of a 14 GB database using RMAN should not take much longer than 20 minutes (that's on veeeery slow disks)

    Are you doing this over a slow Network ?
    If possible backups should always be done locally on the server machine. THEN copy the backup sets to tape/remote server/wherever
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  8. #8
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198
    I pretty much got out of Oracle a short time after I made this post.

    I'm not in a good position at this time to offer a good answer to more recent versions of Oracle.

    The other posters may have a good suggestions. In 8i it was a good way.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

Posting Permissions

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