Re: Backup tool

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 31 Jul 2001 06:03:10 -0700
Message-ID: <1e8276d6.0107310503.6bfb1867_at_posting.google.com>


"Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> wrote in message news:<9jjppg$mba$1_at_news247.cnt.ru>...
> Hello!
>
> You needn't OEM for backup also as any other tools.
> You can write script fro export and put at "crontab"(on Unix) or
> "sheduler"(on NT).
>
> Best regards!
> Yaroslav.
>
> Jing Liang <jingjing_at_bellsouth.net> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ
> ÓÌÅÄÕÀÝÅÅ:ttd77.5384$UB6.512471_at_e3500-atl1.usenetserver.com...
> > Hi,
> >
> > In our oracle server, we use nonarchivelog, normally I use export to
 backup
> > the users through OEM scheduler, but OEM often crash. I am looking for
> > another backup tools. I know arcserver is a backup tool for oracle, is any
> > good backup tool that you can recommand? Thanks in advance.

Yes, Yaroslav is true, exports can be handled from crontab. However, I do not think that only export is a good way to handle database backup. Maybe some offline backup is not a bad idea. Very simple script can do folowing:

  1. shutdown immediate DB, listener
  2. backup all datafiles, control files, redo logs etc. to tape
  3. startup DB, listener

In all Unix based OS is really easy to write this script.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader
Received on Tue Jul 31 2001 - 15:03:10 CEST

Original text of this message