RE: ORA-230 and RMAN scheduling

What Oracle version are the target databases you're backing up?

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse Sent: Wednesday, November 14, 2007 8:51 AM To: oracle-l_at_freelists.org
Subject: ORA-230 and RMAN scheduling

Hey all,

In the past few weeks, I've had my full RMAN backups fail with ORA-230. Checking on logs and timings, I believe that the scheduled RMAN archivelog
backups are coinciding with the controlfile autobackup. It appears to be
complete coincidental, however it's happening with increased frequency.

Of course, since I'm the only DBA here, I've attempted to consolidate all
Oracle DB management into Grid Control (GC 10.2.0.3.0 with 10.1.0.5.0 DBs),
including RMAN scheduling. The only way I can see to prevent the obnoxious
GC backup scheduling from comflicting is to convert my half-hour repeating
archivelog backups schedule to 20 different daily ones, save for the estimated time of the full backup. Obviously, this isn't my first choice.

I'd like ("like" isn't the right word here) to stick with GC in order to maintain simplicity in management. Thoughts on avoiding the ORA-230? I'm
starting the fulls 10 minutes later for now, but this is a temporary bandaid
that will surely break in the future.

TIA!
Rich

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 14 2007 - 09:08:14 CST