RE: Oracle Archive Solution
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <litanli@xxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 20 Apr 2012 13:35:52 -0400
We used to have a sophisticated home unix korn shell grown archiving solution,
(in previous yearssss -- that also went to tape -- including several
directories and where not deleted until the where backed up to tape at least
twice.
But now all the home grown solutions have given way to utilizing RMAN to manage
backups and archivelogs, and that probably should be the core of your backup
solutions. RMAN is also supported by oracle -- whereas your home grown
solution is your own.
We have a recovery window of X days -- and permanently configure rman to backup
to disk. sys admins back up the backups to tape or virtual tape libraries
etc., beyond the scope of this reply.
A couple permanent configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
This default configuration will put your archivelogs into subdirectories by
date. For example <backup dir>/archivelog/<date1>, <date2> etc, and the
directories are automatically created including the archivelog dir.
Some of actual rman backup commands pertaining to archive logs are
crosscheck archivelog all;
delete noprompt expired archivelog all;
backup archivelog all not backed up 1 times;
delete noprompt archivelog until time "sysdate-4" backed up 1 times to device
type disk
To go into the complete backup solution is probably not something for a simple
email, just remember:
"You do not have a backup solution until you have done a restore." -- probably
several.
Best Regards,
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Li Li
Sent: Friday, April 20, 2012 12:31 PM
To: oracle-l
Subject: Oracle Archive Solution
Hi List,
I am wondering if anyone has implemented an archive solution and would
be willing to share what product you used, either commercial, open
source or home-grown? We are at a point that we have to archive data
based on dates as our database has grown tremendously since the
company started and data has never been archived.
TIA,
-Li
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
