| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How to housekeep archive log files?
Jackling,
You don't need to keep archive logfiles older than your last cold backup, unless you consider restoring the database to point in time prior to last cold backup. You do need archive logfiles around your last hot backup. As far as how far back you need them, you won't know for sure. Therefore you have to keep all from your last cold backup on (again, unless you consider point in time recovery which may require more).
The word "keep" in the above paragraph means keep either on disk or tapes. But if you're not short of disk space, why not keep one copy on disk, one on tape until the copy on disk is too old? Keeping an additional copy on disk shortens database down time and adds a little more protection against media (tape i.e.) failure.
Yong Huang
"PasirRis" <jackling_at_singnet.com.sg> wrote in article
<99advh$mnp$1_at_violet.singnet.com.sg> :
>version: Oracle Std Ed 8.1.7 on Sun Solaris 8.
>
>
>'archive log list' tells me some archive log seq nos. e.g. from 132 and
>current is 149.
>I do a hot backup of datafiles
>then, I issue the command 'alter system log switch'. (so, the current arch.
>log file will be 150 and files up to 149 is the targeted group for backup) I
>backup all the archive log files in the directory.
>
>I suppose after the datafiles, archive log files are backup (say to tape), I
>don't need to keep them in the disk and can remove those 'old' archive log
>files already.
>
>Question:
>
>(Any sample?) How to write a script to remove those archive log files
>already backuped? In the sample above, I suppose I should keep archive files
>from 150 onwards on the disk but anything b4 it can be removed from disk
>SAFELY (?).
>
>Any good idea?
>
>thanks,
>jackling.
>
>
 |
 |