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