RE: Oracle Archive Solution
Date: Fri, 20 Apr 2012 13:35:52 -0400
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA1B9553AE9E_at_JAXMSG01.crowley.com>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 20 2012 - 12:35:52 CDT