Re: Archivelog on Rac 11gr2

From: John Clarke <john.clarke_at_centroid.com>
Date: Sat, 14 Jan 2012 10:59:46 -0500
Message-ID: <CB37108E.63210%john.clarke_at_centroid.com>

Sounds like you're using ASM for data files - I'd put archive logs in ASM as well. There are a couple of ways to do this but I'd enable FRA by setting db_recovery_file_dest to an ASM disk group name, then do this: Shutdown instances and then startup one of them. Then

SQL> startup mount
SQL> alter database archivelog
SQL> alter database open

You only need to do this from one instance. When it's done, just start the other instance (srvctl start instance �).

I'm assuming you're using RAC based on your "each node" comment.

---

John Clarke
www.centroid.com

From: Alex Cwb <ab80cwb_at_gmail.com<mailto:ab80cwb_at_gmail.com>> Reply-To: "ab80cwb_at_gmail.com<mailto:ab80cwb_at_gmail.com>" <ab80cwb_at_gmail.com<mailto:ab80cwb_at_gmail.com>> Date: Sat, 14 Jan 2012 10:11:08 -0500
To: "oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>" <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: Archivelog on Rac 11gr2

Hi,
I have a rac database on 11gr2 for study purposes, and I would like to put this db on archivelog mode in order to study backup with Rman. However, my doubt is related to the location of those archive log ... if I have to put in a shared are, such as ASM (sth like +DATA/arch) or if I have to enable arch on each node but in local disk (sth like /u02/arch for n1 and n2).

And the last doubt, the procedure to enable, do I have to execute on each node?
I found out the steps on this page:
http://www.toadworld.com/Newsletter/TWPIPELINESept2008/PIPESept08Oracle/tabid/450/Default.aspx

Any suggestion is very welcome.
Thanks in advance for the help.

Alex

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Sat Jan 14 2012 - 09:59:46 CST