RE: Do you store your archive logs in ASM managed disk space?
Date: Fri, 8 Feb 2008 22:28:48 +0100
I always use the asm diskgroups to store the archived redo logs (but I only use ASM for rac systems, for which I find it easier to use a shared filesystem for the archived redo logs).
When taking backups I also backup the archived redo logs with rman. Have you considered using the controlfile autobackup feature instead of backing up the controlfile yourself?
Oracle Database Administrator
tel +32(0)3 451 23 82
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter Sent: vrijdag 8 februari 2008 22:14
Subject: Do you store your archive logs in ASM managed disk space?
I am expecting to be migrating one of my databases ot 10g sometime this year and am considering ASM, hence the question above. From a quick skim of the Administrator's Guide it looks as though I could but all of the database files including archive logs, backup control files, and (?) rman backup files into the ASM controlled disks.
My current procedure for backing up the database is to run rman in /nocatalog mode, force a log switch, and then backup the control file. The backup control file is then saved with the rman files and the necessary archive logs in case it is needed for recovery. To do something similar in an ASM based environment, I would have to store my archive logs in a standard file system. Is this the way most people using ASM are working?
If it makes a difference, my current and probable future environment will be Solaris.
http://www.freelists.org/webpage/oracle-l Received on Fri Feb 08 2008 - 15:28:48 CST