| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Archived logs maintanance
After a good cold backup, your old archived logs are useless. It would be
better to store the files from cold back up, rather than old archived logs
on DVD. Becuase if the system dies, you still have a good cold back up,
rather than the useless old archived logs.
Guang
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Alex
Sent: Friday, November 19, 2004 2:50 PM
To: oracle-l_at_freelists.org
Subject: Archived logs maintanance
Hi All,
Previous DBA did not set up any archived logs maintanance here si I am in the process of developing a process that will store old archived logs on DVD. We're on 9.2.0.5 on Win2K. Here is what I am thinking: after each cold backup, do alter system archive log current to archive the latest redo, zip all old logs and copy them to DVD, then delete them from disk. Can someone share a script or info on this?
Thanks
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 19 2004 - 14:20:43 CST
 |
 |