Can it export automatically every day?
My software environment is Windows 2000 + Oracle 8i.
Printable View
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.
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.
Backups are for begginers anyhow, just let it fly!
Yeah, and archivelog mode is for whimps!Quote:
Originally Posted by Mr.Hanky
Exactly, if there is ever a problem tell the developers to use key entry, that'll get their attention.Quote:
Originally Posted by dbtoo
HmmmmmQuote:
Originally Posted by KenEwald
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.
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.
I've been told that I have a big head - but that's not the same thing.Quote:
Originally Posted by KenEwald
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.
I wonder what you used to do during those 17 Days :DQuote:
Originally Posted by KenEwald
It was a table that couldn't be reorg'd online because of a large index key, so we rebuilt it on another db (exp/imp) and captured the delta transactions.