-
Export automatically every day ?
Can it export automatically every day?
My software environment is Windows 2000 + Oracle 8i.
-
yes you can, schedule it via the windows scheduler. Export is not a good backup method by the way
-
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.
-
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
-
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.
-
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
-
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."
-
Thank your advice anyway!
-
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
-
Backups are for begginers anyhow, just let it fly!
I remember when this place was cool.
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
|