| 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
Are you suggesting to store both cold backup (weekly) and the archived log (for that prior 7 days)files on DVD?
"Goulet, Dick" <DGoulet_at_vicr.com> wrote:That depends on what your going to do. It is possible that you may want
to load a previous cold backup & do a point in time recovery that is
before the next cold backup. In which case those old archive logs are
no longer useless. Of course if you've got a DVD drive that can hold
the cold backup, why do them cold? Use Rman & backup the database hot.=20
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Guang Mei [mailto:gmei_at_incyte.com]=20
Sent: Friday, November 19, 2004 3:10 PM
To: stant_98_at_yahoo.com; oracle-l_at_freelists.org
Subject: 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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 19 2004 - 15:11:49 CST
 |
 |