Re: Backing up 8i on NT

Is there a script or other way to do this automatically? Particularly for use on NT.

Thanks,
Gerald

In article <3A1D2561.5B0F686A_at_bridgewatersystems.com>, tony.walby_at_bridgewatersystems.com says...
> I have no idea why you would want to do an incremental backup when the
> system is not 24*7. I f you have the time to do a cold copy backup then
> that would be best. Shutdown the database and listener (So user do not try
> to connect, not necessary but good practice). then shutdown the database
> and perform a cold copy. When the cold copy is complete it is best to trim
> archive logs they can take up rather a large amount of space. if you are in
> a development environment or have to fix user problems with data on a
> regular bases performing an export after the backup would help this
> problem. est practice would be after the backup bring the database up in
> restricted mode and export the database (Or just a specific owner would do
> if the app and data owned by one user.). then alter the database open. The
> reason the export is after the backup is that from time to time exports
> have been known to hang or crash and corrupt. This is more frequent in
> oracle 7 (My experience is 1 out of every 150 exports or so). In Oracle 8
> and 8i the export utility seems more stable.
>
> Hope this helps.
>
> Tony
>
> gorgos_at_my-deja.com wrote:
>
> > Hello again
> >
> > Can anybody recommend a backup strategy for 8i on NT. There are only
> > 90 users with 2Gb of data, and it is not 24*7. Is the best way to shut
> > down the database and use an NT backup?
> >
> > What about archive logs? Should they be deleted every night after the
> > backup ?
> >
> > Any thoughts would be appreciated.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> begin:vcard
> n:Walby;Tony
> tel;fax:613-591-6656
> tel;work:613-591-9104 X2030
> x-mozilla-html:FALSE
> url:www.bridgewatersystems.com
> org:Bridgewater Systems;R&D
> version:2.1
> email;internet:tony.walby_at_bridgewatersystems.com
> title:Oracle Database Administrator
> adr;quoted-printable:;;555 Legget Drive=0D=0ASuite 800 Tower A=0D=0A ;Kanata ;Ontario; k2k 2x3;Canada
> fn:Tony Walby
> end:vcard
>
 

-- 

--
Gerald B. Rosenberg
NewTechLaw