Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need advice on backup management
Ryan,
Your backup strategy should be based on your user's needs.
If they need 7 * 24 uptime, you will need to use hot backups. You take hot backups with the RDBMS and application up and running in ARCHIVELOG mode.
- Will they need 7 * 24 uptime or will you have a window for cold backups?
- What is your recovery window when something breaks? The longer the interval between backups, the longer it takes to recover.
- Can they afford to lose all their work since the last backup? If not you must use ARCHIVELOG mode.
- etc.
If their uptime needs are less severe, you can shut down and take cold backups. You still need ARCHIVELOG mode to protect against loss of work.
In either case, you must guarantee that all files of all tablespaces
are included in your backup schedule. As tables grow and tablespaces fill
up, you will need to add datafiles. To me, this means a script that automatically
adjusts to changes in your database structure. Now, you can write and maintaine
this script or you can use a product that provides this capability. I have
done both. I prefer the product. I used scripts on Oracle 6, OEBU on Oracle
7 and RMAN is replacing OEBU as we migrate to Oracle 8.
Ryan wrote:
I am the sole (beginning) DBA and developer for Oracle 8.0.4 on SolarisReceived on Mon Jan 18 1999 - 21:35:59 CST
2.6 where I work. It is a new database and we have not setup any
procedures for backing up the database. I have the DBA Handbook by
oracle press but would like to get some 'real world' advice from those
of you who actually do the backups/admin of Oracle databases. Any advice
on doing backups would be appreciated. Specifically: Whether or not to
use Racovery/Backup manager. OS specifics like tar files etc..I tried to stay OFA compliant when installing Oracle by splitting the
control and redo files acroos three mount points (as the installer
requested). I also manually move several datafiles across different
drives to improve performace (serperating index and data tablesapce
datafiles etc...) and updated the locations with 'alter database'. I
just wanted you to have a feel with how are db is spread out.Thank you for any advice,
Ryan
--- Remove [NO SPAM] from email address to reply -