Re: Backup tool
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:
- shutdown immediate DB, listener
- backup all datafiles, control files, redo logs etc. to tape
- startup DB, listener
In all Unix based OS is really easy to write this script.
-- _________________________________________ Dusan Bolek, Ing. Oracle team leaderReceived on Tue Jul 31 2001 - 15:03:10 CEST