Re: archivelogs scheduling
From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Fri, 4 Mar 2011 08:51:28 +0100
Message-ID: <4D709A00.6010802_at_nordea.com>
P D pisze:
> I inherited a system that I only want for there to be 7 days of archivelogs kept on the server. The rest should be backed up and removed by RMAN. Right now there seems to be several weeks worth of archivelogs and I am not sure what the schedule is for them. I looked at the script and it doesn't seem to indicate how the logs are being removed or what the settings are. Where else should I look? Is there a parameter that needs to be alter to be 7 instead?
Date: Fri, 4 Mar 2011 08:51:28 +0100
Message-ID: <4D709A00.6010802_at_nordea.com>
P D pisze:
> I inherited a system that I only want for there to be 7 days of archivelogs kept on the server. The rest should be backed up and removed by RMAN. Right now there seems to be several weeks worth of archivelogs and I am not sure what the schedule is for them. I looked at the script and it doesn't seem to indicate how the logs are being removed or what the settings are. Where else should I look? Is there a parameter that needs to be alter to be 7 instead?
You may check db preferences with "show all" command, if not already checked
-- Pole nakazi ---------------------------------------------------------------------- Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com> pos : DBA at DIiUSI addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland phone : +48 58 667 17 43 mobile: +48 602 42 42 77 Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia, wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000021828, dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku, VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego, o kapitale zakladowym i wplaconym w wysokosci: 227.593.500,00 zlotych, NIP: 586-000-78-20, REGON: 190024711-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 04 2011 - 01:51:28 CST