Re: Solaris 10 oracle backup

DO NOT depend on exports for backup. It may help to have them for redundancy and certain types of data restoration.

DO find out what your recovery _requirements_ are. You can't have a good backup procedure without knowing what you need to do with the backups.

This guy has some interesting insights:
http://dizwell.com/main/content/view/32/49/

Be sure your vendor doing the backup is either doing an RMAN backup, a hot backup, or a cold backup. Find out which. Some vendors have ignorant people. If you have disk space, it is reasonable to use RMAN to backup to disk, then copy those files to tape. If you have some sort of snapshot ability, it is reasonable to put all files into hot backup mode and snap them. RMAN has less of an impact than hot backups on an in-use database, unless you have a fast snapshot.

The backup and recovery manuals are available at http://tahiti.oracle.com. Read and understand them if you have DBA in your title, official or not.

The Oracle version _is_important. See
http://www.dbaoracle.net/readme-cdos.htm

jg

--
@home.com is bogus.
http://www.newscientist.com/channel/info-tech/mg18925405.700.html