Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Remove archive log files in a production system
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.10Received on Thu Oct 20 2005 - 03:32:22 CDT
![]() |
![]() |