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

Thread: Export automatically every day ?

Hybrid View

  1. 06-28-2005, 04:17 AM #1
    osgood
    osgood is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 06-28-2005, 04:24 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  3. 06-28-2005, 04:48 AM #3
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    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.
    Reply With Quote Reply With Quote
  4. 06-28-2005, 12:22 PM #4
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    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
    Reply With Quote Reply With Quote
  5. 06-28-2005, 02:47 PM #5
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    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.
    Reply With Quote Reply With Quote
  6. 06-28-2005, 02:59 PM #6
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Quote Originally Posted by KenEwald
    Has anyone ever told you that you have a very large brain.
    I've been told that I have a big head - but that's not the same thing.

    To be perfectly honest, when I saw your post, my first reaction was "That's smart!" It's taken me quite some time to change my mind.
    "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
    Reply With Quote Reply With Quote
  7. 06-29-2005, 12:59 AM #7
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Quote Originally Posted by KenEwald
    DaPi,

    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.
    I wonder what you used to do during those 17 Days
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  8. 06-28-2005, 05:30 AM #8
    osgood
    osgood is offline Junior Member
    Join Date
    Jun 2005
    Posts
    5
    Thank your advice anyway!
    Reply With Quote Reply With Quote
  9. 06-28-2005, 08:21 AM #9
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    Reply With Quote Reply With Quote
  10. 06-28-2005, 10:17 AM #10
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    Backups are for begginers anyhow, just let it fly!
    I remember when this place was cool.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width