asked on Best way to completely backup a oracle 10g database
Hello,
i've just just taken over management of an oracle 10g database and i've noticed there are no backups in place in the event of hardware or operating system failure.
I'm looking for the best way to schedule automatic backups of an oracle 10g database to a remote location.
I'm looking for a complete backup as the database has tables, views, packages, functions and triggers all of which i need backed up.
Preferably i'd need my backup destination to be either a remote server on vlan, a remote ftp server or possibly an AWS S3 bucket.
What would other oracle database administrators suggest?
i've just just taken over management of an oracle 10g database and i've noticed there are no backups in place in the event of hardware or operating system failure.
I'm looking for the best way to schedule automatic backups of an oracle 10g database to a remote location.
I'm looking for a complete backup as the database has tables, views, packages, functions and triggers all of which i need backed up.
Preferably i'd need my backup destination to be either a remote server on vlan, a remote ftp server or possibly an AWS S3 bucket.
What would other oracle database administrators suggest?
DatabasesOracle Database
Last Comment
Martyn Spencer
See https://docs.oracle.com/cd/E14148_02/wlcp/ocsg41_otn/restore/rdbms_backup.html
Identifying what you gave in terms resources, etc. OS, ....
Identifying what you gave in terms resources, etc. OS, ....
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
We are using a windows base server
Double check installed apps to confirm you do not have backup agent backup exec, tivoli, networker, etc that backs up the db.
Which OS version, how much space resources do you have available.
Which OS version, how much space resources do you have available.
If you have no solution in place, a low-cost product that I found (Handy Backup) can be found here. I don't use it (most of my backups are scripted), but maybe it will help you?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I think that jtrifts' answer is probably the most thorough and the assisted answers provide some useful detail too.
You are not specifying the OS.