Re: Archives files

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Tue, 25 May 1999 09:28:44 -0700
Message-ID: <374ACFBC.D9628280@us.oracle.com>

Tom

It would be interesting to get some numbers on this. I agree it should be done, but in my time in the field as a consultant, I never dealt with a single client that actually did. We should use you as an example of what SHOULD be done!

Pete

Thomas Kyte wrote:

> A copy of this was sent to Pete Sharman <psharman_at_us.oracle.com>
> (if that email address didn't require changing)
> On Mon, 24 May 1999 09:51:34 -0700, you wrote:
>
> >Quite right, but here's the kicker. Every time I've seen comments like this,
> >including in manuals, training courses etc., I have to laugh, because how do you
> >really, really verify the backup has worked? Only by restoring the backup and
> >making sure the database starts. How many of us do this to test the backup has
> >worked? I'd venture to say none!
> >
>
> i'd venture to disagree with you
>
> - i *always* test the integrity of my exports
>
> - i periodically test the integrity of my backups. you don't have to restore
> the entire database to test this -- just system and one or two random
> tablespaces, recover them and make sure it works. Occasionally you have to do
> this due to programmer error (need to recover a tablespace to get back that
> dropped table but you don't want to PIT recovery the entire tablespace -- just
> that table).
>
> Lots of people do.
>
> >Pete
> >
> >Zeth Johansson wrote:
> >
> >> Hi!
> >>
> >> You can delete all archive log files older than your latest verified full
> >> backup of the datafiles. You should backup controlfiles with "ALTER DATABASE
> >> BACKUP CONTROLFILE".
> >>
> >> Regards
> >>
> >> Zeth
> >>
> >> Eric DANTIE wrote:
> >>
> >> > I've got a database which can't be stopped. So I do online backups (with
> >> > a tar command and alter tablespace xxx begin backup).
> >> >
> >> > When may I delete the archivelog files safely? It now occupies more than
> >> > 7Go space!!!
> >> >
> >> > And one more question: Can I back up controls files online? Or it's not
> >> > necessary: it can be regenerated...
> >> >
> >> > thanks
> >> >
> >> > Eric
>
> See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Service Industries
> Reston, VA USA
>
> --
> Opinions are mine and do not necessarily reflect those of Oracle Corporation

--

Regards

Pete

---

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

---

Received on Tue May 25 1999 - 11:28:44 CDT