Re: Archives files

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 24 May 1999 09:51:34 -0700
Message-ID: <37498396.EE36DD62@us.oracle.com>

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!

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

--

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 Mon May 24 1999 - 11:51:34 CDT