Re: long term archivelog retention
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Mon, 22 Apr 2013 18:06:12 -0700 (PDT)
Message-ID: <1366679172.66372.YahooMailClassic_at_web181201.mail.ne1.yahoo.com>
... The catch with that is that you can't rely on autobackup of the spfile and controlfile, so your scripts need to take that into account.
Date: Mon, 22 Apr 2013 18:06:12 -0700 (PDT)
Message-ID: <1366679172.66372.YahooMailClassic_at_web181201.mail.ne1.yahoo.com>
... The catch with that is that you can't rely on autobackup of the spfile and controlfile, so your scripts need to take that into account.
In complete agreement ... I always force my own backup of controlfile contents and spfile.
If I am going to restore back to some prehistoric point in time ( or even reasonably close ) I am going to use a version of the control file that makes sense to me.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 23 2013 - 03:06:12 CEST