Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: What to keep in ASM?

Re: What to keep in ASM?

From: Alex Gorbachev <>
Date: Mon, 26 Feb 2007 16:22:50 -0500
Message-ID: <>

See inline...

On 2/26/07, Don Seiler <> wrote:
> On 2/25/07, Alex Gorbachev <> wrote:
> > Keeping controlfiles/redo on ASM partially, why would you even want to
> > consider it?
> > Your complex configuration gives you more troubles than benefits -
> > it's just a mess of different storage technologies.
> So you're suggesting to keep controlfiles/redo completely in ASM? Or
> completely on another filesystem?

If I was you, I wouldn't go to the non-standard setup without a reason. multiplexing controlfiles and redo logs over ASM and filesystem is a non-standard configuration and I also don't see a reason for doing it. If you think it would add you resiliency - describe why.

> > You might have a reason not to trust your backups to ASM but (if you
> > are on RAC) you would need cluster file system then.
> No this is just a single-instance. Thanks.

In this case I would doubt if you really need ASM at all but that's another story. ;-)

> > To get your backup to another host here is an option (just a sketch):
> > Create separate ASM DG with LUNs visible from both - production and
> > development server. Instead of rsync, use RMAN to backup your FRA or
> > backup pieces to this special DG. Unmount from production. Mount on
> > test host and get backup from there.
> I'll show this to my SA and see how he likes it. Sounds a lot easier
> on the system than rsyncing all the data (especially after Sunday's
> level 0). The one issue would be that our restores and duplications
> currently take almost 9 hours (as do level 0 backups). So when I do a
> duplication to dev, I do this overnight, which is normally when the
> backups would run. To stick with that current process, I'd need the
> disk available to both.

As I mentioned, if you have dedicated DG for backup only (not FRA location) than you should be able to unmount it and temporary mount on your development machines subject to SA policies.

> Thanks again,
> Don.
> --
> Don Seiler

Best regards,
Alex Gorbachev
Received on Mon Feb 26 2007 - 15:22:50 CST

Original text of this message