Re: Archives files

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Fri, 21 May 1999 00:57:15 -0700
Message-ID: <374511DB.FDE80E9A@us.oracle.com>

Eric

For safety's sake (i.e. in case the backup of the archives to tape has failed), I would normally say keep the archive for two or even three database backups if you have the space.

For online backup, I normally like to use both alter database backup controlfile to 'filespec' and alter database backup controlfile to trace. Call me paranoid if you like, but I ahd to try and manually recreate the controlfile eons ago (7.1) when it included both the name and size of all the datafiles and the logfiles, and the experience scarred me for life!

HTH. Pete

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 Fri May 21 1999 - 02:57:15 CDT