Re: Backup & Recovery Procedures

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 3 Oct 2000 16:39:14 +0100
Message-ID: <8rcuj3$nlh$1@soap.pipex.net>

thanks to all for you comments

as far as Bill's question goes. My feeling is that there isn't in fact such a thing as a development site. What I mean is however much management might decide 'Oh we don't need that we can always rebuild it' Should one actually have to rebuild....

thanks again to everyone.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<bill_buchan_at_my-deja.com> wrote in message
news:8rcfih$gmc$1_at_nnrp1.deja.com...


> On a similar thread....

>

> I've recently started working at a development site.  The last place I

> worked I was used to backing up live databases (running in archive log

> mode, backing up everything in sight! to disk and to tape). We had

> plenty of resources to do this and plenty spare hardware.

>

> Now I don't have any live data and any changes to database objects are

> done through SQL scripts held in change control (and backed up

> separately).

>

> So now I occassionally do full exports to tape (to keep a copy of test

> data and allow for a quicker restoration of the database in case of

> failure) and back up parameter files.  I am much more constrained in

> terms of off-line storage and spare hardware (single server, a few

> tapes, disks pretty full!).

>

> But I feel a bit "naked" after the back-up frenzy of live data; is there

> any other factors that I should consider for a purely development site?

>

> Any advice appreciated.

>

> Thanks!

>

> - Bill.

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Tue Oct 03 2000 - 10:39:14 CDT