[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 <=
|
|
|