DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Export automatically every day ?

  1. #1
    Join Date
    Jun 2005
    Posts
    5

    Question Export automatically every day ?

    Can it export automatically every day?
    My software environment is Windows 2000 + Oracle 8i.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    yes you can, schedule it via the windows scheduler. Export is not a good backup method by the way

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    I wouldn't rule out export as a backup. It's a perfectly good method of backing up *some* data. Understand it's limitations and using it where applicable.

    I use it to backup my rman catalog and a few small databases with infrequent writes and long recovery windows.

  4. #4
    Join Date
    Jun 2005
    Posts
    5
    Thank your advice anyway!

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    rman=backup
    exp=copy

    If all you want to do is copy some data for archival purposes, export may be appropriate if you understand the implications of using it. As far as a backup methodology, stay away from it. See http://marist89.blogspot.com/2005/05/backup-top-11.html for my backup tips.
    Jeff Hunter

  6. #6
    Join Date
    Jan 2001
    Posts
    3,134
    Backups are for begginers anyhow, just let it fly!
    I remember when this place was cool.

  7. #7
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    Quote Originally Posted by Mr.Hanky
    Backups are for begginers anyhow, just let it fly!
    Yeah, and archivelog mode is for whimps!

  8. #8
    Join Date
    Jan 2001
    Posts
    3,134
    Quote Originally Posted by dbtoo
    Yeah, and archivelog mode is for whimps!
    Exactly, if there is ever a problem tell the developers to use key entry, that'll get their attention.
    I remember when this place was cool.

  9. #9
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Quote Originally Posted by KenEwald
    I use it to backup my rman catalog . . . . .
    Hmmmmm

    Export:
    - no need to shutdown db

    Cold Backup:
    - faster restore (no need to rebuild db & import is slow)
    - can roll forward with archlogs if required

    I think cold backup wins.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  10. #10
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    DaPi,

    Has anyone ever told you that you have a very large brain.

    I can't think of the reason we're doing an export of the rman catalog, but I think it was something like portability or how to restore the catalog if you don't have the catalog in a dr situation, or something .. it seemed like a good idea at the time.

    Get this, I had an exp of a 42gig database that took hours to export and 17 DAYS to import (clobs)... long story, but it had to be export/imported.

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