Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Remove archive log files in a production system

Remove archive log files in a production system

From: Urko Benito <ubenito_at_masterd.es>
Date: Thu, 20 Oct 2005 10:32:22 +0200
Message-ID: <d41k23xsit.ln2@izas.masterd.es>


Hello,

We have a production system which generates a lot of archive log files (10 Mb size), we do a backup with a script (setting the table space to "backup mode" and using rsync command to copy), but we have a question.

1.- Can we remove the "old archive log files", for example, we have:

$ ls -l|more
total 94637712
-rw-r----- 1 oracle dba 10486272 ago 22 23:45 arch_1_46000.arc
-rw-r----- 1 oracle dba 10486272 ago 22 23:49 arch_1_46001.arc
-rw-r----- 1 oracle dba 10486272 ago 22 23:55 arch_1_46002.arc
-rw-r----- 1 oracle dba 10486272 ago 22 23:58 arch_1_46003.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:03 arch_1_46004.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:07 arch_1_46005.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:13 arch_1_46006.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:17 arch_1_46007.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:21 arch_1_46008.arc
-rw-r----- 1 oracle dba 10485760 ago 23 00:25 arch_1_46009.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:28 arch_1_46010.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:29 arch_1_46011.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:33 arch_1_46012.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:38 arch_1_46013.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:43 arch_1_46014.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:48 arch_1_46015.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:53 arch_1_46016.arc
-rw-r----- 1 oracle dba 10486272 ago 23 00:56 arch_1_46017.arc
-rw-r----- 1 oracle dba 10486272 ago 23 01:01 arch_1_46018.arc
-rw-r----- 1 oracle dba 10478080 ago 23 01:06 arch_1_46019.arc
-rw-r----- 1 oracle dba 10486272 ago 23 01:09 arch_1_46020.arc

.........
........
.....

This files are from 22 Ago and we don't need it. So the question is simple,

can we do a simple:

$ cp archv_1_46* /mnt/SOME_BACKUP_SERVER

$ rm archv_1_46*

to remove all files since 22 Ago TO 26 Ago?

2.- Which is the better, have too many archives (like we have with 10 Mb size) or one big archvive log file (with 600 Mb to copy into a CD)??

Thanks everybody

--

 »»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»
 Urko Benito Mateo		| Ctra. de Madrid, N-IIa, Km. 314,8
 Master-D			| Tlf: (+34) 976-76.41.00  Ext: 4429
 Tecnologías de la Información	| Fax: (+34) 976-76.41.10
Received on Thu Oct 20 2005 - 03:32:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US