Re: Solaris 10 oracle backup

In article <1140651737.192022.166340_at_z14g2000cwz.googlegroups.com>,  "eeb4u_athotmail_com" <eeb4u_at_hotmail.com> wrote:

> Michael Vilain wrote:
> > In article <QZGdnSnMj44uMGHenZ2dnUVZ_sydnZ2d_at_comcast.com>,
> > "Mike Dundas" <mdundas_at_Nospamthanks.comcast.net> wrote:
> >
> > > We have just recently installed two servers running Solaris 10 and an
> > > Oracle
> > > database (don't know much about version, will need to check further).
> > > Currently, I use Veritas Netbackup 4.5 datacenter for all of our server
> > > backups to a Quantum ATL. Solaris 10 isn't supported with Netbackup ver
> > > 4.5, and although I have the new Veritas software, I haven't worked out a
> > > plan for the upgrade yet. My primary concern is to get backups of the
> > > two
> > > servers. I have attached a DLT drive to one server and I am using
> > > ufsdump
> > > to get the OS, but wondered what the correct procedure was for the db
> > > dump.
> > > Is it possible? Do I need to put Db in queiscent mode etc? What can I do
> > > for
> > > now until I upgrade Netbackup.
> > >
> > > thanks,
> > >
> > > Mike Dundas
> > > System Administrator
> > > The Asbury Park Press
> >
> > I know there's RMAN, the Oracle backup tool or you can "roll your own"
> > by either shutting down the database cold, doing backups, and restarting
> > or doing an incremental backup of the database tablespaces in "backup
> > mode" along with the archive redo logs then restoring the tablespaces.
> >
> > Unless you've done Oracle backups before, you'd best involve the Oracle
> > DBAs to help you.
> >
> > --
> > DeeDee, don't press that button! DeeDee! NO! Dee...
>
> Unfortunately, there is no Oracle DBA. I may need to contact the
> vendor that supplied the servers for additional info. I am the DBA/Sys
> Admin/Sys Analyst/programmer/help desk!!
>
> I call upon google for many answers.
>
> Once Veritas is ugraded I will be using a oracle client, I assume there
> is one, I use one for our sybase and informix backups.
>
> Thanks for your help,
>
> Mike Dundas

There may be. RMAN is the only thing I've heard of but have no direct exposure to it. If you're unfamiliar with this area, HIRE A CONSULTANT to set it up. If backups aren't done right, you'll be screwed royally. Be sure you can restore a system once you've done backups. Also be sure you can restore onto 'bare metal' if you lost the system disk.

Sounds like you need to get up to speed on this ASAP but unfortunately database backups are _not_ something you can just pick up. Unless you understand the implications of how a DBMS works (Oracle especially) your backups will be total CACA and worthless.

You can start by doing cold backups by shutting down Oracle, doing the backups, then restarting. If you can't script that, again HIRE A CONSULTANT.

-- 
DeeDee, don't press that button!  DeeDee!  NO!  Dee...