Veritas-bu

[Veritas-bu] RE: Veritas-bu digest, Vol 1 #2819 - RE: Oracle Policy volume pool overriding

2004-01-12 13:30:03
Subject: [Veritas-bu] RE: Veritas-bu digest, Vol 1 #2819 - RE: Oracle Policy volume pool overriding
From: mhickey AT glasshouse DOT com (Mark Hickey)
Date: Mon, 12 Jan 2004 13:30:03 -0500
Jon,
    Yes, you can do what you want to do, but I haven't the time right
now to go over it all in detail.  Briefly, you need two schedules in the
policy, named daily-application-bu and weekly-application-bu, or
whatever, that point to the right pools, and have the desired frequency,
window, etc.  In the RMAN script use either the SEND or PARMS RMAN
command (which one is correct depends on the Oracle version) to set the
environment variable NB_ORA_SCHED to the schedule that you want to use
for the backup.  
The environment variables and how to pass them are documented in the
Oracle SAG.  If you contact me privately I can perhaps be of more help,
but it might be a couple of days.

Mark Hickey
Senior Technology Consultant
Glasshouse Technologies, Inc.
www.glasshouse.com
--------------------------------
Message: 7
Date: Mon, 12 Jan 2004 09:06:49 -0800
From: "Jon D. Benson" <jbenson AT neurome DOT com>
To: " (veritas-bu AT mailman.eng.auburn DOT edu)"
<veritas-bu AT mailman.eng.auburn DOT edu>
Subject: [Veritas-bu] NBU45-FP5: Oracle Policy Volume Pool not
overriding

Greetings

I recently implemented a Oracle policy to run hot backups of my 
development instance. I set the policy to run weekly full backups and 
daily differential incremental backups. My usual procedure is to setup 
the policy to use a WEEKLY pool as the policy volume pool and to set the

daily schedule to override policy volume pool to use a DAILY pool. This 
is a standard procedure for my other policies.

My problem is that the oracle policy utilizes a third schedule -- the 
Default-Application-Backup schedule. This schedule is the actual 
schedule that media manager uses to determine pools. So what is see is 
that regardless of the override setting on my daily policy this policy 
always uses the WEEKLY pool (because the Default-Applicaiton-Backup 
schedule isn't set to override). Conversely if I set the 
Default-Application-Backup schedule to override then both weekly and 
daily schedules use the DAILY pool.

Are there any methods I can use so an Oracle policy can use two pools?

thanks!
-- 
Jon D. Benson
Network Systems Administrator
Neurome, Inc.
La Jolla, CA





<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] RE: Veritas-bu digest, Vol 1 #2819 - RE: Oracle Policy volume pool overriding, Mark Hickey <=